[Libreoffice-bugs] [Bug 139883] Calc refuses to edit an unprotected cell in a protected worksheet when the selected range includes protected cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

Douglas Boffey <douglas.boffey at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |douglas.boffey at gmail.com

--- Comment #3 from Douglas Boffey <douglas.boffey at gmail.com> ---
Created attachment 169179
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169179&action=edit
Requested test file

1. Created new spreadsheet
2. Right clicked on cell A1 & chose Format cells
3. Went to Cell Protection tab, and deselected 'Protected'.  Clicked OK
4. Clicked Tools > Protect Sheet from the menu
5. OK clicked (no password, 'Select protected cells' & 'Select unprotected
cells' check boxes selected, all others deselected - i.e. keep the defaults)
6. Selected the range A1:B2, with A1 being the active cell
7. Started typing.  The diagnostic 'Protected cells can not be modified.'
appears

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210127/98750fc4/attachment.htm>