Keyboard shortcut to drop down the filter list (AutoFilter)

Discuss the spreadsheet application

Keyboard shortcut to drop down the filter list (AutoFilter)

Postby CTBarbarin » Sun Nov 19, 2017 6:50 am

Hello all,

Grrrr...am I missing something?

In Excel:
  • turn on AutoFilter
  • select one of the column headers (which now has the dropdowns with AutoFilter enabled)
  • Keyboard shortcut of [Alt] + [Down Arrow] (same shortcut for almost all combo boxes/dropdowns on all Windows systems...ever) will display the filter list so you can use the arrow keys on the keyboard to filter your table.

I'm looking for the equivalent in ooCalc.

I found in an old thread (https://forum.openoffice.org/en/forum/viewtopic.php?t=26178) something mentioned about the shortcut [Ctrl] + D. Unfortunately, this does not drop down the filter list. This shortcut drops down the "auto complete" list ("Selection List" function as it is referred to in the Customize Keyboard dialog box)...in other words, it is the list of all of the unique values in that column for you to select to set the active cell value to. This shortcut will change the value/contents of my column header, not change the filter.

Looking through the function list in the Customize Keyboard dialog box, nothing jumped out at me. Is there an equivalent function? If someone can tell me, I'll create my own shortcut.

If this function does not exist...well "COME ON NOW!!!" :D This seams like a pretty basic standard function. This should not require some AHK voodoo (also mentioned in above thread) to make it work.

Thanks for any help anyone can provide,

CTB

OpenOffice 4.1.2 on Windows 8.1
CTBarbarin
 
Posts: 21
Joined: Thu Apr 02, 2015 6:24 am
Location: Phoenix, AZ

Re: Keyboard shortcut to drop down the filter list (AutoFilt

Postby Zizi64 » Sun Nov 19, 2017 10:23 am

The Autofilter function exists in the Apache OpenOffice and the LibreOffice, but they are not precisely same:

The Autofilter function is available from the menu item 'Data' in the AOO, or by the next shorcut serie:
Select the range to filter; ALT-D; ALT-F; ALT-F; choose the Header option; ENTER

Autofilter of AOO.png
Autofilter of the AOO

You can move in the dropdown list by usage UP or Down arrow.


The Autofilter function is available from the menu item 'Data' in the LO (5.3.7 version), or by the next shorcut serie:
Select the range to filter; ALT-D; ALT-F; ENTER

Autofilter of LO.png
Autofilter of the LO

You can NOT simply move in the dropdown list by usage Up or Down arrow.
Use the TAB before to choose parts of the dropdown, then you can move in the list by tha Up/Down ARROWS, but you NEED to tick or untick the selected option by SHIFT-SPACE (in my LO 5.3.7).

My opinion: Use a mouse... :bravo:



But you can Customize the Keyboard shortcuts by usage the
Tools - Customize - Keyboard

I do not know if the filter dropdown activity is available by a shortcut key...
Here are some old topics:
https://forum.openoffice.org/en/forum/v ... =9&t=26178
https://forum.openoffice.org/en/forum/v ... =9&t=67721
Last edited by Zizi64 on Sun Nov 19, 2017 6:49 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9587
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Keyboard shortcut to drop down the filter list (AutoFilt

Postby CTBarbarin » Sun Nov 19, 2017 5:03 pm

Hi Zizi64,

Thank you for the feedback.

Zizi64 wrote:The Autofilter function is available from the menu item 'Data' in the AOO, or by the next shorcut serie:
Select the range to filter; ALT-D; ALT-F; ALT-F; choose the Header option; ENTER

Autofilter of AOO.png

You can move in the dropdown list by usage UP or Down arrow.


Sorry for the confusion...I'm looking for a keyboard shortcut to drop down the AutoFilter list (after AutoFilter has been enabled)...not the shortcut to enable AutoFilter.


Zizi64 wrote:My opinion: Use a mouse... :bravo:


But the goal is to not use the mouse.

In one of my classes years ago about designing software, they mention the time it takes to switch between KB and mouse, and to design your software as much as possible to use the KB (GUI software/OSs, by design, are mouse friendly already)...now my CDO (OCD, but in alphabetical order...like it should be :lol:) is always looking for a way to do things without the mouse. It is much faster this way.

It is possible to do this in XL...it should be possible to do this in AOO.

Zizi64 wrote:I do not know if the filter dropdown activity is available by a shortcut key...
Here are some old topics:
https://forum.openoffice.org/en/forum/v ... =9&t=26178
https://forum.openoffice.org/en/forum/v ... =9&t=67721


Thank you, I will look through these when I get a chance.

Thanks again,

CTB

OpenOffice 4.1.2 on Windows 8.1
CTBarbarin
 
Posts: 21
Joined: Thu Apr 02, 2015 6:24 am
Location: Phoenix, AZ

Re: Keyboard shortcut to drop down the filter list (AutoFilt

Postby DavidHMcCracken » Sat Apr 04, 2020 2:48 am

Thank you for mentioning the Alt+DownArrow key to open a dropdown list. I was not aware of this and was about to write a macro to do it for my ooBasic dialogs. This does cause a dialog listbox to drop down but subsequent arrow keys (specifically key release event) trigger an execute event, which is clearly not what we want. I don't know whether my macro solution to that problem can be applied in your case but this is what works in my situation. Key release triggers a macro which sets a flag telling the execute macro to ignore the current event. The execute macro resets this flag but doesn't do its normal operation. This works because the execute event occurs after all mouse and key events.
Code: Select all   Expand viewCollapse view
dim ignoreThisEvent as boolean

sub listboxExecute
   if ignoreThisEvent then
      ignoreThisEvent = FALSE
   else
       normalFunction
   endif
end sub

sub listboxKeyRelease(event as object)
   if event.KeyCode = com.sun.star.awt.Key.RETURN then
      normalFunction
   else
      ignoreThisEvent = TRUE
   endif
end sub
W10 Libre 6.1.5.2 and Ubuntu-Mate 18.04 Libre 6.0.7.3
DavidHMcCracken
 
Posts: 31
Joined: Tue Apr 10, 2018 6:15 am


Return to Calc

Who is online

Users browsing this forum: Bill and 25 guests