I need to track changes done by undo/redo so I can update them in our tables. I am able to accomplish this with Ctrl + Z and Ctrl + Y, as these hotkeys will emit the actionComplete event of action type undoRedo.
However, when I call the methods programmatically like so:
this.spreadsheetObj.redo();It does not emit actionComplete, nor any other event that I can find in the documentation. Is there a way for me to capture the cells that are changed by these methods?
Hi Sangeetha,
Thanks for getting back to me. I need a way to determine which cells/ranges were changed by an undo or redo action, and I need a way to confirm that it was an undo/redo action that was performed. I can then get the values in those ranges using the getData method, and update our tables. This needs to include copied/pasted ranges in case a cut/paste was undone/redone.
In the attachment I have a screen shot showing the actionComplete event for Ctrl + Z/Y, this is what I am currently using. There is an example of the event when using cut/paste, and when saving cell.
Thanks!