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: [email protected]
ReportedBy: [email protected]
CC: [email protected]
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.
