Issue 120511 - [From Symphony]The labels in the Legend of Excel chart is different with that in MS Office
Summary: [From Symphony]The labels in the Legend of Excel chart is different with tha...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-09 08:09 UTC by Clarence GUO
Modified: 2012-08-31 01:46 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
sample of the bug (15.00 KB, application/vnd.ms-excel)
2012-08-09 08:15 UTC, Clarence GUO
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Clarence GUO 2012-08-09 08:09:02 UTC
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)
Comment 1 Clarence GUO 2012-08-09 08:15:01 UTC
Created attachment 78892 [details]
sample of the bug

I'll responsible for this bug
Comment 2 Clarence GUO 2012-08-14 09:58:54 UTC
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
Comment 3 Terry Yang 2012-08-31 01:46:46 UTC
Confirm at my side, the Lables should be Series 1 and series 2.