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