OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources]

1.

Request a Standard Filter

Once you define your data range, you can request a filter by selecting

Data, Filter, Standard Filter . Calc displays the

Standard Filter dialog box.

2.

Specify the Filter Criteria

Select from the

Field Name dialog box. All the fields defined by the data range's column names will appear when you open the

Field Name list box. Select a condition in the

Condition list box, such as an equal sign or less-than sign, and then enter a quantity (you can also click the

Value list box's down arrow to see a list of possible values) stating what you want to filter by. For example, if you enter UnitsPrice, <, and 9.99, you are requesting that you only want to see the products that are priced less than $9.99.

You may add additional criteria to filter down your data even further by selecting

AND or

OR from the

Operator column and entering second and even third criteria.

TIP

Click the

More button to see additional filter options, such as the ability to make your criteria case sensitive so a match is made against text fields only if the uppercase and lowercase letters match your criteria's uppercase and lowercase letters. Also, you can request that the filtered data be copied to a range you specify instead of the filtering taking place right in your data range itself.

Click

OK to apply the filter and view the results.

3.

Remove the Filter

To restore your data to its original state once you've viewed, printed, stored, or saved the filtered data, select

Data, Filter, Remove Filter to remove the filter and return your complete data range to your spreadsheet.

4.

Use the AutoFilter

To use the AutoFilter feature, select

Data, Filter, AutoFilter. Arrows appear to the right of each field name.

When you click one of the field name arrows, a list of values opens to display all possible unique values in that field, with scrollbars if needed to display the entire list. When you select any value in that list, Calc immediately filters on that value, displaying only those records that match that criteria. For example, if you click the

UnitsInStock field name arrow and select

12 , only the products with an inventory of

12 will appear in the list.

Once you create the filter, you can print, sort, save, or copy the filtered data and return to the full database by selecting

Data, Filter, AutoFilter once again to remove the check mark next to the command.