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.
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
I can confirm with Version: 18.104.22.168.alpha0+
Build ID: 89f5c1516fd3cf96488d97f62065b1ae0bdb9efa
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-18_10:10:39
open file .ods from attachment
save as xlsx
close , reopen
Added Markus as he's fixed many similar XLSX conversion issues such as Bug 81407.
4.2.7 will preserve the chart type on round trip and exporting to .XLSX.
I think that was fixed by http://cgit.freedesktop.org/libreoffice/core/commit/?id=d8dcf2d4861b830ce9dfdf04bee4d365b4724d1e but not sure.
At least the description of the problem and the commit seem to match.
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
http://dev-builds.libreoffice.org/daily/ 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.
Migrating Whiteboard tags to Keywords: (bibisectRequest)