Issue 104184 - Conditional formatting does not modify cell protection and language
Summary: Conditional formatting does not modify cell protection and language
Status: CONFIRMED
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:
URL:
Keywords: needhelp, oooqa
Depends on:
Blocks:
 
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: ---

Attachments
example spreadsheet (8.12 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-08 09:38 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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
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...