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:
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?
(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
(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.
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.
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.
(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.
(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.