Bug 162169 - Protected cells in calc should also get keyboard focus for screenreader accessibility
Summary: Protected cells in calc should also get keyboard focus for screenreader acces...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: accessibility
Depends on:
Blocks: a11y, Accessibility
  Show dependency treegraph
 
Reported: 2024-07-24 07:50 UTC by Julian Dreykorn
Modified: 2024-07-29 06:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Julian Dreykorn 2024-07-24 07:50:15 UTC
Description:
Since I'm blind I use NVDA on Windows. When opening a file with protected cells, which can/may not be unprotected right now, it's not possible for me to select them using arrow key navigation. However, even though editing them is not possible, selecting them for just checking the content using the arrow keys would be essential anyway.

Steps to Reproduce:
1. Open a file in Calc which has one or more protected cells
2. Press the arrow keys to navigate to the corresponding cells

Actual Results:
Protected cells cannot be selected, making it impossible for the screenreader user to read the content.

Expected Results:
Protected cells should be read-only, but selecting them needs to work as normal.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 6; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
Comment 1 Michael Weghorn 2024-07-29 06:36:14 UTC
(In reply to Julian Dreykorn from comment #0)
> When opening a file with protected
> cells, which can/may not be unprotected right now, it's not possible for me
> to select them using arrow key navigation. However, even though editing them
> is not possible, selecting them for just checking the content using the
> arrow keys would be essential anyway.

Whether cells can be selected or not is configurable when enabling protection for the sheet.

"Allow all users of this sheet to:" defaults to allowing selecting protected cells.

So if this doesn't work for your particular case, it seems that the person who protected the sheet explicitly disabled that. I suggest to ask them to allow this.

I'm closing this ticket for now as NOTABUG, since it seems that this generally works as expected. (Selecting cells is possible unless explicitly disabled.)

In case you have this issue in cases where selecting has not explicitly been disabled, please reopen and provide more details (in particular, a sample file).