Re: How to add color scales to ODF?

2012-05-20 Thread Inge Wallin
On Tuesday, May 15, 2012 16:59:30 Kohei Yoshida wrote: On Tue, May 15, 2012 at 10:28 AM, Eike Rathke er...@redhat.com wrote: So, what we could do is prepare two proposals, the clean incompatible one and the ugly more compatible one ;-) It's then up to the TC to decide. I think this is a

Re: How to add color scales to ODF?

2012-05-17 Thread Eike Rathke
Hi Markus, On Wednesday, 2012-05-16 15:14:54 +0200, Markus Mohrhard wrote: Disadvantages: - need to introduce some non style parts into the style section Um.. why? what? how? IMHO something like information that the style should only be applied for the top 10% of a range is nothing

Re: How to add color scales to ODF?

2012-05-16 Thread Markus Mohrhard
Hey Eike, The other not so clean solution but more likely accepted solution is to add also a new section for conditional formats. But instead of moving all conditional formatting information just store the range in this section. This is an approach that should work and also pass the TC

Re: How to add color scales to ODF?

2012-05-15 Thread Eike Rathke
Hi Markus, On Saturday, 2012-05-12 02:33:42 +0200, Markus Mohrhard wrote: I think the best solution would be to move all conditional format entries out of the style section and only reference the styles later. [...] I just fear that this is such a big incompatible change that we will not

Re: How to add color scales to ODF?

2012-05-15 Thread Kohei Yoshida
On Tue, May 15, 2012 at 10:28 AM, Eike Rathke er...@redhat.com wrote: So, what we could do is prepare two proposals, the clean incompatible one and the ugly more compatible one ;-)  It's then up to the TC to decide. I think this is a sensible approach. However, given how slow the TC can be,

Re: How to add color scales to ODF?

2012-05-15 Thread Michael Stahl
On 15/05/12 16:59, Kohei Yoshida wrote: On Tue, May 15, 2012 at 10:28 AM, Eike Rathke er...@redhat.com wrote: So, what we could do is prepare two proposals, the clean incompatible one and the ugly more compatible one ;-) It's then up to the TC to decide. I think this is a sensible

Re: How to add color scales to ODF?

2012-05-15 Thread Kohei Yoshida
On Tue, 2012-05-15 at 17:26 +0200, Michael Stahl wrote: the problem with doing that of course is that there is a high risk that the ODF import will forever have to carry around ugly code to import stuff that never made it into ODF. Sure. But that's how things are with other things that are

Re: How to add color scales to ODF?

2012-05-12 Thread Stefan Knorr (Astron)
Only sent this to Kohei... sending to list, too, now. On 12 May 2012 12:09, Stefan Knorr (Astron) heinzless...@googlemail.com wrote: Hi all, On 11 May 2012 17:50, Kohei Yoshida kohei.yosh...@gmail.com wrote: On Fri, May 11, 2012 at 8:53 AM, Michael Stahl mst...@redhat.com wrote: i wonder if

Re: How to add color scales to ODF?

2012-05-12 Thread Markus Mohrhard
Heyy 2012/5/12 Stefan Knorr (Astron) heinzless...@googlemail.com: Only sent this to Kohei... sending to list, too, now. On 12 May 2012 12:09, Stefan Knorr (Astron) heinzless...@googlemail.com wrote: Hi all, On 11 May 2012 17:50, Kohei Yoshida kohei.yosh...@gmail.com wrote: On Fri, May

Re: How to add color scales to ODF?

2012-05-11 Thread Thorsten Behrens
Markus Mohrhard wrote: I know that these ideas and comment don't really help finding a solution for my problem but right now I mostly know what color scales are not. And the first thing I had to learn is that they don't really fit into our existing conditional formatting system. This is not

Re: How to add color scales to ODF?

