Thanks for the new conditional formatting dialog. I would like to suggest two small enhancement requests which improve usability with regards to cell styles for conditions:
It would be good if the cell style which is selected by default in the dialog is not the style named "Default", but rather the style in the list named "Result". Suggestion: Set the style "Result" as style selected by default for conditions in the dialog.
Rationale of this request: 100% of users want to choose a style which is different from the default cell style, because they want to see the result of conditional formatting in their sheet.
Please add two more cell styles to the list of cell styles in the dialog which are very commonly used by users:
* Style "Positive values (green font colour)" and
* Style "Negative values (red font colour)"
Rationale of this request: From all spreadsheets using conditional formatting I have see so far, the vast majority of sheets just marks positive and negative values. The set-up of this in Calc is a bit cumbersome, because everyone needs to define two new cell styles when they simply want to mark values >=0 and <0
System: Ubuntu 12.10, 64-Bit, LibreOffice Version 18.104.22.168 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)
@Astron: What is the opinion of the UX team about this?
(a) Makes sense to me. Why would you want to apply the Default style, ever?
(b) Makes sense to me, too. BUT: for this to work, we'd need condition presets ... which we don't have (and which I didn't include for normal rules in my mockup either). Thus the best we can do right now, is set up styles for red text and green text, I guess.
Setting Unconfirmed => New. Modified bug title to be shorter.
(In reply to comment #2)
> Hi all.
> (a) Makes sense to me. Why would you want to apply the Default style, ever?
Ok. I can change that to the one you suggest. Should I use "Result" instead?
> (b) Makes sense to me, too. BUT: for this to work, we'd need condition
> presets ... which we don't have (and which I didn't include for normal rules
> in my mockup either). Thus the best we can do right now, is set up styles
> for red text and green text, I guess.
Ok. Can you suggest two designs for styles. Please note that they will be hard-coded into calc code and are also visible in the normal cell style selection.
(a) Yes, Gerry's suggestion of Result sounds good.
(b) Okay, suggestions:
Green: Default font, Regular, Font size 10pt, Colour "Chart 4"
Red: Default font, Italic, Font size 10pt, Colour "Chart 5" *
* Italic in the hope that this makes it easier for colourblind users.
Oh and names for the styles would of course be something like "Positive Value" and "Negative Value".
Thanks. All sounds good.
I also like Astron's idea to have the negative values in italics. This helps for colourblind users, but also for printouts on monochrome printers.
Should be implemented by the new pre defined formats.