Spread 11.0.6 formulas are not displaying value on load

Spread 11.0.6 formulas are not displaying value on load

Posted by: Shalini89garg on 9 May 2018, 4:28 pm EST

• 

  Shalini89garg

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 May 2018, 4:28 pm EST

  Hi ,

  I am facing Issues with formula .
  
  Can anyone please help on this.

  Steps to reproduce.

  1. Run the attached file and click on sheet 4
  2. Column G8,H9,G12 are having formula but still its showing value as 0 on load.
     
     If we give formula directly then its working but on load its not working.

  SpreadJSExportIncludeHeaders - Copy.zip

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 May 2018, 9:24 pm EST

  Hi Shalini,

  This looks the correct behavior, sheets are added to Spread one by one. At the time when Sheet1 is ready with formula Sheet2 is not present, so the formula is not calculated.
  
  If you assign the formula for an existing sheet, the formula works fine.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2018, 4:48 pm EST

  Hello,

  Since you are loading data using Sheet.fromJSON in different sheets one by one. The formulas are not calculated since you have cross sheet references formulas. When loading the whole spread json data, the calc service will handle the formula after all sheet and data loaded. and for performance consideration, calc service will not recalc multi times.

  For the workaround, you can invoke recalcAll method to recalc all formula again manually once the workbook is loaded completely.

  Thanks,
  
  Deepak Sharma