[Libreoffice-ux-advise] conditional format dialog

Markus Mohrhard markus.mohrhard at googlemail.com
Fri May 11 10:23:25 PDT 2012


2012/5/11 Michael Stahl <mstahl at redhat.com>:
> On 11/05/12 15:57, Stefan Knorr (Astron) wrote:
>> Meanwhile, there's an implementation detail that I would find useful to know:
>> how are data bars and colour scales implemented in ODF? Are there
>> styles for them [1]? Would styles make sense from your perspective?
>> Actually, are data bars a specced ODF feature, or is this an extension
>> of the spec?
> see thread "How to add color scales to ODF?":
> http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/29440
> and whether to use styles or not is what the thread is mainly about :)

But this will only be something for storing them. Internally we will
not use styles for color scales and data abrs. They will save the
necessary information directly and skip the over- engineered style
handling in calc core.

Using styles for the user does not make sense and we should only over
usefule choices for the user there. In case of color scales it will
the type of the point, the value/formula if needed, and the color. For
data bars this will be a bit more complex and we need to limit us for
now to some basic features. Length of the shortest and of the longest
bar and the color of the data bar. Mostly the MSO 2007 opetions +
maybe the option from 2010 allowing to mark that negative values are
painted independently in another color, and that the zero point is at
the center of the cell. I'll try to support the data bar features from
Office 2007 and have no idea yet if it is possible to add one or two
of the useful 2010 features too.


More information about the Libreoffice-ux-advise mailing list