[Libreoffice-bugs] [Bug 141913] New: Bypass cell protection selection

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141913
           Summary: Bypass cell protection selection
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: olivier.hallot at libreoffice.org
            Blocks: 107450

Created attachment 171416
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171416&action=edit
Sample file that shows how to bypass protected cell selection

Assuming that you are not to be allowed to set your cursor in the protected
cell range if option "Select protected cells" is unchecked.

1) When it is unchecked, cursor movements to enter the protected range is
forbidden: OK

2) Click on a protected cell will NOT place the cursor at the desired place: OK

3) Type a range reference inside the protected area in the Name box (upper
left). The range is selected, copy action is possible. NOT OK. 


In the sample file attached, the orange range is protected and selection not
allowed (no password). 
Insert A1:A10 in the Name box to get the range A1:A10 selected anyway. Copy and
paste elsewhere to have the contents copied (with the protect flag enabled, by
the way).


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107450
[Bug 107450] [META] Cell and sheet protection bugs and enhancements
-- 
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/20210426/3b3612d7/attachment.htm>