Issue 119489 - [From Symphony]Graphic Export to Excel, Line graph fails to display properly after open the saved .xls file in MS office.
Summary: [From Symphony]Graphic Export to Excel, Line graph fails to display properly ...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-29 05:46 UTC by Terry Yang
Modified: 2012-06-15 10:02 UTC (History)
1 user (show)

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

Attachments
Sample file (21.37 KB, application/vnd.sun.xml.calc)
2012-05-29 05:46 UTC, Terry Yang 		no flags Details
Sample file (29.37 KB, application/vnd.sun.xml.calc)
2012-05-29 06:02 UTC, Terry Yang 		no flags Details
Show Obsolete (1) Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Terry Yang 2012-05-29 05:46:38 UTC 
Created attachment 77682 [details]
Sample file

1. Import and open the attached .sxc file.
2. Click "Save as" and select "MS Excel 97/2000/xp (.xls)" from file type list.
3.  Import the .xls document  and open it with MS office.
4. Graphic Export to Excel is not operating
Comment 1 Terry Yang 2012-05-29 06:02:49 UTC 
Created attachment 77684 [details]
Sample file

Add new sample file
Comment 2 Terry Yang 2012-06-14 02:54:41 UTC 
1. Import and open the attached .sxc file.
2. Click " Save ->Save as" and select "MS Excel 97/2000/xp (.xls)" from file type list.
3. Export the .xls document and open it with MS office.
4. Line graph fails to display properly

Update the repro steps
Comment 3 Terry Yang 2012-06-14 03:16:25 UTC 
The defect is the 3D line chart(The first chart) display incorrect in the MS office.
Comment 4 Jianyuan Li 2012-06-14 03:35:18 UTC 
I am checking this issue.
Comment 5 Jianyuan Li 2012-06-15 10:02:38 UTC 
As talked with QA, the issue is mainly focus on the lost fill color in the line chart(the first chart).

Conclusion: The issue is an expected behavior. It is not an issue.

Why:
Open the sample file in OOo1.1(I used this version. Maybe 1.x is also okay). Check a data point for one data series. You will find "None" is set in the "area" tab. To check this, convert chart type as 2D line chart with symbols.
That is to say, data point area fill is none although it looks a color is filled in 3D mode. Data series(containing the data points) properties are applied and individual data point properties are ignored. It is a OOo behavior for line 3D chart. When exported as xls file, properties for data series and individual data point both will be exported. Excel will be applied data series properties and then individual data point properties. So at last none fill will be set. This is a feature gap between OOo and Excel.