Hi,
I have some cell that contains formula pasted from another cell. And in MS Excel I was able to calculate the value by clicking on each item.
calculate.gif (203.8 KB)
I could also create macro to automate this calculation if needed.
However, in Aspose, when I ran
workbook.CalculateFormula();
those cells were not calculated and when I checked those cells, they were not considered as formula (IsFormula = false)
Could you let me know how to get those formulas calculated? I’ve attached the test files for your reference.
test.zip (82.4 KB)
Thanks,