Bug 103511 - Right-aligned hyperlink in shrinked cell contaminates following cells if they are empty
Summary: Right-aligned hyperlink in shrinked cell contaminates following cells if they...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
Reported: 2016-10-26 07:52 UTC by V.I.
Modified: 2021-11-17 13:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Two lines illustrating the bad behaviour and the good behaviour of a hyperlink (8.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-10-26 07:55 UTC, V.I.

Note You need to log in before you can comment on or make changes to this bug.
Description V.I. 2016-10-26 07:52:30 UTC
When there's a hyperlink in a cell (cell #1) that I manually shrinked and right-aligned, and if the following (right) cell (cell #2) is empty, the hyperlink of cell #1 is also clickable in cell #2 (and the cells to its right, also), and makes the editing of cell #2 difficult/annoying (see the first line in my attached file).
This bad behaviour doesn't happen when the cell # 2 is not empty (see the second line in my attached file).

Steps to Reproduce:
1. Create a new document in Calc
2. Put a hyperlink in the A1 cell
3. Shrink the A1 cell so that it's just a few (say, 5) characters long
4. Right align the A1 cell
5. Put the mouse over the B1 cell

Actual Results:  
When the mouse is over the B1 cell, there's a pop-up with the A1 cell hyperlink. The B1 cell is not easily editable.

Expected Results:
There shouldn't be any pop-up in the B1 cell. The B1 cell should be easily editable.

Reproducible: Always

User Profile Reset: No

Additional Info:
- I have the problem on Ubuntu with version of LibreOffice, and still have the problem with a version manually installed on my Ubuntu.

- I tried and find this bug in the bugs-list. I didn't find it, but maybe this one is related to mine ?

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0
Comment 1 V.I. 2016-10-26 07:55:30 UTC
Created attachment 128277 [details]
Two lines illustrating the bad behaviour and the good behaviour of a hyperlink
Comment 2 Buovjaga 2016-11-11 20:58:19 UTC
Repro from scratch.

Arch Linux 64-bit, KDE Plasma 5
Build ID: 553cfda502a1516673233e409f91372766da6c4d
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on November 11th 2016

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-
Comment 3 QA Administrators 2018-08-22 02:36:38 UTC Comment hidden (obsolete)
Comment 4 V.I. 2018-09-02 14:26:46 UTC
This bug is still present in the latest downloadable LibreOffice version. Here's the information from Help - About LibreOffice :

Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; 
Locale: fr-FR (fr_FR.UTF-8); Calc: group threaded
Comment 5 QA Administrators 2019-10-28 03:29:06 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2021-10-28 04:14:26 UTC Comment hidden (obsolete)
Comment 7 Kevin Suo 2021-11-17 13:33:12 UTC
The cell B1 is easily editable. Activating the hyperlink requires Ctrl-click, thus there no problem with editing.

However the hyperlink is still set to B1, if you Ctrl-click in B1 the hyperlink is open. As a result this should remain open.

Version: / LibreOffice Community
Build ID: 35d9d085436e159bdeb6cba9c94865d6346af530
CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded