Issue 104184 - Conditional formatting does not modify cell protection and language
Summary: Conditional formatting does not modify cell protection and language
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1
Hardware: PC All
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp, oooqa
Depends on:
Reported: 2009-08-12 11:14 UTC by gfman
Modified: 2014-01-08 09:41 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

example spreadsheet (8.12 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-08 09:38 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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
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...