Guarantee all updates received

Guarantee all updates received

Posted by: alexei.snisarenko on 16 December 2021, 7:24 pm EST

• 

  alexei.snisarenko

  • Post Options:
  • Link
    Copy

  Posted 16 December 2021, 7:24 pm EST

  I use GC.Spread.Sheets.Workbook.bind(GC.Spread.Sheets.Events.RangeChanged,…) to subscribe on updates in a workbook.

  My use case is:

  1. Load workbook (xlsx file) with complex formulas and dependencies in it
  2. Update certain cell in the workbook which triggers about 100 cells to be updated in different worksheets
  3. Collect all updates
  4. Exit

  Given that bound handler gets triggered separately for every worksheet I am wondering if there is a way to say that calculations have completed?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 20 December 2021, 12:20 am EST

  Hey,

  For your use case, you can bind the workbook with RangeChanged Event. It gives you the type of action that raises the RangeChanged Event. Check for actionType === evaluateFormula, it will be trigged after all the cells have been updated.
  
  RangeChanged Event: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Events~RangeChanged_EV.html
  
  RangeChangedAction Enumeration: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.RangeChangedAction.html
  
  Thanks.