Re: [libreoffice-users] Calc how to display Autofilter values?

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


On 6/9/21 8:24 PM, Alan B wrote:
> 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.
>
>
>
> On Wed, Jun 9, 2021 at 6:49 AM Mike Flannigan <mflan@mflan.com 
> <mailto:mflan@mflan.com>> wrote:
>
>
>     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
>
>
>     On 6/9/21 3:07 AM, users+help@global.libreoffice.org
>     <mailto:users+help@global.libreoffice.org> wrote:
> >     Many moons ago I was using some Calc sheets with AutoFilter routinely. The
> >     filter value would be changed, the sheet closed and sometime later opened
> >     again.
> >
> >     To understand the displayed rows the filter values needed to be known. And
> >     that involved opening each filter and checking the value.
> >
> >     So I asked, is there a way to display those values? No answers. And the
> >     need went away.
> >
> >     Just recently had the same need in Excel. Found online the exact answer
> >     needed to make it work.
> >     https://www.extendoffice.com/documents/excel/1444-excel-display-show-filter-criteria.html
> >     The section "Display / Show auto filter criteria in worksheet with VBA
> >     code" is what I referenced.
> >
> >     I've used that info to try and extrapolate a similar method in Calc to no
> >     avail.
> >
> >     Have done a limited amount of searching in Andrew Pitonyak's OpenOffice.org
> >     Macros Explained book and searched through OASIS Open Document Format
> >     documents using terms like "filter" and "range". The answer might have been
> >     staring me in the face, I'm thinking in particular of section 15.6.3 of
> >     Andrew Pitonyak's OpenOffice.org Macros Explained, but I just didn't
> >     understand it.
> >
> >     Can anyone provide guidance to display the autofilter values in a Calc
> >     sheet equivalent to the instructions provided for Excel at the link above?
> >
> >     Thank you.
>
>
>
> --
> 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