Aspose Cells produces "#N/A" values, Excel does not

Aspose.Cells Product Family
1

Hi,

Using Aspose Cells for Java, version 22.7.

Sample code:

Workbook workbook = new Workbook("input.xlsx");
workbook.calculateFormula();

WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.get("IT Concentration");

Cells cells = worksheet.getCells();
for (int c = 0; c < cells.getCount(); c++) {
    Cell cell = cells.get(c);
    if (cell.isFormula() && cell.isErrorValue()) {
        System.out.println(cell.getName() + ", error value: " + cell.getStringValue());
    }
}

Output:

E11, error value: #N/A
Y19, error value: #N/A
Z19, error value: #N/A
AB19, error value: #N/A
AC19, error value: #N/A
AD19, error value: #N/A
AE19, error value: #N/A

Source workbook: input.zip (907.9 KB)

Please not that calculation in Excel does not produce any errors.

Kind regards,
Taras

2

This seems to be a regression introduced in Aspose Cells for Java, version 22.2.

When using version 22.1, no errors values are reported using the sample code and workbook above.

3

@TarasTielkes,

Thanks for the template file.

Please notice, I am able to reproduce the issue as you mentioned by using your template file. I found Aspose.Cells formula calculation engine produces “#N/A” values for certain cells. I have logged a ticket with an id “CELLSJAVA-44796” for your issue. We will look into it soon.

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

4

Hi @Amjad_Sahi,

Thank you for the confirmation.

From our side, we’d be interested in knowing which particular part of the formula the bug relates to, in order to decide how to work around the problem, until the release containing the fix is available.

Kind regards,
Taras

5

@TarasTielkes,

Please spare us little time to evaluate your issue in details first. Then, we could share an update or devise some workaround (if applicable/available) to cope with it for the time being.

1 Like
6

@TarasTielkes,

This is to inform you that your issue has been resolved now. The fix will be included in the next official release (Aspose.Cells v22.8) which is scheduled to be released in the second week of August 2022. You will also be notified when the next version is published.

Please note, we found there was a bug of rounding up decimal values. For some special values, if they were used in formulas with ROUNDUP function, the calculations were giving incorrect results. We have corrected the issue now.

7

The issues you have found earlier (filed as CELLSJAVA-44796) have been fixed in this update. This message was posted using Bugs notification tool by Peyton.Xu