I have an example workbook that shows in Excel that cells I2 to I6 have the value 0.
TestCase03.zip (9.7 KB)
However, when opening in Aspose.Cells (.NET) 20.5 and after CalculateFormula, the value for cells I3, I4 and I5 are not 0 compared to what Excel says. Example code below:
var workbook = new Workbook("TestCase03.xlsx"); Worksheet wksheet = workbook.Worksheets["Sheet1"]; // Calculate formula. workbook.CalculateFormula(); Cell i3 = wksheet.Cells["I3"]; Cell i4 = wksheet.Cells["I4"]; Cell i5 = wksheet.Cells["I5"]; Console.WriteLine(i3.ToString()); // Should be 0 but shows 2. Console.WriteLine(i4.ToString()); // Should be 0 but shows 3. Console.WriteLine(i5.ToString()); // Should be 0 but shows 4.
Can you please have a look at this problem?