I’m running in to an issue with calculations where a formula that should produce a valid result is giving me a #NAME? error instead. For some reason, setting the formula again after the calculation and calculating again resolves this.
Basically the following happens:
Workbook.CalculateFormula()
Cell.Value is #NAME?
Cell.Formula = Cell.Formula
Workbook.CalculateFormula()
Cell.Value is 4500
I’ve attached a sample project which reproduces this behavior. Is there some change I can make to get CalculateFormula to work the first time?
Edit: I did some more testing and discovered that filling the primaryDataSet after the other sets resolves this issue. This is an acceptable workaround for me. However, I feel that if manual calculation is specified, this should not be a problem in the first place.
AsposeTester.zip (5.5 MB)