IF() Formula returns 0 instead of #N/A

Aspose.Cells Product Family
1

“IF()” Formula is producing 0 instead of #N/A as Excel does.

B5 = #N/A

=IF(B5, “Y”, “N”)
Excel -> #N/A
Aspose -> 0

Attached is the test files and sample program.

Excel 2003
Aspose 7.1.1.6

Thanks,
John

2
Hi,

I can notice the issue using your file as Aspose.Cells formula calculation engine returns "0" instead of "#N/A".

Sample code:


Workbook wb = new Workbook(@"E:\test2\ifformula/If_NA.xls");

wb.CalculateFormula();

Debug.WriteLine(wb.Worksheets[0].Cells["D4"].StringValue);// ""
Debug.WriteLine(wb.Worksheets[0].Cells["D7"].StringValue); //"0"

I have logged a ticket with an id: CELLSNET-40440. We will look into it soon.

thank you.
3

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.