[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Ambiguity concerning named ranges in charts
Occassionally I dive into the ODF spec with specific questions in mind. In
this case, I dove into v1.2 cd3 (which I think is current) to answer the
question: "Can I use named cell ranges in a chart?"
The first thing I noticed is that the "Y" values are specified by a
different attribute than the "X" values. For "X" values, the answer
appears to be no, as the data type of table:cell-range-address for the
chart:domain element is "cell-range-address-list" and the definition for
this type is taken from section 8.2.1.4. The answer also appears to be no
for "Y" values too, as this is also the data type of the
chart:values-cell-range-address attribute.
From 8.2.1.4:
"A cell range address list is a list of cell ranges and cell addresses.
Each item in the list is separated by a space. If any table name used in
the list contains a blank character, the table name is quoted within
apostrophes (')."
There is ambiguity here because neither "cell range" nor "cell addresses"
have been defined. "Cell Range Addresses" is defined in 8.2.1.2, and the
reference to "Table Cells" is defined in 8.2.1. Additionally, section
8.2.1 and subsections seem to be conceptual sections which define no
elements or attributes, and it's sandwitched between sections which define
elements.
So, four actionable items:
1] Pls make all of 8.2.1 and subsections more clear, using consistent
terminology.
2] Pls consider making "Y" and "X" values be specified by the same
attribute.
3] Pls consider making an attribute ALWAYS have the same data type
(table:cell-range-address's contextual typing system is confusing)
4] Pls consider including named ranges in table:cell-range-address and/or
chart:values-cell-range-address. (See this languishing RFE which has been
open since 2006: http://www.openoffice.org/issues/show_bug.cgi?id=64604)
I'll write a new feature proposal for this if needed. I'm waiting for
definitive word that 8.2.1.4 excludes named ranges first, tho.
Thx,
Bryce
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]