Manual Calculation possible?

Manual Calculation possible?

Posted by: zhoubing.yang on 16 November 2022, 1:11 pm EST

• 

  zhoubing.yang

  • Post Options:
  • Link
    Copy

  Posted 16 November 2022, 1:11 pm EST

  Hi,
  
  My team tried to develop feature to manually execute formula calculation as a way to improve large sheet performance.
  
  I noticed spread object contains an option called calcOnDemand, I have tried to turn it on but nothing happened.
  
  Can you show me an example on how to turn off automatic formula calculation on sheet if that is possible? Much appreicated.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 17 November 2022, 4:14 pm EST - Updated 17 November 2022, 4:19 pm EST

  Hi,

  You could use the suspendCalcService method to suspend the calcService and use the resumeCalcService method to resume the calcService. Manually calculating the formulas is not feasible, especially for the complex formula.

  For improving the performance, you could refer to the following docs that describes the best practices: https://www.grapecity.com/spreadjs/docs/BestPractices

  You can refer to the following sample:
  
  https://jscodemine.grapecity.com/share/DAEOBwEaXEqwH7_llyLKHg/

  References:

  suspendCalcService method: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#suspendcalcservice

  resumeCalcService method: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#resumecalcservice

  Regards,
  
  Ankit

  

• 

  zhoubing.yang

  • Post Options:
  • Link
    Copy

  Posted 21 November 2022, 4:53 pm EST

  Thank you for getting back on this topic Ankit,
  
  I understand there is no nature way of doing this passively. Are you aware of any spread event we can intercept before it’s executing the calculation based on the formula?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2022, 8:33 am EST

  Hi,

  You could use the EditEndingEvent that occurs when a cell is leaving the edit mode and check if the editor’s value is a formula. You can also cancel the operation by setting the “cancel” param to true.

  Please refer to the following sample: https://jscodemine.grapecity.com/share/Vo8TE8ASe06IySQnVlz61A/

  References:

  EditEnding Event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#editending

  evaluateFormula method:
  
  https://www.grapecity.com/spreadjs/api/modules/GC.Spread.Sheets.CalcEngine#evaluateformula

  Regards,

  Ankit