Workbook.CalculateFormula populating with wrong values

Aspose.Cells Product Family
1

Hi,

After calling Workbook.CalculateFormula some cells have value 0 (different than MS Excel).
For replicating the issue please use the attached file, the following code and compare the values with the ones diplayed when opening the file in MS Excel:

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

Console.WriteLine(“Before CalculateFormula:”);
Console.WriteLine("H13 = " + workbook.Worksheets[0].Cells[“H13”].StringValue);
Console.WriteLine("H14 = " + workbook.Worksheets[0].Cells[“H14”].StringValue);
Console.WriteLine("H15 = " + workbook.Worksheets[0].Cells[“H15”].StringValue);
Console.WriteLine("H21 = " + workbook.Worksheets[0].Cells[“H21”].StringValue);

workbook.CalculateFormula();

Console.WriteLine(“After CalculateFormula:”);
Console.WriteLine("H13 = " + workbook.Worksheets[0].Cells[“H13”].StringValue);
Console.WriteLine("H14 = " + workbook.Worksheets[0].Cells[“H14”].StringValue);
Console.WriteLine("H15 = " + workbook.Worksheets[0].Cells[“H15”].StringValue);
Console.WriteLine("H21 = " + workbook.Worksheets[0].Cells[“H21”].StringValue);

Regards,
Aurelian Iordache
IBM Romania

2

Hi Aurelian,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing your code with your given source Excel file using the latest version: Aspose.Cells
for .NET v8.2.1.3. The calculated values are 0 which were earlier non-zeros.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-43065.

I have also pasted the console output of your code for a reference.

Console Output:

Before CalculateFormula:
H13 = 1,137,180
H14 = 363,893
H15 = 177,664
H21 = 50,025
After CalculateFormula:
H13 = 0
H14 = 0
H15 = 0
H21 = 0

3

Hi,


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

We have fixed your issue now.

Let us know your feedback.

Thank you.

4

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

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