Bug 139247 - CHART: Legends are lost after saving to XLSX
Summary: CHART: Legends are lost after saving to XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss, filter:xlsx
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2020-12-26 18:53 UTC by paulystefan
Modified: 2024-07-01 03:14 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
source of xlsx with graph errors (1.51 MB, application/vnd.oasis.opendocument.spreadsheet)
2020-12-26 18:53 UTC, paulystefan
Details
xlsx of source ods (887.01 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-12-26 18:55 UTC, paulystefan
Details
Simple ODS example (34.39 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-12-27 12:14 UTC, Roman Kuznetsov
Details
The example file and its docx version in current master (273.67 KB, image/png)
2020-12-29 10:54 UTC, Gabor Kelemen (allotropia)
Details
other example (weather chart) (30.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-06-16 10:15 UTC, László Németh
Details
screenshot of the bad export of the chart only with secondary axis data seris (49.35 KB, image/png)
2021-06-16 10:16 UTC, László Németh
Details
extended example paris tokyo budapest with budapest 2 (42.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-07-01 01:05 UTC, paulystefan
Details
extended example paris tokyo budapest with budapest 2 xlsx (12.65 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-07-01 01:07 UTC, paulystefan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description paulystefan 2020-12-26 18:53:26 UTC
Created attachment 168502 [details]
source of xlsx with graph errors

LO 7.04.2 x64 to 

Some basic functions in graphs are not converted to xlsx.

So x and y axle legends disappear or change.


See examples on the sheet like "AT" with graphs after saving of ods in xlsx.

Saving of ods and xlsx is very slow in relation to xlsx in MSO 2016.
Comment 1 paulystefan 2020-12-26 18:55:00 UTC
Created attachment 168503 [details]
xlsx of source ods

xlsx-file is signifikant smaller
Comment 2 Roman Kuznetsov 2020-12-27 12:14:07 UTC
Created attachment 168514 [details]
Simple ODS example
Comment 3 Roman Kuznetsov 2020-12-27 12:16:49 UTC
I confirm the lost of legend in

Version: 7.2.0.0.alpha0+ (x64)
Build ID: ad9e04321df25824d2288a2ef1f4275f070f1cf7
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL

Open Simple ODS example in LO, save it to XLSX and open XLSX in MS Excel => legens on chart are lost
Comment 4 Gabor Kelemen (allotropia) 2020-12-29 10:54:57 UTC
Created attachment 168555 [details]
The example file and its docx version in current master

How it looks in:

Version: 7.2.0.0.alpha0+
Build ID: 2577d9ecea199ca2c10d852cf279053a1b22faf7
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded

The X axis title should be exported, but this does not happen way back to:

Verzió: 6.0.7.3
Build az.: 1:6.0.7-0ubuntu0.18.04.10
CPU szálak: 8; OS: Linux 5.0; Felületmegjelenítés: alapértelmezett; VCL: gtk3; 
Területi beállítások: hu-HU (hu_HU.UTF-8); Calc: group

The secondary Y axis is different from Excel, there it is a different values axis and in Calc it's just a mirror of the primary axis.
Comment 5 paulystefan 2020-12-30 11:05:53 UTC
Some users want also in single curve charts y-axles with numbers left and right.

And that is also possible in MSO with XLSX.

Loss of x-axle is here in action.
Comment 6 paulystefan 2021-01-30 01:28:51 UTC
improved mostly but not perfect in LO 7.1.0.3 x64
Comment 7 László Németh 2021-06-16 10:15:42 UTC
Created attachment 172939 [details]
other example (weather chart)
Comment 8 László Németh 2021-06-16 10:16:55 UTC
Created attachment 172940 [details]
screenshot of the bad export of the chart only with secondary axis data seris

Budapest is ok, but not Tokyo.
Comment 9 paulystefan 2022-07-01 01:05:08 UTC
Created attachment 181047 [details]
extended example paris tokyo budapest with budapest 2

Version: 7.3.4.2 (x64) / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (de_DE); UI: de-DE
Calc: CL

for me are Budapest and Budapest2 not ok.
see attachment
Comment 10 paulystefan 2022-07-01 01:07:23 UTC
Created attachment 181048 [details]
extended example paris tokyo budapest with budapest 2 xlsx

xlsx export with

Version: 7.3.4.2 (x64) / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (de_DE); UI: de-DE
Calc: CL

for me are Budapest and Budapest2 not ok.
see attachment
Comment 11 QA Administrators 2024-07-01 03:14:13 UTC
Dear paulystefan,

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