I have a cell, which calculates a hyperlink based on a base address which resides in a named cell. The URL is contatenated with a ticket number which resides in C* cells. The number contains spaces, thus the spaces are removed before added to thebase url.
The resulting URL works and opens fine in a browser, when clicking with the mouse.
However, how can the URL get triggered by using a keyboard only?
It seems there is a mouse-action which does not have a counterpart on the keyboard - which seems to be an accessibility issue.
Steps to Reproduce:
1. add a cell, type in a url, and add a name to the cell, "baseAddressUrl".
2. add a new row and a cell with a number, use cell !C4! for example and type "123456"
3. on column D add the following macro: =HYPERLINK(CONCATENATE(baseAddressUrl,SUBSTITUTE(C4," ","")),"link")
4. click on cell !D4!. A browser opens and shows a url
5. try to have the browser opens the url by just using the keyboard....
nothing, there seems no keyboard access to triggering HYPERLINK elements within Calc. I read it seems to work in Writer, but I did not check this.
A keyboard shortcut is given by the LibreOffice team which maps into the keyboard shortcuts interaction design patterns and lets end users trigger a link by just using the keyboard.
User Profile Reset: No
As written, a shortcut should open the browser, congruent to the use of the mouse.
Created attachment 148882 [details]
Sample with generated link
Sample which contains a column with a generated link. Click on link->works.
Try to open by only using the keyboard. I was not able to achieve this.
How can users with screen readers open such links?
added as "bug request" not as "feature request", as LibreOffice is designed to be accessible and in this case a keyboard-alternative for a mouse action seems to be missing.
WCAG 2.0, 2.1.1
WCAG 2.0, 2.1.1
BITV 2.0, 2.1.1
Section508; 1194.21 (a)
Section508; 1194.21 (l)
Section508; 1194.22 (e)
Section508; 1194.22 (f)
Section508; 1194.22 (n)
The keyboard shortcut it's Ctrl+Click, what can be change in Menu/Tools/Options/LibreOffice/Security/Security Options & warnings - Optins - Ctrl+Click required to follow hyperlinks.
If disable only click is needed.
The inquiry was about keyboard access.
The given solution was to change from Ctrl+Click to Click, which is a mouse option.
I am looking for a KEYBOARD ALTERNATIVE to trigger a link by only using the keyboard. The computer in use does neither have a mouse pointing device or a touch pad.
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
I can confirm the issue. In this case, I think enter ou control + enter should make it possible to trigger the click on the navigation mode.
The usual way of a11y is to press enter on focused links, or ctrl/cmd+enter in our case. That's easy for whole cells but might be a bit tricky for cell content with for example "Hello" <a href=...>foo</a> World".
But we should definitely go for it.