We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Array formula evaluation problem

We recently purchased Aspose Cell for Java but ran into a problem with Array formula’s

wb.calculateFormula() results in a different result (#N/A) compared to the Excel value.

In the attached example cell A1 contains an Array Formula, which is evaluated to a proper value on Excel, but a #N/A value by Aspose Cells for Java version 21.8

example.zip (8.2 KB)
image.png (20.2 KB)
image.png (162.0 KB)

We have logged the issue as “CELLSJAVA-43758” in our database for investigations. Once we will have some news for you, we will update you in this topic.

Please try the latest fix:
aspose-cells-21.8.5-java.zip (7.4 MB)

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