Issue 93395

Summary: AutoFilter drop-down is not accessible via keyboard
Product: Calc Reporter: christoph
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: frank.loehmann, issues, logicdaemon, mdxonefour, rainerbielefeld_ooo_qa
Version: 3.3.0 or older (OOo)Keywords: accessibility
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Description christoph 2008-09-02 18:20:52 UTC
The AutoFilter feature (Extras -- Filter... -- AutoFilter) adds dropdown buttons
to the spreadsheet cells. There is no real alternative: using the Standard
Filter in the same menu may remove the AutoFilter controls and does not provide
enough data fields to show the filter criteria (refer to issue #17995).

Proposal: Usually, Alt+CursorDown opens such drop-down menus. In Calc, this key
combination is used to resize the current cell. It may make sense to add a
context sensitive exception here:
* If the cursor is inside a cell with an AutoFilter dropdown, then pressing
Alt+CursorDown will open the drop-down.
* If the drop-down is open, then pressing Alt+CursorUp will close it.

This proposal has been discussed with fl.
Comment 1 niklas.nebel 2008-09-04 13:18:56 UTC
For selection list (including validity) and DataPilot page fields we use Ctrl+D.
Shouldn't we extend that instead of Alt+Down?
Comment 2 frank.loehmann 2008-10-10 16:37:14 UTC
We should use ALt+Cursor down in Calc to open the list box for consistency
reasons too. Row height could be changed when cell is in edit mode or at least
via dialog or on any other cell of that row. 

If we have more than one list box on a cell (filter+validation), we should
cascade it. First Alt+Cursor down opens the first list box, the second Alt +
Cursor down the next one. Alt + Cursor up always closes current opened list box.

@MD: Another issue for the accessibility list.
Comment 3 eric.savary 2008-10-27 14:16:48 UTC
Remvoving keyword accessibility because though this is not consistent with the
rest of the UI (Ctrl+Down) there IS a shortcut to access the the filter listbox.
Comment 4 hmssg 2009-07-20 09:27:06 UTC
@es: Are you sure, there is a shortcut? What key is assigned?
Comment 5 Rainer Bielefeld 2013-06-17 06:11:13 UTC
Still Reproducible with server installation of  "AOO 4.0.0-Dev – English UI / German locale [AOO400m2(Build:9701)  -  Rev. 1489073  2013-06-03 13:48:37]" on WIN7 Home Premium (64bit)", own separate user profile. I can't find any possibility to do an auto filter action only using keyboard. And so I see this one as an accessibility related issue

Additional Info:
a) There is a mistake in the report, Auto Filter will be added with 'Data -> Filter -> Autofilter', not with "Extras -- Filter... -- AutoFilter"