Bug 40124 - Combined chart lines moved importing Excel XLS and XLSX
Summary: Combined chart lines moved importing Excel XLS and XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: Confirmed:
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: OOXML-ComboChart
  Show dependency treegraph
Reported: 2011-08-15 22:58 UTC by Christopher M. Penalver
Modified: 2021-05-03 07:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Sample XLS resaved in MSO 2016 as XLSX (33.72 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-11-10 11:01 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher M. Penalver 2011-08-15 22:58:19 UTC
Downstream bug may be found at:

OOo bug may be found at:

1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

2) apt-cache policy libreoffice-calc
  Installed: 1:3.3.3-1ubuntu2
  Candidate: 1:3.3.3-1ubuntu2
  Version table:
 *** 1:3.3.3-1ubuntu2 0
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

3) What is expected to happen in LibreOffice Calc via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/179531/+attachment/2145491/+files/to-m20e_4.xls && localc -nologo to-m20e_4.xls

is the graph looks like as it does in Excel ( https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/179531/+attachment/2145492/+files/SS_image.gif ).

4) What happens instead is the colored lines of the graph are moved in Calc.
Comment 1 Björn Michaelsen 2011-12-23 12:33:47 UTC Comment hidden (obsolete)
Comment 2 Christopher M. Penalver 2012-01-16 17:36:30 UTC
Reproducible in:
lsb_release -rd
Description: Ubuntu precise (development branch)
Release: 12.04

apt-cache policy libreoffice-impress
  Installed: 1:3.5.0~beta2-2ubuntu3
  Candidate: 1:3.5.0~beta2-2ubuntu3
  Version table:
 *** 1:3.5.0~beta2-2ubuntu3 0
        500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages
        100 /var/lib/dpkg/status
Comment 3 retired 2014-01-21 10:40:28 UTC
OS > All
Comment 4 Joel Madero 2015-05-02 15:41:31 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2015-06-20 13:12:38 UTC

Win 7 Pro 64-bit Version:
Build ID: 3ecef8cedb215e49237a11607197edc91639bfcd
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-06-19_23:16:58
Locale: fi-FI (fi_FI)
Comment 6 QA Administrators 2016-09-20 10:10:36 UTC Comment hidden (obsolete)
Comment 7 Thomas Lendo 2017-12-06 23:00:03 UTC
Still repro in Version:
Build ID: aa0b08980aba7bc82ab75151129b0c643cde7dfa
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; 
Locale: de-DE (de_DE.UTF-8); Calc: group threaded
Comment 8 QA Administrators 2018-12-07 03:46:56 UTC Comment hidden (obsolete)
Comment 9 Timur 2020-11-10 11:01:22 UTC
Created attachment 167166 [details]
Sample XLS resaved  in MSO 2016 as XLSX

Repro 7.1+ for both XLS and MSO-saved XLSX.
Comment 10 Gabor Kelemen (allotropia) 2020-11-10 17:35:18 UTC
Combined chart comprising of Line, Dot with Lines, Dot with Lines and Markers type data series. We still don't support such complexity.