Bug 102162 - FORMATTING: Protected cell can be unprotected copy pasting them to a new document
Summary: FORMATTING: Protected cell can be unprotected copy pasting them to a new docu...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.7.2 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Protection
  Show dependency treegraph
 
Reported: 2016-09-13 15:51 UTC by michele
Modified: 2017-07-05 21:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with one protected cell and the rest not protected are not selectable. Password is blank. (6.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-09-13 15:51 UTC, michele
Details

Note You need to log in before you can comment on or make changes to this bug.
Description michele 2016-09-13 15:51:35 UTC
Created attachment 127299 [details]
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.
Comment 1 Buovjaga 2016-10-26 16:23:26 UTC
Repro.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.2.2.2.0+
Build ID: 5.2.2-1
CPU Threads: 8; OS Version: Linux 4.7; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Comment 2 Timur 2017-01-04 09:33:43 UTC
Per https://help.libreoffice.org/Calc/Protecting_Cells_from_Changes this might be enhancement and is formally not considered a bug, although it is in the nutshell. 
But the problems stems from the possibility to select "unchecked" cells (protected or unprotected) at all, either single protected cell or the whole sheet with Edit-Select All.
So this bug should not be "protected cells can be copied" but "cells marked as not selectable should not be selected".