Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Cell protection can be bypassed|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||ACCEPTED ---||QA Contact:|
|Priority:||P3||CC:||issues, rainerbielefeld_ooo_qa, www.openoffice.org|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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.