Bug 123560 - Add shortcut to open AutoFilter widget when in range (regardless of button visibility)
Summary: Add shortcut to open AutoFilter widget when in range (regardless of button vi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: accessibility
Depends on:
Blocks: a11y, Accessibility AutoFilter
  Show dependency treegraph
 
Reported: 2019-02-19 07:26 UTC by Roman Kuznetsov
Modified: 2024-04-30 07:14 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Proposed solution (147.27 KB, image/jpeg)
2019-02-21 09:59 UTC, Heiko Tietze
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2019-02-19 07:26:45 UTC
Description:
Add opportunity to open Autofilter window uses shortcut.

I want to have opportunity to open Autofilter window by shortcut when cursor is on cell in Autofilter range.
For example, Autofilter range is A1:B100 and cursor is in cell B52 (I don't see first line with Autofilter's controls). I use a shortcut and it opens Autofilter window for B column and I'll can use Autofilter options without scroll page to up.
I know I can fixed first row, but I want use a shortcut anyway ;-) It will be more fast for me

Steps to Reproduce:
1. See description above


Actual Results:
I can open Autofilter window only by mouse

Expected Results:
I can open Autofilter window by shortcut from any cell of Autofilter's range


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Cor Nouws 2019-02-20 19:23:09 UTC
Hi Roman,

(In reply to Roman Kuznetsov from comment #0)

> Actual Results:
> I can open Autofilter window only by mouse

When the cursor is in the top cell, then Alt+Down opens the widget.

> Expected Results:
> I can open Autofilter window by shortcut from any cell of Autofilter's range

Do you want the Autofilter window to open on the position of the cursor, or on the position of the top row?
Comment 2 Cor Nouws 2019-02-20 19:24:15 UTC
(In reply to Cor Nouws from comment #1)
> When the cursor is in the top cell, then Alt+Down opens the widget.
For me in Version: 6.3.0.0.alpha0+
Build ID: aa31976c2e4399a86bc6f70f140972d9ccef6fc0
CPU threads: 4; OS: Linux 4.15; UI render: GL; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-12_16:47:45
Locale: nl-NL (nl_NL.UTF-8); UI-Language: en-US
Calc: threaded
Comment 3 Cor Nouws 2019-02-20 19:25:15 UTC
(In reply to Cor Nouws from comment #1)
> Do you want the Autofilter window to open on the position of the cursor, or
> on the position of the top row?
Ah, on top of the row, the normal position.
Comment 4 Heiko Tietze 2019-02-21 09:59:12 UTC
Created attachment 149460 [details]
Proposed solution

We discussed the topic in the design meeting. It's possible to jump to the first cell and to open it per alt+down. But this functions is related to selection lists (Data > Validity > Lists) and doesn't work on all systems (unclear why not). If the user wants to filter at row >100 s/he has to go up or to freeze the first row; somewhat cumbersome. And while detaching the widget from its control is not a nice solution in general, it might be handy in this case as the dialog has buttons for finalization.

In a nutshell, the design team approves the request. We want a command assigned to a shortcut e.g. ctrl+alt+F that opens the autofilter widget (and perhaps creates the filter if not done) at the current position when row 1 is out of the view.
Comment 5 Stéphane Guillou (stragu) 2021-06-20 08:18:42 UTC
This would also be useful for accessibility purposes, to save one single action as opposed to "Ctrl + Up" followed by "Alt + Down".

By the way, would the same shortcut be used for a Standard Filter range?

Adding relevant blocked meta.

Clarifying title too.
Comment 6 ady 2023-07-06 13:06:37 UTC
(In reply to Stéphane Guillou (stragu) from comment #5)
> This would also be useful for accessibility purposes, to save one single
> action as opposed to "Ctrl + Up" followed by "Alt + Down".

I'm confused by several comments in this report.

For me, [ALT]+[DOWN ARROW] is aimed at introducing a (repeating) value, usually in a (new) adjacent cell in the same column.

OTOH, AutoFilter can be easily activated, because the icon for it is present in several places/toolbars already. Even if the active cell is not the top-most of the range (with non-empty values), pressing the AutoFilter icon will activate the feature on the top-most cell(s) of that range.
Comment 7 Stéphane Guillou (stragu) 2024-04-30 07:14:03 UTC
(In reply to ady from comment #6)
> I'm confused by several comments in this report.
> 
> For me, [ALT]+[DOWN ARROW] is aimed at introducing a (repeating) value,
> usually in a (new) adjacent cell in the same column.
But if the header of an active autofilter range is focused, it opens the autofilter popdown instead - which works well and does not need changing, in my opinion.

> OTOH, AutoFilter can be easily activated, because the icon for it is present
> in several places/toolbars already. Even if the active cell is not the
> top-most of the range (with non-empty values), pressing the AutoFilter icon
> will activate the feature on the top-most cell(s) of that range.
OP is not talking about turning autofilter on or off (which indeed works well, as your describe), but about opening the header menu of an existing autofilter regardless of the header's visibility.