OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: Re: [office] Fw: Proposal: Add multiple cell ranges support to Data Pilot



Hi Helen,

Would it be possible for you to enter this in the New Proposal Form format on the Wiki?

See step 2 described here:  http://wiki.oasis-open.org/office/How_to_propose_a_change_or_addition_to_ODF

-Rob



Zhi Yu Yue <yuezhiyu@cn.ibm.com>

07/03/2008 03:57 AM

To
office@lists.oasis-open.org
cc
Subject
[office] Fw: Proposal: Add multiple cell ranges support to Data Pilot






The following is the proposal from Symphony Spreadsheet team. Thanks.

Best Regards,
Helen Yue

_________________________________________________________

Yue Zhi Yu  |
 Manager of User Experience & Applications, Lotus Symphony |  yuezhiyu@cn.ibm.com
(8610)82452783 (phone) | 90-52783 (tie-line) | IBM China Development Laboratory


----- Forwarded by Zhi Yu Yue/China/IBM on 07/03/2008 03:37 PM -----
From: Su Ying Rui/China/IBM
To: Zhi Yu Yue/China/IBM@IBMCN
Cc: Xu Ming Wang/China/IBM@IBMCN, Yue MA/China/IBM@IBMCN, Ming Fei Jia/China/IBM@IBMCN
Date: 07/03/2008 03:12 PM
Subject: Proposal: Add multiple cell ranges support to Data Pilot





Data pilot is one useful way to analyze and evaluate data. In current ODF specification (v1.2 draft 7), the source of the data pilot table can be a cell range located within the same document. However, multiple cell ranges as data source are required in many cases. The following proposal below is aimed to add the multiple cell ranges support as data source of data pilot. In this case, the data pilot function will combine the multiple cell ranges as the source into one data pilot table. The following is the proposal:


8.9 <table:data-pilot-tables>


8.9.1.1 Data Pilot Table Source


The source of the data pilot table is either stored in a database, that is, a database table itself, a SQL query or a named query, or it is a list of cell ranges located within the same document. It can also be provided by an external component in an implementation dependent way.

The source of the data pilot table is specified by one of the following elements that are contained in the <table:data-pilot-table> element:

8.9.2 <table:source-cell-range>

...


8.9.3 <table:source-cell-ranges>


If the source of a data pilot table is a list of cell ranges, the <table:source-cell-ranges> element contains information about the cell ranges and how the data pilot table gets the data from the ranges. Before the source data is processed by the data pilot data, a filter may be applied to it. This filter has to be specified by a <table:filter> child element.


<define name="table-source-cell-ranges">

       <element name="table:source-cell-ranges">

               <ref name="table-source-cell-ranges-attlist"/>

               <optional>

                       <ref name="table-filter"/>

               </optional>

       </element>

</define>

8.9.4 <table:source-service>

Best Regards

Rui SuYingӢ
User Experience & Applications,
IBM Lotus Symphony,
IBM China Software Development LAB, Beijing

http://www.ibm.com/software/lotus/symphony/

Tel: 86-10-82452814  
Internet E-mail: ruisuy@cn.ibm.com
Address: 2/F, DeShi Building No.9, East Road, ShangDi, Haidian District,  Beijing 100085, PRC



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]