Download it now!
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: 2019-02-25 18:16 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

ODS with shared status (10.42 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2016-10-06 11:22 UTC, Buovjaga

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.