| Summary: | FILESAVE: Line Chart (Points only): Data point color not preserved when export to XLSX | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Kevin Suo <suokunlong> |
| Component: | Chart | Assignee: | Markus Mohrhard <markus.mohrhard> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | ||
| Priority: | medium | ||
| Version: | 3.6.7.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | All | ||
| See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=81396 https://bugs.documentfoundation.org/show_bug.cgi?id=90728 https://bugs.documentfoundation.org/show_bug.cgi?id=96469 https://bugs.documentfoundation.org/show_bug.cgi?id=124817 |
||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 75057 | ||
| Attachments: |
attachment 102886 saving as xlsx
screenshot: original chart in ods file screenshot: exported xlsx file open with libreoffice screenshot: exported xlsx file open with MSO 2010 Saved by LO 4.3.0.2, opened by Kingsoft 2013 Saved by LibreOffice Dev 4.3.1.0, open with MSO 2010 |
||
Created attachment 102887 [details] attachment 102886 [details] saving as xlsx Created attachment 102888 [details]
screenshot: original chart in ods file
Created attachment 102889 [details]
screenshot: exported xlsx file open with libreoffice
Created attachment 102890 [details] screenshot: exported xlsx file open with MSO 2010 When open the exported xlsx file with MSO 2010, data points color are also different compared with openning with LibreOffice (comment 3) (In reply to comment #3) > Created attachment 102889 [details] > screenshot: exported xlsx file open with libreoffice Confirmed with LO 4.3.0.2, 4.2.6.1, 4.1.6.2, 4.0.6.2, 3.6.7.2 in Ubuntu 12.04 x86 (In reply to comment #4) > Created attachment 102890 [details] > screenshot: exported xlsx file open with MSO 2010 > > When open the exported xlsx file with MSO 2010, data points color are also > different compared with openning with LibreOffice (comment 3) Same result while opened file saved by LO 4.2.6.1 and below with Kingsoft 2013 (In reply to comment #6) Looks like point shape also changed, square to diamond and vice versa Created attachment 102898 [details]
Saved by LO 4.3.0.2, opened by Kingsoft 2013
Different result if saved file with LO 4.3.0.2 opened in Kingsoft.
(In reply to comment #7) > Looks like point shape also changed, square to diamond and vice versa Yes it is...Thanks for pointing out. (In reply to comment #8) > Different result if saved file with LO 4.3.0.2 opened in Kingsoft. That image is inconceivable. But I think that may be Kingsoft's bug if it open like that. (In reply to comment #6) > Same result while opened file saved by LO 4.2.6.1 and below with Kingsoft > 2013 Sorry..only 4.2.6.1, 4.2.5.2, 4.1.6.2 that has same result while opened in Kingsoft. 4.0.6.2 and 3.6.7.2 is different with newest version, but both version shows the same. (In reply to comment #10) Yes it's really different. Perhaps you had test that with 4.3.x ? Any difference while opened with MSO ? Per https://bugs.freedesktop.org/show_bug.cgi?id=81396#c2 Line Chart (Points only) has this issue, Line Chart (Points and lines) works OK. Created attachment 102955 [details] Saved by LibreOffice Dev 4.3.1.0, open with MSO 2010 The test file when save as XLSX using 4.3.1.0.0+, and open with MSO, the same result as in comment 8. It was not only an export but also an import issue. Both are fixed now and will be pushed soon. |
The ods file in attachment 102886 [details] contains a simple line chart (dots only). When export as XLSX, data points color are changed. Windows XP SP3 LibreOffice 4.2.6.1