Bug 103963 - FILEOPEN: DOCX: Chart bars not imported
Summary: FILEOPEN: DOCX: Chart bars not imported
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Hardware: All All
: high major
Assignee: Balázs Varga
Keywords: bibisected, bisected, filter:docx, regression
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
Reported: 2016-11-16 22:44 UTC by Xisco Faulí
Modified: 2019-10-14 14:32 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:

How it looks in MSO 2010 (19.42 KB, image/png)
2017-07-25 20:51 UTC, Xisco Faulí
How it looks in LO MASTER (55.07 KB, image/png)
2019-10-14 13:51 UTC, Balázs Varga

Note You need to log in before you can comment on or make changes to this bug.
Description Xisco Faulí 2016-11-16 22:44:37 UTC
1. Open attachment 93843 [details]

Observed behaviour: Red chart bars are not imported

Reproduced in 

Build ID: 757a60d01dd152aadab2ba3c8224252481ce8a88
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; Layout
Engine: new; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

but not in

Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
Comment 1 Xisco Faulí 2016-11-16 22:46:11 UTC
Regression introduced by:

author	Jean-Tiare Le Bigot <admin@jtlebi.fr>	2016-10-13 21:43:41 (GMT)
committer	Markus Mohrhard <markus.mohrhard@googlemail.com>	2016-11-06 06:02:27 (GMT)
commit	4bcf1872bbe9db1388769485a7e4c0cbcce3d53c (patch)
tree	0110875cf6db25b7208099e9394995254111b221
parent	17e9dc436bc6ad8d3a5bbde15d4d47262650aa2c (diff)

chartx: fix sparse chart import

Adding CC: to Jean-Tiare Le Bigot
Comment 2 Jean-Tiare LE BIGOT 2016-11-17 01:08:47 UTC
I wonder how this document has been created. It seems to use stranegely exotic features...

Basically, there are (internally):
1/ a bar chart
2/ a line chart

Both have 13 elements and, interesting fact, there own category column. That makes 4 series of 13 elements.

The fun begins when, strangely, the category series of the line chart decides to declare 15 elements ans start at offset 2.

To handle this, I guess MSO parses the <c:f>Sheet1!$A$4:$A$16</c:f> like fields and uses it as a base for offset calculation.

But that would be a *lot* of non-fun to implement... Anyway, that's the root cause.
Comment 3 Markus Mohrhard 2016-11-17 07:17:48 UTC
Moving to the chart component to make sure it shows up in my regression list.
Comment 4 Xisco Faulí 2016-11-17 09:53:47 UTC
The mentioned commit is also affecting attachment 85112 [details] as the second chart is no longer displayed after the commit. Raising severity and priority
Comment 5 Jean-Tiare LE BIGOT 2016-11-18 01:06:37 UTC
I h've commited a tentative hack/fix to https://gerrit.libreoffice.org/#/c/30942/. I'm really not proud of it...

It should use the formula parser instead of this ugly hack but it's not possible in that function and changing it to accept more parameters would break the API (inheritance...). And it's only available in calc anyway, which is not using this code path either.

Moreover, whenever you start to take data into account that you previously ignored (the offset in this specific commit), you start to see some bugs that were previously hidden. For instance, the second graph in the doc you attached loads fine except that... there are now 11 empty leading cells as requested by the file. Word is smart enough to trim that at draw time. I did not find where to do this.

I'm out of luck... Trying to do well. Break even more :(

I'm definitively not an expert regarding LO code base. Could you point me through ways to improve this ? Especially on how to trim the leading cells ? I'm starting to wonder if we should not revert all this mess...
Comment 6 Markus Mohrhard 2016-11-18 08:02:19 UTC
Don't worry. I'm back from vacation and have a look at the chart regressions.
Comment 7 Xisco Faulí 2016-12-01 17:58:14 UTC
Hello Jean-Tiare,
I've just tested your commit in

Build ID: 18b3138a7ac4da823e41640bed8a4707029b8fb0
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

and the problems are fixed now. Thank you very much for your work.
Close this issue as RESOLVED FIXED whenever you have some time.

Comment 8 Xisco Faulí 2016-12-08 09:22:04 UTC
Well, my previous comment 7 wasn't totally correct.

Build ID: 7fc84a8e6678e3d0399983f5a078c9b2beb6ee4b
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

the chart bars from attachment 93843 [details] aren't visible yet. However, the problem with regards to attachment 85112 [details] is already fixed, thus, lowering severity and priority
Comment 9 Xisco Faulí 2017-07-25 20:51:46 UTC
Created attachment 134859 [details]
How it looks in MSO 2010
Comment 10 Xisco Faulí 2017-07-25 20:52:57 UTC
Still reproducible in

Build ID: 1e87e93132f808ab95eab932b36bfe40d3cc607a
CPU threads: 1; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2017-07-25_06:09:29
Locale: es-ES (es_ES); Calc: group

@Dennis, do you think you could take a look at this one at some point?
Comment 11 QA Administrators 2018-07-26 02:41:02 UTC Comment hidden (obsolete)
Comment 12 Aron Budea 2018-10-30 08:42:05 UTC
Still occurs in (140434a7677946020bb2c6db9ed3afe8998ee7d0) / Windows 7.
Comment 13 qscesz84563 2018-11-29 08:08:59 UTC
Still exists in version
Version: (x64)
Build ID: 0f25a3c36f27fd51453b9a9115f236b83c143684
CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-11-27_20:06:55
Locale: zh-TW (zh_TW); UI-Language: en-US
Calc: threaded
Comment 14 Xisco Faulí 2019-09-02 12:25:54 UTC
Still reproducible in

Build ID: 41cd3e8e817c8c33a13608e62eeb06ce2c6977e4
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

@Balázs Varga, since you recently fixed bug 124083, which are introduced by the same commit, I thought you might be interested in this issue...
Comment 15 Balázs Varga 2019-10-14 13:50:12 UTC
Probably, this patch could help here too:

Balazs Varga committed a patch related to this issue.
It has been pushed to "master":


tdf#128016 Chart OOXML Import: fix duplicated category labels

It will be available in 6.4.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.
Comment 16 Balázs Varga 2019-10-14 13:51:19 UTC
Created attachment 155003 [details]
How it looks in LO MASTER
Comment 17 Xisco Faulí 2019-10-14 13:56:55 UTC
Verified in

Build ID: 9b5dad13b56bdde7c40970351af3da3a2c3c9350
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

@Balazs Varga, thanks for fixing this issue. Can it be backported to libreoffice 6.3?
Comment 18 Balázs Varga 2019-10-14 14:32:11 UTC
> @Balazs Varga, thanks for fixing this issue. Can it be backported to
> libreoffice 6.3?

Yes, it would be good. But there will be some merge conflict. My first tip is we need these too: https://cgit.freedesktop.org/libreoffice/core/commit/?id=fa0a981af41a2606541eec1cb20a379a739691e0 and https://cgit.freedesktop.org/libreoffice/core/commit/?id=8906275d40a1828db684e7d9c9bc4934a937bc6c

but I will check first. :)