Bug 51181 - Pasting from data source changes cell protection
Summary: Pasting from data source changes cell protection
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.4 release
Hardware: Other All
: medium minor
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Paste Cell-Sheet-Protection
  Show dependency treegraph
Reported: 2012-06-17 13:57 UTC by Thomas Nilefalk
Modified: 2018-02-22 16:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Nilefalk 2012-06-17 13:57:05 UTC
Problem description: 
Data copied from a data source changes protection of cells when pasted.

Steps to reproduce:
1. Press F4 to open datasources and select one
2. Protect some cells and leave other cells unprotected
3. Protect the table/spreadsheet
4. Select all data from the data source and paste it in the unprotected cells

Current behavior:
The cells that were unprotected as become uneditable.

Expected behavior:
The cells maintain their unprotected state.

Platform (if different from the browser): 
Browser: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.56 Safari/536.5
Comment 1 bfoman (inactive) 2013-01-18 13:06:19 UTC
Confirmed with:
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

After pasting some biblio database records into unprotected cells they became uneditable and I got a warning "Protected cells can not be modified" error.
Comment 2 Alex Thurgood 2015-01-03 17:39:46 UTC Comment hidden (no-value)
Comment 3 QA Administrators 2017-01-03 19:37:09 UTC Comment hidden (obsolete)
Comment 4 Timur 2017-01-04 09:12:13 UTC
I can't reproduce this in any version. Maybe there's some finesse about "Select all data from the data source and paste it in the unprotected cells".
Comment 5 Timur 2018-02-22 16:54:50 UTC
I'll mark as Invalid. Could be a duplicate of See Also.