Bug 99877 - [CHART] XLTX wrongly imported chart
Summary: [CHART] XLTX wrongly imported chart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on: 127397
Blocks: OOXML-ComboChart
  Show dependency treegraph
 
Reported: 2016-05-16 11:54 UTC by Dennis Roczek
Modified: 2024-03-02 14:24 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
AVEM.xltx with broken chart on tab "Ergebnis" (40.18 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.template)
2016-05-16 11:54 UTC, Dennis Roczek
Details
AVEM1.ods - converted from the AVEM.XLTX (32.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-16 11:55 UTC, Dennis Roczek
Details
escel and libreoffice calc comparison (167.45 KB, image/png)
2016-05-16 11:59 UTC, Dennis Roczek
Details
Copy and Paste does work (158.37 KB, image/png)
2016-05-16 12:02 UTC, Dennis Roczek
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Roczek 2016-05-16 11:54:18 UTC
Created attachment 125086 [details]
AVEM.xltx with broken chart on tab "Ergebnis"

On the tab 'Ergebnis' you can see the chart which is imported wrongly. I will attach screenshpts of excel 2013 and the same file converted by excel in xltx and ods.


PS: I wasn't sure if the component is filters and storage or chart... I guess it is chart as the same is happening with an converted ods files.
Comment 1 Dennis Roczek 2016-05-16 11:55:16 UTC
Created attachment 125087 [details]
AVEM1.ods - converted from the AVEM.XLTX
Comment 2 Dennis Roczek 2016-05-16 11:59:52 UTC
Created attachment 125088 [details]
escel and libreoffice calc comparison

BTW:

Version: 5.2.0.0.alpha1+
Build-ID: d8f73e1da3f799b004dec3875f433aa44685fc23
CPU-Threads: 4; BS-Version: Windows 6.2; UI-Render: Standard; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-05-01_13:08:56
Gebietsschema: de-DE (de_DE)
Comment 3 Dennis Roczek 2016-05-16 12:02:32 UTC
Created attachment 125089 [details]
Copy and Paste does work

Interestingly that copy and paste from excel does work!
Comment 4 Buovjaga 2016-05-16 12:58:53 UTC
Confirmed.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.2.0.0.alpha1+
Build ID: 1dbdc947fcc9d843764731e6dae7ce60082576e0
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on May 14th 2016
Comment 5 QA Administrators 2017-05-22 13:41:14 UTC Comment hidden (obsolete)
Comment 6 Dennis Roczek 2017-05-25 14:11:40 UTC
still repro, nothing changed
Version: 5.3.0.3 (x64)
Build-ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
CPU-Threads: 4; BS-Version: Windows 6.19; UI-Render: Standard; Layout-Engine: neu; 
Gebietsschema: de-DE (de_DE); Calc: group
Comment 7 eisa01 2018-03-17 15:07:25 UTC
Still present

Version: 6.1.0.0.alpha0+
Build ID: 8e8dd8f320a3ff59ff8a16c1a7a867888ce80700
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-13_23:59:29
Locale: en-US (en_US.UTF-8); Calc: group
Comment 8 QA Administrators 2019-03-18 03:45:27 UTC Comment hidden (obsolete)
Comment 9 eisa01 2019-04-20 17:42:31 UTC
This is still present

Version: 6.3.0.0.alpha0+
Build ID: ea9c13be02ba731074fa4207944ff7df40a0fb5c
CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-04-10_20:43:17
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 10 QA Administrators 2021-04-20 03:54:53 UTC Comment hidden (obsolete)
Comment 11 Dennis Roczek 2021-08-17 09:41:55 UTC
still repro with

Version: 7.1.2.2 (x64) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
Comment 12 Justin L 2022-03-02 05:58:14 UTC
This seems primarily like bug 127397 - where the axis X / Y axis are flipped. So lets make this report dependent on that one, and then any remaining issues (like the extra Mentor G series not seen in Excel) can be cleaned up.
Comment 13 QA Administrators 2024-03-02 03:15:50 UTC Comment hidden (obsolete)
Comment 14 Dennis Roczek 2024-03-02 14:24:32 UTC
still nothing changed in

Version: 24.2.0.3 (X86_64) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 4; OS: macOS 11.7.10; UI render: Skia/Raster; VCL: osx
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded