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 <>
07/03/2008 03:57 AM
To
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 |
(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:
<table:database-source-sql>. See
.
<table:database-source-table>.
See.
<table:database-source-query>.
See .
<table:source-cell-range>. See
.
<table:source-cell-ranges>
See 8.9.3.
<table:source-service>. See .
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:
Address: 2/F, DeShi Building No.9, East Road, ShangDi, Haidian District,
Beijing 100085, PRC
