[Bug 136003] PROTECT SHEET: Can't delete rows, despite of allow to deletes

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136003

--- Comment #13 from Sahil Gautam <me.sahilgautam at gmail.com> ---
There is no easy way to unprotect all the cells of a sheet. So the user has to
go the long way, select all the cells, then right click > format cells > cell
protection, and then uncheck. That too works only when the sheet is empty
(doesn't have anything in any cell).

Test it like this
create an empty sheet, then check cell protection for all the cells by
selecting all, then right click > format cells > cell protection (protected by
default). uncheck it, and then check if protection is turned off for all the
cells or not, by going to random cells and checking cell protection. (it works
for empty sheet i.e. you would be able to unprotect all the cells.)

then again close this sheet and create a new sheet, write something in some
cells (say 1 2 3 4 5 6 in the first 6 cells of column A). Then go ahead and try
to unprotect all the cells again using the same method above. It doesn't work. 

So there is a need to have a button (or something similar) which can toggle
cell protection for either the whole sheet, or the selection. (I don't know if
there is any).

And Excel doesn't allow deleting rows with protected cells, so I think would be
better to keep the behaviour consistent with it. (I mean it might be a big deal
for some people)

-- 
You are receiving this mail because:
You are on the CC list for the bug.