Bug 92348 - Chart which is invisible in Excel shown in Calc
Summary: Chart which is invisible in Excel shown in Calc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
Reported: 2015-06-26 11:41 UTC by Alain Williams
Modified: 2019-05-14 12:46 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Screenshot showing blank cells (94.74 KB, image/jpeg)
2015-06-26 11:41 UTC, Alain Williams
sample file (194.98 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-01-30 15:51 UTC, Xisco Faulí

Note You need to log in before you can comment on or make changes to this bug.
Description Alain Williams 2015-06-26 11:41:17 UTC
Created attachment 116839 [details]
Screenshot showing blank cells

When viewing a .xlsx file I find that some of the cells are not displayed, the data is there in that I can move the cursor over and see contents.

The original file can be found here:

(Sorry for the subject matter, but it is where I found the problem).

A screen shot shows the issue.

I am running 64 bit CentOS 6.
I see the same problem under CentOS 7 (libre office
Comment 1 Pedro 2015-06-26 13:03:59 UTC
This also looks the same and works with LibreOffice v4.4.3 under Windows XP.

The blank cells are a chart that doesn't even show up on Excel 2003 or 2010...

You can click on the empty area and delete the object (with the Del key only)

Moving the chart in LibreOffice (where the chart shows the axes) causes the program to crash with Fatal Error: bad rational: zero denominator.
Comment 2 Matthew Francis 2015-08-12 09:35:15 UTC
Bibisect 43all points to the range

# first bad commit: [ba6eb41acb8df58f3009920f8ab8b32a3e1b764e] source-hash-ae4e4a11d4300f7448cb6bd170fcb034542caddc

The most likely thing in there is the below commit.

commit 44cfc7cb6533d827fd2d6e586d92c61d7d7f7a70
Author: Michael Meeks <michael.meeks@suse.com>
Date:   Tue Oct 9 12:22:23 2012 +0100

    re-base on ALv2 code. Includes (at least) relevant parts of:

(The later crash is a separate issue)
Comment 3 Matthew Francis 2015-08-12 09:42:19 UTC
-> Crash mentioned in comment 1 split into bug 93382
Comment 4 Robinson Tryon (qubit) 2015-12-13 11:13:02 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2017-10-23 14:10:32 UTC Comment hidden (obsolete)
Comment 6 Xisco Faulí 2017-10-23 14:22:11 UTC
Still reproducible in

Build ID: d76c4e5c9aaf8bd27ec97679bcaeba5b18aca493
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group
Comment 7 Xisco Faulí 2018-01-30 15:30:35 UTC
Hi Alain Williams,
The file is no longer accesible. Could you please attach it in here ?
Comment 9 Alain Williams 2018-01-30 15:45:50 UTC
Sorry: my mouse triple clicked, here is a saner URL:

Comment 10 Xisco Faulí 2018-01-30 15:51:01 UTC
Created attachment 139447 [details]
sample file
Comment 11 QA Administrators 2019-01-31 03:48:03 UTC Comment hidden (obsolete)
Comment 12 Roman Kuznetsov 2019-02-25 20:05:40 UTC
still repro in

Version: (x64)
Build ID: 47c498417248444cab4e8f597ddeec4e0d585a71
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-02-21_08:39:21
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 13 Gabor Kelemen (allotropia) 2019-05-14 11:30:44 UTC
This seems to be gone in very current bibisect-win32-6.3 :

Build ID: c5c425296debb2fbd67af8ec29f87e285d08575f
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded

Bibisect says this commit did the trick: 

$ git bisect log
# bad: [836932d586429932ed61dd6490f30db26ee9c24f] source c5c425296debb2fbd67af8ec29f87e285d08575f
# good: [ea94942caaf195b8d8b2d5c2abb523359ab390e7] source a20a2d7e0d28658f2d9089da076961a599833a28
git bisect start 'origin/master' 'oldest'
# good: [c9f282d8b3525b381dd8bd21663c48067237498a] source 0c314c90a7af7d9e855e3cacfd8e7a31ed065a26
git bisect good c9f282d8b3525b381dd8bd21663c48067237498a
# good: [ac38d0460dd17e5c6723ae3b7dbdf02cb0f136fc] source 5355f0d691cdefcebec25a555344d5cd78605c71
git bisect good ac38d0460dd17e5c6723ae3b7dbdf02cb0f136fc
# good: [0e4b1d743a8e6dec583e9931abe76fa268647b26] source b9e75051807b807a6c9b96433390e09abaf38c24
git bisect good 0e4b1d743a8e6dec583e9931abe76fa268647b26
# good: [b05b033002039a55e13ce8f9f14ff31963da5fa0] source 55e28737e973b40f72d398c9bb7a4a41307eb562
git bisect good b05b033002039a55e13ce8f9f14ff31963da5fa0
# good: [b81d0a51785cf0e78f6e82100356aefc7fc8978d] source ed423da9d968d6f534a6d4d27b45aa96cd5b47d4
git bisect good b81d0a51785cf0e78f6e82100356aefc7fc8978d
# good: [1f7d629537c781404f8e9b1c82174dddc7832f37] source 0e86f0c79e29bde4a29ef77046621398b6bede63
git bisect good 1f7d629537c781404f8e9b1c82174dddc7832f37
# good: [bdcbbf9c3b6c559e9c35e9429fc72c46c0892e12] source 258761507b08f6965c7f57b26fa5a02a692903a1
git bisect good bdcbbf9c3b6c559e9c35e9429fc72c46c0892e12
# bad: [ef5f4d77973c354279c5473946661a69366c9a85] source 3d6e2081f0ab71ad4515fed864c3f36566e466c3
git bisect bad ef5f4d77973c354279c5473946661a69366c9a85
# good: [765a74f8a193e14bd16d11f85e634ecbdaa0f1ca] source bfdb5a2d96483907cd4b757398b3df159a9e7af2
git bisect good 765a74f8a193e14bd16d11f85e634ecbdaa0f1ca
# good: [9a0bda924b953dc46cfe15e60d5f48fc55777688] source 59278fa913116482c7d02e0729487ccd153545ae
git bisect good 9a0bda924b953dc46cfe15e60d5f48fc55777688
# bad: [aebad265fb4d7655ea1a070c0577e2644c65c9dd] source d27ad84ec7a0aafb07d6a6152c686f4bc802f661
git bisect bad aebad265fb4d7655ea1a070c0577e2644c65c9dd
# bad: [ca5a38f2bf6bb2013d4ea1436625c26358f8eadc] source d0119ff7f2c68aa05286bd303128f3a69c6bbd6a
git bisect bad ca5a38f2bf6bb2013d4ea1436625c26358f8eadc
# good: [8c39f73d71c838a4890233f40f91bec3f204ad25] source 5218ca22b472a80969a715e38d7cb8d052be4b6a
git bisect good 8c39f73d71c838a4890233f40f91bec3f204ad25
# first bad commit: [ca5a38f2bf6bb2013d4ea1436625c26358f8eadc] source d0119ff7f2c68aa05286bd303128f3a69c6bbd6a
Comment 14 Xisco Faulí 2019-05-14 12:46:18 UTC
Fixed in

Build ID: 630db80d17616d635cf2e5f1d5a0852428b794a3
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