Bug 123560 - Add opportunity to open Autofilter window uses shortcut
Summary: Add opportunity to open Autofilter window uses shortcut
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2019-02-19 07:26 UTC by Roman Kuznetsov
Modified: 2019-06-13 14:32 UTC (History)
5 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.