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

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

Posted by: sebastian on 26 May 2022, 5:15 am EST

• 

  sebastian

  • Post Options:
  • Link
    Copy

  Posted 26 May 2022, 5:15 am EST

  Reproduction:

  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
• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 27 May 2022, 5:52 am EST - Updated 3 October 2022, 9:13 am EST

  hi,

  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.

  Regards,
  
  Avinash

  

• 

  sebastian

  • Post Options:
  • Link
    Copy

  Posted 1 June 2022, 3:58 am EST

  You’re right,

  EditEnded

  fires properly. But why does not EditEnding?

• 

  sebastian

  • Post Options:
  • Link
    Copy

  Posted 1 June 2022, 4:00 am EST

  Please try the same thing, but with

  EditEnding

  event

• 

  sebastian

  • Post Options:
  • Link
    Copy

  Posted 1 June 2022, 4:04 am 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?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 2 June 2022, 8:35 am EST

  Hi,

  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.

  
      spread.commandManager().execute({
            cmd: "cancelInput",
            sheetName: spread.getActiveSheet().name()
          });
  
  

  API:

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

  Regards,
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 9 June 2022, 8:23 am EST

  Hi,

  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?

  Regards,
  
  Avinash

• 

  sebastian

  • Post Options:
  • Link
    Copy

  Posted 24 June 2022, 5:30 am 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.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 27 June 2022, 12:21 am EST

  Hi,

  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.

  Regards,
  
  Avinash

• 

  kevin.ashley

  

  • Post Options:
  • Link
    Copy

  Posted 14 December 2023, 11:01 am EST

  Hello,

  My apologies for the delay on this one, it would seem that this issue slipped by our team. Are you still having this issue or can we close this case?

  Regards,
  
  Kevin