Calc how to display Autofilter values?

users
#1

See this:
https://bytefreaks.net/applications/libreoffice-calc-get-the-distinct-unique-values-in-a-column-or-a-list-of-elements

You can use Ctrl-z to undo the command, but don't use Ctrl-Shift-y to redo it
on another column.  You must go through the command again on another column
and then do Ctrl-z again.

Mike

#2

Not at all what I'm trying to do. Distinct values have their uses. But I
already knew how to do that.

I'm trying to display the AutoFilter values being applied to a table so
they can be read without opening up each filter at the top of each column
to see what the settings are.

For example, three columns Name, Weight, Dimensions. The table has 1000
rows. AutoFilter is in use and 727 rows are displayed. What are the filter
settings? Sure, can tell if a filter is applied by looking at the filter
list widget and opening it if it shows the filter is in use. And even if
all three are in use, no big deal. Only three to open and check the values.

When the table has 30+ columns and hundreds or thousands of rows, not such
a simple task. Much more convenient just to have a formula that will
display the settings of all applied filters.

If I'm not explaining the requirement clearly please look at the link to
the Excel solution. That's got pictures along with an explanation of the
problem and solution.

That's what I'd like to reproduce in Calc.

#3

Ahh.  Now I understand.  I can see how that might be useful.
Sorry, but I don't know a way to do that right now.
Seems like that might be a relatively easy thing to do,
but I don't know how.

Mike