Issue 123703

Summary: Selectable locked cells after rebooting with “No Select locked cells” option
Product: Calc Reporter: papayes <jyl44>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: bart.bremmers, bkfallert, elish, fbarcellona, gurus.knugum, hanya.runo, issues, marcelly.bernard, rainerbielefeld_ooo_qa, tommym.carver
Version: 4.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.3
Developer Difficulty: ---
Description Flags
Not allow Select locked cells.ods none

Description papayes 2013-11-18 08:50:14 UTC
Created attachment 81949 [details]
Not allow Select locked cells.ods

with AOO 4.0.1 US or French version, Windows, MacOsX, Linux DEB or RPM
not with LibO 4
After securing a sheet with the option not to allow: Select locked cells.
At the reopening of the file, they can be selected (but not be copied or edited thankfully).
1. Selecting the set of the sheet:
2. Format > Cells... > Format Cells > Cell Protection tab: Check the check to Protected
3. Selecting cells unprotect
4. Format > Cells...> Cell Protection: Uncheck Protected
5. Tools> Protect Document> Sheet ...
6. Uncheck the Enable option: Select locked cells
7. OK, check the selection of non-protected cells, save the document and close Calc
8. At the opening, the selection is possible, even if the writing is impossible. 

Note : With or without a password 

Comment 1 Edwin Sharp 2013-11-18 16:12:58 UTC
Locked cells can be selected.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Comment 2 Bart 2014-03-11 21:23:24 UTC
Behavior is confirmed here as of Mar 11 2014. I am using oo 4.0.1 Windows 7 64bit.
Un-checking "Select Locked Cells" only works until you close the document. Re-opening the document you can select all cells.
It is a great feature for distributed spreadsheets with many users, I look forward to the fix.
Thank you.
Comment 3 Rainer Bielefeld 2014-04-16 06:22:46 UTC
Version has been modified erroneous, so back to old version
Comment 4 Rainer Bielefeld 2014-04-16 06:23:48 UTC
New feature in AOO 4.0.0, never worked correctly in an official build.

Filesave problem? Fileopen problem? Something else?
Comment 5 bmarcelly 2014-05-29 07:25:48 UTC
The "Select locked cells, Select unlocked cells" items are not described in the help pages on sheet protection.

I could not find an API concerning this "feature". The consequence is that when you unprotect/reprotect a sheet you will also allow to select all cells.
Comment 6 hanya 2014-05-29 07:53:12 UTC
The function was enabled by issue 119552.
Comment 7 Johnny Rosenberg 2014-11-09 22:28:26 UTC
I was just going to create a bug report about this, but I found this one first, fortunately…

Same thing happens here. After reloading the file, cells that are not supposed to be selectable can be selected.

Apache OpenOffice 4.1.1.
AOO411m6(Build:9775)  -  Rev. 1617669
2014-08-13 09:23 - Linux i686

Operating system: Ubuntu 14.04.

A fix would be much appreciated.
Comment 8 j.nitschke 2015-12-21 03:58:11 UTC
*** Issue 126750 has been marked as a duplicate of this issue. ***
Comment 9 j.nitschke 2015-12-21 04:00:15 UTC
*** Issue 126271 has been marked as a duplicate of this issue. ***
Comment 10 j.nitschke 2015-12-21 11:55:56 UTC
seems this option was only implemented for excel compatibility

can't find anything in the opendocument specs

maybe it's possible to show this option only for excel files
at least put a note in the help
Comment 11 Frank Barcellona 2015-12-21 15:09:27 UTC
I really like this option.  I hope there will be a fix for it.
Comment 12 orcmid 2015-12-27 04:17:10 UTC
(In reply to j.nitschke from comment #10)
> seems this option was only implemented for excel compatibility
> can't find anything in the opendocument specs
> html#element-table_table
> maybe it's possible to show this option only for excel files
> at least put a note in the help

The OpenDocument specification does not address user-interface provisions.  

The implementation of such features would be by entries in a package's settings.xml <office:document-settings> element.  This provides implementation-settings that apply to a document. 

One problem with using settings.xml in this case is that such protection is set at the sheet level, not the document level.  The convenient way to handle that would be with an extension that defines a couple of attributes about sheet-level selections in the <table:table> element of the sheet that the options apply to.

I created a sheet with selection not permitted for protected cells and it has no effect when the document is reloaded after being saved.  The same is apparently true for LibreOffice.  There is no indication about protection in the settings.xml file and the <table:table> element for a protected sheet does have a table:protected="true" attribute but nothing else.

This is a definite defect, since there is a way to handle it with ODF although it will not be recognized by software that does not recognize OpenOffice-specific settings in an .ods.  It would be very strange to have this be effective only when saving the document in .xls format.
Comment 13 mroe 2017-09-07 09:06:40 UTC
*** Issue 127532 has been marked as a duplicate of this issue. ***