Calculate formula gives different result than Excel

Hello,


We have an excel date formula that when computed by Aspose with CalculateFormula gives a different result then the result from excel 2013.

Sample Code:

var workbook = new Workbook(“Test.xlsx”);

System.Console.WriteLine(“INITIAL INPUT”);
System.Console.WriteLine(work.Worksheets[0].Cells[2, 1].Value);
System.Console.WriteLine(work.Worksheets[0].Cells[2, 2].Value);
System.Console.WriteLine(work.Worksheets[0].Cells[2, 3].Value);

workbook.CalculateFormula();

System.Console.WriteLine(“RESULT AFTER CALCULATEFORMULA”);
System.Console.WriteLine(work.Worksheets[0].Cells[2, 1].Value);
System.Console.WriteLine(work.Worksheets[0].Cells[2, 2].Value);
System.Console.WriteLine(work.Worksheets[0].Cells[2, 3].Value);

Test.xlsx is attached.

Best regards,
Stefan Botan,
IBM Romania

Hi Stefan,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.2.2.2, and we are able to notice the incorrect value calculated by Aspose.Cells API for the TEXT function. We have logged the problem in our bug tracking system for further investigation & correction purposes. The ticket Id for your future reference is CELLSNET-43139. Please spare us little time to properly analyze the problem cause. In the meanwhile, we will keep you posted with updates in this regard.

We are sorry for the inconvenience caused to you.

Hi Stefan,


This is to inform you that we have fixed the problem logged earlier as CELLSNET-43139 in bug tracking system. The fix will be provided in couple of days after performing QA on it. We will update you here once the release is ready for you to test.

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.2.2.3 and let us know your feedback.

The issues you have found earlier (filed as CELLSNET-43139) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.