Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-3326

11.4 <chart:plot-area> and 11.11 <chart:series>, cell ranges

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: Public Review
    • Labels:
      None
    • Proposal:
      Hide
      • specify that <chart:series chart:values-cell-range-address... > must be used, even when the series are consecutive
      • specify that <chart:series chart:values-cell-range-address...> takes precedence over <chart:plot-area table:cell-range-address...>
      • perhaps in ODF Next, one should consider removing table:cell-range-address from <chart:chart> altogether ?
      Show
      specify that <chart:series chart:values-cell-range-address... > must be used, even when the series are consecutive specify that <chart:series chart:values-cell-range-address...> takes precedence over <chart:plot-area table:cell-range-address...> perhaps in ODF Next, one should consider removing table:cell-range-address from <chart:chart> altogether ?
    • Resolution:
      Hide

      1. Remove the following from 11.4 <chart:plot-area>:

      If data for a chart is provided by a document other than the chart document itself, the |table:cell-range-address| attribute defines the ranges in that providing document that contain the data. This data is interpreted by the chart as consecutive series. Addressing of documents is described in 19.912.

      If the chart data is to be taken from the table element contained in the |<chart:chart>| element itself, the |table:cell-range-address| attribute shall be omitted.

      2. Deprecate the use of table:cell-range-address at chart:plot-area and extend the description:

      19.595.5 table:cell-range-address at chart:plot-area *(deprecated) *

      The |table:cell-range-address| attribute specifies the ranges from which all the data for the chart comes. The range given here is interpreted by the chart as consecutive series.

      *The table:cell-range-address attribute at the <chart:plot-area> element has no effect in case the data is assigned to the <chart series> elements directly by chart:values-cell-range-address attributes).

      The use of the |table:cell-range-address| attribute is deprecated if favor of the chart:values-cell-range-address attributes of <chart:series> elements.*

      3. Adapt the headings of 19.17 and 20.45

      19.17 chart:data-source-has-labels (deprecated)
      20.45 chart:series-source (deprecated)

      4. Adapt last paragraph of 19.912.3 xlink:href/<chart:chart> to


      If the xlink:href attribute is omitted, its value is assumed to be ".." (U+002E, FULL STOP followed by U+002E, FULL STOP).


      Show
      1. Remove the following from 11.4 <chart:plot-area>: – If data for a chart is provided by a document other than the chart document itself, the |table:cell-range-address| attribute defines the ranges in that providing document that contain the data. This data is interpreted by the chart as consecutive series. Addressing of documents is described in 19.912. If the chart data is to be taken from the table element contained in the |<chart:chart>| element itself, the |table:cell-range-address| attribute shall be omitted. — 2. Deprecate the use of table:cell-range-address at chart:plot-area and extend the description: — 19.595.5 table:cell-range-address at chart:plot-area *(deprecated) * The |table:cell-range-address| attribute specifies the ranges from which all the data for the chart comes. The range given here is interpreted by the chart as consecutive series. *The table:cell-range-address attribute at the <chart:plot-area> element has no effect in case the data is assigned to the <chart series> elements directly by chart:values-cell-range-address attributes). The use of the |table:cell-range-address| attribute is deprecated if favor of the chart:values-cell-range-address attributes of <chart:series> elements.* — 3. Adapt the headings of 19.17 and 20.45 — 19.17 chart:data-source-has-labels (deprecated) 20.45 chart:series-source (deprecated) 4. Adapt last paragraph of 19.912.3 xlink:href/<chart:chart> to If the xlink:href attribute is omitted, its value is assumed to be ".." (U+002E, FULL STOP followed by U+002E, FULL STOP).

      Description

      a) The spec mentions that "If the chart data is to be taken from the table element contained in the <chart:chart> element itself, the table:cell-range-address attribute (on <chart:plot-area>) shall be omitted." but it isn't explicitly specified when the table:cell-range-address must be present

      b) It seems that chart:values-cell-range-address is optional on <chart:series>, although 19.15.1<chart:chart>, <chart:series> provides some guidance

      This raises some questions / issues, consider this case:

      <chart:plot-area table:cell-range-address="Sheet1.$A$1:Sheet1.$B$1">
      ...
      <chart:series chart:values-cell-range-address="Sheet1.$A$1"/>
      <chart:series chart:values-cell-range-address="Sheet1.$B$1"/>
      ...

      • If the chart data is not to be taken from the table element contained in the <chart:chart> element itself, shall the table:cell-range-address be present ? Or may it be omited when <chart:series chart:values-cell-range-address..>'s are present ?
      • and the other way around: may <chart:series chart:values-cell-range-address...> be omited when the series are consecutive and <chart:plot-area table:cell-range-address... is present ? It seems not, since 19.15.1 mentions using the value of this attribute
      • it seems logical to just ignore <chart:chart table:cell-range-address...> when one ore more <chart:series chart:values-cell-range-address..>'s are present

        Attachments

          Activity

            People

            • Assignee:
              Patrick Patrick Durusau
              Reporter:
              bart.hanssens Bart Hanssens (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: