Please see AsposeArrayFormulaIssue.7z in https://spideroak.com/browse/share/arcticpenguin/aspose/aspose-bug/
This issue is with cell E183 on sheet Calculations; it calculated differently in Excel vs Aspose. Interesting that removing what should be irrelevant parts of the sheet makes the problem go away.
@andyczerwonka,
Thanks for the sample project with template file.
After an initial test, I am able to reproduce the issue as you mentioned using your sample code with your template file. I have logged a ticket with an id “CELLSJAVA-42380” for your issue. We will look into it soon.
Once we have an update on it, we will let you know here.
Thank you.
@andyczerwonka
Thanks for using Aspose APIs.
This is to inform you that we have fixed your issue CELLSJAVA-42380 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
@andyczerwonka
Please download and try the latest fix and let us know your feedback.
The issues you have found earlier (filed as CELLSJAVA-42380) have been fixed in Aspose.Cells for Java 17.9.