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

[jorge]

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 
> 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 +, 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=en-US=UNIX=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

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

[Larry Evans]

On 09/26/2016 02:41 PM, Bruce Hohl wrote:

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   |


Ah!  Never thought of repeating the column headers.



If you install the LO help there is good explanation and example of using
Advanced Filters.


I do have some help; however, as noted in my OP, pressing the help
button sent my browser to:

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

Looking further, I did find more help here:

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

but that didn't mention the duplication of column names.
It seems intuitive now.

Thanks.

-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

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

[Bruce Hohl]

> 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 
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 +, 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=en-US=UNIX=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

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

[Larry Evans]

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 +, 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=en-US=UNIX=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

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

[Larry Evans]

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



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

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

[Larry Evans]

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 +, 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
>>
>>> table for example or at the end if it isn't big.
>>>
>>> Then you have to add the filter that you need and put bellow of the
>>> header that you want to filter.
I'm not sure what this means.  When you say "add the filter" I guess
that means under the "select_op" column I should put a comparison
operator such as > or >= or <=.  Is that right?  But where can I put
the logical operators, AND or OR, that are available with the
Standard Filter?
>>>
>>> Then run the wizard : Advanced Filter (Before select the table that you
>>> want to filter) and in options you can select where to put the datas
>>> filtereds.
Where do I find this wizard : Advanced Filter? I looked under
File>Wizards; however, there was no mention Advanced Filter among the
Wizards listed
>>>
>>> Example:
>>>
>>>
>>>  Province
>>> Sells
>>> Costs
>>>   Profits
>>>  Alajuela
>>>10
>>> 2
>>> 8
>>>Puntarenas
>>>20
>>> 1
>>>19
>>> Limón
>>>20
>>> 4
>>>16
>>>   Heredia
>>>10
>>> 7
>>> 3
>>>  San José
>>>20
>>> 5
>>>15
>>> Alajuela
>>>10
>>> 8
>>> 2
>>> Heredia
>>>40
>>> 9
>>>31
>>> Puntarenas
>>>50
>>>12
>>>38
>>> Advanced Filter:(Read Filter Criteria From)
>>> Province
>>> Sells
>>> Costs
>>> Profits
>>>
>>>
>>>
 20

I'm guessing that this is:

  > 20

and it's a row underneath the Province column in the filter table?

>>>
>>>
>>>
>>>
>>>
>>>
>>> Results of Advance data Filtereds:
>>> Province
>>> Sells
>>> Costs
>>> Profits
>>> Heredia
>>>40
>>> 9
>>>31
>>> Puntarenas
>>>50
>>>12
>>>38
>>> In this case, we filtered the column Sells to show only Province that
>>> have sells higher than 20
>>
[snip]
>>>
>>> El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió:
 I selected Data>Filter>Advanced Filter; however,
 I had no idea what to do next.  I selected Help button,
 which sent my browser to:


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


 which was, again, no help.

 How do I fill out the "Advanced Filter" dialog?

 -regards,
 Larry

[snip]

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