Bug 157413 - URLlink Button placed on top of a chart presents a URL tip popup when the mouse hovers anywhere over the chart
Summary: URLlink Button placed on top of a chart presents a URL tip popup when the mou...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: preBibisect, regression
Depends on:
Blocks: Tooltip
  Show dependency treegraph
 
Reported: 2023-09-24 16:00 UTC by Colin
Modified: 2023-10-12 05:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Composite screen grab showing both states of the mouse hover (218.99 KB, image/png)
2023-09-24 16:01 UTC, Colin
Details
Simple Demo File (43.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-09-25 17:39 UTC, Colin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Colin 2023-09-24 16:00:30 UTC
Description:
When a chart object is placed on a sheet (the chart is flipped 90 degrees right) and a hyperlink button is placed on top of the chart object then hovering the mouse anywhere on the chart produces the hint to ctrl-click to open the hyperlink as if it were a text link. I'm uncertain whether having multiple buttons is significant.

If the mouse is hovered over the URL Button it produces the correct tip identifying where it is going.

Attached is a composite screen grab where the top half demonstrates the tip for anywhere on the chart and the bottom half identifies what would be expected if the mouse hovers over the button.

Not to worry about exposing the address. The reponse requires a Qcode scan and an encrypted passcode sent from another device.

Steps to Reproduce:
With tips activated and with a chart created from data over which it has been laid and a pair of Hyperlink buttons to external websites moved into position on top of some empty space on the chart (I also have two local hyperlink buttons located directly beneath the external links):-

1) Mouse hover over any area of the chart and observe that it will produce a tip as though it were a text hyperlink for the first hyperlink below the mouse location.
2) Mouse hover over the hyperlink button and observe that it correctly identifies the target.

Actual Results:
Unexpected and potentially inaccurate tip. It's almost as if the surface of the chart is acting as a syphon to a hypothetical tip for a hypothetical text URL.

Expected Results:
The tip in the top half of the image should never occur.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.6.2 (X86_64) / LibreOffice Community
Build ID: f654817fb68d6d4600d7d2f6b647e47729f55f15
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
Comment 1 Colin 2023-09-24 16:01:31 UTC
Created attachment 189795 [details]
Composite screen grab showing both states of the mouse hover
Comment 2 Colin 2023-09-25 11:13:30 UTC
What may be another symptom of the problem is that when identifying the file to which the URL relates, it used to be that one could simply hover the mouse over the URL type selector and use the mouse scroll wheel to scroll between "TEXT" & "BUTTON" as opposed to formally entering the list to select or interacting with the selector button. 7.5.6.2 was only installed yeaterday and the "feature" identified itself immediately following installation.

