Re: [oic] charts in spreadsheets, ranges

[Daniel Rentz <Daniel.Rentz@Sun.COM>]

Hello,

I asked Ingrid Halama (Chart developer @ Sun) about this, and I've 
inserted her answers below.

Daniel

-------------------------


Dear TC,

Some information about the chart ranges from my side inline.
Hanssens Bart schrieb:
> 
> On the The Hague plugtest wiki, we've noticed that implementations
> vary in the way they deal with hrefs to embedded charts and cell
> ranges on charts.
> 
> Some implementations require chart:plot-area table:cell-range-address
> in order to draw the chart, while others depend on chart:series
> chart:values-cell-range-address
> 
> It's a bit more detailed in ODF 1.2 cd2 _when_ the
> table:cell-range-address is to be omitted, although as Andreas
> pointed out on the Plugfest mailing list, the question remains _why_
> there are two places to set the range... (and what happens when the
> two are out of sync)

If the chart:plot-area table:cell-range-address is given and also ranges 
at the chart:series elements are provided the ranges at the chart:series 
have the higher priority.
The chart:plot-area table:cell-range-address should be exported still 
for backwards compatibility. Early implementations of ODF have not been 
able to cope with the independent ranges for different series. Instead 
only one single range was
separated into rows or columns. This single range is expected at the 
'table:cell-range-address' at the <chart:plot-area>.

> So, for maximum interoperability, I guess a consumer must be able to
> 
> - handle both href "./Object 1" and "Object 1/" hrefs

This will be handled within issue 103076 for OpenOffice.org. Thanks for 
reporting this!
http://graphics.openoffice.org/issues/show_bug.cgi?id=103076

> - draw the
> chart even when the cell range is missing on the chart:plot-area or
> the chart:series

This will be fixed with issue 103147 in OpenOffice.org . But see below.
http://graphics.openoffice.org/issues/show_bug.cgi?id=103147

> And a producer should probably set the cell range on both elements.

This is not really optional. Somewhere it must be stated who should 
provide the data for the chart. Is it the chart itself or the parent 
application or something else?
With ODF 1.2 an attribute xlink:href was newly introduced at the 
<chart:chart> element to make this information explicit. As long as that 
new attribute is not used the following rules should be used:
The chart:plot-area table:cell-range-address attribute must be set, if 
the data should be taken from the parent application (e.g. the hosting 
spreadsheet or text document). The chart:plot-area 
table:cell-range-address attribute must be omitted if the data should be 
taken from the table element provided within the chart:chart element itself.

The new attribute xlink:href will be implemented in OpenOffice.org with 
issue 103209.
http://graphics.openoffice.org/issues/show_bug.cgi?id=103209

Hope that helps,
Ingrid

> IIRC the correct way for the href is "Object 1/" (why is there a
> space by the way ? It is a valid IRI, but still strange), although
> this will break older implementations that rely on "./Object 1". Not
> sure if there's a work-around that's both correct and
> backwards-compatible...