Details

    • Type: New Feature
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 06
    • Fix Version/s: ODF 1.3
    • Component/s: Part 1 (Schema), Table
    • Labels:
      None
    • Proposal:
      Hide

      9.6.5. remains as is. 19.593.9 has the underlined sentence added. 19.673.x is new and included in the appropriate place in the document.

      9.6.5 <table:source-cell-range>

      The <table:source-cell-range> element specifies a cell range as a source of data for a data pilot table. A filter may be specified by a <table:filter> child element that is applied prior to return of data to a data pilot table.

      19.593.9 <table:source-cell-range>

      The table:cell-range-address attribute specifies the cell range containing the source data. The value of this attribute shall be an absolute cell address that contains a table name. The dollar signs “$” (U+0024, DOLLAR SIGN) that indicate an absolute address may be omitted. If also a table:name attribute is given specifying a named range, the cell range specified by the table:cell-range address attribute shall match the cell range specified by the named range.

      19.673.x <table:source-cell-range>

      The table:name attribute specifies the name of a named range containing the source data. The value of this attribute shall be a string matching the value of a table:name attribute of a table:named-range element.

       

      --- OpenDocument-v1.2-os-schema.rng	2011-09-28 22:00:00.000000000 -0600
      +++ OpenDocument-v1.2-os-schema-proposal.rng	2018-06-04 21:14:52.071754913 -0600
      @@ -4823,9 +4823,23 @@
       		</element>
       	</define>
       	<define name="table-source-cell-range-attlist">
      -		<attribute name="table:cell-range-address">
      -			<ref name="cellRangeAddress"/>
      -		</attribute>
      +	        <interleave>
      +	             <choice>
      +		        <attribute name="table:cell-range-address">
      +		        	<ref name="cellRangeAddress"/>
      +		        </attribute>
      +			<group>
      +			  <attribute name="table:name">
      +			    <ref name="string"/>
      +			  </attribute>
      +			  <optional>
      +			    <attribute name="table:cell-range-address">
      +			      <ref name="cellRangeAddress"/>
      +			    </attribute>
      +			  </optional>
      +			</group>
      +		    </choice>
      +		</interleave>
       	</define>
       	<define name="table-source-service">
       		<element name="table:source-service">
      Show
      9.6.5. remains as is. 19.593.9 has the underlined sentence added. 19.673.x is new and included in the appropriate place in the document. 9.6.5 <table:source-cell-range> The <table:source-cell-range> element specifies a cell range as a source of data for a data pilot table. A filter may be specified by a <table:filter> child element that is applied prior to return of data to a data pilot table. 19.593.9 <table:source-cell-range> The table:cell-range-address attribute specifies the cell range containing the source data. The value of this attribute shall be an absolute cell address that contains a table name. The dollar signs “$” (U+0024, DOLLAR SIGN) that indicate an absolute address may be omitted. If also a table:name attribute is given specifying a named range, the cell range specified by the table:cell-range address attribute shall match the cell range specified by the named range. 19.673.x <table:source-cell-range> The table:name attribute specifies the name of a named range containing the source data. The value of this attribute shall be a string matching the value of a table:name attribute of a table:named-range element.   --- OpenDocument-v1.2-os-schema.rng 2011-09-28 22:00:00.000000000 -0600 +++ OpenDocument-v1.2-os-schema-proposal.rng 2018-06-04 21:14:52.071754913 -0600 @@ -4823,9 +4823,23 @@ </element> </define> <define name="table-source-cell-range-attlist"> - <attribute name="table:cell-range-address"> - <ref name="cellRangeAddress"/> - </attribute> + <interleave> + <choice> + <attribute name="table:cell-range-address"> + <ref name="cellRangeAddress"/> + </attribute> + <group> + <attribute name="table:name"> + <ref name="string"/> + </attribute> + <optional> + <attribute name="table:cell-range-address"> + <ref name="cellRangeAddress"/> + </attribute> + </optional> + </group> + </choice> + </interleave> </define> <define name="table-source-service"> <element name="table:source-service">

      Description

      Currently, a data pilot table data specifies its source data cell range via <table:source-cell-range> element. This element has the table:cell-range-address attribute to specify the range.

      The new feature being proposed herein will allow specifying the source data by textural name, which corresponds with the name of a named range defined by the table:named-range element. Such name shall be given in the table:name attribute of the <table:source-cell-range> element.

      The precondition is that the document contains a named range whose name equals the name specified in the <table:source-cell-range> element.

      Example:

      <table:named-expressions>
      <table:named-range table:name="MyData" table:base-cell-address="$Data.$B$4" table:cell-range-address="$Data.$A$1:.$B$4"/>
      </table:named-expressions>
      <table:data-pilot-tables>
      <table:data-pilot-table table:name="DataPilot1">
      <table:source-cell-range table:name="MyData"/>
      ....
      </table:data-pilot-table>
      </table:data-pilot-tables>

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow
              Reporter:
              kyoshida Kohei Yoshida (Inactive)
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: