Get old value by getDirtyCells

Get old value by getDirtyCells

Posted by: cangod05 on 10 October 2022, 1:45 pm EST

• 

  cangod05

  • Post Options:
  • Link
    Copy

  Posted 10 October 2022, 1:45 pm EST

  Hi Admin, I want to get old values when cell changed, copy paste, delete, undo and change one cell, So I decided to use getDirtyCells but It has an issue like can’t get when undo action, Do you have method to fix that problems or events are action when before changed cell

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 10 October 2022, 7:32 pm EST

  Hi,

  Bind to the CellChanged and RangeChanged events to detect when the cell value changes, and paste is triggered.

  Please see the following example: https://jscodemine.grapecity.com/share/-sFiWlHSX0iv8dQvitmyxA/

  API References:

  CellChanged Event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#cellchanged

  RangeChanged Event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#rangechanged

  Regards,

  Ankit