Issue 24823 - Allow REPLACE in unprotected cells on protected sheets
Summary: Allow REPLACE in unprotected cells on protected sheets
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 680m20
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 108447 (view as issue list)
Depends on:
Reported: 2004-01-26 10:05 UTC by oc
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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".