# Testname: Autofiltertest
Document Owner: Frank Stecher | Last document change: 07.04.2008 | Status of document: Standard
Valid for version: OpenOffice.org_2.4, OpenOffice.org_3.0

### Test purpose:

Test the Autofilter

### Known issues:

### Preconditions of test:

### Test documents:

http://www.openoffice.org/nonav/issues/showattachment.cgi/48310/Autofilter.ods

### Testcases:

Defined Database Range | Status: Standard | -
Download and open the test document autofilter.ods Switch to Sheet Databaserange if it is not opened with this Sheet active. Select the autofilter on column A (Partnumber) to show AF004 Is a blue arrow shown in the Filter listbox to indicate this column has an filter applied ? If not, file an Issue. Open the Autofilter drop down box on column B (Part Name). Is there anything else than A318 Elite or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Open the Autofilter drop down box on column C (Single Price). Is there anything else than 78000000 or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Open the Autofilter drop down box on column D (Stock). Is there anything else than 1 or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Open the Autofilter drop down box on column E (Expected payments). Is there anything else than 78000000 or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Does the subtotal function show 1 in cell D21 and $78,000,000.00 in E21 ? If not, file an Issue. Unset the Autofilter on Column A (Partnumber) by selecting All in the drop down listbox. Select the Autofilter on column D (Stock) to show 6 Is a blue arrow shown in the Filter listbox to indicate this column has an filter applied ? If not, file an Issue. Open the Autofilter drop down box on column A (Partnumber). Is there anything else than AF001, AF009, AF010 or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Open the Autofilter drop down box on column B (Part Name). Is there anything else than A300-600SAT, A321, A330-200 or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Open the Autofilter drop down box on column C (Single Price). Is there anything else than 35685000, 43000000, 98000000 or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Open the Autofilter drop down box on column E (Expected payments). Is there anything else than 214110000, 258000000, 588000000 or All, Top ten and Standard Filter ... on it ? If yes, file an Issue. Does the subtotal function show 18 in cell D21 and $1,060,110,000.00 in E21 ? If not, file an Issue. Set the Autofilter on Column B (Part Name) to A300-600SAT. Are there now two blue arrows on the Autofilter drop down listboxes in columns B and D ? If not, file an Issue. Is it possible to change the Autofilter value on Column C (Stock) to 5 ? If so, file an Issue. Unset the Autofilter on Column B (Part Name) by selecting All from the drop down listbox. Change the Autofilter value on Column D (Stock) from 6 to 3. Is the blue arrow still shown ? If not, file an Issue. Does Column A now contain only the column header and the values AF018 and AF019 ? If not file an Issue. Does Column B now contain only the column header and the values A380-800 and A380-800 F ? If not file an Issue. Does Column C now contain only the column header and the values $221,000,000.00 and $198,000,000.00 ? If not file an Issue. Unset the Autofilter on Column D (Stock) by selecting All in the drop down listbox. Apply the Top 10 option from the drop down listbox of the Autofilter on column B (Part Name). is anything shown except of the column headers and a zero value in D21:E21 ? If yes, file an Issue. remove the Top 10 option from the Autofilter on Column B by selecting All from the drop down listbox of the Autofilter. Apply the Top 10 option from the drop down listbox of the Autofilter on column C (Single Price). Are the rows 11 to 20 shown ? Is D21 set to 55 and E21 set to $8,359,000,000.00 ? If not file an Issue. Unset the Autofilter on Column C (Single Price) by selecting All in the drop down listbox. Apply the option Standard Filter from the drop down listbox of the Autofilter in column B (Part Name) In the new opened dialog window set the Value field of the first line to A319, the first Operator field to AND, the second Field name to Partnumber, the second condition to >=, the second value to AF018, the second operator to OR, the third Field name to Stock, the third condition to < and the third Value to 3. Click on the More button and tag the Copy results to... checkbox, type A25 into the target input line next to List box under the copy results to... checkbox. Click on Ok. Are the Partnumbers AF004, AF006, AF015, AF016 and AF017 with the correspondent Values from the Part Name, Single Price, Stock and Expected payments columns pasted with the columnheaders and activated Autofilter into the range A25:E30 ? If not, file an Issue. Close the document and discard the changes to be able to use the same document for the next testcase.
Automatic Database Range | Status: Standard | -
Download and open the test document autofilter.ods Switch to the second sheet (Auto_Database_range) Set the filter criterion on column B (Type) to Ruby using the drop down list box. Changed the black arrow down symbol to a blue one ? If not file an Issue. A4 and A7 contain Rubina and Princess ? B4 and B7 contain Ruby ? C4 and C7 contain 8-00 ct and 10.00 ct ? D4 and D7 contain $5,324.00 and $15,789.00 ? C8 shows 18.00 ct and D8 shows $21,113.00 ? If one of the above conditions is not met, file an Issue. Set the Autofilter on column C (Weight) to 10 using the drop down list box. Now you should have two blue down arrows in the column headers, If not file an Issue. Open the drop down list box on column A (Name), could you set an other name than Princess ? If so, file an Issue. Place the cell cursor on A15 (point on A15 with the mouse pointer and click the left mouse button). Data - Filter - Autofilter Now you should have an autofilter selector box in A15 and B15. Set the drop down list box on A15 to tt. Open the drop down list box on B15. Is there anything else shown as All, Top ten, Standard Filter, 1 and 3 ? Id so, file an Issue. Place the cell cursor in A1 Data - Filter - Autofilter Set the drop down list box in A1 to All. Is the whole filtered area shown again ? If not file an Issue. CTRL+Z (undo the filter range change) You should have on row with the Name set to Princess. Data - Filter - Autofilter Now the Autofilter should be removed and the whole range A1:D8 must be shown. If not file an Issue.
Deletion of filtered rows | Status: Standard | -
Download and open the test document autofilter.ods On sheet "Databaserange" filter column D (Stock) for "6" Select entries in column A (column 2, 10 and 11) and press delete On "Delete Contents" dialog choose "All" and press ok Filter column D (Stock) for "All" Verify that only cells A2, A10 and A11 are blank Close document
Copy / Paste of filtered rows | Status: Standard | -
Download and open the test document autofilter.ods On sheet "Databaserange" filter column D (Stock) for "6" Select filtered area (A2:E11) Copy selection to clipboard (ctrl-c) Paste clipboard to A23 (ctrl-v) Verify that only three columns are copied Select A27:E28 and copy selection to clipboard (ctrl-c) Paste clipboard to A2 (ctrl-v) Press "Yes" on overwriting warning Filter column D (Stock) for "All" Verify that only tvo rows are empty Close document
Overview of menu entries and operations | Status: Standard | -
Download and open the test document autofilter.ods On sheet "Databaserange" filter column D (Stock) for "6" Select filtered area (A2:E11) Choose menu Edit - Delete contents On "Delete Contents" dialog choose "All" and press ok Verify that the area is deleted Filter column D (Stock) for "All" Verify that only cells A2, A10 and A11 are blank Press UNDO button twice to get back the filtered unchanged area Select filtered area (A2:E11) Choose menu Edit - Delete Cells Choose "Delete whole rows" Filter column D (Stock) for "All" Verify that there are now 16 rows in the dataarea Press UNDO button twice to get back the filtered unchanged area Select rowheader 2,10 and 11 to select the 3 complete rows Choose context on selected rowheaders "Edit - Delete Rows" Filter column D (Stock) for "All" Verify that there are now 16 rows in the dataarea Press UNDO button twice to get back the filtered unchanged area Select cell C21 and press icon for auto sum Verify that the function "Subtotal" is inserted instead of "Sum" Press "ESC" to remove the subtotal Select B2:B11 Type "Test" and press ALT-ENTER Filter column D (Stock) for "All" Verify that only cells B2, B10 and B11 have content "Test" Press UNDO button twice to get back the filtered unchanged area Select B2:B11 Verify that the following menu items are disabled Edit cut fill all Insert cells rows columns names create Format merge cells auto format Data sort subtotals multiple operations group and outline all data pilot all auto fill by draging the cell corner Verify that the following menu items are taking the range of the filtered area Insert names define labels Data define range Verify that the following menu items are taking the current cell of the filtered area Insert names insert note show note Verify that the following menu items are enabled Data filter auto filter standard filter advanced filter remove filter hide filter Close document

