Calc Open Office Part IV

Sorting Data

• The sorting mechanism in a Calc document rearranges the data in the sheet.
• STEP 1: Select the data that you want to sort.
• STEP 2: Use Data > Sort to open the Sort dialog.
• You can sort by up to three columns or rows at a time.

Sort Dialog Box

Sort Options

1. Range contains column labels Check the Range contains column labels checkbox to prevent column headers from being sorted with the rest of the data.
2. If the Range contains column labels checkbox is not checked, however, then the columns are identified by their column name; Column A, for example.

Range contains column labels

Copy sort results to

• Normally, sorting the data causes the existing data to be replaced by the newly sorted data. 
• The Copy sort results to checkbox, however, causes the selected data to be left unchanged and a copy of the sorted data is copied to the specified location.

Conditional Formatting

• You can set up cell formats to change depending on conditions that you specify. For example, in a table of numbers, you can show all the values above the average in green and all those below the average in red. 
• Conditional formatting depends upon the use of styles.

STEPS:

1. Create your cell/page style
2. Select the cells to apply conditional formatting
3. Choose Format > Conditional Formatting
4. Enter the conditions
5. Click OK