|
»Spread for Windows Forms
» Product Tour
» Sorting
|
|
jump to:
|
|
Sorting |
|
You can sort the data displayed in the sheet either by column or by row.
Typically, all the rows of a sheet are sorted by the values in a particular
column. But FarPoint Spread allows various ways of performing a sort with
various properties and methods for each type of sorting.
There are various properties of sorting. The order of the sort can be in
ascending order (A to Z, zero to 9) or descending order (Z to A, 9 to zero).
The method of comparison can be customized. You can select which values to use
as a key when comparing in order to sort the values. The sort indicator, an
arrow typically, can be displayed in the header for the column being used as a
sort key.
The sorting is done depending on the data type of the values in the cells. If
you sort cells with data of the DateTime type, then it sorts those cells by
date, and if you sort cells with data of the string type, it sorts those cells
alphabetically.