Calculation error when turning on/off AutoCalculation

Calculation error when turning on/off AutoCalculation

Posted by: alan.fallas on 23 December 2021, 10:16 am EST

• 

  alan.fallas

  • Post Options:
  • Link
    Copy

  Posted 23 December 2021, 10:16 am EST

  I have a complex spreadsheet where in order to improve performance of the data loading I’m switching on and off the AutoCalculation property on the SheetView. After setting AutoCalculation=true some formulas don’t get correctly calculated and the result is incorrect. I also tried calling RecalculateAll and the error persists.
  
  I was able to isolate the problem where I switch AutoCalculation off, assign values to some cells, switch AutoCalculation on and finally get the value from a cell with a formula.
  
  Can I email the code sample given that my company policies don’t allow me to post in the forum this reduced code sample?

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 23 December 2021, 6:09 pm EST

  Hi Alan,

  We have created a support case [ID: CAS-27746-H5Y4Q9] for you on our Support Portal which is private. You can share your sample there.
  
  You will find the case in the “My Support” section of your Grapecity account.

  Regards
  
  Avnish