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: dataLoss
Depends on:
Blocks: OOXML-Chart OOXML-Doc-Themes
  Show dependency treegraph
 
Reported: 2015-08-23 05:09 UTC by Luke
Modified: 2023-09-06 15:02 UTC (History)
11 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 Comment hidden (obsolete)
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.
Comment 9 QA Administrators 2021-05-20 04:34:32 UTC Comment hidden (obsolete)
Comment 10 Luke 2022-02-02 00:15:55 UTC
attachment 118096 [details] Chart still disappear in Version: 7.4.0.0.alpha0+ / Build ID: 026e2f437e969d75209ed05211e7f02349035b98
Comment 11 Stéphane Guillou (stragu) 2023-09-06 15:02:16 UTC
Reproduced with attachment 118096 [details] in recent master build:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2ae9eb8be8d7eb9c3a72953a295d128b45639ea3
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Tomaz, how do Chart styles and Document themes relate on MSO's side?