How to get old values in spreadsheet before update


#1

Hi,
I am unable to get old values before/after update of cell value.

i have tried below
beforeAction - event not getting fired at all
afterAction - event not getting fired at all
beforeEditStart - gives new value instead of old
beforeEditEnd- gives new value instead of old
beforeValueChange - gives new value only

please check and let me know
Note- I am using spreadsheet 4.2 version. i read that beforeAction and afterAction added in 4.3 .what about other functions?is there a way?


#2

You may get the actual (old) value of a cell before the edit operation is complete with the getValue() method.
Like:
https://snippet.dhtmlx.com/d8jk4vmd