Issue 61781 - Pasting from the clipboard on an unprotected cell makes it protected
Summary: Pasting from the clipboard on an unprotected cell makes it protected
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-02-08 12:41 UTC by danielfl
Modified: 2017-05-20 11:11 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Paste your information in editable cell (B9). The password is "1" (6.32 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-02-08 12:52 UTC, danielfl
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description danielfl 2006-02-08 12:41:05 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, 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.
Comment 1 danielfl 2006-02-08 12:52:55 UTC
Created attachment 33947 [details]
Paste your information in editable cell (B9). The password is "1"
Comment 2 frank 2006-02-08 13:13:40 UTC
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.

Comment 3 danielfl 2006-02-09 12:30:13 UTC
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
Comment 4 niklas.nebel 2006-05-11 10:17:36 UTC
Changing target (last integration for 2.0.3 is over).
Comment 5 niklas.nebel 2007-12-04 18:07:14 UTC
retarget 2.x -> 3.x
Comment 6 Marcus 2017-05-20 11:11:33 UTC
Reset assigne to the default "".