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 13:27, Johnny Rosenberg wrote:
> > I searched for Standard Filter examples and the only thing I found had
> > a string or a number in the Value fields. I want to use an expression
> > instead, but that doesn't seem possible, or maybe I'm just doing it
> > wrong.
> > For example:
> >
> > Column A    >=   Today()-7
> >
> > Doesn't work at all. The only thing that happens is that rows not
> > containing a date at all in Column A are hidden. In this case I only
> > want to hide those rows older than a week. I guess I am just not doing
> > it right, right?
> >
> >
> >
> > Kind regards
> >
> > Johnny Rosenberg
> > ジョニー・ローゼンバーグ
>
>
> Data>Filter>Advanced Filter...
> Point to a 2-cell range with column label and calculated value.
>
> Cell #1: =$A$1
> Cell #2: =">="&TODAY()-7

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
ジョニー・ローゼンバーグ

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