`EditEnding` / `EditEnded` event doesn’t fire properly

Posted by: sebastian on 25 May 2022, 8:15 pm EST

  • Posted 25 May 2022, 8:15 pm EST

    1. Create at least 2 sheets
    2. Create an event handler for `EditEnding` event
    3. Start editing a formula in one of them
    4. Switch to other sheet while editing a formula (picking a cell)
    5. Click away from the second sheet.
    6. Observe the blue border marking an active cell is gone, but `EditEnding` event not firing

  • Replied 26 May 2022, 8:52 pm EST


    We are sorry but in our end, the edit-ended event is getting called. Could you please refer to the following gif and let me know if we missed any steps.


  • Replied 31 May 2022, 6:58 pm EST

    You’re right, `EditEnded` fires properly. But why does not EditEnding?
  • Replied 31 May 2022, 7:00 pm EST

    Please try the same thing, but with `EditEnding` event
  • Replied 31 May 2022, 7:04 pm EST

    Also - hitting escape while editing a formula resets user to the original sheet where they started the formula, while clicking away does not - it just discards the editing.

    Is there any way to reset the user back to the original sheet on clicking away?
  • Replied 1 June 2022, 11:35 pm EST


    For EditEniding:

    this seems like unexpected behavior from SJS. W have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information from the team, The internal ID for this issue will be SJS-13283.

    For Esc issue:

    When ESC button is clicked spreadJS executes the cancelInput command. You may execute this command whenever you like. Please refer to the following code snippet and let me know if you face any issues.

    cmd: "cancelInput",
    sheetName: spread.getActiveSheet().name()


    cancelInput: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Commands~cancelInput.html?highlight=cancelinput%2C

  • Replied 8 June 2022, 11:23 pm EST


    The devs have requested the use case. Could you please share the use case that you are trying to implement so that we could investigate it further and help you accordingly?

  • Replied 23 June 2022, 8:30 pm EST

    The usecase is this:
    We have custom page navigation (in a sidebar) and we show native tabs when a user starts editing a formula.

    We want to be able to disable the sidebar navigation, so user don’t click there while editing a formula, because picking a sheet for a reference only works in custom tabs.

    The problem is, that `EditEnding` event doesn’t seem to fire properly, so we’re not notified when the user clicks away, thus we can’t reenable the navigation.
  • Replied 26 June 2022, 3:21 pm EST


    Thanks for the information. We have shared it with the team. We will update you regarding this as have more findings related to this issue.

Need extra support?

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

Learn More

Forum Channels