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

            Bug ID: 102162
           Summary: FORMATTING: Protected cell can be unprotected copy
                    pasting them to a new document
           Product: LibreOffice
           Version: 4.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: michele.marr...@studiostorti.com

Created attachment 127299
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127299&action=edit
Spreadsheet with one protected cell and the rest not protected are not
selectable. Password is blank.

Tested on LibreOffice:
Versione: 5.2.0.4
Build ID: 066b007f5ebcc236395c7d282ba488bca6720265
OS: Ubuntu 14.04

Version: 4.4.7.2
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
OS: Ubuntu 14.04

Problem description:
Many user expect that by protecting cells by unflagging options "Select
protected cells" and "Select unprotected cells" cells can not be selected, and
copy-pasted. It is not the case if you click in the intersection between Column
and Raw Headers.


Step by step:
-select cells to be protected;
-tools -> Protect Document -> Sheet;
-Unflag  "Select protected cells" and "Select unprotected cells";
-By clicking the top left corner between A and 1, is possible to select all the
sheet;
-if the selection is copy and pasted into another sheet is possible to edit the
content of protected cells.


Expected behaviour:
If unflag the  "Select protected cells" and "Select unprotected cells" checkbox
I would expect not to be able to select the entire sheet. 

Also I would expect not being able to copy and paste protected cells. 

I am aware of this page
https://help.libreoffice.org/3.6/Calc/Protecting_Cells_from_Changes so this
might not be a bug but a feature request.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to