TEXTJOIN() function results inconsistent with Excel

Aspose.Cells Product Family
1

Hi,

Using Aspose Cells for Java, version 24.8.

Sample code:

Workbook workbook = new Workbook("calculation.xlsx");
Worksheet worksheet = workbook.getWorksheets().get("Calculation Name");
Cells cells = worksheet.getCells();

System.out.println("before recalc");
System.out.println("A1: " + cells.get("A1").getValue());
System.out.println("A2: " + cells.get("A2").getValue());
System.out.println("A3: " + cells.get("A3").getValue());
workbook.calculateFormula();
System.out.println("after recalc");
System.out.println("A1: " + cells.get("A1").getValue());
System.out.println("A2: " + cells.get("A2").getValue());
System.out.println("A3: " + cells.get("A3").getValue());

This gives the following output:

CellsHelper.getVersion() = 24.8.0
before recalc
A1: 
A2: 
A3: 
after recalc
A1: 
A2: ,
A3: ,

As you can see, for cells A2 and A3, the result produced by recalculating in Aspose differs from the result produced by Excel.

Kind regards,
Taras

calculation.zip (7.6 KB)

2

@TarasTielkes,

Thanks for the template XLSX file.

After an initial test, I am able to reproduce the issue as you mentioned by using your template XLSX file. I found TEXTJOIN() function results are inconsistent with MS Excel.

We require thorough evaluation of the issue. 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-46105

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
We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells for Java v24.9) that we plan to release in the first half of September 2024. You will be notified when the next version is released.

4

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