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

Free Support Forum - aspose.com

Workbook setting "ReCalculateOnOpen" not persisted

Using Aspose Cells for Java, version 19.1.

Sample code:

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
workbook.save("saved-by-aspose.xlsx", SaveFormat.XLSX);

Workbook loaded = new Workbook("saved-by-aspose.xlsx");

The output for the loaded workbook gives true for the “ReCalculateOnOpen” workbook setting.

Kind regards,


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-42813 - Workbook setting "ReCalculateOnOpen" not persisted

Hi @ahsaniqbalsidiqui,

Thanks for checking. After thinking about the behavior of Aspose Cells 19.1 a bit more, it might also be that the setting is persisted correctly, but not read correctly from the saved file.

Kind regards,


Thank you for sharing more observations. We will consider them while analyzing this issue in detail.


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.


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

Your issue should be fixed in it.

Let us know your feedback.
aspose-cells-19.1.1-java.zip (6.5 MB)

Hi @Amjad_Sahi,

Thanks for the quick fix. Was the bug in the writing of the setting, or in the reading?

Kind regards,


We will provide details on your query “Was the bug in the writing of the setting, or in the reading?” soon.


It was the issue of opening XLSX file.


Thanks for checking. That does make sense of the test results I was getting.

Kind regards,


You are welcome.

The issues you have found earlier (filed as CELLSJAVA-42813) have been fixed in Aspose.Cells for Java 19.2. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi