How to detect if there is any modification in spreadjs

How to detect if there is any modification in spreadjs

Posted by: vishal.mokal on 11 April 2023, 11:16 am EST

• 

  vishal.mokal

  • Post Options:
  • Link
    Copy

  Posted 11 April 2023, 11:16 am EST

  I am saving spreadsheets as json in database only if it is modified.
  
  to do so i end up registering multiple events as per my requirement.

  but that list is getting big and big, is there any single method available to check if spreadsheet is modified or not

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 12 April 2023, 12:29 pm EST

  Hello,
  
  We are sorry for the inconvenience caused. There is no method to check whether the spreadsheet is modified or not. You would need to bind event handlers to different events to detect the changes in the spreadsheet and based on that you can determine whether a spreadsheet is modified or not.
  
  Alternatively, you can bind an event listener to the command manager of the spread. The event listener is invoked when an ui operation is performed which modifies the spreadsheet. You can get the command manager using spread.commandManager() and bind event handler using commandManager.addListener(‘appListener’, function) method.
  
  Please refer to the code snippet and attached sample for further understanding.
  
  let commandManager = spread.commandManager();
  
  commandManager.addListener(‘appListener’, (args) => {
  
  console.log(args);
  
  });
  
  Sample: https://jscodemine.grapecity.com/share/HUsbJPk1f0mBB_Kao2uybw/?defaultOpen={“OpenedFileName”%3A[“%2Findex.html”%2C"%2Fpackage.json"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}
  
  Please let us know if you face any difficulties or if you have any doubts.
  
  Doc reference

  spread.commandManager(): https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Workbook#commandmanager

  CommandManager class: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Commands.CommandManager#class-commandmanager

  Regards,
  
  Avinash