Download it now!
Bug 90728 - Net Line Only Charts converted to Line and Point
Summary: Net Line Only Charts converted to Line and Point
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: target:5.0.0
Keywords: bibisectRequest, regression
Depends on:
Reported: 2015-04-20 03:20 UTC by Luke
Modified: 2015-12-17 08:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Native Calc Net Line Chart (13.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-04-20 03:20 UTC, Luke
Excel Radar chart without points or markers (13.32 KB, application/
2015-04-20 03:22 UTC, Luke

Note You need to log in before you can comment on or make changes to this bug.
Description Luke 2015-04-20 03:20:32 UTC
Created attachment 114933 [details]
Native Calc Net Line Chart

Steps to reproduce:
1) In Calc create a Line Only Chart
2) Save as XLSX
1) Create a Radar Chart in Excel
2) Open in Calc
3) Save as XLSX

In both cases the Net Line Only Charts are converted to Line and Point charts. In the Excel case, the point(mark) colors are incorrectly similar to Bug 81407. The points from one series are using the colors from another series.
Comment 1 Luke 2015-04-20 03:22:44 UTC
Created attachment 114934 [details]
Excel Radar chart without points or markers

If you round trip this file in Calc, it will convert it to a Radar with Markers chart
Comment 2 raal 2015-04-20 18:37:27 UTC
I can confirm with Version:
Build ID: 89f5c1516fd3cf96488d97f62065b1ae0bdb9efa
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-18_10:10:39
Locale: cs_CZ
and 4.3.3

open file .ods from attachment
save as xlsx
close , reopen
Comment 3 Luke 2015-04-20 20:10:40 UTC
Added Markus as he's fixed many similar XLSX conversion issues such as Bug 81407.
Comment 4 Luke 2015-04-21 23:51:59 UTC
4.2.7 will preserve the chart type on round trip and exporting to .XLSX.
Comment 5 Markus Mohrhard 2015-04-22 03:43:06 UTC
I think that was fixed by but not sure.

At least the description of the problem and the commit seem to match.
Comment 6 Commit Notification 2015-04-23 00:09:00 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

add test for line only chart export, related tdf#90728

It will be available in 5.0.0.

The patch should be included in the daily builds available at in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Comment 7 Robinson Tryon (qubit) 2015-12-17 08:55:00 UTC
Migrating Whiteboard tags to Keywords: (bibisectRequest)