Cells.Workbook.settings.shared flag on default shared template

Aspose.Cells Product Family
1

Hi!
Aspose.Cell for .net 17.10, 17.11, 18.7
MS Office 365.

How to change workbook.Settings.Shared flag on shared template by default?
If loaded xlsx template shared by default Shared flag can’t be changed. If the template is unshared by default - everything works great.
Snippet:
_workbook = new Workbook(path, loadOptions)
_workbook.Settings.Shared = false (or true).

Furthermore, some of properties can be changed, another - not.
For ex the value of Shared, RemovePersonalInformation can’t be changed while ShowTabs, FirstVisibleTab are changeble.

2

@De_Yuree,

The Boolean attribute WorkbookSettings.Shared is not read-only so you can get or set the property. Please try latest version/fix, Aspose.Cells for .NET 23.10

If you still find the issue with latest version, kindly zip and attach sample Excel files and sample code to reproduce the issue, we will check it soon.

3

Please, see attachments.
Checked on versions Aspose.Cells 17.0, 18.7.

There are two primitive templates 5.png (95.0 КБ).
Only one difference is shared attribute. With shared template changing Shared prop doesn’t have any effect. BTW not only Shared property unavailible for changing but not all of them (the logic is not clear what of props are changable)!
6.PNG (234.5 КБ)
When template is unshared properties can be changed as expected.
7.PNG (233.9 КБ)

4

@De_Yuree
By creating sample files and testing with the latest version, we can reproduce the issue. Discovered that the template still remains in the shared state after setting Workbook.Settings.Shared to false. Please refer to the attachment (21.4 KB).

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-54387

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

5

@De_Yuree
As an alternative, you can call the Workbook.AcceptAllRevision() method after setting Workbook.Settings.Shared to false. The state can change normally.

The sample code as follows:

Workbook book = new Workbook(filePath + "Test1_shared.xlsx");
book.Settings.Shared = false;
book.AcceptAllRevisions();
book.Save(filePath + "out.xlsx");
6

Thanks,
book.AcceptAllRevisions() tested and it works as expected.

7

@De_Yuree,

It’s good to know that the suggested code segment works for your needs. You may use this workaround for the time being until we fix the issue.

8

@De_Yuree,

We are pleased to inform you that your issue ("logged earlier as “CELLSNET-54387”) has been resolved, so you won’t require a workaround. The fix will be included in our upcoming release (Aspose.Cells v23.11), which we plan to release next month in the first half of November. You will be notified when new versions are released.

9

The issues you have found earlier (filed as CELLSNET-54387) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi