-----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. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (MingW32) iEYEARECAAYFAkPOXF0ACgkQzIf+rZpn0oRDSwCdHFSNI8UcU9k77Xwwrv8VR94H 3KQAn3BUu5ceARKDXFE63aZyEwxs746x =LCbA -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]