incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 118648] New: FIND/REPLACE FAILS on unprotected cells if Sheet Protection is on
Date Sun, 27 Nov 2011 10:08:05 GMT
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.

Mime
View raw message