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 <cppljev...@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+unsubscr...@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+unsubscr...@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