AllowSort Property

Gets or sets whether users can sort rows in the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AllowSort As Boolean

'Usage
 
Dim instance As SheetView
Dim value As Boolean
 
instance.AllowSort = value
 
value = instance.AllowSort

public bool AllowSort {get; set;}

Property Value

Boolean: true to allow users to sort rows; false otherwise

Remarks

When this property is set to true, users can double-click a column header cell to sort all the rows of a sheet according to the values in that column. Typically, a sort indicator displays in that header cell. For more information on the operation of sorting columns and rows in a sheet, refer to Customizing Sorting of Rows of User Data.

Example

This example allows the user to sort the sheet.

FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
FpSpread1.ActiveSheetView.SetValue(0, 0, 9);
FpSpread1.ActiveSheetView.SetValue(1, 0, 5);
FpSpread1.ActiveSheetView.SetValue(2, 0, 7);
sv = FpSpread1.ActiveSheetView;
if (IsPostBack)
{
    sv.AllowSort = true;
}

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
FpSpread1.ActiveSheetView.SetValue(0, 0, 9)
FpSpread1.ActiveSheetView.SetValue(1, 0, 5)
FpSpread1.ActiveSheetView.SetValue(2, 0, 7)
sv = FpSpread1.ActiveSheetView
If IsPostBack Then
    sv.AllowSort = True
End If

Reference

SheetView Class
SheetView Members
GetColumnSortIndicator Method
SetColumnSortIndicator Method
Sort Method

User-Task Documentation

Customizing Sorting of Rows of User Data