Different value after CalculateFormula()

Aspose.Cells Product Family
1

Hello,


I’ve attached a xls document. The code that I’m running is the following:

var excelDocument = new Workbook(“TestFiles\G1.xls”);
var worksheet = excelDocument.Worksheets[1];
var cellValue = worksheet.Cells[“D23”];
Console.WriteLine("before CalculateFormula() " + cellValue.Value);
excelDocument.CalculateFormula();
Console.WriteLine("after CalculateFormula() " + cellValue.Value);
Console.ReadLine();

If you run the code you can see that the value of the cell is different.

Thank you,
George Radu
Software Developer
IBM Romania
2

Hi,


Although Shakeel Faiz has logged a ticket already, I have evaluated your issue a bit using your sample code with your template file with Aspose.Cells for .NET v8.4.2.7 (please try Aspose.Cells for .NET v8.4.2.7), well, there is a minor difference regarding the calculated value. It is different only at the last digit (9th) which should be accommodated as I think. Here is the output console:

before CalculateFormula() 122781676
after CalculateFormula() 122781675

Do you still want and think it should be fixed in the component? We can surely set the logged issue active for processing.

Thank you.


3

Hi,


This is also my result. That last digit (9th) is quite important.

Thank you,
George Radu
Software Developer
IBM Romania
4

Hi,


Thanks for providing your feedback.

Alright! as Shakeel Faiz has already logged a ticket “CELLSNET-43719” for the issue into our database, I have activate the issue now and asked the relevant developer to fix it (if possible). Hopefully your issue would be fixed soon.

Once we have any update on it, we will let you know here.

Thank you.
5

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.5.0.1

We have fixed your issue “CELLSNET-43719” now.

Let us know your feedback.

Thank you.

6

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

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