Slow Performance when I try to use formula

Slow Performance when I try to use formula

Posted by: cangod05 on 16 July 2023, 11:01 pm EST

• 

  cangod05

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 July 2023, 11:01 pm EST - Updated 17 July 2023, 5:29 am EST

  Hi Admin,
  
  When I try to use sheet.setFormula it take a long time to paint canvas. Do you have another sollution to increase this performance when I use Formula. Because each row it has a total from current year => current year + 100 year ( by total column).
  
  Thanks you.
  
  I try to use

  	spread.suspendCalcService(true);
  	sheet.suspendEvent();

  But it don’t make it to be faster
  
  Best regards.

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 17 July 2023, 8:04 am EST

  Hello,

  You can use spread.suspendPaint() method to suspend the painting of spread before changing the sheet data and applying formulas in cells. It is a recommended practice. To resume the painting of Spread, spread.resumePaint() method can be utilized.

  Please refer to the link https://www.grapecity.com/spreadjs/docs/BestPractices to learn more about best practices in SpreadJS.

  Please refer to the attached sample for more understanding.

  sample:https://jscodemine.grapecity.com/share/Rx5M2xqyXkCm95EqwKbexw/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please let us know if you still face the issue and provide us with a minimal sample or file that replicates the issue you are facing. You may modify the sample as well that we have shared with you. We will be happy to help you accordingly.

  Regards