Issue 6496 - Chart looses information when storing sheet in Excel format
Summary: Chart looses information when storing sheet in Excel format
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows 2000
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2002-07-20 18:00 UTC by rdreier
Modified: 2013-02-24 21:22 UTC (History)
2 users (show)

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

Attachments
Added attachment original Excel file (59.50 KB, application/octet-stream)
2002-07-20 18:02 UTC, rdreier 		no flags Details
added attachment Excel file after saving in OOo 1.0.0 german (36.00 KB, application/octet-stream)
2002-07-20 18:04 UTC, rdreier 		no flags Details
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 rdreier 2002-07-20 18:00:39 UTC 
(German version)
I have an Excel sheet with a chart (spline with dots) in it. When I load it in OOo 
and save it (even without modifications at the chart) as Excel file again and load this new file the 
lines in the chart are gone.
Comment 1 rdreier 2002-07-20 18:02:54 UTC 
Created attachment 2295 [details]
Added attachment original Excel file
Comment 2 rdreier 2002-07-20 18:04:29 UTC 
Created attachment 2296 [details]
added attachment Excel file after saving in OOo 1.0.0 german
Comment 3 prgmgr 2002-10-01 01:16:23 UTC 
Ruediger, thank you for using and supporting OOo.

Duplicated on Win NT 4.0 SP6a, OOo 1.0.1.

The chart inside the Excel file is a XY ( Scatter ) with data points 
connected by smoothed lines.

When OOo saves this chart, the smoothed lines are lost.
Comment 4 kla 2002-11-28 11:15:21 UTC 
I take it
Comment 5 kla 2002-11-28 11:22:02 UTC 
Hi Björn,
one for you.
Thomas
Comment 6 bjoern.milcke 2002-12-03 17:06:08 UTC 
If you import the excel document, export it as calc document and
reload this, you get the correct chart (with splines). Only if you
export it as Excel and reload, you get no lines, so I assume it is an
Excel export problem.
Comment 7 john.marmion 2003-01-03 17:31:36 UTC 
I have agreed with Daniel to investigate this.
Comment 8 john.marmion 2003-01-03 18:44:43 UTC 
Yes, it certainly looks like an excel export issue.
Comment 9 daniel.rentz 2003-01-07 10:09:16 UTC 
Bjoern,
back to you.

The property "Lines" from service 
com.sun.star.chart.LineDiagram returns sal_False in splined xy charts. This 
causes the filter to write a symbols-only chart.
Works correctly with splined line 
charts.
Comment 10 bjoern.milcke 2003-01-07 12:15:52 UTC 
Ok, I see.

If a chart uses splines, the spline type should be 1 or 2 and Lines
should be true. For line charts the spline type should be 0 and Lines
true.
Comment 11 bjoern.milcke 2003-01-07 17:42:55 UTC 
Bug is fixed (CWS bm2)
Comment 12 bjoern.milcke 2003-02-06 12:44:30 UTC 
please verify
Comment 13 bjoern.milcke 2003-02-06 12:45:12 UTC 
srx644 bm2
Comment 14 kla 2003-02-10 09:58:29 UTC 
verified
Comment 15 kla 2003-02-18 14:29:34 UTC 
Tested and closed.