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

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
GetColumnSortIndicator Method
SetColumnSortIndicator Method
Sort Method

User-Task Documentation

Customizing Sorting of Rows of User Data