Bug 60837 - FORMATTING: Conditional formatting not allowed for unprotected cells in protected sheets
Summary: FORMATTING: Conditional formatting not allowed for unprotected cells in prote...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-02-14 11:57 UTC by B.J. Herbison
Modified: 2013-02-14 14:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Spreadheet with protected sheet containing unprotected cells. (9.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-02-14 11:57 UTC, B.J. Herbison

Note You need to log in before you can comment on or make changes to this bug.
Description B.J. Herbison 2013-02-14 11:57:54 UTC
Created attachment 74806 [details]
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.

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: release
Comment 1 Markus Mohrhard 2013-02-14 14:18:34 UTC
I'm sorry but it was a necessary change. With the change from cell attribute based conditional formats to sheet based conditional formats and making it possible to change the cell protection by conditional formats we decided that defining and modifying conditional formats should not be possible in protected sheets.

This was necessary to prevent some nasty corner cases where one would be able to mess up protected sheets.