Page 1 of 1

Keyboard shortcut to drop down the filter list (AutoFilter)

PostPosted: Sun Nov 19, 2017 6:50 am
by CTBarbarin
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

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

PostPosted: Sun Nov 19, 2017 10:23 am
by Zizi64
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

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

PostPosted: Sun Nov 19, 2017 5:03 pm
by CTBarbarin
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

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

PostPosted: Sat Apr 04, 2020 2:48 am
by DavidHMcCracken
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