Re: [libreoffice-users] Re: Filter rows of certain dates, LibreOffice Calc

2012/7/22 Andreas Säger <villeroy@t-online.de>:
> Am 22.07.2012 19:31, Johnny Rosenberg wrote:
> > Thanks for the suggestion. However, I failed making it work. I tried a
> > few different variations on that and either nothing happened at all,
> > or I got an error message saying that there are no valid filter
> > parameters in that range of cells.
> >
> >
> > Kind regards
> >
> > Johnny Rosenberg
> > ジョニー・ローゼンバーグ
>
>
> The "advanced filter" is documented. It reads filter criteria from cells
> rather than dialog or drop-downs.
> It uses the exact same type of criteria ranges as the database functions
> (DSUM, DCOUNT etc). You may refer to the filter documentation or D-function
> reference.
>
> Example file of mine: http://www.mediafire.com/view/?6vkfs9qq1qg666x

Okay, now I see. I used those D-functions in the past, so it's obvious
to me now. I totally misunderstood you last time. Thanks!


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+help@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