Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.7 released

 

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

Apache Events

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.