Calc Guide

Click on the Options tab (see Figure 308) to set the sort options. Check
the Range contains column labels checkbox to prevent column
headers from being sorted with the rest of the data. The Sort by list
box in Figure 307 displays the columns using the column headers if the
Range contains column labels checkbox in Figure 308 is checked. If
the Range contains column labels checkbox is not checked,
however, then the columns are identified by their column name;
Column A, for example.
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. You can either directly enter a
target address (Sheet3.A1, for example) or select a predefined range.
Check the Custom sort order checkbox to sort based on a predefined
list of values. To set your own predefined lists, use Tools > Options >
OpenOffice.org Calc > Sort Lists and then enter your own sort lists.
Predefined sort lists are useful for sorting lists of data that should not
be sorted alphabetically or numerically. For example, sorting days
based on their name.
Figure 308. Set sort options.
366 OpenOffice.org 3.x Calc Guide