Compact diff datastructure for Excel files

Compact diff datastructure for Excel files

Posted by: peter on 24 October 2025, 6:51 pm EST

• 

  peter

  • Post Options:
  • Link
    Copy

  Posted 24 October 2025, 6:51 pm EST

  We’re interested in sending diffs (changes in excel file) between services over the network. Is there a canonical representation of this diff that we can send and apply to an open SpreadJS file?

• 

  peter

  • Post Options:
  • Link
    Copy

  Posted 25 October 2025, 12:08 pm EST

  I see there is getDirtyCells, https://help.grapecity.com/spread/SpreadSheets10/JavascriptLibrary~GC.Spread.Sheets.Worksheet~getDirtyCells.html

  but it only tells you if cell values changed. Is there a way to get all the change, including formatting?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 27 October 2025, 1:42 am EST

  Hi,

  As I understand, you have an Excel file loaded in SpreadJS and want to send any changes made in this file to another SpreadJS instance in real time.

  You’re correct that getDirtyCells only detects value changes. To capture formatting or other types of changes, you can use the addListener method of SpreadJS’s command manager, which triggers for every change. You can then send these changes and apply them using SpreadJS APIs. Refer to the example below:

  spread.commandManager().addListener('app', (args) => {
      console.log("commandManager", args);
  });

  Regards,
  
  Priyam