Apache OpenOffice (AOO) Bugzilla – Issue 61781
Pasting from the clipboard on an unprotected cell makes it protected
Last modified: 2017-05-20 11:11:33 UTC
When I copy text information from a web page and paste it in an unprotected cell of a protected spreadsheet, the cell becomes protected automatically. When I paste it by pressing Ctrl+Shift+V and selecting "Unformatted Text" the problem does not happen. As an example, take the attached spreadsheet protected-cell.ods. It's protected with password "123". All cells but A1 are protected. Go to http://openoffice.org/, select the words "free office suite" (any other frase should do), and copy it into the clipboard by pressing Ctrl-C. Then open the protected-cell.ods spreadsheet, click on the A1 cell and press Ctrl-V to paste the contents of the clipboard. Try to modify the contents of the A1 cell and notice that it became protected. Repeat the process but instead of pasting with a Ctrl-V, do it with Ctrl-Shift-V and select "Unformatted Text". This way the cell doesn't become protected.
Created attachment 33947 [details] Paste your information in editable cell (B9). The password is "1"
Hi Niklas, using the document and pasting a simple sting results in an protected cell and a broken merged cell. Please have a look at this one. Frank
About the first problem: If you modify the "Default" style (unchecking "Protected" option) the problem does not happen. The Calc copy this style (Default) to cell when the formatted content is pasted.(?) Daniel FL
Changing target (last integration for 2.0.3 is over).
retarget 2.x -> 3.x
Reset assigne to the default "issues@openoffice.apache.org".