Bug 88160 - EDITING and FILESAVE and UNSHARING of sheet is not possible, file with password
Summary: EDITING and FILESAVE and UNSHARING of sheet is not possible, file with password
Status: RESOLVED DUPLICATE of bug 56173
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium major
Assignee: Not Assigned
Depends on:
Blocks: Password-Protected
  Show dependency treegraph
Reported: 2015-01-07 15:12 UTC by chris
Modified: 2022-07-18 11:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

simple test file (11.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-08 12:41 UTC, chris

Note You need to log in before you can comment on or make changes to this bug.
Description chris 2015-01-07 15:12:39 UTC

Comment 1 raal 2015-01-07 15:25:27 UTC
Please explain more what do you mean. You can not uncheck Tools - Share Document?
Comment 2 chris 2015-01-07 15:29:45 UTC
I have a simple spreadsheet that contains data only (no calculations). I set the spreadsheet as shared.

I can open the spreadsheet and edit cells, but any attempt to save the sheet either by hitting the save button or (on closing the window) by selecting save from the "save before closing" pop-up window simply fails. So I can't edit and save the sheet.

I've attempted to unshare the sheet by unselecting the "share this spreadsheet ......" button under the Tools/Share Document button, but this fails so I cannot unshare the document. I suspect the "share" may have some connection to the inability to save changes to the sheet.
Comment 3 raal 2015-01-07 22:29:42 UTC
I can not confirm with LO 4.3.3, Ubuntu

Can you reproduce with new file? Is path where the file is saved writable?
After uncheck "Share Document" calc save document, so if Calc can not save file probably don't uncheck "share doc".
Comment 4 chris 2015-01-08 12:41:22 UTC
Created attachment 111955 [details]
simple test file

Sequence followed for creating the file was :

1. New file
2. Name and save empty file
3. Enter text in file
4. "Save as" same file name with password 123456
5. Share file
6. Try to save file. Doesn't save using "save" button, File/Save, or closing window and selecting save from dialogue
7. Close file unsaved from dialogue
8. Re-open file - file is now marked as shared
9. Add text in cell C1 (or make no change to file)
10. Can't uncheck shared button under Tools/Share Document
11. Can't save file (with or without change to file)
Comment 5 chris 2015-01-08 12:44:17 UTC
This was on Debian not Ubuntu.

File is writeable as shown above.
Comment 6 raal 2015-01-08 15:33:33 UTC
I can confirm with LO 4.3.3, with Version:
Build ID: 1b9bcc2e7f31e880e71c8d2a2aaf1b2839d4d32a
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-12-14_15:56:02 , 
with version Version:
Build ID: 6db4dfae163753dfa1724120c5e235274559bcf0
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2014-12-31_02:11:39, 
with Version:
Build ID: 7f476fea47f06a7f8cc961dd4f6595a524346fa5
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-27_23:36:28
Comment 7 QA Administrators 2016-01-17 20:04:56 UTC Comment hidden (obsolete)
Comment 8 chris 2016-01-18 14:54:51 UTC
Confirming that using version on Debian testing the bug still exists and behaviour is unchanged.
Comment 9 QA Administrators 2017-03-06 14:33:37 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2019-12-03 14:29:11 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2022-04-27 04:01:49 UTC Comment hidden (obsolete)
Comment 12 Gabor Kelemen (allotropia) 2022-07-18 11:31:16 UTC

*** This bug has been marked as a duplicate of bug 56173 ***