[Libreoffice-ux-advise] conditional format dialog
Stefan Knorr (Astron)
heinzlesspam at googlemail.com
Sun Apr 29 06:14:23 PDT 2012
> As already discussed in Hamburg I'm happy with the current proposal
> but I have one point that I only noticed today. Would it be possible
> to add a concept for data bars and color scales?
Possible, certainly. I think, in the combo box "Cell value is" we'd
need a third choice like "(Apply to) All values". Then, you'd get a
new combo box replacing "equal to" and "Enter value". In this combo
box, you could then choose "Color Scale", "Data Bars" (and possibly
So far, so good... However, now there would be a myriad of elements
that we'd need to fit somewhere, for colour scales e.g.:
* number of colours (Excel offers two or three – which makes sense)
* type (percentage, absolute value etc.), value, colour for minimum
* type (percentage, absolute value etc.), value, colour for maximum
* type (percentage, absolute value etc.), value, colour for midpoint
(only in the case of a three colour scale)
Data bars in Excel offer even more customisability...
What I am getting at, is: it should be no problem to fit the data bars
and colour scales into the dialogue, but for the detailed
configuration, we'd need two somewhat ugly new dialogues...
> We already have a
> simple proof of concept for data bars from Michael and I would like to
> implement color scales at least for 3.7.
More information about the Libreoffice-ux-advise