Calculation error when turning on/off AutoCalculation

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

  • 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?
  • Replied 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.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels