Spread Windows Forms 8.0 Product Documentation > Developer's Guide > Customizing Row or Column Interaction > Managing Sorting of Rows of User Data > Allowing the User to Automatically Sort Rows |
You can set the spreadsheet to allow the user to automatically sort the data when a column header is clicked. The first time the column header is clicked (selected) the unsorted icon is displayed. The second click displays the sort icon and sorts the column. If the user clicks successively on the same column, then the direction of the sort is reversed. This does not affect the data model, only how the data is displayed. This figure shows the unsorted icon:
Use the Column object AllowAutoSort property or the SheetView SetColumnAllowAutoSort method to allow the user to perform automatic sorting when the header cell of a column is clicked. Set the SortIndicator property of the column you want to show the indicator.
The SetColumShowSortIndicator method or ShowSortIndicator property can be set to display or hide the sort indicator. The sort indicator appears in the header column as shown in this figure, illustrating the ascending and descending sort indicators.
Ascending Sort Indicator | Descending Sort Indicator |
---|---|
When a user sorts data, the AutoSortingColumn event occurs before the sort and then the AutoSortedColumn event occurs after the sort.
Use either the AllowAutoSort property of the columns or the SetColumnAllowAutoSort method of the Sheets object to allow automatic sorting of the specified columns.
This example allows automatic sorting for the first 30 columns in the sheet.
C# |
Copy Code
|
---|---|
fpSpread1.Sheets[0].Columns[0,29].AllowAutoSort = true; or fpSpread1.Sheets[0].SetColumnAllowAutoSort(0,30,true); |
VB |
Copy Code
|
---|---|
FpSpread1.Sheets(0).Columns(0,29).AllowAutoSort = True or FpSpread1.Sheets(0).SetColumnAllowAutoSort(0,30,True) |
Use the AllowAutoSort property to allow automatic sorting of the specified columns.
This example allows automatic sorting for the first 30 columns in the sheet.
C# |
Copy Code
|
---|---|
FarPoint.Win.Spread.Column mycols;
mycols = fpSpread1.ActiveSheet.Columns[0,29];
mycols.AllowAutoSort = true;
|
VB |
Copy Code
|
---|---|
Dim mycols As FarPoint.Win.Spread.Column mycols = FpSpread1.Sheets[0].Columns(0,29) mycols.AllowAutoSort = True |