Bug 142609

Summary: Autofilter command does not have shortcut
Product: LibreOffice Reporter: NISZ LibreOffice Team <libreoffice>
Component: CalcAssignee: Gabor Kelemen (allotropia) <kelemeng>
Status: VERIFIED FIXED    
Severity: normal CC: buzea.bogdan, heiko.tietze, kelemeng, miguelangelrv, nemeth, varga.balazs3
Priority: medium    
Version: 7.2.0.0 alpha1+   
Hardware: All   
OS: All   
Whiteboard: target:7.2.0
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 98259    
Attachments: The UI in Excel
Screen customize keyboard.

Description NISZ LibreOffice Team 2021-06-01 15:49:38 UTC 
Created attachment 172559 [details]
The UI in Excel

Unlike in Excel, the Autofilter command in Calc cannot be enabled/disabled with a keyboard shortcut.

Steps to reproduce:
    1. In Calc open the Data menu 

Actual results:
Autofilter menu item does not show shortcut.

Expected results:
Excel has Ctrl-Shift-L for this feature which is currently unused in Calc and globally as well. That could be assigned.

LibreOffice details:
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 1 m_a_riosv 2021-06-01 16:16:12 UTC 
Created attachment 172560 [details]
Screen customize keyboard.

I can be assigned with Menu/Tools/Customize/Keyboard.

But there are two Autofilter, and only the second one works after assign.

Maybe that's in relation.
Comment 2 Commit Notification 2021-06-02 14:24:38 UTC 
Gabor Kelemen committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/21c87b0dfa9b8f672af9f7ca2b012ba211956c5c

tdf#142609 Assign shortcut key to Calc Autofilter command

It will be available in 7.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 3 BogdanB 2021-06-04 18:49:43 UTC 
Nice feature! Thanks for solving this!

Now Autofilter could be create/close with Ctrl+Shift+L. Very easy!!!

Verified in
Version: 7.2.0.0.alpha1+ / LibreOffice Community
Build ID: e96554b67b17f9d3d91b0bb1f29ab0b9cdc43dcb
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded