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

Allow data pilot source cell range to be referenced by textural name.

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 06
    • Fix Version/s: ODF 1.3
    • Component/s: Part 3 (Schema) [1.2: 1], 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 (Inactive)
              Reporter:
              kyoshida Kohei Yoshida (Inactive)
            • Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: