Issue 73008 - Conditional Formatting
Summary: Conditional Formatting
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial with 9 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 126127 (view as issue list)
Depends on:
Reported: 2006-12-30 18:17 UTC by claudiadzm
Modified: 2016-05-23 13:40 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Conditional Formatting (11.47 KB, application/vnd.sun.xml.calc)
2006-12-30 18:19 UTC, claudiadzm
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description claudiadzm 2006-12-30 18:17:46 UTC
When using the function STYLE() in a "Conditional formatting" it would be
possible to apply more than 3 different cell-styles in a table.
But the constant actualizing makes the document flittering (right word?) and
perhaps needs to much processor-ressources.
Would be fine if that could be changed so that it would be possible to use
STYLE() in combination with IF or VLOCCKUP.
I'll add an example-doc
Comment 1 claudiadzm 2006-12-30 18:19:19 UTC
Created attachment 41790 [details]
Conditional Formatting
Comment 2 gercokees 2007-03-13 09:20:17 UTC
i think it is a miracle that this works. i agree that, when the flickering is
stopped, this would be a nice (but hidden) feature.
Comment 3 Joe Smith 2007-07-11 15:57:37 UTC
I think the problem here is that you are modifying the cell contents in the
conditional formatting formula, triggering continuous display updates, with 100%
cpu and flickering.

See Issue 71392 (dup of Issue 66415) for another example with a different
approach and no flickering; however you can't apply the conditional formatting
to a cell which receives entry data, only to a formula.
Comment 4 frank 2007-07-31 13:45:06 UTC
one for the requirements team
Comment 5 oooforum (fr) 2015-02-24 14:35:42 UTC
*** Issue 126127 has been marked as a duplicate of this issue. ***
Comment 6 oooforum (fr) 2016-05-23 13:40:09 UTC
Use CF+ to extend your formats beyond 3 conditions: