Download it now!
Bug 125259 - FILEOPEN:XLS: Image overlaps border
Summary: FILEOPEN:XLS: Image overlaps border
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: lowest trivial
Assignee: Not Assigned
Keywords: filter:xls
Depends on:
Blocks: Cell-Border Calc-Images
  Show dependency treegraph
Reported: 2019-05-13 11:20 UTC by AnJingjing
Modified: 2020-08-25 18:46 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

xls file (67.50 KB, application/
2019-05-13 11:21 UTC, AnJingjing
Line displays in Excel (23.74 KB, image/png)
2019-05-13 11:23 UTC, AnJingjing
Line displays in Numbers (42.90 KB, image/png)
2019-05-13 11:24 UTC, AnJingjing
line not display in Calc (57.81 KB, image/png)
2019-05-13 11:26 UTC, AnJingjing
comparison MSO 2010 and LibreOffice 6.4 Master (115.75 KB, image/png)
2019-10-21 11:57 UTC, Xisco Faulí
Image moved to another place (92.00 KB, application/
2019-10-21 12:00 UTC, Xisco Faulí

Note You need to log in before you can comment on or make changes to this bug.
Description AnJingjing 2019-05-13 11:20:46 UTC
Please see attached file, it is created using POI in java code.
There should be a line on the left side of the QR code, but not shown in LibreOffice Calc. It shows in Excel and Mac/IPhone Numbers.

Steps to Reproduce:
I am using POI creating xls file, there are many logic, all logic works fine but a line not display. This line display in microsoft Excel and in Numbers in iphone. But not display in libreoffice calc, neither on ubuntu not in windows.

Actual Results:
solid line not shown.

Expected Results:
solid line should display.

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 AnJingjing 2019-05-13 11:21:52 UTC
Created attachment 151352 [details]
xls file

the xls file
Comment 2 AnJingjing 2019-05-13 11:23:59 UTC
Created attachment 151353 [details]
Line displays in Excel
Comment 3 AnJingjing 2019-05-13 11:24:53 UTC
Created attachment 151354 [details]
Line displays in Numbers
Comment 4 AnJingjing 2019-05-13 11:26:44 UTC
Created attachment 151355 [details]
line not display in Calc
Comment 5 m.a.riosv 2019-05-13 12:09:24 UTC
Black line it's not showed with calc, but I'm not sure it is part of the QR code.

Adding the line with calc it is there at reopening the file.
Comment 6 m.a.riosv 2019-05-13 12:09:39 UTC
Comment 7 AnJingjing 2019-05-14 01:42:19 UTC
thanks. The line is not part of the QRCode, it is a kind of "Shape" which created in Java POI code:
                HSSFSimpleShape line1 = patriarch.createSimpleShape(a1);

                line1.setLineStyleColor(10, 10, 10);
                line1.setFillColor(90, 10, 200);

You can drag the QR code and enlarge you can see that there is no line in QRCode. I draw a "shape" using POI code beside the QRcode, by draw, I mean "insert a shape to the xls file".

The result is that the line not show in Calc but can display in other program like Excel or Numbers.

Could you analyze the file? I believe the shape is in the file because other program can read it. But calc can't, could you help analyze the reason why the shape not displayed?
Comment 8 Xisco Faulí 2019-10-21 11:57:58 UTC
Created attachment 155191 [details]
comparison MSO 2010 and LibreOffice 6.4 Master
Comment 9 Xisco Faulí 2019-10-21 11:58:24 UTC
Reproduced in

Build ID: de4839e66d3d195315729b95cc144cdab96b6e74
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
Comment 10 Xisco Faulí 2019-10-21 11:59:08 UTC
Also reproduced in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-
Comment 11 Xisco Faulí 2019-10-21 12:00:37 UTC
Created attachment 155192 [details]
Image moved to another place
Comment 12 Xisco Faulí 2019-10-21 12:01:59 UTC
just an overlapping problem...
Comment 13 AnJingjing 2019-11-20 03:24:36 UTC
(In reply to Xisco Faulí from comment #12)
> just an overlapping problem...

Could you share the progress for now?