'Declaration Public Enum SortIndicator Inherits System.Enum
'Usage Dim instance As SortIndicator
public enum SortIndicator : System.Enum
'Declaration Public Enum SortIndicator Inherits System.Enum
'Usage Dim instance As SortIndicator
public enum SortIndicator : System.Enum
Member | Description |
---|---|
Ascending | Displays the ascending sort indicator |
Descending | Displays the descending sort indicator |
None | Displays no sort indicator |
private void Page_Load(object sender, System.EventArgs e) { if(IsPostBack)return; FpSpread1.ActiveSheetView.ColumnCount = 3; FpSpread1.ActiveSheetView.Columns[2].Width = 120; FpSpread1.ActiveSheetView.SetColumnLabel(0, 0, "LName"); FpSpread1.ActiveSheetView.SetColumnLabel(0, 1, "FName"); FpSpread1.ActiveSheetView.SetColumnLabel(0, 2, "SSN"); FpSpread1.ActiveSheetView.SetValue(0, 0, "Adams"); FpSpread1.ActiveSheetView.SetValue(1, 0, "Bjorn"); FpSpread1.ActiveSheetView.SetValue(2, 0, "Casey"); FpSpread1.ActiveSheetView.SetValue(0, 1, "Marie"); FpSpread1.ActiveSheetView.SetValue(1, 1, "Johan"); FpSpread1.ActiveSheetView.SetValue(2, 1, "Marv"); FpSpread1.ActiveSheetView.SetValue(0, 2, "243-65-0987"); FpSpread1.ActiveSheetView.SetValue(1, 2, "246-78-6767"); FpSpread1.ActiveSheetView.SetValue(2, 2, "223-98-1357"); ListBox1.Items.Add("None"); ListBox1.Items.Add("Ascending"); ListBox1.Items.Add("Descending"); ListBox1.AutoPostBack = true; } private void ListBox1_SelectedIndexChanged(object sender, System.EventArgs e) { if(ListBox1.Items[0].Selected) { FpSpread1.ActiveSheetView.SetColumnSortIndicator(0,FarPoint.Web.Spread.Model.SortIndicator.None); FpSpread1.ActiveSheetView.AllowSort = true; } else if(ListBox1.Items[1].Selected) { FpSpread1.ActiveSheetView.SetColumnSortIndicator(0,FarPoint.Web.Spread.Model.SortIndicator.Ascending); FpSpread1.ActiveSheetView.AllowSort = true; } else if(ListBox1.Items[2].Selected) { FpSpread1.ActiveSheetView.SetColumnSortIndicator(0,FarPoint.Web.Spread.Model.SortIndicator.Descending); FpSpread1.ActiveSheetView.AllowSort = true; } }
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If(IsPostBack)Then Return FpSpread1.ActiveSheetView.ColumnCount = 3 FpSpread1.ActiveSheetView.Columns(2).Width = 120 FpSpread1.ActiveSheetView.SetColumnLabel(0, 0, "LName") FpSpread1.ActiveSheetView.SetColumnLabel(0, 1, "FName") FpSpread1.ActiveSheetView.SetColumnLabel(0, 2, "SSN") FpSpread1.ActiveSheetView.SetValue(0, 0, "Adams") FpSpread1.ActiveSheetView.SetValue(1, 0, "Bjorn") FpSpread1.ActiveSheetView.SetValue(2, 0, "Casey") FpSpread1.ActiveSheetView.SetValue(0, 1, "Marie") FpSpread1.ActiveSheetView.SetValue(1, 1, "Johan") FpSpread1.ActiveSheetView.SetValue(2, 1, "Marv") FpSpread1.ActiveSheetView.SetValue(0, 2, "243-65-0987") FpSpread1.ActiveSheetView.SetValue(1, 2, "246-78-6767") FpSpread1.ActiveSheetView.SetValue(2, 2, "223-98-1357") ListBox1.Items.Add("None") ListBox1.Items.Add("Ascending") ListBox1.Items.Add("Descending") ListBox1.AutoPostBack = True End Sub Private Sub ListBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged If ListBox1.Items(0).Selected Then FpSpread1.ActiveSheetView.SetColumnSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.None) FpSpread1.ActiveSheetView.AllowSort = True ElseIf ListBox1.Items(1).Selected Then FpSpread1.ActiveSheetView.SetColumnSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Ascending) FpSpread1.ActiveSheetView.AllowSort = True ElseIf ListBox1.Items(2).Selected Then FpSpread1.ActiveSheetView.SetColumnSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Descending) FpSpread1.ActiveSheetView.AllowSort = True End If End Sub
System.Object
System.ValueType
System.Enum
FarPoint.Web.Spread.Model.SortIndicator
FarPoint.Web.Spread.Model Namespace
SortIndicator Property
Customizing the Graphical Interface
Customizing Sorting of Rows of User Data