Talk:Documentation/How Tos/Using Data Ranges, Data Sort and Data Filters

How do you filter by field "contains" X? This is driving me nuts!--Anonperson 08:50, 5 March 2009 (UTC)

I'm also a little surprised there are no videos for OpenOffice on this site, unless I totally missed them...--Anonperson 08:50, 5 March 2009 (UTC)

---

Advanced filter has wrong description, "Enter your sort criteria, under each column. Note that criteria on a same 'row' are combined by an OR, while criteria in the same column are combined as AND. In order to enter names with the equals sign, don't forget to put in quotation marks ()."

Correct would be:

Enter your filter criteria, under each column. Note that criteria on a same 'row' are combined by an AND, while criteria in different rows are combined by an OR.

A filter criteria is a text written in the form 'comparison operator comparison value', e.g. >0 or <=2011-02-13. For comparison with a single value you may write the text or number without equal sign.

To design a criterion between add an additional column with the same field name.

The example is wrong, because the criterion is written in a wrong way. It should be the text "<25".

Regina 15:07, 27 March 2011 (UTC)