Workbook.CalculateFormula bug

Aspose.Cells Product Family
1

Hi,

Workbook.CalculateFormula() doesn’t work for “=ABS(FIXED(2,0))”, after calling the method the result of this formula is “#VALUE!”.
Using the attached file run this code:

var workbook = new Workbook(“TestFiles\CalculateFormulaBugDemo.xlsx”);
Console.WriteLine(“A1 value before Workbook.CalculateFormula: {0}”, workbook.Worksheets[0].Cells[“A1”].Value);

workbook.CalculateFormula();

Console.WriteLine(“A1 value after Workbook.CalculateFormula: {0}”, workbook.Worksheets[0].Cells[“A1”].Value);

Console.ReadKey();

Thanks,
Aurelian Iordache
IBM Romania

2

Hi Aurelian,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. Aspose.Cells could not calculate the value of the formula inside the cell A1. 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-42508.

3

Hi Shakeel,

Thank you for logging this issue, just as a note this bug could have impact on formulas using other functions not only on the functions used in this formula. MS Excel seems to automatically coerce the values returned by functions to data types required as input by other functions while Aspose marks the cell as invalid (A value used in the formula is of wrong data type.)

Regards,
Aurelian Iordache
IBM Romania

4

Hi Aurelian,

Thanks for your posting and using Aspose.Cells.

We have logged your comment in our database against this issue. Please spare us some time. We will let you know once there is some fix or update for you.

5

Hi,

Thanks for using Aspose.Cells.

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

6

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

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

Hello,

We’ve tested against Aspose.Cells version 8.0.1.0, the issue seems to have been fixed.

Thank you,
Mihai Andrei
Sr Software Engineer
IBM Romania

8

Hi Mihai Andrei,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest version. Let us know if you encounter any other issue, we will be glad to look into it and help you further.