TerryJ aready said that you need to use RegExps. I suggest voting for filters to be improved in future versions of OO. For this you need to register at http://www.openoffice.org/servlets/Join and vote for issue http://www.openoffice.org/issues/show_bug.cgi?id=35579 While at it you also may want to vote for http://www.openoffice.org/issues/show_bug.cgi?id=33851 and http://www.openoffice.org/issues/show_bug.cgi?id=12666
Thanks a lot for your support. WBR, K. Palagin. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 13, 2007 5:53 AM > To: [email protected] > Subject: [users] Calc filter > > Hello, > I had a question about Open Office Calc. > > I was using autofilter and wanted to do a standard filter for > only entries that "contained" a certain word and that "did > not contain" a certain word. I could not find these phrases > in the Filter Criteria condition menu. > > Is it still possible to do what I wanted to do but just a > different way? I know MS Excel autofilter allows for making a > custom selection that does have "contain/ does not contain" > options among others. > > Sincerely, > Colin > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