### References:

-

### Acronyms:

-

## testcase specification history

Autofiltertest
Date | Change | User
--- | --- | ---
07.04.2008 (22:31:00) | status updated | Oliver Craemer
07.04.2008 (22:30:44) | status updated | Oliver Craemer
07.04.2008 (22:30:32) | status updated | Oliver Craemer
07.04.2008 (12:01:40) | testcase details added | Oliver Craemer
07.04.2008 (11:50:34) | testcase added | Oliver Craemer
07.04.2008 (11:39:39) | testcase details added | Oliver Craemer
07.04.2008 (11:19:44) | testcase added | Oliver Craemer
07.04.2008 (10:14:38) | testcase details added | Oliver Craemer
07.04.2008 (10:01:24) | testcase added | Oliver Craemer
19.11.2007 (11:47:43) | status updated | Frank Stecher
19.11.2007 (11:47:32) | status updated | Frank Stecher
19.11.2007 (11:47:21) | testcase :Defined Database Range updated | Frank Stecher
18.09.2007 (12:18:01) | testcase :Automatic Database Range updated | Frank Stecher
18.09.2007 (12:17:37) | version updated | Frank Stecher
17.09.2007 (17:13:57) | testcase details added | Frank Stecher
14.09.2007 (15:00:44) | testcase details updated | Frank Stecher
14.09.2007 (14:59:50) | testcase details updated | Frank Stecher
14.09.2007 (14:28:14) | testcase details updated | Frank Stecher
14.09.2007 (12:46:22) | testcase details added | Frank Stecher
12.09.2007 | Testcase specification created | Frank Stecher