Trigger LeaveCell() when changing active cell.

Posted by: imgodot on 8 September 2017, 3:18 pm EST

  • Posted 8 September 2017, 3:18 pm EST

    I am programmatically changing the current cell in a Spread.
    When I do that, I want the LeaveCell() event to fire.

    What code/method do I need to use so that when I change the active cell in the Spread, LeaveCell() will fire?

    -- Paul
  • Marked as Answer

    Replied 8 September 2017, 3:18 pm EST


    Please note that LeaveCell does not fire when the ActiveCell is changed via code, because the vent is called only when the ActiveCell changes due to user interaction ie. it occurs when the user leaves a cell.

    Hence, the solution for you is to explicitly handle/fire the LeaveCell event once you change the ActiveCell.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels