incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
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

             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

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
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:
------- You are receiving this mail because: -------
You are on the CC list for the bug.

View raw message