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?