Template (2).zip (6.6 KB)
We have been ASPOSE client for a very long time and recently we have found an issue with formula evaluation;
Please find attached zip file with sample excel file for you to easily reproduce the problem;
Here is the sample code for you:
Workbook targetWorkbook = new Workbook("C:\temp\Template (2).xlsx"); Console.WriteLine(targetWorkbook.Worksheets["Sheet1"].Cells["C5"].StringValue); // When you open file in excel, you get displayed different result to what is shown here // As a matter of fact, "targetWorkbook.Worksheets["Sheet1"].Cells["C5"].Value" also returns the different result to excel
I have tried the latest version (19.9) of ASPOSE.Cells library,
Can you please have a look at the possible defect mentioned above?
Please investigate, acknowledge and possibly give an ETA on a fix,