True False cmd/sc_delete.png True False cmd/sc_delete.png True False cmd/sc_delete.png True False cmd/sc_delete.png False 6 Standard Filter False 0 0 dialog False True True vertical 12 False end _Clear True True True True True False True 0 _OK True True True True True True Saves all changes and closes dialog. False True 1 _Cancel True True True True True Closes dialog and discards all changes. False True 2 _Help True True True True True False True 3 True False True end 0 True False True True 0 none True True 12 6 True True never always in True False True True True False True False True True 3 6 12 True False AND OR Operator 1 For the following arguments, you can choose between the logical operators AND / OR. 0 1 True False AND OR Operator 2 For the following arguments, you can choose between the logical operators AND / OR. 0 2 True False AND OR Operator 3 0 3 True False AND OR Operator 4 0 4 True False Operator 0 0 True False Field name 1 0 True False Condition 2 0 True False Value 3 0 True False Field Name 1 Specifies the field names from the current table to set them in the argument. 1 1 True False Field Name 2 Specifies the field names from the current table to set them in the argument. 1 2 True False Field Name 3 Specifies the field names from the current table to set them in the argument. 1 3 True False Field Name 4 1 4 True False = < > <= >= <> Largest Smallest Largest % Smallest % Contains Does not contain Begins with Does not begin with Ends with Does not end with Text color Background color Condition 1 Specifies the comparative operators through which the entries in the Field name and Value fields can be linked. 2 1 True False = < > <= >= <> Largest Smallest Largest % Smallest % Contains Does not contain Begins with Does not begin with Ends with Does not end with Text color Background color Condition 2 Specifies the comparative operators through which the entries in the Field name and Value fields can be linked. 2 2 True False = < > <= >= <> Largest Smallest Largest % Smallest % Contains Does not contain Begins with Does not begin with Ends with Does not end with Text color Background color Condition 3 Specifies the comparative operators through which the entries in the Field name and Value fields can be linked. 2 3 True False = < > <= >= <> Largest Smallest Largest % Smallest % Contains Does not contain Begins with Does not begin with Ends with Does not end with Text color Background color Condition 4 2 4 True True True Remove 8 image1 True 4 1 True True True Remove 8 image2 True 4 2 True True True Remove 8 image3 True 4 3 True True True Remove 8 image4 True 4 4 True False True False True True True True True Value 1 Specifies a value to filter the field. 0 0 True False True liststore2 0 1 1 3 1 0 3 2 True False True False True True True True True Value 1 Specifies a value to filter the field. 0 0 True False True liststore1 0 1 0 3 1 0 3 1 True False True False True True True True True Value 1 Specifies a value to filter the field. 0 0 True False True liststore3 0 1 1 3 1 0 3 3 True False True False True True True True True Value 1 Specifies a value to filter the field. 0 0 True False True liststore4 0 1 1 3 1 0 3 4 0 0 True False Filter Criteria False True 1 True True True True True False 6 True True 6 True False True True 6 12 _Case sensitive True True False True True True Distinguishes between uppercase and lowercase letters when filtering the data. 0 0 Range c_ontains column labels True True False True True True Includes the column labels in the first row of a cell range. 0 1 Regular _expressions True True False True True True Allows you to use regular expressions in the filter definition. 1 0 _No duplications True True False True True True Excludes duplicate rows in the list of filtered data. 1 1 Co_py results to: True True False True True True Select the check box, and then select the cell range where you want to display the filter results. 0 2 _Keep filter criteria True True False True True True Select the Copy results to check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range. 1 2 0 0 True False 12 True 12 True False Copy results to Select the check box, and then select the cell range where you want to display the filter results. 0 0 True True 1 True 30 True Copy results to Select the check box, and then select the cell range where you want to display the filter results. 1 0 True True True Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size. 2 0 0 1 False False 12 False False Data range: 0 0 0 False False True dummy 0 1 0 0 2 True False Op_tions True Shows additional filter options. False True 2 clear ok cancel help Specifies the logical conditions to filter your table data.