Test Case AOOTest-320: Support_1024Columns(Data -)Filter -)Advance Filter) [Version : 1] | ||
---|---|---|
Author: | undefined - 24/10/2012 14:21:16 | |
Summary: | ||
Preconditions: | ||
#: | Step actions: | Expected Results: |
1 |
| Expected Results |
2 | Open the sample file Copy the data to new range between Column 1000 and Column 1024(Column ALM and Column AMJ). | Month Standard Luxury Business Suite January 1200 850 1500 2400 February 1900 1000 1400 3400 March 1250 900 1600 2800 April 2000 950 1550 3200 |
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' or Standard(1800'. | Month Standard Luxury Business Suite February (1800 |
4 | Select the records to be filtered.(the cell range inputted in step1) | |
5 | Click 'Data -) 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 Month cells OR a value of under 1800 in the Standard cells will be displayed. |
7 | Click 'OK' button. | only the records that comply the filter conditions are displayed. The other rows are hidden from view. Month Standard Luxury Business Suite January 1200 850 1500 2400 February 1900 1000 1400 3400 March 1250 900 1600 2800 |
Execution type: | Manual | |
Importance: | Medium | |
Test Focus: | ||
Feature first available at which release: | ||
Automation script name: | ||
Testsuite set: | ||
Requirements | None | |
Keywords: | None |