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