How to filter cells based on value in current cell?

asked 2015-05-21 15:23:23 +0200

Steinar gravatar image

updated 2015-05-21 17:15:17 +0200

I'd like to add a keyboard shortcut to LibreOffice calc that applies a simple filter for the value in current cell; i.e. in the same manner as if I'd applied autofilter and selected the value from the dropdown.

I'm guessing that it can be done using a macro, but have very limited experience with libreoffice macros. I tried "record macro", but couldn't get it to work. Any help or tips are appreciated.

edit retag flag offensive close merge delete


"I tried "record macro", but couldn't get it to work." Please explain what you mean. Macro recording doesn'work? Or it works but you cannot run just recorded macro? Or you don't know how to create a keyboard shortcut for your macro? Or something else?..

Vitaly gravatar imageVitaly ( 2015-05-23 12:36:09 +0200 )edit

@Vitaly I tried to record while setting up a simple filter, but the recording didn't pick up what I was doing. I also tried with auto-filter, but got the same result.

Steinar gravatar imageSteinar ( 2015-05-24 19:39:50 +0200 )edit