Issue 104184

Summary: Conditional formatting does not modify cell protection and language
Product: Calc Reporter: gfman <gianfranco.mancuso>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, rainerbielefeld_ooo_qa
Version: OOo 3.1Keywords: needhelp, oooqa
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
example spreadsheet none

Description gfman 2009-08-12 11:14:06 UTC 
Calc: conditional formatting doesn't work correctly.

Two new cell styles were created:
name = "input_yes" => cell colour = green + cell protection = no
name = "input_no"  => cell colour = red + cell protection = yes.

After selecting a cell and double-clicking on one of the names listed in the 
Style List, the cell has been formatted correctly.
After selecting a cell and updating its style using the Conditional Formatting 
function, the color is correctly updated but the cell protection is NOT changed.
Comment 1 Rainer Bielefeld 2009-08-13 11:33:10 UTC 
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated 
[OOO310m11 (Build 9399)]" and can confirm the reported inconsistency. But may be
it's a feature and not a bug that cell protection is excluded from conditional
formatting? Can't decide that.

Additionally 'Font / Language' will not be modified by 'Conditional Formatting'.
Comment 2 Edwin Sharp 2014-01-08 09:34:49 UTC 
As given in description.

AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian
Comment 3 Edwin Sharp 2014-01-08 09:38:19 UTC 
Created attachment 82241 [details]
example spreadsheet

column B - applied manually
column C - applied via conditional formatting

It is expected that cell C2 will have no protection - like cell B1.
Comment 4 Edwin Sharp 2014-01-08 09:41:14 UTC 
like cell B2...