|Test Case AOOTest-319: CoreFunction(Data -)Filter -)Advance Filter)_Case sensitive [Version : 1]|
|Author:||undefined - 24/10/2012 14:21:16|
|#:||Step actions:||Expected Results:|
Open the sample file.
Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. (Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR. ) For example, the right table represents the filter criteria is 'Month='February'.
Select the records to be filtered.(the cell range inputted in step1)
Click 'Manipulate -) Filter -) Advance Filter'.
The 'Advance Filter' dialog appears.
Select the cell range that defines the filter conditions.(the cell range input in step2)
Specify that only rows which either have the value 'February' in the column 'Month' will be displayed.
Click the 'more' button ,check the check box 'Case sensitive' in the group 'Options'.
Click 'OK' button.
only the records that comply the filter conditions are displayed. The other rows are hidden from view. In our example, only the second record is displayed.
|Feature first available at which release:|
|Automation script name:|