We have reproduced the Aspose calculation error in a small workbook. The problematic workbook is attached as aspose-array-formula-bug.xlsx. A small driver Java program is attached as AsposeArrayFormulaIssue.java.
https://spideroak.com/browse/share/arcticpenguin/aspose/aspose-bug/
When Aspose calculates the workbook, the cell B4 receives the value zero. If we then recalculate the workbook within Excel, the cell receives the value 0.7029. B4 is only one of many cells whose values are not calculated correctly.
This behaviour occurs with Aspose versions 16.12.0 (our production version) and 17.6.0 (the latest release at time of writing).
@andyczerwonka
Thanks for using Aspose APIs.
We were able to observe this issue as per your description and sample code. We have logged this issue in our database for investigation and for a fix. Once, there is some news for you, we will let you know asap.
This issue has been logged as
-
CELLSJAVA-42337 - Aspose.Cells is unable to calculate the value of cell B4 of Calculations worksheet
@andyczerwonka,
This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42337”) now. We will soon provide you the fix after performing QA and incorporating other enhancements and fixes.
Once the fix is available for public use, we will share the Download link here.
Thank you.
@andyczerwonka,
Please try our latest version/fix: Aspose.Cells for Java v17.6.7:
Your issue should be fixed in it.
Let us know your feedback.
Thank you
The issues you have found earlier (filed as CELLSJAVA-42337) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi
The issues you have found earlier (filed as CELLSJAVA-42337) have been fixed in Aspose.Cells for Java 17.7.
The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan