At 17:02 02/05/2008 +0200, Maik Barlach wrote:
I am working with Open Office 2.4. Referring to the calculation program I am using frequently the filter function. What I am missing there are selectable conditions like "begin with", "end with" or "contain". These are very useful condition which I often would have needed and which I miss in this program. Or are this conditions applicable and I didn´t find it yet?
If you click the More button in the Filter dialogue, you will see a "Regular expression" tick box. If this is ticked, you can use regular expressions in the Value field (or in the referenced cell). This may help you to achieve what you need. Use "^" to anchor your match to the beginning of the cell contents, and "$" for the end. (Look up "regular expressions" in the help text for more details.)
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
