charts in spreadsheets, ranges

[Hanssens Bart <Bart.Hanssens@fedict.be>]

Hi,


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)


So, for maximum interoperability, I guess a consumer must be able to

- handle both href "./Object 1" and "Object 1/" hrefs
- draw the chart even when the cell range is missing on the chart:plot-area or the chart:series


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

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...



Best regards,

Bart