Free Support Forum - aspose.com

Invalid calculation result for UNIQUE() function

Hi,

Using Aspose Cells for Java, version 21.2.

Sample code:

Workbook workbook = new Workbook("input.xlsx");
workbook.calculateFormula();
Cell cell = workbook.getWorksheets().get(0).getCells().get("C1");

System.out.println(cell.isErrorValue());
System.out.println(cell.getValue());

The output of above code for the attached input workbook is:

true
#NAME?

Opening the workbook in Excel 365 does not show any issues or formula evaluation errors.

Kind regards,
Taras

input.zip (7.8 KB)

@TarasTielkes,
We have observed this issue and logged it in our database for further investigation. We will notify you here once any update is ready for sharing.

This issue is logged as:
CELLSJAVA-43400 - Invalid calculation result for UNIQUE() function

@TarasTielkes,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Please try the latest fix v21.2.5:
aspose-cells-21.2.5-java.zip (7.2 MB)

Hi @johnson.shi,

The 21.2.5 version does indeed resolve the issue reported.

Thank you,
Taras

@TarasTielkes,

Good to know that you are up and running again with the new fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.