On Wed, 2006-01-18 at 10:18 -0500, Chuck wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Jonathon Coombes wrote: > > On Tue, 2006-01-17 at 13:01 -0500, Chuck wrote: > >> Karlis Erglis wrote: > It would be goot to improve AutoFilter in OO > >> CALC. Including such criteria like 'contains' or 'do not > >> contains'.Becose of this i still must use MS Excel. :( > > >> > >> I would add to that "blanks" and "non-blanks". I use these filters 10x > >> as often as any others and I suspect it's the same for many other users. > >> Currently I have to do a standard filter which is not as fast. > > > > All these can be done with the regular expressions feature, and then > > some. Have a look in the help under Calc for the regular expressions > > usage in filters and that should get you on track to seeing how > > powerful this feature is in Calc. > > > > Regards > > Jonathon > > I'm familiar with regex's but how do you specify one in an auto filter? > The drop down doesn't let you enter a regex.
No, that is true, but you can choose the standard filter feature and do it through that. Regards Jonathon -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]