Bug 48762

Summary:	FORMATTING: Pasting rich text into unprotected cell changes the cell to protected
Product:	LibreOffice	Reporter:	karaluh <karaluh>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	christopher.m.penalver
Version:	3.4.5 release
Hardware:	x86 (IA32)
OS:	Linux (All)
Whiteboard:	BSA
i915 platform:		i915 features:

Description karaluh 2012-04-16 02:15:06 UTC

Steps to reproduce:
1. Unprotect cell
2. Protect sheet
3. Paste the text "Fast, secure and stylishly simple," from ubuntu.com into the unprotected cell.

Current behavior:
Cell becomes protected.

Expected behavior:
Cell stays unprotected. See also https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/704789

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:11.0) Gecko/20100101 Firefox/11.0

Comment 1 Jorendc 2014-07-04 08:47:45 UTC

Reproducible, tested using Linux Mint 17 x64 with LibreOffice Version: 4.4.0.0.alpha0+ Build ID: f511a2915ed856f048fd7dd91fd9f7537b1e0479

Steps:
* Open Calc
* Right click on Cell A1 > Format Cells...
* Tab 'Cell Protection' > uncheck 'Protected' > OK
* Right click on the sheet1 tab > Protect Sheet...
* Enter a password and click OK

* From http://www.ubuntu.com/ copy 'Open source, OpenStack software and tools for private and public clouds.'
* In Calc select cell A1 > Ctrl+V to paste

Behavior: try to right click on A1. It only has the context menu of a protected cell. If you unprotect the sheet again, and go again to the 'Cell protection' (steps above) you'll see the 'Protection' is checked again.

Kind regards,
Joren

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.