OASIS Open Document Format for Office Applications (OpenDocument) TC

Dear TC members,


I would like to request a discussion on the following proposal in the next
call. Thanks.

http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot


Best Regards,

Helen Yue

Hi Helen,

On Wed, 2008-08-20 at 14:09 +0800, Zhi Yu Yue wrote:
> 
> Dear TC members,
> 
> I would like to request a discussion on the following proposal in the
> next call. Thanks. 
> 
> http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot 

I just wanted to say that the proposal looks reasonable to me.

One thing I would consider changing is, for backward compatibility with
pre-1.2 processors, we should definitely keep the
table:source-cell-range attribute even if the table:source-cell-ranges
attribute is preferred for 1.2 and above.

So for instance, if only one cell range is specified, the 1.2 processor
should put that range in both table:source-cell-range and
table:source-cell-ranges attributes.  And if there are multiple cell
ranges specified, put the range that is considered most representative
(or simply just the first range of the range set) to the
table:source-cell-range so that the older processors can at least load
something.

Also, is there any constraints on the geometry of the cell ranges?  For
example, do all the cell ranges have to have the same width, or can the
widths of ranges be different?  Also, when the field names are given in
the first row of each cell range, do they have to match for all the cell
ranges?  I'm just trying to picture how those multiple ranges are merged
into one data set.

Thanks, and sorry about the last reply.

Kohei

-- 
Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc.

On Thu, 2008-08-21 at 12:37 -0400, Kohei Yoshida wrote:
> Thanks, and sorry about the last reply.
                              ^^^^
I meant late reply. :-P

Kohei

-- 
Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc.

Hi Kohei,

I think your suggestion makes sense.
I have added the corresponding description into the backwards compatibility
section of my proposal, http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot.
Thanks.

 

Best Regards,

Helen Yue

_________________________________________________________

Yue Zhi Yu  |  Manager
of User Experience & Applications, Lotus Symphony |  yuezhiyu@cn.ibm.com





From:
Kohei Yoshida <kyoshida@novell.com>

To:
Zhi Yu Yue/China/IBM@IBMCN

Cc:
office@lists.oasis-open.org, Su Ying
Rui/China/IBM@IBMCN, Xu Ming Wang/China/IBM@IBMCN

Date:
08/22/2008 12:52 AM

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





Hi Helen,


On Wed, 2008-08-20 at 14:09 +0800, Zhi Yu Yue wrote:

>

> Dear TC members,

>

> I would like to request a discussion on the following proposal in
the

> next call. Thanks.

>

> http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot


I just wanted to say that the proposal looks reasonable to me.


One thing I would consider changing is, for backward compatibility with

pre-1.2 processors, we should definitely keep the

table:source-cell-range attribute even if the table:source-cell-ranges

attribute is preferred for 1.2 and above.


So for instance, if only one cell range is specified, the 1.2 processor

should put that range in both table:source-cell-range and

table:source-cell-ranges attributes.  And if there are multiple cell

ranges specified, put the range that is considered most representative

(or simply just the first range of the range set) to the

table:source-cell-range so that the older processors can at least load

something.


Also, is there any constraints on the geometry of the cell ranges?  For

example, do all the cell ranges have to have the same width, or can the

widths of ranges be different?  Also, when the field names are given
in

the first row of each cell range, do they have to match for all the cell

ranges?  I'm just trying to picture how those multiple ranges are
merged

into one data set.


Thanks, and sorry about the last reply.


Kohei


--

Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc.

<kyoshida@novell.com>



---------------------------------------------------------------------

To unsubscribe from this mail list, you must leave the OASIS TC that

generates this mail.  Follow this link to all your TCs in OASIS at:

https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php

Dear TC members,

Per our discussion today, I have updated my proposal
with changes highlighted with bold text, http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot.

As to the definition of "table:source-cell-ranges",
I'm reusing the existing "cellRangeAddressList". It is consistent
with other existing cell ranges, such as "table:print-ranges".
Your comments are welcome.

 

