Workbook setting "ReCalculateOnOpen" not persisted

Aspose.Cells Product Family
1

Using Aspose Cells for Java, version 19.1.

Sample code:

System.out.println(CellsHelper.getVersion());
Workbook workbook = new Workbook();
workbook.getSettings().setReCalculateOnOpen(false);
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
cells.get("A1").setValue(2);
cells.get("A2").setValue(3);
cells.get("A3").setFormula("A1*A2");
workbook.save("saved-by-aspose.xlsx", SaveFormat.XLSX);

Workbook loaded = new Workbook("saved-by-aspose.xlsx");
System.out.println(loaded.getSettings().getReCalculateOnOpen());

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

Kind regards,
Taras

2

@TarasTielkes,

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
3

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,
Taras

4

@TarasTielkes,

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

5

@TarasTielkes,

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.

6

@TarasTielkes,

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)

7

Hi @Amjad_Sahi,

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

Kind regards,
Taras

8

@TarasTielkes,

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

9

@TarasTielkes,

It was the issue of opening XLSX file.

10

@Amjad_Sahi,

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

Kind regards,
Taras

11

@TarasTielkes,

You are welcome.

12

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