Bug 100433 - Shared document status lost when saved as XLSX
Summary: Shared document status lost when saved as XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2016-06-16 16:15 UTC by Dan
Modified: 2022-09-08 14:14 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:
Regression By:

ODS with shared status (10.42 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2016-10-06 11:22 UTC, Buovjaga
Equivalent feature in Excel (27.25 KB, image/png)
2022-09-08 14:14 UTC, Gabor Kelemen (allotropia)

Note You need to log in before you can comment on or make changes to this bug.
Description Dan 2016-06-16 16:15:48 UTC
/Tools/Share Document, check "share document with other users", ok

If file is originally .ods with "shared document" enabled, saving as XLSX loses the shared status.

If file is originally .xlsx, the shared status is lost when the document is closed;  also, any saving of the document while open (where it claims as shared), tries to save as non-shared and asks to merge manually with original "shared" document, which is the document open...
Comment 1 Buovjaga 2016-06-18 19:35:46 UTC

Arch Linux 64-bit, KDE Plasma 5
Build ID: c13f60e7cd18df6b0ab70289f5b91ee01e4ae126
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on June 18th 2016
Comment 2 Bartosz 2016-10-06 11:07:31 UTC
Could you please attach some .xlsx and .odt documents on which it is possible to reproduce this issue?
Comment 3 Buovjaga 2016-10-06 11:22:05 UTC
Created attachment 127839 [details]
ODS with shared status

Save this as XLSX and observe the title bar drop (shared)
Comment 4 Buovjaga 2016-10-06 11:23:45 UTC
Then you can set the XLSX to shared mode and try saving it.

You will get an error dialog:

This spreadsheet is no longer in shared mode.

Save your spreadsheet to a separate file and merge your changes to the shared spreadsheet manually.
Comment 5 QA Administrators 2021-02-25 04:08:32 UTC Comment hidden (obsolete)
Comment 6 Roman Kuznetsov 2021-03-02 14:34:22 UTC
Still repro in

Version: (x64) / LibreOffice Community
Build ID: af64bc49d872d8a040d66387303def98eae5cd51
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded
Comment 7 Justin L 2022-09-08 13:49:58 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2022-09-08 14:02:05 UTC
(In reply to Justin L from comment #7)
> Is this really something that MS Formats know about? Is this a Microsoft
> thing, or is it a LibreOffice-only feature?

I only found this, already deprecated, feature: https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534

Replaced by https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104
Comment 9 Gabor Kelemen (allotropia) 2022-09-08 14:14:08 UTC
Created attachment 182309 [details]
Equivalent feature in Excel

(In reply to Justin L from comment #7)
> Is this really something that MS Formats know about? Is this a Microsoft
> thing, or is it a LibreOffice-only feature?

Yes, there is something similar in Excel. I recall people were using this feature and place files on Sharepoint servers (maybe it works on simpler services like smb too) to have collaborative shared editing of spreadsheets.