How to add color scales to ODF?

Markus Mohrhard markus.mohrhard at googlemail.com
Fri May 11 10:48:41 PDT 2012


2012/5/11 Kohei Yoshida <kohei.yoshida at gmail.com>:
> On Fri, May 11, 2012 at 11:50 AM, Kohei Yoshida <kohei.yoshida at gmail.com> wrote:
>
>> My gut feeling (totally unscientific and may be illogical) tells me
>> that wedging this information into the style section may not be the
>> cleanest approach.  I could, however, imagine we define these color
>> scales elsewhere, and reference them from the style section somehow,
>> either by name or by index.  Or just totally leave it outside the
>> style section.  Somehow I tend to think that this feature behaves more
>> like a database range, chart source range, or pivot table data source,
>> than conditional formatting.  And based on how Markus is implementing
>> it so far even in the core, the color scale data is separated stored
>> than the conventional conditional formatting data.
>
> Actually I'll take a step back from this.  The existing conditional
> formatting implementation *does* have the concept of ranges.  For
> instance, unique values condition only makes sense when it's applied
> to a range of cells.  So, color scales may be considered a logical
> extension of the conventional conditional formatting.
>
> Come to think of it, how are we dealing with these unique values,
> non-unique values conditions in ODF, which has similar range
> requirement to color scales (and data bars)?
>

The unique value condition is not saved to odf. See
11d375a4e719ce4836015020d2f120765672fb09

So if we find a solution here for color scales we might use the same
solution to export this to odf.

Regards,
Markus


More information about the LibreOffice mailing list