Spread Windows Forms 11.0 Product Documentation
Sheet Property (AutoSortingColumnEventArgs)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > AutoSortingColumnEventArgs Class : Sheet Property
Gets the sheet whose rows are to be automatically sorted.
Syntax
'Declaration
 
Public ReadOnly Property Sheet As SheetView
'Usage
 
Dim instance As AutoSortingColumnEventArgs
Dim value As SheetView
 
value = instance.Sheet
public SheetView Sheet {get;}

Property Value

SheetView object containing the sheet to sort
Example
This example changes the color of the sorted column.
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;
}
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
See Also

Reference

AutoSortingColumnEventArgs Class
AutoSortingColumnEventArgs Members