[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 --- Comment #9 from LeroyG --- (In reply to software.v9onn from comment #8) > Perhaps it would make sense if we have an indicator for protected cells? Protect the spreadsheet, and choose menu View - Value Highlighting: cells protected are shown with gray background. (In reply to software.v9onn from comment #8) > Cell protection should be from column P to AB. In this case, select P1:AB200, and mark as Protected. Rows 201 and downward are protected already. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 --- Comment #8 from software.v9...@slmail.me --- Again wrong. Cell protection should be from column P to AB. No matter which column(s) I choose, I can unprotect it, but not if I choose everything. This is a bug, but I can live with it, now I found out how to unprotect. Perhaps it would make sense if we have an indicator for protected cells? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 --- Comment #7 from software.v9...@slmail.me --- Sorry, the cell protection seems to be from C to AB -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 --- Comment #6 from software.v9...@slmail.me --- Thanks for the quick reply. there is a cell protection, but I forgot which cells. So LeroyG is right, all is protected except A1:AB200. I don't know, how he found the protected area. If I highlight only the protected cells, then I can unprotect it again. But if I choose all cells, it does not unprotect. So if I highlight an area: shouldn't it unprotect everything within the highlighted area? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 LeroyG changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #5 from LeroyG --- (In reply to software.v9onn from comment #0) > The ok button in the protect sheet menu is grayed out when you try to cancel > protection. "Protect" was not yet applied, so if unmarked, there is nothing to accept. Correct behavior. (In reply to software.v9onn from comment #3) > The sheet protection was my misunderstanding: if the check box "protect this > sheet and the contents of the protected cells" is checked, then I thought it > is already protected. So I tried to uncheck it to unprotect. Wrong logic. Yes, the prefilled checkbox could be a bit confusing, but the text points clearly to a future action (Protect), and not to a state (Protected). Compare with menu Sheet - Clear Cells (same that Backspace key). Menu Tools has a checkbox next to Protect Sheet to show if the spreadsheet is already protected. > There is a cell protection. Yes, all the spreadsheet, except A1:AB200. > If you highlight all cells and try to remove the cell protection, it doesn't > work. Unmarking Protected, works for me. Not a bug with: Version: 7.4.3.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 1; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 software.v9...@slmail.me changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 --- Comment #3 from software.v9...@slmail.me --- There is a cell protection. If you highlight all cells and try to remove the cell protection, it doesn't work. I guess this is because there is a matrix formula in it and it may be automatically protected? The sheet protection was my misunderstanding: if the check box "protect this sheet and the contents of the protected cells" is checked, then I thought it is already protected. So I tried to uncheck it to unprotect. Wrong logic. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 raal changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||r...@post.cz --- Comment #2 from raal --- Maybe wrong attachment? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156793] Protect sheet and cell protection cannot be undone
https://bugs.documentfoundation.org/show_bug.cgi?id=156793 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #1 from m.a.riosv --- The attachment has not a protected sheet. Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.