|
»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 multiple ways to perform a sort with various properties and methods for setting up each type of sorting.
The sort order 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 to sort the values. The sort indicator, often an arrow, can be displayed in the header for the column being used as a sort key.
The sorting depends 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.