Custom formula recalc

Custom formula recalc

Posted by: tovarnakm on 10 August 2021, 8:57 am EST

• 

  tovarnakm

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 August 2021, 8:57 am EST

  Hi,

  I would like to ask you about the side effects that may occur when I will disable recalculation of custom formula on spreadsheet initialization using doNotRecalculateAfterLoad: true. It is performance heavy if I have 500+ request for each cell (also spreadsheet freezes). Or do you have some recommendation how to handle case with recalculation sequentially?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 11 August 2021, 4:59 am EST

  Hi,

  doNotRecalculateAfterLoad options just p[revfetn the recalculation after loading the workbook(after we use the fromJSON method). Further getting 500+ calls for each is cell is not expected from SpreadJS. Could you please provide a working sample that demonstrates the issue so that we could investigate it further and assist you accordingly?

  API References:
  
  fromJSON: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Workbook~fromJSON.html

  Regards,
  
  Avinash