#NULL! value calculated as 0

Aspose.Cells Product Family
1

Hello,

We’ve identified an issue with formula calculation - it seems #NULL! values are calculated as 0 by Aspose.

Please see the attached test file, the B3 column contains an invalid formula which results to #NULL!. After performing workbook calculation with Aspose, it will resolve to 0.

We are using Aspose.Cells version 8.0.0.0.

Any feedback will be highly appreaciated.

Thank you,
Mihai Andrei
Sr Software Engineer
IBM Romania

2

Hi,


Thanks for the sample file.

After an initial test, I observed the issue as you mentioned by using your sample file and following sample code. Aspose.Cells gives 0 as calculated value instead of #NULL!:
e.g
Sample code:

var workbook = new Workbook(“e:\test2\testfile.xlsx”);

Console.WriteLine(“B3 StringValue: {0}”, workbook.Worksheets[0].Cells[“B3”].StringValue);


workbook.CalculateFormula();

Console.WriteLine(“B3 StringValue: {0}”, workbook.Worksheets[0].Cells[“B3”].StringValue); //0 - not Ok

I have logged a ticket with an id “CELLSNET-42559” for your issue. We will look into it soon.

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

Thank you.
3

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

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

Hello,

We have tested against Aspose.Cells 8.0.1.0 but the problem is still reproducible.

Please advise.

Thank you,
Mihai Andrei

5

Hi Mihai,


Thank you for writing back.

Please download and use the latest version of Aspose.Cells for .NET 8.0.1.3 as it returns NULL instead of 0 for Cell B3, that is a correct behavior.

Please feel free to write back in case you need our further assistance with Aspose.Cells APIs.