Issue 73008 - Conditional Formatting
Summary: Conditional Formatting
Status: CONFIRMED
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:
URL:
Keywords:
: 126127 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-12-30 18:17 UTC by claudiadzm
Modified: 2016-05-23 13:40 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Conditional Formatting (11.47 KB, application/vnd.sun.xml.calc)
2006-12-30 18:19 UTC, claudiadzm 		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 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 
hmmm
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:
http://extensions.openoffice.org/en/project/extend-your-conditional-formatting