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

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

     [ https://issues.oasis-open.org/browse/OFFICE-3665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andreas Guelzow updated OFFICE-3665:
------------------------------------
    Assignee: Andreas Guelzow

> 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
>            Assignee: Andreas Guelzow
>            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)