Bug Hunting Session
Bug 48762 - FORMATTING: Pasting rich text into unprotected cell changes the cell to protected
Summary: FORMATTING: Pasting rich text into unprotected cell changes the cell to prote...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Paste Cell-Protection
  Show dependency treegraph
Reported: 2012-04-16 02:15 UTC by karaluh
Modified: 2019-02-07 16:00 UTC (History)
3 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 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: Build ID: f511a2915ed856f048fd7dd91fd9f7537b1e0479

* 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,
Comment 2 QA Administrators 2015-07-18 17:43:00 UTC Comment hidden (obsolete)
Comment 3 Buovjaga 2015-10-17 12:33:00 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2015-10-22 09:40:48 UTC
Still repro on Linux.

Build ID: Arch Linux build-3
Locale: fi-FI (fi_FI.UTF-8)
Gnome Shell 3.18.1
Comment 5 QA Administrators 2017-01-03 19:41:34 UTC Comment hidden (obsolete)
Comment 6 Timur 2017-01-04 08:37:03 UTC
Reproduced with any rich text, like bold and italic from another spreadsheet.
Comment 7 Timur 2019-02-07 16:00:50 UTC
Repro 6.3+.