[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

Buovjaga <ilmari.lauhakangas at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|difficultyInteresting,      |needsUXEval
                   |easyHack                    |
                 CC|                            |ilmari.lauhakangas at libreoff
                   |                            |ice.org,
                   |                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org
             Status|ASSIGNED                    |NEW

--- Comment #11 from Buovjaga <ilmari.lauhakangas at libreoffice.org> ---
(In reply to Sahil Gautam from comment #8)
> * The Real Bug
> This bug "Delete Rows/Delete Columns disabled even when checked in the
> Protect Sheet dialog box" is not a bug in
> itself, but is a consecuence of all cells being protected by default.
> Deleting rows/columns is not allowed,
> even when it is checked in the Protect Sheet dialog box, if the cells are
> protected. This is what the code says, and
> what the release notes say
> https://wiki.documentfoundation.org/ReleaseNotes/5.4#Calc, and what the
> Buovjaga said
> in  https://bugs.documentfoundation.org/show_bug.cgi?id=43535. And tdf#43535
> has been solved.
> 
> This issue can simply be solved by making all cells unprotected by default
> in calc sheet.

Good catch! In bug 43535 comment 14 Kohei says about inserting "I took that
behavior from how Excel handles it". I just tested with online Excel and the
deletion behaves the same way with the same protection options.

So yeah, maybe UX team can think about how to convey this better to users.

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