incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raphael Bircher <rbirc...@apache.org>
Subject Re: Discussion on bug 120511 (The labels in the Legend of Excel chart is different with that in MS Office)
Date Tue, 14 Aug 2012 11:10:19 GMT
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



Mime
View raw message