Apache OpenOffice (AOO) Bugzilla – Issue 27253
Improvement of conditional formatting
Last modified: 2013-08-07 15:14:30 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" "Between" "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" "Between" "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
*** Issue 27254 has been marked as a duplicate of this issue. ***
Hi Bettina, some good sugestions, so this is for you. Frank
-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.
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
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 :(
.
Good suggestions. Most important to start with - at least for me - is more than three conditional formats. Any progress on this ?
taking the issue
The "New Style" buttons have been added in CWS "calc49". For allowing more conditions, there's issue 8812.
reassigning to QA for verification
verified in internal build cws_calc49. Autotest c_updt2.bas enhanced
Verified in DEV300m49 on WinXP Closing