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

Free Support Forum - aspose.com

Another array-formula bug

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.