can be done on selected range. But this kind of sorting is generally not recommended, because the other relevant data are also not sorted. Therefore, OpenOffice Calc displays a warnning message for this type of sorting. Refer Figure .
. Sorting data by selection: Step : Select any particular field in which you want sort. Step : Click required Sort icon from standard tool bar or Data → S ort command . Calc, display a “Sort Range” warning message as shown in the Figure .
“Sort Range” message box has two options, viz. ( ) Extend selection ( ) Current selection. Step : “Extend Selection” – Sort all the data based on the selection. “Current Selection” – Sort only the selected range of data, remaining data are not sorted.
Chapter . . Filtering Filter is a way of limiting the information that appears on screen. Filters Figure .
Sort by selection are a feature for displaying and browsing a selected list or subset of data from a worksheet. The visible records satisfy the condition that the user sets. 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 tools bar” (or) click Data → Filter → Auto Filter Chapter 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