Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Allow REPLACE in unprotected cells on protected sheets|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description oc 2004-01-26 10:05:03 UTC
Give some cells the unprotected attribute (FORMAT-CELLS-CELL PROTECTION) and protect the sheet (TOOLS-PROTECT DOCUMENT-SHEET). If you now try to do a search and replace you will get a errormessage. As discussed with FT and BH it should be possible that the replace will be possible for the unprotected part of the sheet.
Comment 1 peschtra 2005-01-08 21:18:01 UTC
This is still true in 1.1.4 & 1.9.65. Would think that the expected behavior should be that unproctected cells on a protected sheet could be changed via find & replace, especially since they can be changed by hand. Changed component to Editing.
Comment 2 merschmann 2007-03-18 16:13:31 UTC
... and still with OOo-2.2-RC3... This works in Excel2000.
Comment 3 webweaver64 2009-11-17 06:26:04 UTC
This is still the case in 3.1. To allow people to make changes where necessary, I have to tell them to un-protect the sheet do the finds & replacements, then re-protect the sheet. Which is really giving people access to the sheet that they shouldn't have.
Comment 4 Rainer Bielefeld 2010-01-19 17:59:32 UTC
*** Issue 108447 has been marked as a duplicate of this issue. ***
Comment 5 bettina.haberer 2010-05-21 14:46:28 UTC
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".