[libreoffice-users] How to display AutoFilter filter criteria?

When I set up a spreadsheet with AutoFilter I often insert a row at the top
to show how many rows are displayed by the current filter, e.g. ="Rows
displayed - " & SUBTOTAL(103,A3:A20000)

Now I'm trying to find a way to display the criteria used by the AutoFilter.

e.g. "Rows displayed - " & SUBTOTAL(103,A3:A20000) & " - filter applied:
<the filter(s)>"

Obviously could use an Advanced Filter and create some formula to produce
the <the filter(s)> element above.

Am hoping to find a way to inspect the conditions used in the AutoFilter
and append them to the "Rows displayed..." legend.

Any suggestions?

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy