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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: lowest trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: Cell-Border Calc-Images
  Show dependency treegraph
 
Reported: 2019-05-13 11:20 UTC by AnJingjing
Modified: 2022-08-26 06:30 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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

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
Description:
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
https://en.wikipedia.org/wiki/QR_code
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.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
                line1.setLineStyleColor(10, 10, 10);
                line1.setFillColor(90, 10, 200);
                line1.setLineWidth(HSSFShape.LINEWIDTH_ONE_PT);
                line1.setLineStyle(HSSFShape.LINESTYLE_SOLID);


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

Version: 6.4.0.0.alpha1+
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-3.3.0.4
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...

Hi,
Could you share the progress for now?
Comment 14 QA Administrators 2022-08-26 03:36:22 UTC Comment hidden (obsolete)
Comment 15 AnJingjing 2022-08-26 06:30:34 UTC
This bug is still present in:

Version: 7.2.7.2 (x64) / LibreOffice Community
Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded