You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Clarence GUO <cl...@gmail.com> on 2012/08/14 11:59:03 UTC
Discussion on bug 120511 (The labels in the Legend of Excel chart is
different with that in MS Office)
Hi~
I'm doing bug 120511. I'm going to change the default behavior of the
legend display when creating a chart, which needs your comments.
When MS Excel creates a chart, if the chart data range doesn't contain
strings which can be regarded as data series name, Excel will use
Series<Num> as the default series names. e.g., Series1, Series2... While in
AOO, the default names will be the column or row names. e.g., Column A,
Column B...
So some Excel users will complain their XLS files will show different
legend labels of chart on AOO.
In order to satisfy these MS users and in order to not impact the
compatibilty of ODS files as well, I'm going to change the default data
series naming algorithm. the solution will be:
- If the opened file is ODS format, the default data series names will be
Column<XXX> or Row<XXX> as before, no matter what format it is resaved
before close;
- If the opened file is XLS format, the default data series names will be
Series<Num>, no matter what format it is resaved before close;
User Scenario 1:
Create a Spreadsheet file, create a chart, the default data series names on
legend will show Column A, Column B...
Resave the file to XLS, don't close it, create a chart again, the default
data series names on legend will also show Column A, Column B... (No matter
change the data series names of only chart 2 to Series 1, Series 2.. or
change both charts, will confuse users at this time)
Save again and reload the XLS, the default data series names of the two
charts are Series 1, Series 2...
User Scenario 2:
Open a XLS file which has chart with default data series names on legend,
the default data series names of the charts will show Series 1, Series 2...
Create a new chart, the default data series names of the charts will also
show Series 1, Series 2...
Resave the file to ODS, don't close it, create a chart again, the default
data series names of the charts will still show Series 1, Series 2...
Save again and reload the ODS, the default data series names of the all
charts are Column A, Column B...
Do you agree my proposal? Any comments and concerns please let me know.
Thanks & Regards,
Clarence
Re: Discussion on bug 120511 (The labels in the Legend of Excel chart
is different with that in MS Office)
Posted by Clarence GUO <cl...@gmail.com>.
HI~ Raphael,
Thanks for your comment.
About your second user scenario, the default chart data series names in ODS
file shows different with it's copy of XLS file, I think it is reasonable
and acceptable.
Because they are different file format, the default name should follow the
rule of their master applicatons. ODS should follow AOO's rule, which will
show Column A, Column B... XLS should follow Excel's rule, which will show
Series 1, Series 2...
Although they come from the same origian, now they are different file
formats, so they will have some differences.
Regards,
Clarence
2012/8/14 Raphael Bircher <rb...@apache.org>
> Am 14.08.12 11:59, schrieb Clarence GUO:
> > Hi~
> > I'm doing bug 120511. I'm going to change the default behavior of the
> > legend display when creating a chart, which needs your comments.
> > When MS Excel creates a chart, if the chart data range doesn't contain
> > strings which can be regarded as data series name, Excel will use
> > Series<Num> as the default series names. e.g., Series1, Series2... While
> in
> > AOO, the default names will be the column or row names. e.g., Column A,
> > Column B...
> > So some Excel users will complain their XLS files will show different
> > legend labels of chart on AOO.
> > In order to satisfy these MS users and in order to not impact the
> > compatibilty of ODS files as well, I'm going to change the default data
> > series naming algorithm. the solution will be:
> >
> > - If the opened file is ODS format, the default data series names will be
> > Column<XXX> or Row<XXX> as before, no matter what format it is resaved
> > before close;
> > - If the opened file is XLS format, the default data series names will be
> > Series<Num>, no matter what format it is resaved before close;
> >
> > User Scenario 1:
> > Create a Spreadsheet file, create a chart, the default data series names
> on
> > legend will show Column A, Column B...
> > Resave the file to XLS, don't close it, create a chart again, the default
> > data series names on legend will also show Column A, Column B... (No
> matter
> > change the data series names of only chart 2 to Series 1, Series 2.. or
> > change both charts, will confuse users at this time)
> > Save again and reload the XLS, the default data series names of the two
> > charts are Series 1, Series 2...
> >
> > User Scenario 2:
> > Open a XLS file which has chart with default data series names on legend,
> > the default data series names of the charts will show Series 1, Series
> 2...
> > Create a new chart, the default data series names of the charts will also
> > show Series 1, Series 2...
> > Resave the file to ODS, don't close it, create a chart again, the default
> > data series names of the charts will still show Series 1, Series 2...
> > Save again and reload the ODS, the default data series names of the all
> > charts are Column A, Column B...
> >
> > Do you agree my proposal? Any comments and concerns please let me know.
> The problem you try to solve is the following scenario:
>
> Sameone recive a XLS Document from a other person who has Excel. The
> Person who has Excel has allready a printout. The person with Apache
> OpenOffice recive the document, make also a printout, and this two
> documents shows different.
>
> I fear a bit, you don't solve problems at all: Think about the following
> User Scenario:
>
> - User make a new Table and create a Chart
> - User save it to ods
> - User make a Copy to OOXML or XLS too
> - User has, for whatever reason, only the XLS document, and open it on
> Apache OpenOffice
> - The Document looks different.
>
> I beleve, to make User realy happy this need a Checkbox
>
> But I'm not a Calc specialist at all, so wait for other comments please.
>
> Greetings Raphael
>
>
>
Re: Discussion on bug 120511 (The labels in the Legend of Excel chart
is different with that in MS Office)
Posted by Raphael Bircher <rb...@apache.org>.
Am 14.08.12 11:59, schrieb Clarence GUO:
> Hi~
> I'm doing bug 120511. I'm going to change the default behavior of the
> legend display when creating a chart, which needs your comments.
> When MS Excel creates a chart, if the chart data range doesn't contain
> strings which can be regarded as data series name, Excel will use
> Series<Num> as the default series names. e.g., Series1, Series2... While in
> AOO, the default names will be the column or row names. e.g., Column A,
> Column B...
> So some Excel users will complain their XLS files will show different
> legend labels of chart on AOO.
> In order to satisfy these MS users and in order to not impact the
> compatibilty of ODS files as well, I'm going to change the default data
> series naming algorithm. the solution will be:
>
> - If the opened file is ODS format, the default data series names will be
> Column<XXX> or Row<XXX> as before, no matter what format it is resaved
> before close;
> - If the opened file is XLS format, the default data series names will be
> Series<Num>, no matter what format it is resaved before close;
>
> User Scenario 1:
> Create a Spreadsheet file, create a chart, the default data series names on
> legend will show Column A, Column B...
> Resave the file to XLS, don't close it, create a chart again, the default
> data series names on legend will also show Column A, Column B... (No matter
> change the data series names of only chart 2 to Series 1, Series 2.. or
> change both charts, will confuse users at this time)
> Save again and reload the XLS, the default data series names of the two
> charts are Series 1, Series 2...
>
> User Scenario 2:
> Open a XLS file which has chart with default data series names on legend,
> the default data series names of the charts will show Series 1, Series 2...
> Create a new chart, the default data series names of the charts will also
> show Series 1, Series 2...
> Resave the file to ODS, don't close it, create a chart again, the default
> data series names of the charts will still show Series 1, Series 2...
> Save again and reload the ODS, the default data series names of the all
> charts are Column A, Column B...
>
> Do you agree my proposal? Any comments and concerns please let me know.
The problem you try to solve is the following scenario:
Sameone recive a XLS Document from a other person who has Excel. The
Person who has Excel has allready a printout. The person with Apache
OpenOffice recive the document, make also a printout, and this two
documents shows different.
I fear a bit, you don't solve problems at all: Think about the following
User Scenario:
- User make a new Table and create a Chart
- User save it to ods
- User make a Copy to OOXML or XLS too
- User has, for whatever reason, only the XLS document, and open it on
Apache OpenOffice
- The Document looks different.
I beleve, to make User realy happy this need a Checkbox
But I'm not a Calc specialist at all, so wait for other comments please.
Greetings Raphael