Bug 106965 - Copy/Paste can bypass cell protection after multiple select of cells or sheets
Summary: Copy/Paste can bypass cell protection after multiple select of cells or sheets
Status: RESOLVED DUPLICATE of bug 96157
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on: 106952
Blocks: Paste Cell-Sheet-Protection
  Show dependency treegraph
Reported: 2017-04-05 08:33 UTC by Jean-Sebastien Bevilacqua
Modified: 2022-09-12 13:25 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Sebastien Bevilacqua 2017-04-05 08:33:33 UTC
When you copy/paste, you can paste in a protected cell.

Steps to reproduce:

- Open calc
- Create a second sheet
- Protect the second sheet
- Copy some random content
- Come back on the first sheet and select both sheets
- Paste content

-> It will bypass protection on the second sheet

This bug affects master and I'm working on it.
Comment 1 Jean-Sebastien Bevilacqua 2017-05-03 15:42:07 UTC
Gerrit patch: https://gerrit.libreoffice.org/#/c/36130/
Comment 2 Timur 2017-05-18 08:09:20 UTC Comment hidden (obsolete)
Comment 3 Jean-Sebastien Bevilacqua 2017-05-18 08:12:06 UTC Comment hidden (obsolete)
Comment 4 Timur 2017-05-18 08:33:28 UTC
*** Bug 96157 has been marked as a duplicate of this bug. ***
Comment 5 Timur 2017-05-18 08:34:54 UTC
From Bug 96157: 
attachment 120897 [details] is Video of the bug:
A1 B1 and D1 are unprotected, but C1 is protected
A2 B2 and D2 are unprotected, but C2 is protected
Clic on A1, Ctrl-Clic on B1 and D1
Sheet protection is enabled with no selection on protected cells.
Move to B2, paste... D2 witch is protected is affected by the paste.
It should not...
Comment 6 Timur 2017-07-18 15:50:38 UTC
This one is marked as "LibreOffice" while I guess it's Calc only. True there are also Writer bugs for protected cells in table but in different bugs. 
Jean-Sebastien, could you review your code and remarks once more? Asking as a non-dev who sees that you tried to solve this issue.
Comment 7 Xisco Faulí 2017-10-19 08:40:24 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2018-11-17 03:47:24 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2020-11-17 05:00:06 UTC Comment hidden (obsolete)
Comment 10 Timur 2022-09-12 13:25:18 UTC
I don't know how I marked duplicate, but I don't repro steps from Description with older LO. So I mark duplicate the other way around.

*** This bug has been marked as a duplicate of bug 96157 ***