2012-05-11 Thread Eike Rathke
Hi Markus, On Friday, 2012-05-11 03:20:37 +0200, Markus Mohrhard wrote: A possible way a color scale entry would look like is: colorScale range=$A$4:$D$10 entry type=value val=10 col=ff11ff entry type=max col=ff /colorScale colorScale range=$H3:$I$20 entry type=min col=ff11ff

Re: How to add color scales to ODF?

2012-05-11 Thread Michael Stahl
On 11/05/12 13:21, Eike Rathke wrote: Hi Markus, On Friday, 2012-05-11 03:20:37 +0200, Markus Mohrhard wrote: A possible way a color scale entry would look like is: colorScale range=$A$4:$D$10 entry type=value val=10 col=ff11ff entry type=max col=ff /colorScale colorScale

Re: How to add color scales to ODF?

2012-05-11 Thread Kohei Yoshida
On Fri, May 11, 2012 at 8:53 AM, Michael Stahl mst...@redhat.com wrote: i wonder if that restriction is really necessary. IMO it is. Imagine a case where the same color scale definition is applied to non-contiguous regions, and you having to decide whether to scale those regions as if they are

Re: How to add color scales to ODF?

2012-05-11 Thread Kohei Yoshida
On Fri, May 11, 2012 at 11:50 AM, Kohei Yoshida kohei.yosh...@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

Re: How to add color scales to ODF?

2012-05-11 Thread Markus Mohrhard
2012/5/11 Kohei Yoshida kohei.yosh...@gmail.com: On Fri, May 11, 2012 at 11:50 AM, Kohei Yoshida kohei.yosh...@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

Re: How to add color scales to ODF?

2012-05-11 Thread Kohei Yoshida
On Fri, 2012-05-11 at 19:48 +0200, Markus Mohrhard wrote: 2012/5/11 Kohei Yoshida kohei.yosh...@gmail.com: 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

Re: How to add color scales to ODF?

2012-05-11 Thread Markus Mohrhard
Hey, 2012/5/11 Kohei Yoshida kohei.yosh...@gmail.com: On Fri, 2012-05-11 at 19:48 +0200, Markus Mohrhard wrote: 2012/5/11 Kohei Yoshida kohei.yosh...@gmail.com: Come to think of it, how are we dealing with these unique values, non-unique values conditions in ODF, which has similar range

Re: How to add color scales to ODF?

2012-05-11 Thread Markus Mohrhard
Hey, 2012/5/11 Kohei Yoshida kohei.yosh...@gmail.com: On Fri, 2012-05-11 at 19:48 +0200, Markus Mohrhard wrote: 2012/5/11 Kohei Yoshida kohei.yosh...@gmail.com: Come to think of it, how are we dealing with these unique values, non-unique values conditions in ODF, which has similar range

Re: How to add color scales to ODF?

2012-05-10 Thread Thorsten Behrens
Markus Mohrhard wrote: conditionalFormatting sqref=C2:D5 cfRule type=colorScale priority=1 colorScale cfvo type=num val=0/ cfvo type=num val=10/ color rgb=FF63BE7B/ color rgb=EF9C/ /colorScale /cfRule /conditionalFormatting I'm open for

Re: How to add color scales to ODF?

2012-05-10 Thread Markus Mohrhard
Hey Thorsten, I'm open for suggestions how I can add this sanely to ods. I would like to support as much from MSO 2010's color scale feature as possible but have no idea yet what I can achieve in the remaining 4 weeks. Hi Markus, you're the man on the ground, so I'd guess you'll know best

How to add color scales to ODF?

2012-05-09 Thread Markus Mohrhard
Hey, I just reached a state where I can think about adding support for color scales into ODF. Normally this would not be such a big deal but for color scales we face several problems. Color scales are a form of conditional formatting but our current conditional formatting system is based on

Re: How to add color scales to ODF?

2012-05-09 Thread Tommy
On Thu, 10 May 2012 03:02:43 +0200, Markus Mohrhard markus.mohrh...@googlemail.com wrote: Hey, I just reached a state where I can think about adding support for color scales into ODF. Normally this would not be such a big deal but for color scales we face several problems. snip do you