Bug 121034 - Mouse pointer turns to hand over hyperlink even without Ctrl being pressed, hence cell not selectable by mouse
Summary: Mouse pointer turns to hand over hyperlink even without Ctrl being pressed, h...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 124996 (view as bug list)
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2018-10-29 16:20 UTC by Buovjaga
Modified: 2021-10-23 05:55 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Example of such a Link (3.76 KB, image/png)
2019-01-14 13:58 UTC, Gerhard Weydt
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Buovjaga 2018-10-29 16:20:56 UTC
1. Open 144647
2. Hover over the link in A4

Arch Linux 64-bit
Version: 6.2.0.0.alpha1+
Build ID: bfa6aeb379e5dfcf6f1f97b3365ab551995ab3d5
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on 28 October 2018

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 1 Buovjaga 2018-10-29 16:24:01 UTC
This also happens when:
- hyperlink in a cell, cursor in a shape or text box
- hyperlink in a shape or text box, hover mouse pointer above hyperlink
- hyperlink in a shape or text box, cursor in same shape or text box
- hyperlink in a shape or text box, cursor in other shape or text box
Comment 2 Buovjaga 2018-10-29 16:27:21 UTC
Urgh, step 1 should be
Open attachment 144647 [details]
Comment 3 Gerhard Weydt 2018-12-31 23:18:12 UTC
Confirmed with
Version: 6.2.0.1 (x64)
Build-ID: 0412ee99e862f384c1106d0841a950c4cfaa9df1
CPU-Threads: 4; BS: Windows 10.0; UI-Render: GL; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded
and also in 6.0.6.2
on Windows 10 x64.
I especially want to draw the attention to the fact that as a consequence you cannot select the underlying cell using the mouse, you have to reach it using the up/down/left/right keys. Hence I extended the title.
As far as I could test it, Excel does behave as I would expect.
Comment 4 Gerhard Weydt 2018-12-31 23:25:48 UTC
And the link even covers the adjacent cells to the right if the column containing it is hidden!
Comment 5 Harald Koester 2019-01-04 21:54:23 UTC Comment hidden (obsolete)
Comment 6 Gerhard Weydt 2019-01-05 18:52:03 UTC
(In reply to Harald Koester from comment #5)
> (In reply to Gerhard Weydt from comment #3)
> > I especially want to draw the attention to the fact that as a consequence
> > you cannot select the underlying cell using the mouse, you have to reach it
> > using the up/down/left/right keys. Hence I extended the title.
> On my system (win10, 64 bit) no problem with reaching the cell with the
> hyperlink by using the mouse.

It is no problem to reach the cell containing the hyperlink, but it is one for a subsequent cell covered by the sometimes quite long text of the hyperlink, or at least if you try to click into the part of the cell which is covered by it. I hope you can confirm that, as I am also using Windows 10, 64 bit.
Comment 7 Harald Koester 2019-01-08 12:53:29 UTC
(In reply to Gerhard Weydt from comment #6)
> (In reply to Harald Koester from comment #5)
> > (In reply to Gerhard Weydt from comment #3)
> > > I especially want to draw the attention to the fact that as a consequence
> > > you cannot select the underlying cell using the mouse, you have to reach it
> > > using the up/down/left/right keys. Hence I extended the title.
> > On my system (win10, 64 bit) no problem with reaching the cell with the
> > hyperlink by using the mouse.
> 
> It is no problem to reach the cell containing the hyperlink, but it is one
> for a subsequent cell covered by the sometimes quite long text of the
> hyperlink, or at least if you try to click into the part of the cell which
> is covered by it. I hope you can confirm that, as I am also using Windows
> 10, 64 bit.

Yes, confirmed:
If you click (without pressing Ctrl) a hyperlink, the corresponding cell(s), shape or text box are not selected. If you click beside a hyperlink, but inside the corresponding cell(s), shape or text box these cell(s), shape or box are selected. But I'm not sure if this should be treated as a bug.
Comment 8 Gerhard Weydt 2019-01-09 00:20:09 UTC
(In reply to Harald Koester from comment #7)
> (In reply to Gerhard Weydt from comment #6)
> > (In reply to Harald Koester from comment #5)
> > > (In reply to Gerhard Weydt from comment #3)
> > > > I especially want to draw the attention to the fact that as a consequence
> > > > you cannot select the underlying cell using the mouse, you have to reach it
> > > > using the up/down/left/right keys. Hence I extended the title.
> > > On my system (win10, 64 bit) no problem with reaching the cell with the
> > > hyperlink by using the mouse.
> > 
> > It is no problem to reach the cell containing the hyperlink, but it is one
> > for a subsequent cell covered by the sometimes quite long text of the
> > hyperlink, or at least if you try to click into the part of the cell which
> > is covered by it. I hope you can confirm that, as I am also using Windows
> > 10, 64 bit.
> 
> Yes, confirmed:
> If you click (without pressing Ctrl) a hyperlink, the corresponding cell(s),
> shape or text box are not selected. If you click beside a hyperlink, but
> inside the corresponding cell(s), shape or text box these cell(s), shape or
> box are selected. But I'm not sure if this should be treated as a bug.

Why should this not be considered a bug?
I think we all agree that in case Ctrl is pressed the behaviour is correct, namely that the hyperlink is selected and executed, when it is clicked.
But if Ctrl isn't pressed, I think that this shows the clear intention to use the normal behaviour of Calc, namely to select the cell clicked on, regardless of the contents displayed in that region of the screen.
As I remarked already in comment 3, Excel, as far as I could test it without a MS Office license, works as I would expect Libo to work; so I think that is a behaviour many people would expect, and which I personally also do.
Comment 9 Timur 2019-01-14 11:45:27 UTC
I don't understand this bug. 
Mouse pointer turns to hand over hyperlink, but I can select cell by mouse anywhere outside the link clicking in empty space in cell (right or above .)
Comment 10 Gerhard Weydt 2019-01-14 13:58:40 UTC
Created attachment 148307 [details]
Example of such a Link
Comment 11 Gerhard Weydt 2019-01-14 14:00:56 UTC
(In reply to Timur from comment #9)
> I don't understand this bug. 
> Mouse pointer turns to hand over hyperlink, but I can select cell by mouse
> anywhere outside the link clicking in empty space in cell (right or above .)

In most cases rows are not higher than the room needed or the text, and so the first one, two or three... of the cells to the right of the cell containing the link will often be completely covered by the text of the link.
Look at the attachment "Example of such a Link": The cells in column D and E cannot be selected by clicking, and only the right part of the cell in column F can. Even the cell in column C containing the link, which you would eventually want to change, can only be reached by the up/down/left/right keys or entering the address in the address field.
Comment 12 m_a_riosv 2019-04-28 23:04:29 UTC
*** Bug 124996 has been marked as a duplicate of this bug. ***
Comment 13 Tristan Miller 2019-10-21 16:27:17 UTC
(In reply to Gerhard Weydt from comment #4)
> And the link even covers the adjacent cells to the right if the column
> containing it is hidden!

This may be Bug 74533.
Comment 14 Gerhard Weydt 2019-10-23 21:37:19 UTC
(In reply to Tristan Miller from comment #13)
> (In reply to Gerhard Weydt from comment #4)
> > And the link even covers the adjacent cells to the right if the column
> > containing it is hidden!
> 
> This may be Bug 74533.

Well spotted! At first glance I do not understand bug 74533 completely, but it certainly seems to be connected with the problem, even though this bug here is probably the more basic problem.
I added 74533 to "see also".
Comment 15 QA Administrators 2021-10-23 03:44:53 UTC Comment hidden (obsolete)
Comment 16 Buovjaga 2021-10-23 05:55:41 UTC
Hey, now it's working! Tested with all Linux VCL backends and Windows.

Arch Linux 64-bit
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 463d261e3509cc857e248d8bd5787a45d385a646
CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 15 October 2021

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 7cd5b35caa8d4fa9d0ba2b2c6ce4b88726ed2be6
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded