[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (OFFICE-3665) Allow data pilot source cell range to be referenced by textural name.
[ https://issues.oasis-open.org/browse/OFFICE-3665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andreas Guelzow updated OFFICE-3665:
------------------------------------
Proposal:
h3. 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.
h3. 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.
h3. 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.
{noformat}
--- 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">{noformat}
was:
h3. 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.
h3. 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.
h3. 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">
> Allow data pilot source cell range to be referenced by textural name.
> ---------------------------------------------------------------------
>
> Key: OFFICE-3665
> URL: https://issues.oasis-open.org/browse/OFFICE-3665
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: New Feature
> Components: Part 1 (Schema), Table
> Affects Versions: ODF 1.2 CD 06
> Reporter: Kohei Yoshida
> Priority: Major
> Fix For: ODF 1.3
>
>
> 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>
--
This message was sent by Atlassian JIRA
(v7.7.2#77003)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]