I do have at least 617 instances prior to this installation where the scroll wheel functioned and the chart background never "syphoned" the text tip onto the screen.
Comment 3 Colin 2023-09-25 11:43:27 UTC
(In reply to Colin from comment #2)
> What may be another symptom of the problem is that when identifying the file
> to which the URL relates, it used to be that one could simply hover the
> mouse over the URL type selector and use the mouse scroll wheel to scroll
> between "TEXT" & "BUTTON" as opposed to formally entering the list to select
> or interacting with the selector button. 7.5.6.2 was only installed
> yeaterday and the "feature" identified itself immediately following
> installation.
> 
Is this the new "norm"? Further experimentation identifies that all "multi-choice" selections in all parameter settings panes now require physical entry into the selection box rather than just hover and scroll.

Once upon a time, pre-7.5.6.2 for me, we could scroll through the multi choice panes with the mouse outside the boundaries of the input boxes and it would scroll from top to bottom of the pane (spiritually linked to the scroll-bar) but then moving to hover over the target parameter would scroll that parameter's values.

A good example is the "Properties Push Button" pane for "Control Properties" when in edit mode and right-clicking a push-button.

I create multiple push buttons daily so it was a valued feature and it feels like somebody fixed something that was never broken.
Comment 4 m_a_riosv 2023-09-25 17:24:39 UTC
Please attach a sample file, so someone can test.
Comment 5 Colin 2023-09-25 17:39:21 UTC
Created attachment 189812 [details]
Simple Demo File

The Web links will only take you to the public facing logon page that's freely available to everybody on the planet - with a computer and web service that is.

Obviously, the "local" links will bomb-out because the tester's local environment will not match mine.

All aspects of the "feature" including the inability to scroll through the button editing pane when editing is enabled.
Comment 6 Colin 2023-09-25 17:47:17 UTC
Correction: It produces the invalid tip syphoned from the first button wherever the mouse is located over the chart. It doesn't just produce the tip for the button immediately below the mouse.

Whilst this is having a limited cosmetic effect it may be symptomatic of a bigger problem - like the "side-effect" of no longer being able to scroll through the panes and then focus the mouse-scroll onto the input box detected purely upon the current location of the mouse.
Comment 7 m_a_riosv 2023-09-25 21:09:38 UTC
Deleting the chart, doesn't solve the issue for me.

I think it is something in relation with the forms properties.
Doing a copy of 'Hand' button, and pasting in it the URL of 'Data' button, it works fine for me.
Comment 8 Colin 2023-09-25 21:25:14 UTC
(In reply to m.a.riosv from comment #7)
> Deleting the chart, doesn't solve the issue for me.
> 
I have another file with 620 Buttons stacked neatly into "Fit to cell" - "Resize with cell" columns and that works perfectly. As would be expected, the mouse scroll provides a dynamic update as it moves over each button.

That sheet has a chart which is in an area that has never seen a button and there's no "interference" from URL legends.

Are you observing the same issue with scrolling through the button properties and is it a seperately reportable "feature"?
Comment 9 Buovjaga 2023-10-10 10:18:42 UTC
(In reply to m.a.riosv from comment #7)
> Deleting the chart, doesn't solve the issue for me.
> 
> I think it is something in relation with the forms properties.
> Doing a copy of 'Hand' button, and pasting in it the URL of 'Data' button,
> it works fine for me.

How is the issue seen after you delete the chart? I did it and I only see the tooltip when hovering over the buttons. I wonder what are the reproduction steps from scratch or with the data.
Comment 10 Colin 2023-10-10 10:50:14 UTC
(In reply to Buovjaga from comment #9)
> (In reply to m.a.riosv from comment #7)
> 
> How is the issue seen after you delete the chart? I did it and I only see
> the tooltip when hovering over the buttons. I wonder what are the
> reproduction steps from scratch or with the data.

You may have noticed the chart is a stacked bar chart with columns defining the positive or negative effect of the month's movement. could the chart type be significant?

I've also noticed that if you left click the chart surface the tooltip becomes a permanent addition to the cursor - following it all around the chart but disappearing when the mouse moves "out of bounds"
Comment 11 m_a_riosv 2023-10-10 21:56:08 UTC
(In reply to Buovjaga from comment #9)
> (In reply to m.a.riosv from comment #7)
> ...
> How is the issue seen after you delete the chart? I did it and I only see
> the tooltip when hovering over the buttons. I wonder what are the
> reproduction steps from scratch or with the data.
It shows empty tooltips for second to fourth button.
Comment 12 m_a_riosv 2023-10-10 22:10:15 UTC
(In reply to m.a.riosv from comment #11)
> ....
> It shows empty tooltips for second to fourth button.
Ok my bad, the same behavior as with the chart.

Passing the validator to the file for version 1.3 extended:
URLError.ods/content.xml[2,77434]: Error: attribute "table:cell-range-address" has a bad value
I don't know if it has something to do.
Comment 13 Colin 2023-10-11 04:03:09 UTC
(In reply to m.a.riosv from comment #11)
> (In reply to Buovjaga from comment #9)
> > (In reply to m.a.riosv from comment #7)

> It shows empty tooltips for second to fourth button.

They were intentionally "nulled" to avoid unnecessary tooltip intrusions
Comment 14 Colin 2023-10-11 04:15:54 UTC
(In reply to Colin from comment #13)
> (In reply to m.a.riosv from comment #11)
> > (In reply to Buovjaga from comment #9)
> > > (In reply to m.a.riosv from comment #7)
> 
> > It shows empty tooltips for second to fourth button.
> 
> They were intentionally "nulled" to avoid unnecessary tooltip intrusions

Correction: When a button is first created the link address automatically appears as a "help" popup if the user doesn't provide an alternative. The only way to suppress it was to force a space character in the help attribute.
Comment 15 Stéphane Guillou (stragu) 2023-10-11 17:44:26 UTC
The only way I can reproduce it on Linux with the gtk3 VCL plugin is by following these steps:

1. Open attachment 189812 [details], scroll down a bit (but keep the "Hand" button in view)
2. Hover over the top of the "Hand" button: it displays only the URL in the tooltip
3. With mousewheel, scroll up _once_ without moving the mouse (the pointer should end up over the chart area)

Result: the tooltip changes to "Ctrl-click to open hyperlink: <URL>" (and doing that _does_ open the web browser)
This does not happen if there is no chart behind, or a shape instead of a chart.

Version: 7.5.7.1 (X86_64) / LibreOffice Community
Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

However, with the gen VCL plugin, I can reproduce directly without the trick above.

Regression as I can't reproduce in OOo 3.3, but already present in libreoffice-3.3.0 (tested with gen VCL plugin in the libreoffice-64-release bibisect repository). Noticing that back in OOo 3.3, the cursor would not change to the hand cursor when hovering above the chart.
Comment 16 Colin 2023-10-12 05:22:17 UTC
(In reply to Colin from comment #2)
> What may be another symptom of the problem is that when identifying the file
> to which the URL relates, it used to be that one could simply hover the
> mouse over the URL type selector and use the mouse scroll wheel to scroll
> between "TEXT" & "BUTTON" as opposed to formally entering the list to select
> or interacting with the selector button. 7.5.6.2 was only installed
> yeaterday and the "feature" identified itself immediately following
> installation.
> 


This may be a symptom of a recent windows 10 update. I've just noticed that other - less frequently used apps - that previously permitted "scroll on hover" now also continue scrolling the whole page instead of the selection box.

Is it worth anybody verifiying that I haven't just "lost my marbles"