[OASIS Issue Tracker] Created: (OFFICE-3665) Allow data pilotsource cell range to be referenced by textural name.

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

                 Key: OFFICE-3665
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3665
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: New Feature
          Components: Table
    Affects Versions: ODF 1.2 CD 06
            Reporter: Kohei Yoshida
             Fix For: ODF-Next


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 is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira