Bug 51181

Summary: Pasting from data source changes cell protection
Product: LibreOffice Reporter: Thomas Nilefalk <thomas>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: minor CC: bfo.bugmail, iplaw67
Priority: medium    
Version: 3.5.4 release   
Hardware: Other   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=48762
https://bugs.documentfoundation.org/show_bug.cgi?id=106965
Whiteboard: BSA
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 102593, 107450    

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:
LO 4.0.0.1
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.