ValueChanged event doesn't support Undo operation

ValueChanged event doesn't support Undo operation

Posted by: davide.vago on 29 June 2021, 4:05 am EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 June 2021, 4:05 am EST

  Hi there,

  I’m reaching you out as I realised the ValueChanged event doesn’t trigger whenever the user revert back (Undo) so I’m wondering if you could request the feature to your devs in the next releases as it would be good to have consistency in all the events.

  Our scenario is:
  
  we would like to trigger a custom action whenever the user does change the value of a cell, what we currently have in our hands is:

  • CellChanged (which triggers multiple times: for style, formula, value)
  • RangeChanged (which triggers on copy/paste, dragfill, clear operations)

  So we were exploring the ValueChanged event to see if we could limit triggering our custom action attached to the CellChanged but it seems like the Undo operation doesn’t get tracked by this event.

  Thanks for your support

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 30 June 2021, 8:23 am EST

  Hi Davide,

  You may achieve the required functionality using the CellChanged event. Please refer to the following code snippet.

  
    sheet.bind("CellChanged", (e, args) => {
      if (args.propertyName === "value") {
        console.log("valueChanged");
      }
    });
  
  

  Could you please let me know what issue you are facing while using the CellChanged event?

  Regards,
  
  Avinash