You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2011/11/27 11:08:05 UTC
DO NOT REPLY [Bug 118648] New: FIND/REPLACE FAILS on unprotected
cells if Sheet Protection is on
https://issues.apache.org/ooo/show_bug.cgi?id=118648
Bug #: 118648
Issue Type: DEFECT
Summary: FIND/REPLACE FAILS on unprotected cells if Sheet
Protection is on
Classification: Application
Product: Spreadsheet
Version: OOo 3.3
Platform: PC
OS/Version: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P5
Component: editing
AssignedTo: spreadsheet@openoffice.org
ReportedBy: groachfriends-openoffice@yahoo.com
CC: ooo-issues@incubator.apache.org
Openoffice 330m2 build9567
If a sheet is 'protected', (with a range of protected and unprotected), doing a
find/replace of a character or string (that ONLY appears in unprotected cells)
fails with 'Protected cells cannot be modified'.
Simple reproduction:-
1, New Sheet
2, enter the words "REPLACE" in 2 or 3 random cells, "KEEP" in a few other
random cells.
3, Cell format - cell protection, and UNPROTECT the cells containing the words
"REPLACE"
4, Tools - Protect Document - Sheet - PROTECT the SHEET.
5, CTRL F (Find/replace) - enter "REPLACE" in the 'find', and "DONE" in the
'replace with'
6, Click 'Replace All'
Get error "Protected cells cannot be modified" despite ONLY unprotected cells
only qualifying for change. (No protected cells qualify)
(if you unprotect the sheet, then the find/replace works ok)
Openoffice 330m2 build9567
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118648] FIND/REPLACE FAILS on unprotected cells if
Sheet Protection is on
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118648
--- Comment #3 from jimimaseye <gr...@yahoo.com> 2011-11-30 19:34:37 UTC ---
Glad to hear it Marcus. Hopefully taken more seriously if its platform wide.
(How does this work then? Will this be reviewed and tackled or is this just a
venting portal where Mr Frustrated spouts off without anyone caring?)
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118648] FIND/REPLACE FAILS on unprotected cells if
Sheet Protection is on
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118648
--- Comment #1 from jimimaseye <gr...@yahoo.com> 2011-11-27 10:11:19 UTC ---
Created attachment 77050
--> https://issues.apache.org/ooo/attachment.cgi?id=77050
Sheet containing formated cells for demonstrating the problem
Sheet containing formated cells for demonstrating the problem. Attempt to
replace the words "UNPROTECTED" without unprotecting the sheet.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118648] FIND/REPLACE FAILS on unprotected cells if
Sheet Protection is on
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118648
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P5 |P4
Status|UNCONFIRMED |NEW
Platform|PC |All
Ever Confirmed|0 |1
OS/Version|Windows 7 |All
--- Comment #2 from Marcus <ma...@apache.org> 2011-11-27 18:46:35 UTC ---
I can see the same problem on Linux.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.