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

Hi Bruce and all:

Thank you because I didn't remember that way

Regards,

Jorge Rodríguez

El lun, 26-09-2016 a las 15:41 -0400, Bruce Hohl escribió: 
> > Is there some other way to get a check range?
> Yes, to 'AND' setup your Advanced filter range like this:
> date | check no | check no |
> | >=1000   | <=1100   |
>
> If you install the LO help there is good explanation and example of using
> Advanced Filters.
>
> On Mon, Sep 26, 2016 at 8:53 AM, Larry Evans <cppljevans@suddenlink.net>
> wrote:
>
> > 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/Advanc
> > ed_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-uns
> > ubscribe/
> > 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

-- 
Atentamente,

Jorge Rodríguez


-- 
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