Apache OpenOffice (AOO) Bugzilla – Issue 6496
Chart looses information when storing sheet in Excel format
Last modified: 2013-02-24 21:22:52 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.
Created attachment 2295 [details] Added attachment original Excel file
Created attachment 2296 [details] added attachment Excel file after saving in OOo 1.0.0 german
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.
I take it
Hi Björn, one for you. Thomas
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.
I have agreed with Daniel to investigate this.
Yes, it certainly looks like an excel export issue.
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.
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.
Bug is fixed (CWS bm2)
please verify
srx644 bm2
verified
Tested and closed.