Best Regards,

Helen Yue






From:
Zhi Yu Yue/China/IBM@IBMCN

To:
Kohei Yoshida <kyoshida@novell.com>

Cc:
office@lists.oasis-open.org, Su Ying
Rui/China/IBM@IBMCN, Xu Ming Wang/China/IBM@IBMCN

Date:
08/25/2008 10:06 PM

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







Hi Kohei,



I think your suggestion makes sense. I have added the corresponding description
into the backwards compatibility section of my proposal, http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot.
Thanks.


Best Regards,

Helen Yue

_________________________________________________________

Yue Zhi Yu  |  Manager
of User Experience & Applications, Lotus Symphony |  yuezhiyu@cn.ibm.com





From:

Kohei Yoshida <kyoshida@novell.com>


To:

Zhi Yu Yue/China/IBM@IBMCN


Cc:

office@lists.oasis-open.org, Su Ying
Rui/China/IBM@IBMCN, Xu Ming Wang/China/IBM@IBMCN


Date:

08/22/2008 12:52 AM


Subject:

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









Hi Helen,


On Wed, 2008-08-20 at 14:09 +0800, Zhi Yu Yue wrote:

>

> Dear TC members,

>

> I would like to request a discussion on the following proposal in
the

> next call. Thanks.

>

> http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot


I just wanted to say that the proposal looks reasonable to me.


One thing I would consider changing is, for backward compatibility with

pre-1.2 processors, we should definitely keep the

table:source-cell-range attribute even if the table:source-cell-ranges

attribute is preferred for 1.2 and above.


So for instance, if only one cell range is specified, the 1.2 processor

should put that range in both table:source-cell-range and

table:source-cell-ranges attributes.  And if there are multiple cell

ranges specified, put the range that is considered most representative

(or simply just the first range of the range set) to the

table:source-cell-range so that the older processors can at least load

something.


Also, is there any constraints on the geometry of the cell ranges?  For

example, do all the cell ranges have to have the same width, or can the

widths of ranges be different?  Also, when the field names are given
in

the first row of each cell range, do they have to match for all the cell

ranges?  I'm just trying to picture how those multiple ranges are
merged

into one data set.


Thanks, and sorry about the last reply.


Kohei


--

Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc.

<kyoshida@novell.com>



---------------------------------------------------------------------

To unsubscribe from this mail list, you must leave the OASIS TC that

generates this mail.  Follow this link to all your TCs in OASIS at:

https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php

On Tue, 2008-08-26 at 00:22 +0800, Zhi Yu Yue wrote:
> As to the definition of "table:source-cell-ranges", I'm reusing the
> existing "cellRangeAddressList". It is consistent with other existing
> cell ranges, such as "table:print-ranges". Your comments are welcome.

I think that makes most sense.

Kohei

-- 
Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc.

Hi,

On Monday, 2008-08-25 12:30:29 -0400, Kohei Yoshida wrote:

> On Tue, 2008-08-26 at 00:22 +0800, Zhi Yu Yue wrote:
> > As to the definition of "table:source-cell-ranges", I'm reusing the
> > existing "cellRangeAddressList". It is consistent with other existing
> > cell ranges, such as "table:print-ranges". Your comments are welcome.
> 
> I think that makes most sense.

Seconded. However, how should an ODF 1.2 compliant application that does
have multiple ranges in a data pilot table (a single range of course
should still be stored as table-source-cell-range) behave when storing
in ODF 1.0/1.1 format? Omit the entire data pilot table? Or store any
one range using the table-source-cell-range choice? The result would be
wrong in that case.

[btw, why is this a Cc-party, recipients not being members of the TC
could not properly reply. Please don't include my address when replying,
I do read the list.]

  Eike

-- 
 OpenOffice.org / StarOffice Calc core developer and i18n transpositionizer.
 SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9 F9B5 87F8 D412
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS