Test Case AOOTest-319: CoreFunction(Data -)Filter -)Advance Filter)_Case sensitive [Version : 1] | ||
---|---|---|
Author: | undefined - 24/10/2012 14:21:16 | |
Summary: | ||
Preconditions: | ||
#: | Step actions: | Expected Results: |
1 |
| Expected Results |
2 | Open the sample file. | Month Standard Luxury Business Suite January 1200 850 1500 2400 February 1400 1000 1400 3400 March 1250 900 1600 2800 April 2000 950 1550 3200 february 2000 1000 1400 3400 |
3 | 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'. | Month Standard Luxury Business Suite ='February' |
4 | Select the records to be filtered.(the cell range inputted in step1) | |
5 | Click 'Manipulate -) Filter -) Advance Filter'. | The 'Advance Filter' dialog appears. |
6 | 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. |
7 | Click the 'more' button ,check the check box 'Case sensitive' in the group 'Options'. | |
8 | 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. |
Execution type: | Manual | |
Importance: | Medium | |
Test Focus: | ||
Feature first available at which release: | ||
Automation script name: | ||
Testsuite set: | ||
Requirements | None | |
Keywords: | None |