[libreoffice-users] Re: How to fill in "Read filter criteria from"

On 09/25/2016 10:21 AM, Larry Evans wrote:
> On 09/25/2016 09:39 AM, Larry Evans wrote:
> > On 09/24/2016 07:28 AM, jorge wrote:
> > > I'm sorry, ... it looks worst
> > >
> > > Jorge Rodríguez
> > >
> > >
> > >
> > >
> > > El sáb, 24-09-2016 a las 12:20 +0000, jorge escribió:
> > >
> > > > Hi  again:
> > > >
> > > > I hope in this way you can see better my last e-mail:
> > > >
> > > > At first you have to copy the headers of your table at you side of you
> > Ok.  Did that.  Those are shown in attached in E2:G2
> OOPS.  I should have read:
>
> https://wiki.documentfoundation.org/Netiquette#Avoid_Attachments
>
> The .png file showing this, as well as the actual .odf file,
> can be found at these links:
>
> https://www.dropbox.com/s/5uosutupnclnxrg/find_transaction.advanced_filter.png?dl=0
>
>
> https://www.dropbox.com/s/da11qtifkes1q01/find_transactions.ods?dl=0
>
> Hope this makes things clearer.
>
> [snip]

Googling for "libreoffice advanced filter" lead me to:

https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters

which was *much* more helpful than the help I got from pressing
the help button on the "Advanced Filter" dialog, which, as mentioned
in my OP, sent me here:

https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113

OOPS.  I see on that page, there's a link to "Applying Filters"
and from there, a link to:

https://help.libreoffice.org/5.1/Calc/Filter:_Applying_Advanced_Filters

I should have persisted in reading the document :(

Anyway, apparently there's no way to select a range of check numbers
because the vertical conditions are OR'd together instead of AND'd
together.  I've tried using the AND(>=1000,<=1200); however,
that results in 0 selected rows.  Is there some other way to get
a check range?

I've uploaded a screen shot to:

https://www.dropbox.com/s/piiuz5z1u7s14ch/find_transactions.advanced_filter.NoVerticalAnd.png?dl=0

-regards,
Larry





--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted