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

Free Support Forum - aspose.com

CalculateFormula results in a NullPointerException


we are using Aspose Cells for Java (Version 17.6) and it seems that there is sometimes a serious problem when calculateFormula() is used.
In this example a NullPointerException will be thrown.

workbook = new Workbook(sourceFileName);
workbook.calculateFormula(); --> NPE

I have added a file to reproduce the problem. Test CaclulateFormula.zip (32.7 KB)

Thanks a lot.

Best regards,
Matthias Schlosser


We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42689 - NullPointerException exception raised while calling the CalculateFormula


This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Perfect. Thanks a lot.

Best regards


Please try our latest version/fix (attached): Aspose.Cells for Java v18.7.5:

Your issue “CELLSJAVA-42689” should be fixed in it.

Let us know your feedback.
Aspose.Cells for Java v18.7.5.zip (6.3 MB)


It works fine. Thanks a lot.

Best regards


You are welcome.

The issues you have found earlier (filed as CELLSJAVA-42689) have been fixed in Aspose.Cells for Java 18.8. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: https://docs.aspose.com/display/cellsjava/Installation

This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi