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