/text/scalc/01/12090104.xhp Sun Microsystems, Inc. converted from old format - fpe Options Displays or hides additional filtering options. Options Case sensitive Distinguishes between uppercase and lowercase letters. Regular Expression Allows you to use wildcards in the filter definition. If the Regular Expression check box is selected, you can use EQUAL (=) and NOT EQUAL (<>) also in comparisons. You can also use the following functions: DCOUNTA, DGET, MATCH, COUNTIF, SUMIF, LOOKUP, VLOOKUP and HLOOKUP. Unique records only Excludes duplicate rows in the list of filtered data. Data area Displays the name of the filtered data area in the table. More<< Hides the additional options.

List of Regular Expressions