Bug 93597 - FILEOPEN:Round-tripping OOXML chart with style other than default results in blank chart
Summary: FILEOPEN:Round-tripping OOXML chart with style other than default results in ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
4.4.5.2 release
Hardware: All All
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OOXML-Chart OOXML-Doc-Themes
  Show dependency treegraph
 
Reported: 2015-08-23 05:09 UTC by Luke
Modified: 2019-05-20 05:32 UTC (History)
9 users (show)

See Also:
Crash report or crash signature:


Attachments
Example pie chart (15.11 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-08-23 05:09 UTC, Luke
Details
Result of roundtrip in Calc and Excel (142.00 KB, image/png)
2015-08-23 05:14 UTC, Luke
Details
An example that shows both bar and pie charts with styles fail to rt (manual color works) (32.30 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-08-30 08:08 UTC, Luke
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Luke 2015-08-23 05:09:15 UTC
Created attachment 118096 [details]
Example pie chart

Steps to reproduce:
1. Open the attachment in Calc
2. Save as XLSX
3. Close and open

When opened in Calc, the chart is missing. When opened in Excel, the colors are wrong.
Comment 1 Luke 2015-08-23 05:14:11 UTC
Created attachment 118097 [details]
Result of roundtrip in Calc and Excel
Comment 2 Joel Madero 2015-08-23 20:00:12 UTC
In the future please include:
Your operating system;
Version of LibreOffice.


Confirmed:
Ubuntu 15.04 x64
LibreOffice 5.0.0.5
LibreOffice 4.4.5.2 (it's even worse)


Setting as:
NEW;
Critical: Loss of data doing a relatively common task (pie chart in xlsx) - it's not technically a "loss" because the data is there but for an avg. user, as far as they are concerned the data is gone;
High: Default seems fine here

Would be nice to know if this is a regression - if it is then:
1) We should bump it to highest;
2) We should request a bibisect (bibisectRequest in whiteboard);
3) "regression" in keyboard;


http://downloadarchive.documentfoundation.org/libreoffice/old/
Comment 3 Luke 2015-08-30 08:08:28 UTC
Created attachment 118276 [details]
An example that shows both bar and pie charts with styles fail to rt (manual color works)

I did some more testing and discovered that this affects all charts (pie charts, bar charts...) that use a color style. 

Steps to reproduce an offending chart in Excel: 
1. Create a chart
2. Select the chart
3. click the "paint brush" icon
4. Style -> any style other than default
5. Save 
6. Round trip in LibreOffice

Markus might have some input on this subject.
Comment 5 QA Administrators 2017-03-06 15:00:44 UTC Comment hidden (obsolete)
Comment 6 Luke 2017-03-09 23:29:02 UTC
Chart still disappear in Version: 5.4.0.0.alpha0+
Build ID: 5b805de10a1b05647b616e726f0a8b88ff30ae77
Comment 7 Xisco Faulí 2018-02-26 11:46:02 UTC
Dear Bartosz,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.
Comment 8 Luke 2019-02-25 19:43:19 UTC
attachment 118096 [details] Chart still disappear in Version: 6.3.0.0.alpha0+ (x64)
Build ID: d57af77047a88d3d4ae2edd4c91d001722d55eb2

Not the simplified example, attachment 118276 [details], using default styles is working as of 6.2. Could be related to Bug 84205, which saw similar improvements to default theme handling.