Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

 

Test Case AOOTest-321: Verify function and Check menu (Auto Fill - Advance Filter) [Version : 2]
Author:undefined - 11/03/2014 07:59:26
Summary:

Preconditions:

#:Step actions:Expected Results:
1

Create a empty spreadsheet document

The spreadsheet can be successfully created

2

Input below data into range A1:C24

 

Month Product Sales
Jan A 1200
Jan A 1500
Jan A 1800
Jan A 1600
Jan B 1200
Jan B 1500
Jan B 1800
Feb A 1300
Feb A 1900
Feb B 2100
Feb B 2000
Feb C 1500
Feb C 1700
Feb B 1800
Feb B 1900
Mar B 1400
Mar B 1500
Mar C 1200
Mar C 1200
Mar A 1800
Mar A 1400
Mar A 1600
Mar C 1300

Data can be correctly created

3

Input below data in a empty range of the same sheet

 

Month Sales
Jan 1500
Feb 1500
Mar 1500

 

Data can be correctly created

4

Focus set to any cell of range A1:C24, click the menu 'Data -> Filter -> Advance Filter'

Pop up 'Advance Filter' dialog, and range A1:C24 is selected automatically

6

Select the cell range to define the filter conditions.(the cell range input in step2)

Specify that only rows which sales number is 1500 in Jan, Feb, Mar will be displayed.

7

Click 'More' button, then check the 'Copy results to" check-box and specify a place that the result to be copied to, click 'OK'

The result copied to the specified place. Result will be:

Month Product Sales
Jan A 1500
Jan B 1500
Feb C 1500
Mar B 1500

 

9

Select column A and apply instant filter from menu "Data -> Filter -> Instant Filter'

Instant filter successfully created

10

Click instant filter in cell A1, select 'Jan'

Only rows have 'Jan' in month will be displayed

11

Undo and Redo several times

Undo and Redo work well

Execution type:Manual
Importance:Medium
Test Focus:
Feature first available at which release:
Automation script name:
Testsuite set:
Requirements None
Keywords: None

Apache Software Foundation

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

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