Issue 15146 - Cell protection can be bypassed
Summary: Cell protection can be bypassed
Status: ACCEPTED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2003-06-01 08:51 UTC by ccasteyde
Modified: 2013-08-07 14:38 UTC (History)
3 users (show)

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


Attachments
I created a "quicktest" (6.01 KB, application/octet-stream)
2003-06-03 11:26 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ccasteyde 2003-06-01 08:51:18 UTC
A copy / paste operation of several cells can 
change the contents of protected cells if the paste 
operation overlaps on a protected cell. Operations 
like this should be prohibited. 
 
By the way, cell protection does not protect the 
cell format, only its content (do not know if this is 
a bug however).
Comment 1 Rainer Bielefeld 2003-06-02 15:50:15 UTC
I was not able te reproduce that problem with 1.0.3 german version
WIN98SE.

Reporter, can you attach an example (spreadsheet) and a more detailled
description how to reproduce the problem?

Rainer
Comment 2 Rainer Bielefeld 2003-06-03 06:19:04 UTC
I received some more information from the reporter by email:

This is not a calc bug. This is a writer bug. Calc does everything right,
so you cannot reproduce it. However, if you do the following
(sorry for the translations, I'm not sure since I use a French version):

Start OpenOffice <b>Writer</b>
In the new document, insert an array (CTRL+F12)
Select 4 columns and 3 rows for instance
Type 1 2 3 nothing on the first line,
Type 0 5 6 nothing on the second
Right click on the 6, Protect the cell
Then select the first three items of the first line,
Copy,
Go to the first cell of the second line (wher there is 0),
Past it.

The 6 is replaced by 3, protection bypass.

In calc, you must activate the document/sheet protection.
In writer, you cannont, as soon as you protect a cell,
you cannot modify it... unless you overwrite it with copy / paste.

Therefore a protection check is missing in writer.

Yours,

CC
Comment 3 Rainer Bielefeld 2003-06-03 06:27:58 UTC
Now I can confirm the problem with 1.0.3 german version WIN98SE
(sorry that I did not read Christian's component-entry)

I reproduced as described by Christian, and the "6" was replaced by
the "3", which now was "protected" (I can not delete or replace it in
the cell).

I do not think that this might be a feature, it is a bug.

So status should be NEW (I have no rights to change status)

Rainer
Comment 4 Rainer Bielefeld 2003-06-03 11:26:58 UTC
Created attachment 6612 [details]
I created a "quicktest"
Comment 5 jensja 2003-06-04 01:23:06 UTC
Duplicated with OOo1.1beta2 on windows 2000.
Confirming.

@Rainer: Have you considered joining the QA team?

Jens
Comment 6 h.ilter 2003-06-04 11:08:23 UTC
Reassigned to MRU
Comment 7 michael.ruess 2003-06-04 13:43:04 UTC
MRU->DVO: The cell protection can be bypassed by using the clipboard.
Take the attachment; there select the first row and copy to clipboard.
Go to cell A2, insert content from Clipboard -> protected cell has
been overwritten.
Comment 8 openoffice 2003-09-18 17:26:10 UTC
.
Comment 9 eric.savary 2003-09-26 17:46:23 UTC
According to the OpenOffice.org roadmap 
(http://tools.openoffice.org/releases) this issue was retargeted to 
OOo Later.
Comment 10 Rob Weir 2013-07-30 02:18:31 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.