Apache OpenOffice (AOO) Bugzilla – Issue 126271
Disabling of locked cell selection not working correctly
Last modified: 2017-05-20 09:52:57 UTC
I have a spreadsheet where I need to restrict cell movement to only the unprotected cells. When protecting the sheet, I deselect the option for allowing the user to select locked cells. Initially, all works as expected. The cursor only moves among the unprotected cells. If I click on a protected cell with the mouse, the cursor will not move to that cell. However, if I close the spreadsheet, then reopen it, I can select locked cells. The locked cells still cannot be modified, but if I use the mouse, I can move the cursor to locked cells. I have tested this on Windows and Mac.
(In reply to bfallert from comment #0) However, if I close the spreadsheet, then reopen it, I can select locked > cells. The locked cells still cannot be modified, but if I use the mouse, I > can move the cursor to locked cells. I have tested this on Windows and Mac. What format are you saving the spreadsheet in?
same issue for me exactly
*** Issue 126280 has been marked as a duplicate of this issue. ***
According to comment 1, thanks to attach a sample document. Don't forget to provide any information like password if this document is protected.
Created attachment 84713 [details] requested document per request attached is a copy of the offending document
.
(In reply to bruce from comment #5) > per request attached is a copy of the offending document Now, could you provide a step-by-step to reproduce?
No news since +30 days: closed Feel free to provide the step-by-step required. So this Issue may be closed or progressed as necessary - otherwise the issue may be Resolved as Invalid in the future.
Step by step to repeat the issue: Open a new spreadsheet Enter misc. data into a handful of cells Select about half of these cells Go to Format > Cells > Cell Protection Uncheck the Protected option Go to Tools > Protect Document > Sheet Enter and confirm a password Uncheck the Select Locked Cells option You should now only be able to select the unprotected cells in the spreadsheet. You should not be able to select the locked cells. Save the spreadsheet and quit OpenOffice Reopen the spreadsheet Now, you are able to select any cell, which should not be the case. You cannot edit the locked cells, but you should also not be able to select them.
Can confirm the behaviour with AOO 4.1.1 under Ubuntu 64. 1. Simply open the attached document. You can select all cells. 2. Unprotect the sheet. (Tools → Protect Document → Sheet) Now you can edit all cells. 3. Protect the sheet. (Tools → Protect Document → Sheet) Deselect [_] Select locked cells. → [OK] You can only select the unprotected cells. 4. Save the document. 5. Reload the document and goto 1.
duplicate, this bug had already areport *** This issue has been marked as a duplicate of issue 123703 ***