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

          Priority: medium
            Bug ID: 61418
          Assignee: [email protected]
           Summary: FORMATTING: Conditional formatting does not give an
                    error in protected sheets
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.0.0.3 release
         Component: Spreadsheet
           Product: LibreOffice

Problem description: 

Protection of a sheet prevents conditional formatting changes, but some
operations do nothing instead of displaying an error message.

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..., /Color Scale..., or
/Data Bar...
9.  Open Format/Conditional Formatting/Manage...

Current behavior:

8.  Nothing happens: no conditional formatting box, no message.

9.  A message box with the message: Conditional Formats can not be created,
deleted or changed in protected sheets!

Expected behavior:

8.  A message box appears explaining that conditional formatting is not allowed
in protected sheets, even for protected cells.

9.  Replace the "!" at the end with "even for unprotected cells.". No need for
an exclamation mark, and the extra words would help clarify that the situation
is not an error.

Note: This is based on the response to bug 60837. Any menu items ending with
"..." should elicit a response from the program.

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

Reply via email to