Calculation difference compared with Excel 365

Aspose.Cells Product Family
1

Hi,

Using Aspose Cells for Java, version 25.4.

First, the attached workbook is re-calculated in Excel 365, using CTRL+ALT+F9.

When recalculating the workbook with Aspose Cells 25.4, at least one of the cells changes to a different value.

Sample code:

Workbook workbook = new Workbook("input.xlsb");
Worksheet worksheet = workbook.getWorksheets().get("Validations");
Cells cells = worksheet.getCells();
Cell cell = cells.get("E1483");

System.out.println("before: " + cell.getValue());
workbook.calculateFormula();
System.out.println("after: " + cell.getValue());

For the cell in question, Excel calculates to TRUE, while Aspose Cells calculates to FALSE

Kind regards,
Taras
input.zip (406.0 KB)

2

@TarasTielkes
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-46362

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@TarasTielkes,

This is to inform you that your issue (Ticket ID: “CELLSJAVA-46362”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v25.6) scheduled for release in the first half of June 2025. We will notify you when the next version is released.

4

@amjad.sahi Thank you for the update.
Our of curiosity, in which area of the code was the bug?

5

@TarasTielkes,

There was an bug with formula calculations of MATCH function with INDEX function as lookup array. Moreover, we fixed an issue with calculations of SUM with cached 2D range (when there is only one row of data) which was producing incorrect results.

6

The issues you have found earlier (filed as CELLSJAVA-46362) have been fixed in Aspose.Cells for Java 25.6.