Sorting Data

Overview

You can sort data using up to 256 sort keys.

To sort data, first specify the data you want to sort, then specify which column or row you want to sort by, the priority of that column or row in the sort (sort by that column or row first, second, third, and so on), and whether you want to sort in ascending or descending order.

When specifying the data you want to sort, refer to Using Column and Row Properties for more information. For DLL controls, you can set the Col or Row parameter to 0 to perform a sort on the column or row header. For ActiveX controls, you can set the Col or Row properties to 0 to perform a sort on the column or row header.

Notes:

You cannot sort a sheet that is using virtual mode.
Button, check box, combo box, and picture cells are sorted by the value of the Text property.
If you sort by the column header and perform a sort by row, the row item data will move. If you sort by the row header and perform a sort by column, the column item data will move. For DLL users, perform a sort on the column or row header by setting the SSSort function's Col (or Row) parameter to 0 and the Col2 (or Row2) parameter to –1. For ActiveX users, perform a sort on the column or row header by setting the Col (or Row) property to 0 and the Col2 (or Row2) property to –1.
The sheet does not update cell references in formulas when you sort blocks of cells in the sheet.

You can also allow users to sort columns by clicking the column header. For more information, see Allowing Users To Sort By Columns.

Spread 8.0 Documentation
Sorting Data
Support Options