You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/08/09 10:09:02 UTC
[Bug 120511] New: [From Symphony]The labels in the Legend of Excel
chart is different with that in MS Office
https://issues.apache.org/ooo/show_bug.cgi?id=120511
Priority: P3
Bug ID: 120511
Assignee: ooo-issues@incubator.apache.org
Summary: [From Symphony]The labels in the Legend of Excel
chart is different with that in MS Office
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: clarence.guo.bj@gmail.com
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.0
Component: open-import
Product: spreadsheet
Open the sample file (chart3.xls).
Defect: The labels in the Legend have incorrect values (e.g. 48% and 52 %
instead of Series 1 and series 2 as in MS Excel)
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120511] [From Symphony]The labels in the Legend of Excel chart
is different with that in MS Office
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120511
--- Comment #1 from Clarence GUO <cl...@gmail.com> ---
Created attachment 78892
--> https://issues.apache.org/ooo/attachment.cgi?id=78892&action=edit
sample of the bug
I'll responsible for this bug
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120511] [From Symphony]The labels in the Legend of Excel chart
is different with that in MS Office
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120511
--- Comment #2 from Clarence GUO <cl...@gmail.com> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120511] [From Symphony]The labels in the Legend of Excel chart
is different with that in MS Office
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120511
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |polo8495@hotmail.com
Ever confirmed|0 |1
--- Comment #3 from Terry Yang <po...@hotmail.com> ---
Confirm at my side, the Lables should be Series 1 and series 2.
--
You are receiving this mail because:
You are the assignee for the bug.