I’m attaching a zip with my gradle project where ive recreated the issue. The resources folder has an excel file with a formula in cell G2 of sheet1: =MROUND(MAX(INDEX(B1:B4,MATCH(E2,A1:A4,0),0),0),1).
When I open the excel file in native excel and press calculate I get 23094723074. When I calculate the formula in aspose using the code in the gradle project I get 2147483647. Please help me reconcile the difference.
aspose_example111124.zip (95.1 KB)
@cwedwards92
By testing with sample files and code on the latest version v24.10, we can reproduce the issue. Found that MROUND formula obtained incorrect value after calling Workbook.calculateFormula method.
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-46170
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.
Thanks John, I will keep an eye out here for any updates on whether you are able to fix the issue.
We will evaluate your issue and try to resolve it soon. Additionally, we will provide you with updates on the issue as they become available.
This is to inform you that your issue (Ticket ID: “CELLSJAVA-46170”) has been resolved. The fix/enhancement will be incorporated in the forthcoming release (Aspose.Cells v24.12), scheduled for the first half of December 2024. You will be notified once the new version is published.
The issues you have found earlier (filed as CELLSJAVA-46170) have been fixed in Aspose.Cells for Java 24.12.
thanks guys looks great our application is producing results in parity with the excel application now
You’re welcome! It’s good to hear that the latest version/fix has resolved your issue. Don’t hesitate to reach out if you have any more questions or feedback.