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: 2024-08-26 03:15 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
Comment 16 QA Administrators 2024-08-26 03:15:41 UTC
Dear AnJingjing,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug