Filtering Filter is a way of limiting the information that appears on screen. Filters are a feature for displaying and browsing a selected list or subset of data from a worksheet. The visible records satisfy the condition set by the user. Those that do not satisfy the condition are only hidden, but not removed.
OpenOffice Calc allows three types of filters. They are AutoFilter, Standard Filter and Advanced Filter . . .
Auto Filter: Auto Filter applies a drop-down list box to each field (columns) filled with similar data available in that field. Using the list box item, you can filter the data that matches the criteria of the data concerned. Using Auto Filter: Click Auto Filter icon available on the “Standard tool bar” (or) Click Data → Filter → Auto Filter The list box contains similar data in the fields. Refer Figure .
and . Each list box item will be considered as filter criteria. Drop down list box Figure . Spreadsheet table with Auto Filter Figure .
Auto Filter dropdown list box Select the data item from the list box. Now, Calc shows only the records which are satisfy the selected criteria. Example: If you want to apply an auto filter to the contents of the Figure . , follow the following two steps Step : Place cell pointer anywhere in the table Step : Click Auto Filter icon available on the “Standard tool bar” (or) Click Data → Filter → Auto Filter In the above table, if you want to view only the students belonging to the Group Code Click the dropdown list box’s drop arrow (a tiny triangle) to get the filter criteria.
(Refer Figure . ) Select group code from the list The worksheet displays only the student’s details who are studying in group code (Refer Figure . ) and the remaining records are hidden. Figure .
Filtered details Figure . Standard Filter dialog box Removing Auto Filter: To remove auto filter, click “Auto filter” icon once again . The original table is displayed without filter. .
. Standard Filter: Auto filter