I have an Excel workbook that I’ve tested using Aspose.Cells .NET version 22.3.0. The workbook here TestCase07.zip (29.2 KB)
I used the following C# code to view the values of cells after CalculateFormula:
var workbook = new Workbook("TestCase07.xlsx"); workbook.CalculateFormula(); Worksheet worksheet = workbook.Worksheets["Sheet1"]; string s1 = worksheet.Cells["AV103"].ToString(); // Expected 1 and shows as 1 string s2 = worksheet.Cells["AV104"].ToString(); // Expected 2 but shows as 1 string s3 = worksheet.Cells["AV123"].ToString(); // Expected 3 but shows as 2
Aspose shows the value of cell AV104 is 1 and cell AV123 is 2, but when I open the workbook in Excel, the values are AV104=2 and AV123=3.
Can you please have a look into it?