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