Download it now!
Bug 123159 - Accessibility: No keyboard shortcut to open a HYPERLINK in Calc cells
Summary: Accessibility: No keyboard shortcut to open a HYPERLINK in Calc cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: accessibility
Depends on:
Blocks: a11y
  Show dependency treegraph
Reported: 2019-02-04 14:18 UTC by Oliver Keim
Modified: 2019-09-04 13:41 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Sample with generated link (9.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-04 14:29 UTC, Oliver Keim

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Keim 2019-02-04 14:18:36 UTC
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.

=HYPERLINK(CONCATENATE(baseAddressUrl,SUBSTITUTE(C8," ","")),"link")

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....

Actual Results:
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.

Expected Results:
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.

Reproducible: Always

User Profile Reset: No

Additional Info:
As written, a shortcut should open the browser, congruent to the use of the mouse.
Comment 1 Oliver Keim 2019-02-04 14:29:01 UTC
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?
Comment 2 Oliver Keim 2019-02-05 08:57:39 UTC
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. 

Related Accessibility-Requirements:
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)
Comment 3 m.a.riosv 2019-02-05 09:15:34 UTC
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.
Comment 4 Oliver Keim 2019-02-05 10:31:29 UTC
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.
Comment 5 Xisco Faulí 2019-02-06 17:59:24 UTC
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Comment 6 Alex ARNAUD 2019-02-16 14:06:04 UTC
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.

Best regards,
Comment 7 Heiko Tietze 2019-02-19 09:39:59 UTC
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.