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)
@hbatteram,
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.
@hbatteram,
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