"N/A" values for valid formula cells after calling Workbook.CalculateFormula

Aspose.Cells Product Family
1

Hi,

After calling Worbook.CalculateFormula method some cells having valid formula values are displaying “N/A”.
For reproducing the issue plase use the attached file and the following code:

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

Console.WriteLine(“Before CalculateFormula:”);
Console.WriteLine("C2 = " + workbook.Worksheets[0].Cells[“C2”].Value);
Console.WriteLine("E2 = " + workbook.Worksheets[0].Cells[“E2”].Value);

workbook.CalculateFormula();

Console.WriteLine(“After CalculateFormula:”);
Console.WriteLine("C2 = " + workbook.Worksheets[0].Cells[“C2”].Value);
Console.WriteLine("E2 = " + workbook.Worksheets[0].Cells[“E2”].Value);

Regards,
Aurelian Iordache
IBM Romania

2

Hi Aurelian,


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, and we are able to replicate the said problem. Aspose.Cells API seems to invalidate the formulas in the provided spreadsheet after calling the Workbook.CalculateFormula method. We have logged the problem in our bug tracking system under the ticket CELLSNET-43118 for further investigation & correction purposes. Please spare us little time to properly analyze the problem cause, and to provide a fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.
3

Hi Aurelian,


This is just to inform you that we have fixed the problem logged earlier as CELLSNET-43118 in our bug tracking system. We will provide the fix in couple of days after passing it through the QA. As soon as next revision is available for public use, we will notify you here with the download link to the upgraded API.
4

Hi Aurelian,

Thanks for your using Aspose.Cells.

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

5

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

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

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

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