Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Conditional formatting does not modify cell protection and language|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||elish, issues, rainerbielefeld_ooo_qa|
|Version:||OOo 3.1||Keywords:||needhelp, oooqa|
|Issue Type:||DEFECT||Latest Confirmation in:||4.1.0-dev|
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...