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: 2025-09-06 03:11 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?
Comment 12 QA Administrators 2025-09-06 03:11:07 UTC
Dear Luke,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug