[Libreoffice-bugs] [Bug 126447] Improve Calc auto-filter Help on creating and expanding selection and working with blank lines

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Aug 24 09:03:39 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=126447

--- Comment #5 from Timur <gtimur at gmail.com> ---
There's advanced way of using autofilter that I don't see explained or linked
if using help with F1.
Per https://bugs.documentfoundation.org/show_bug.cgi?id=119949#c21:
Mark the area to which the filter should be applied. Menu Data > Define Range.
Enter Name, Add, OK.
Later, in case not already marked, go to Menu Data > Select Range.
After the area is marked, enable Autofilter by menu Data > Autofilter.

Define Range has it's own help (via F1)
https://help.libreoffice.org/7.3/en-US/text/scalc/01/12010000.html but it
doesn't explain or link use in filter. 
There's another link (how do we get there?)
https://help.libreoffice.org/7.3/en-US/text/scalc/guide/database_define.html
which links "Filtering Cell Ranges" at
https://help.libreoffice.org/7.3/en-US/text/scalc/guide/database_filter.html.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210824/0062cb08/attachment.htm>


More information about the Libreoffice-bugs mailing list