When I open the context menu in a cell in a column within an AutoFilter range, and that column is non-trivially filtered - I think it would be nice if I could clear the filter from that menu. One might as "does that merit putting on the context menu"? Well, if "Data Validation" is in there, I don't see why this shouldn't... and the context menu is not that chock-full of items.
The Autofilter works on the entire column. I do not see, why it should be changed from the context menu of a single cell. For clearing the filter the item "Clear Filter" in the drop-down of the filter is sufficient. Or do I not understand your request?
I had bug 123560, not about the same but it's apparently near
(In reply to Regina Henschel from comment #1) > The Autofilter works on the entire column. I do not see, why it should be > changed from the context menu of a single cell. Because the cell is part of that column. > For clearing the filter the > item "Clear Filter" in the drop-down of the filter is sufficient. That works, certainly, but - it's more convenient if you don't have to scroll up, clear the filter, and possibly scroll down again.
I can get used to the idea.
In Google Drive is right click on Autofilter numbers/area, and Remove filter.
We discussed the topic in the design meeting. Clearing the AF is easy to achieve via the AF-widget. However, when scrolled down it it not reachable anymore and freezing the first row might also not what users want. Plus, adding a UNO command wont hurt the usability. So the proposal is to provide access to the function per dedicated UNO command with user customization. The task is not too difficult and interestingly easy to realize without code pointer.
What do we need to implement here? Does "Reset Filter" work here or a completely new uno command should be implemented which only clears autofilter?
(In reply to Ujjawal Kumar from comment #7) > What do we need to implement here? Does "Reset Filter" work here or a > completely new uno command should be implemented which only clears > autofilter? Add a new UNO command that runs the AF part to reset the filter.
Ujjawal Kumar committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6b67355f1275ea296a6a74c8f4d6a9060ff2f8a1 tdf#164322 Add "Clear AutoFilter" option in context menu of cells It will be available in 25.8.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.
Wow, thanks, Ujjawal Kumar. It is working well. Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d986127690cf6b61e8973ee37e009a1f0dbbc9ca CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Thank you for your kind words BogdanB.