2012/7/22 Andreas Säger <[email protected]>: > 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: [email protected] 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
