[Bug 158724] Conditional Formatting gets overwritten

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=158724

--- Comment #6 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to phantomlord2 from comment #5)
> If i had a checkbox to lock cell formatting in conditional formatting...
Tools > Protect Sheet: + [ ] Edit values (if checked you permit editing cells)

Interestingly the CF neither applying a cell style is not blocked by the
protection (yet, I'd treat this as a bug) but ordinary formatting like
text/background color.

Another option for the sheet protection could be 
Tools > Protect Sheet: + [x] Format cells (if checked you permit any formatting
including DF, CF, and styles).

-- 
You are receiving this mail because:
You are on the CC list for the bug.