Issue 27253 - Improvement of conditional formatting
Summary: Improvement of conditional formatting
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
: 27254 (view as issue list)
Depends on:
Blocks: 101371
  Show dependency tree
Reported: 2004-03-31 17:21 UTC by guraknugen
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description guraknugen 2004-03-31 17:21:46 UTC
Conditional formatting cold be more simple to use. Right now it is a bit 
complicated and it is just as primitive as the MS Excel one. To do it I must 
first define a "Cell style". Why not just include a "New style" button next to 
the Cell style selector of the conditional formatting dialog? Almost everytime I 
want to use conditional formatting I select a range of cells, then format - 
conditional format. Then I enter Condition 1 and when I look for a proper cell 
style I find that I have to make a new one, so I have to leave the conditional 
formatting dialog, create a new cell style and then back again. A lot of work 
with a minimum of result... A "new style" button would make it a lot easier.
So I said it's just as primitive as MS Excel's version. Why not an unlimited 
number of conditions? Three is not good enough, is it? To me the conditional 
formatting seems to be just stolen from Excel. No new fresh ideas at all.
Right now the conditional formatting dialog looks something like this:
Condition 1
Three button: "OK", "Cancel" and "Help".
"Cell value is"
"Formula is"
"Equal to"
"Less than"
"Greater than"
"Less than or equal to"
"Greater than or equal to"
"Not equal to"
"Not beetween"
Formula input field
Cell style selection field
Then the same for condition 2 and 3.

My suggestion:
Main buttons: "OK", "Cancel", "New condition" and "Help"
Condition select field (to select condition 1, 2, 3... depending on how many 
conditions you created)
Cell select (where you enter which cell you want to compare to an expression)
"Cell value is"
"Formula is"
"Equal to"
"Less than"
"Greater than"
"Less than or equal to"
"Greater than or equal to"
"Not equal to"
"Not beetween"
Formula field (where you enter the expression to be compared to the selected 
cell in "Cell select" above)
Cell style selection field
"New cell style" button
Comment 1 frank 2004-04-01 08:06:18 UTC
*** Issue 27254 has been marked as a duplicate of this issue. ***
Comment 2 frank 2004-04-01 08:09:39 UTC
Hi Bettina,

some good sugestions, so this is for you.

Comment 3 jminne 2004-05-07 17:25:57 UTC
-These conditional enhancement requests are great.  Suggestion: Maybe start with
only 1 conditional dialogue, and have an "add" button that will take up to 10 or
more conditionals.
Comment 4 dhollm 2004-09-21 02:30:58 UTC
WRT the relationship of conditional formatting to styles: IMO the style should
contain all formatting information, conditional or unconditional. So my
suggestion would be to integrate conditional formatting into the style
management GUI entirely.

The benefits:
- Applying a conditional format is as simple as applying any style
- Conditional formatting can be more easily reused
- All formatting is collected together which is more intuitive
Comment 5 Dwayne Bailey 2005-09-12 16:03:06 UTC
I see we still haven't really moved on from this in 2.0.

Moving conditional formatting into style might be a good approach.  I would
suggest though that we have the ability to define a style "like this".  So you
can define the condition and point to a cell that is correctly formated for that
condition.  The same foramting will then be applied to those cells that meat the
condition.  This would make my life simple and quick for the kinds of uses I
make of conditional formating.

I have just made a spreadsheet that needs a 4th conditional format.  Now I'm
stuck  :(
Comment 6 frank 2006-02-20 14:43:05 UTC
Comment 7 spoetnik 2006-07-27 14:26:01 UTC
Good suggestions.
Most important to start with - at least for me - is more than three conditional

Any progress on this ?
Comment 8 niklas.nebel 2009-03-18 13:18:51 UTC
taking the issue
Comment 9 niklas.nebel 2009-03-18 13:20:21 UTC
The "New Style" buttons have been added in CWS "calc49".
For allowing more conditions, there's issue 8812.
Comment 10 niklas.nebel 2009-04-03 09:00:23 UTC
reassigning to QA for verification
Comment 11 oc 2009-05-04 13:58:28 UTC
verified in internal build cws_calc49. Autotest c_updt2.bas enhanced
Comment 12 amy2008 2009-06-01 09:33:26 UTC
Verified in DEV300m49 on WinXP