On Sun, 2005-10-23 at 14:10 +0200, [EMAIL PROTECTED] wrote: > in the "filter data" option in calc how can i filter data that "contains" a > certain word or part of word? > > I.e. in a spreadsheet i want to filter all lines that contain the word "xyz" > only.... > > it's an extremely usfull filter option that i'm not able to activate in Open > Office....is it there somewhere or it's not possible to activate such a > filtering option?
Actually, this is available in OpenOffice.org and has been for a long time. When you go into your standard filter, click on the ">> More" button to get more options. Enable the regular expressions and then create a filter based on your word or partial word. I have used this before many times. 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]
