SortIndicator Enumeration

Specifies the display of the sort indicator.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum SortIndicator 
   Inherits System.Enum

'Usage
 
Dim instance As SortIndicator

public enum SortIndicator : System.Enum

Members

Member	Description
Ascending	Displays the ascending sort indicator
Descending	Displays the descending sort indicator
None	Displays no sort indicator

Example

This example populates the spreadsheet with data and in the SelectedIndexChanged event of a list box the SortIndicator is changed based on the selection.

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;
}
}

Visual Basic

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

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.Model.SortIndicator

Reference

FarPoint.Web.Spread.Model Namespace
SortIndicator Property

User-Task Documentation

Customizing the Graphical Interface
Customizing Sorting of Rows of User Data