Details

    • Type: Bug
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: Chart, Public Review
    • Labels:
      None
    • Resolution:
      Hide

      In 19.15.1 replace the section

      "chart:surface - The values given by a chart:values-cell-range-address attribute
      on multiple <chart:series> elements (marked as being of type chart:surface) are
      interpreted as altitudes at specific grid locations.
      Where chart:three-dimensional="true" a surface chart is displayed in a left handed
      three-dimensional Cartesian coordinate system with horizontal x-axis and vertical y-axis (prior
      to any 3D scene transformation). The altitude values are displayed on the y-axis in this case.
      The attribute chart:deep shall be true. The accessory x-coordinates are generated from the
      positions in the altitude -value sequence starting with 1.0. The first altitude value in each
      series gets an x value 1.0. The second altitude value is associated with an x value of 2.0 and
      so forth. The <chart:categories> element can be used to define labels for the x-axis. The
      z-coordinates are generated from the order of the series elements starting with 1.0. The first
      series marked as being of type surface gets an associated z-coordinate of 1.0. The second
      series marked as being of type surface gets a z-coordinate 2.0 and so forth. The series
      names are used as labels at the z-axis. The surface is displayed as specified by the line and
      fill attributes of the first series. Furthermore tThe <chart:data-point> elements of the first
      series can be used to specify differing fill and line styles for the different altitude intervals. The
      surface within the first major interval (starting at lower values) is displayed with the line and fill
      attributes of the first data-point, within the second major interval the surface is displayed with
      the line and fill attributes of the second data-point and so on.
      Where chart:three-dimensional="false" a contour plot is displayed in a 2 dimensional
      Cartesian coordinate system with horizontal x-axis and vertical y-axis. The x-coordinates are
      generated from the positions in the altitude -value sequence starting with 1.0. The
      <chart:categories> element can be used to define labels for the x-axis. The y-
      coordinates are generated from the order of the series elements starting with 1.0. The series
      names are used as labels at the y-axis. A third axis element with chart:dimension="z" is
      used to define the range and segmentation of the displayed altitude values. Contour lines are
      drawn along lines of equal altitude specified by the major interval of the z-axis. The area
      between the contour lines can be filled. The line and fill style is specified by the line and fill
      attributes of the first series. Furthermore the <chart:data-point> elements of the first
      series can be used to specify differing line and fill attributes for the different altitude intervals.
      The contour line and area belonging to the first major interval is displayed with the line and fill
      attributes of the first data-point, the contour line and area belonging to the second interval is
      displayed as specified by the line and fill attributes of the second data-point and so on.
      "

      with

      "chart:surface -
      Depending on the size of the range specified by chart:values-cell-range-address attribute of the first <chart:series> element one of two types of surfaces is rendered:

      (bullet) If the chart:values-cell-range-address attribute of the first <chart:series> element specifies a range with more than one row and more than one column the first version of a surface chart is rendered:

      The value in the ith column and jth row of the cell range given by the chart:values-cell-range-address attribute
      of the <chart:series> element (marked as being of type chart:surface) is the altitude corresponding to the x-value i
      and the y-value j unless <chart:domain> elements are contained in the <chart:series> element (see below).

      If chart:three-dimensional="true" a surface chart is displayed in a right-handed
      three-dimensional Cartesian coordinate system with horizontal x-axis (from left to right), a perspective y-axis
      running from the front to the right rear and a vertical z-axis (prior
      to any 3D scene transformation). The altitude values are displayed on the z-axis in this case.
      The surface is displayed as specified by the line and
      fill attributes of the first series. Furthermore the <chart:data-point> elements of the
      series can be used to specify differing fill and line styles for the different altitude intervals. The
      surface within the first major interval (starting at lower values) is displayed with the line and fill
      attributes of the first data-point, within the second major interval the surface is displayed with
      the line and fill attributes of the second data-point and so on.

      Where chart:three-dimensional="false" a contour plot is displayed in a 2 dimensional
      Cartesian coordinate system with horizontal x-axis and vertical y-axis.
      An axis element with chart:dimension="z" is used to define the range and segmentation of the displayed altitude
      values. Contour lines are
      drawn along lines of equal altitude specified by the major interval of the z-axis. The area
      between the contour lines can be filled. The line and fill style is specified by the line and fill
      attributes of the series. Furthermore the <chart:data-point> elements of the series can be used to specify
      differing line and fill attributes for the different altitude intervals.
      The contour line and area belonging to the first major interval is displayed with the line and fill
      attributes of the first data-point, the contour line and area belonging to the second interval is
      displayed as specified by the line and fill attributes of the second data-point and so on.

      In both cases two <chart:domain> elements may be used to specify the y-values and x-values to be used (see 19.595.x).
      In this case the jth value of the table:cell-range-address
      attribute of the first <chart:domain> element specifies the y-values used for the values in the jth row of the cell
      range given by the
      chart:values-cell-range-address attribute of the <chart:series> element
      and the ith value of the table:cell-range-address attribute of the second <chart:domain> element
      specifies the x-values used for the values in the ith column.

      The attribute chart:deep shall be false. Multiple chart:series elements of type chart:surface will result in multiple surfaces being rendered.

      (bullet) If the chart:values-cell-range-address attribute of the first <chart:series> element specifies a range with a single row or with a single column the second version of a surface chart is rendered:

      The values given by a chart:values-cell-range-address attribute
      on multiple <chart:series> elements (marked as being of type chart:surface) are
      interpreted as altitudes at specific grid locations.

      Where chart:three-dimensional="true" a surface chart is displayed in a left handed
      three-dimensional Cartesian coordinate system with horizontal x-axis and vertical y-axis (prior
      to any 3D scene transformation). The altitude values are displayed on the y-axis in this case.
      The attribute chart:deep shall be true. The accessory x-coordinates are generated from the
      positions in the altitude -value sequence starting with 1.0. The first altitude value in each
      series gets an x value 1.0. The second altitude value is associated with an x value of 2.0 and
      so forth. The <chart:categories> element can be used to define labels for the x-axis. The
      z-coordinates are generated from the order of the series elements starting with 1.0. The first
      series marked as being of type surface gets an associated z-coordinate of 1.0. The second
      series marked as being of type surface gets a z-coordinate 2.0 and so forth. The series
      names are used as labels at the z-axis. The surface is displayed as specified by the line and
      fill attributes of the first series. Furthermore tThe <chart:data-point> elements of the first
      series can be used to specify differing fill and line styles for the different altitude intervals. The
      surface within the first major interval (starting at lower values) is displayed with the line and fill
      attributes of the first data-point, within the second major interval the surface is displayed with
      the line and fill attributes of the second data-point and so on.

      Where chart:three-dimensional="false" a contour plot is displayed in a 2 dimensional
      Cartesian coordinate system with horizontal x-axis and vertical y-axis. The x-coordinates are
      generated from the positions in the altitude -value sequence starting with 1.0. The
      <chart:categories> element can be used to define labels for the x-axis. The y-
      coordinates are generated from the order of the series elements starting with 1.0. The series
      names are used as labels at the y-axis. A third axis element with chart:dimension="z" is
      used to define the range and segmentation of the displayed altitude values. Contour lines are
      drawn along lines of equal altitude specified by the major interval of the z-axis. The area
      between the contour lines can be filled. The line and fill style is specified by the line and fill
      attributes of the first series. Furthermore the <chart:data-point> elements of the first
      series can be used to specify differing line and fill attributes for the different altitude intervals.
      The contour line and area belonging to the first major interval is displayed with the line and fill
      attributes of the first data-point, the contour line and area belonging to the second interval is
      displayed as specified by the line and fill attributes of the second data-point and so on.
      "

      insert a new section:

      "
      19.595.x <chart:domain> - surface
      The table:cell-range-address attribute of the first <chart:domain> element specifies the y-coordinate
      values and the table:cell-range-address attribute of the second <chart:domain> element specifies the x-coordinate
      values for surface charts when the chart:class attribute of its parent <chart:series> element has the value
      chart:surface and the chart:values-cell-range-address attribute of this <chart:series> element specifies a range with more than one row and more than one column.
      attribute-table:cell-range-address_element-chart:domain_value:chart:bubble
      The table:cell-range-address attribute is usable with the following element:
      <chart:domain> 11.12.
      The table:cell-range-address attribute has the data type cellRangeAddressList
      18.3.5.
      "

      add the following paragraph to section 11.12 immediately following the paragraph referring to the bubble chart:

      For surface charts, up to two <chart:domain> elements are allowed to
      exist. The values for the y-coordinates are given by the first
      <chart:domain> element. The values for the x-coordinates are given
      by the second <chart:domain> element.

      Show
      In 19.15.1 replace the section "chart:surface - The values given by a chart:values-cell-range-address attribute on multiple <chart:series> elements (marked as being of type chart:surface) are interpreted as altitudes at specific grid locations. Where chart:three-dimensional="true" a surface chart is displayed in a left handed three-dimensional Cartesian coordinate system with horizontal x-axis and vertical y-axis (prior to any 3D scene transformation). The altitude values are displayed on the y-axis in this case. The attribute chart:deep shall be true. The accessory x-coordinates are generated from the positions in the altitude -value sequence starting with 1.0. The first altitude value in each series gets an x value 1.0. The second altitude value is associated with an x value of 2.0 and so forth. The <chart:categories> element can be used to define labels for the x-axis. The z-coordinates are generated from the order of the series elements starting with 1.0. The first series marked as being of type surface gets an associated z-coordinate of 1.0. The second series marked as being of type surface gets a z-coordinate 2.0 and so forth. The series names are used as labels at the z-axis. The surface is displayed as specified by the line and fill attributes of the first series. Furthermore tThe <chart:data-point> elements of the first series can be used to specify differing fill and line styles for the different altitude intervals. The surface within the first major interval (starting at lower values) is displayed with the line and fill attributes of the first data-point, within the second major interval the surface is displayed with the line and fill attributes of the second data-point and so on. Where chart:three-dimensional="false" a contour plot is displayed in a 2 dimensional Cartesian coordinate system with horizontal x-axis and vertical y-axis. The x-coordinates are generated from the positions in the altitude -value sequence starting with 1.0. The <chart:categories> element can be used to define labels for the x-axis. The y- coordinates are generated from the order of the series elements starting with 1.0. The series names are used as labels at the y-axis. A third axis element with chart:dimension="z" is used to define the range and segmentation of the displayed altitude values. Contour lines are drawn along lines of equal altitude specified by the major interval of the z-axis. The area between the contour lines can be filled. The line and fill style is specified by the line and fill attributes of the first series. Furthermore the <chart:data-point> elements of the first series can be used to specify differing line and fill attributes for the different altitude intervals. The contour line and area belonging to the first major interval is displayed with the line and fill attributes of the first data-point, the contour line and area belonging to the second interval is displayed as specified by the line and fill attributes of the second data-point and so on. " with "chart:surface - Depending on the size of the range specified by chart:values-cell-range-address attribute of the first <chart:series> element one of two types of surfaces is rendered: (bullet) If the chart:values-cell-range-address attribute of the first <chart:series> element specifies a range with more than one row and more than one column the first version of a surface chart is rendered: The value in the ith column and jth row of the cell range given by the chart:values-cell-range-address attribute of the <chart:series> element (marked as being of type chart:surface) is the altitude corresponding to the x-value i and the y-value j unless <chart:domain> elements are contained in the <chart:series> element (see below). If chart:three-dimensional="true" a surface chart is displayed in a right-handed three-dimensional Cartesian coordinate system with horizontal x-axis (from left to right), a perspective y-axis running from the front to the right rear and a vertical z-axis (prior to any 3D scene transformation). The altitude values are displayed on the z-axis in this case. The surface is displayed as specified by the line and fill attributes of the first series. Furthermore the <chart:data-point> elements of the series can be used to specify differing fill and line styles for the different altitude intervals. The surface within the first major interval (starting at lower values) is displayed with the line and fill attributes of the first data-point, within the second major interval the surface is displayed with the line and fill attributes of the second data-point and so on. Where chart:three-dimensional="false" a contour plot is displayed in a 2 dimensional Cartesian coordinate system with horizontal x-axis and vertical y-axis. An axis element with chart:dimension="z" is used to define the range and segmentation of the displayed altitude values. Contour lines are drawn along lines of equal altitude specified by the major interval of the z-axis. The area between the contour lines can be filled. The line and fill style is specified by the line and fill attributes of the series. Furthermore the <chart:data-point> elements of the series can be used to specify differing line and fill attributes for the different altitude intervals. The contour line and area belonging to the first major interval is displayed with the line and fill attributes of the first data-point, the contour line and area belonging to the second interval is displayed as specified by the line and fill attributes of the second data-point and so on. In both cases two <chart:domain> elements may be used to specify the y-values and x-values to be used (see 19.595.x). In this case the jth value of the table:cell-range-address attribute of the first <chart:domain> element specifies the y-values used for the values in the jth row of the cell range given by the chart:values-cell-range-address attribute of the <chart:series> element and the ith value of the table:cell-range-address attribute of the second <chart:domain> element specifies the x-values used for the values in the ith column. The attribute chart:deep shall be false. Multiple chart:series elements of type chart:surface will result in multiple surfaces being rendered. (bullet) If the chart:values-cell-range-address attribute of the first <chart:series> element specifies a range with a single row or with a single column the second version of a surface chart is rendered: The values given by a chart:values-cell-range-address attribute on multiple <chart:series> elements (marked as being of type chart:surface) are interpreted as altitudes at specific grid locations. Where chart:three-dimensional="true" a surface chart is displayed in a left handed three-dimensional Cartesian coordinate system with horizontal x-axis and vertical y-axis (prior to any 3D scene transformation). The altitude values are displayed on the y-axis in this case. The attribute chart:deep shall be true. The accessory x-coordinates are generated from the positions in the altitude -value sequence starting with 1.0. The first altitude value in each series gets an x value 1.0. The second altitude value is associated with an x value of 2.0 and so forth. The <chart:categories> element can be used to define labels for the x-axis. The z-coordinates are generated from the order of the series elements starting with 1.0. The first series marked as being of type surface gets an associated z-coordinate of 1.0. The second series marked as being of type surface gets a z-coordinate 2.0 and so forth. The series names are used as labels at the z-axis. The surface is displayed as specified by the line and fill attributes of the first series. Furthermore tThe <chart:data-point> elements of the first series can be used to specify differing fill and line styles for the different altitude intervals. The surface within the first major interval (starting at lower values) is displayed with the line and fill attributes of the first data-point, within the second major interval the surface is displayed with the line and fill attributes of the second data-point and so on. Where chart:three-dimensional="false" a contour plot is displayed in a 2 dimensional Cartesian coordinate system with horizontal x-axis and vertical y-axis. The x-coordinates are generated from the positions in the altitude -value sequence starting with 1.0. The <chart:categories> element can be used to define labels for the x-axis. The y- coordinates are generated from the order of the series elements starting with 1.0. The series names are used as labels at the y-axis. A third axis element with chart:dimension="z" is used to define the range and segmentation of the displayed altitude values. Contour lines are drawn along lines of equal altitude specified by the major interval of the z-axis. The area between the contour lines can be filled. The line and fill style is specified by the line and fill attributes of the first series. Furthermore the <chart:data-point> elements of the first series can be used to specify differing line and fill attributes for the different altitude intervals. The contour line and area belonging to the first major interval is displayed with the line and fill attributes of the first data-point, the contour line and area belonging to the second interval is displayed as specified by the line and fill attributes of the second data-point and so on. " insert a new section: " 19.595.x <chart:domain> - surface The table:cell-range-address attribute of the first <chart:domain> element specifies the y-coordinate values and the table:cell-range-address attribute of the second <chart:domain> element specifies the x-coordinate values for surface charts when the chart:class attribute of its parent <chart:series> element has the value chart:surface and the chart:values-cell-range-address attribute of this <chart:series> element specifies a range with more than one row and more than one column. attribute-table:cell-range-address_element-chart:domain_value:chart:bubble The table:cell-range-address attribute is usable with the following element: <chart:domain> 11.12. The table:cell-range-address attribute has the data type cellRangeAddressList 18.3.5. " add the following paragraph to section 11.12 immediately following the paragraph referring to the bubble chart: For surface charts, up to two <chart:domain> elements are allowed to exist. The values for the y-coordinates are given by the first <chart:domain> element. The values for the x-coordinates are given by the second <chart:domain> element.

      Description

      In ODF 1.1 the desciption of chart class chart:surface is "the data points are interpreted as tabular data, where each value defines a 'height' at a specific grid location." 10.9 furtehr states that the "<chart:series> element represents a data series in a chart. If the chart requires more input data like scatter and bubble charts, <chart:domain> sub-elements must be defined that mainly contain the cell-range-address of the corresponding data."

      This would allow several surfaces to be shown in the same plot.

      In ODF1.2CD5 the description of chart:surface was changed in an incompatible way to read in 19.15.1: The values given by a chart:values-cell-range-address attribute on multiple <chart:series> elements (marked as being of type chart:surface) are interpreted as altitudes at specific grid locations.

      Since an undefined number of series are used for a single surface it becomes impossible to have more than one surface in a chart.

      So in ODF 1.2 we require:
      <chart:series chart:values-cell-range-address="Sheet1.$B$3:.$B$8" />
      <chart:series chart:values-cell-range-address="Sheet1.$C$3:.$C$8" />
      <chart:series chart:values-cell-range-address="Sheet1.$D$3:.$D$8" />
      <chart:series chart:values-cell-range-address="Sheet1.$E$3:.$E$8" />

      while in ODF 1.1 it would have sufficed to specify:
      <chart:series chart:values-cell-range-address="Sheet1.$B$3:.$E$8" />

      which would allow additional surfaces defined by further series.

      Note that currently Gnumeric uses the second approach (extending it with two chart:domain sub elements if the x, and y values are not the default 1,2,..,5) while Excel uses the first approach.

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow
              Reporter:
              aguelzow Andreas Guelzow
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: