In the simple example shown below, the data consist of the names and
countries of a number of mountains together with their height above sea level.
KSpread can sort data such as this in different ways.
We may want the data sorted so that the names are in
alphabetical order. To do this select the area containing the data (A2:C7
in this case) and choose
from the
menu. This opens the
Sorting
dialog box.
Sorting is done alphanumerically, and the default is case sensitive, numbers coming
before uppercase letters which come before lowercase letters, so that cells
containing the entries
Cat
,
bar
,
77
and
Bat
would be sorted into
the following order:
77 Bat Cat bar
.
Using the
Sort Criteria
page of this dialog box
lets you
Sort Rows
or
Sort Columns
.
If you check the
First row contains headers
box data in the
first row will not be included in the sort operation.
You can choose which column or which row of the data is to be used as a primary sort key and,
if you wish, other columns or rows to be used as secondary and tertiary keys. Using
the example in the above screenshot, choosing column B as the first key and
column C as the second would sort the data by country and, for each country,
by height.
The
Options
page of the dialog allows you to sort using the
order of items in a custom list such as January, February... instead
of alphanumerically.
The cell format is moved with the cell content, if you select
Copy cell Formatting (Borders, Colors, Text Style)
Uncheck the option
Case sensitive sort
to get a sort
not depending on capitalization.
