Can't get calculated value from cell

Aspose.Cells Product Family
1

I have a very simple issue but can't seem to find a solution.

I have a test worksheet that has 2 cells who's values I set with ".PutValue". I then close the workbook.

I then do some work, reopen the same workbook and sheet to retrieve the value of a 3rd cell that has a formula in it. The formula is dependant on the 2 above values.

When I try to retrieve the calculated value, it returns zero.

Is there a function to call to force the calculation?

Johnny

2

Hi Johnny,

To get formula result at run time, please call Workbook.CalculateFormula method before retrieving values to force the calculation.