https://bugs.freedesktop.org/show_bug.cgi?id=60837

          Priority: medium
            Bug ID: 60837
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: FORMATTING: Conditional formatting not allowed for
                    unprotected cells in protected sheets
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: b...@herbison.com
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.0.0.3 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 74806
  --> https://bugs.freedesktop.org/attachment.cgi?id=74806&action=edit
Spreadheet with protected sheet containing unprotected cells.

Problem description: 

Protection of a sheet prevents conditional formatting changes, even for cells
which are not protected.

Steps to reproduce:

1.  Create a new document.
2.  Click above "1", left of "A" to select all cells.
3.  Open Format/Cells.../Cell Protection
4.  Uncheck "Protected".
5.  Click "OK".
6.  Open Tools/Protect Document/Sheet...
7.  Click "OK".
8.  Try to open Format/Conditional Formatting/Condition...
9.  Open Format/Conditional Formatting/Manage...

Current behavior:

8.  The Condition... window does not open.
9.  A message box with the message: Conditional Formats can not be created,
deleted or changed in protected sheets!

Expected behavior:

All steps work--conditional formatting allowed for unprotected cells.

Note:
This is a similar situation to bug 34072, except conditional formatting changes
in protected sheets were allowed when I filed that ticket.

Problem occurs on both Windows 7 and Ubuntu.
Operating System: All
Version: 4.0.0.3 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to