Gets the sheet whose rows are to be automatically sorted.
Syntax
Visual Basic (Declaration) | |
---|
Public ReadOnly Property Sheet As SheetView |
Property Value
SheetView object containing the sheet to sort
Example
This example changes the color of the sorted column.
C# | Copy Code |
---|
private void button1Click(object sender, System.EventArgs e)
{
fpSpread1.ActiveSheet.AutoSortColumn(0);
}
private void fpSpread1_AutoSortingColumn(object sender, FarPoint.Win.Spread.AutoSortingColumnEventArgs e)
{
e.Sheet.Columns[e.Column].BackColor = Color.Yellow;
}
|
Visual Basic | Copy Code |
---|
Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
FpSpread1.ActiveSheet.AutoSortColumn(0)
End Sub
Private Sub FpSpread1_AutoSortingColumn(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.AutoSortingColumnEventArgs)
Handles FpSpread1.AutoSortingColumn
e.Sheet.Columns(e.Column).BackColor = Color.Yellow
End Sub |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also