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


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > AutoFilteredColumnEventArgs Class : Sheet Property
Gets the sheet whose rows were just automatically filtered.
Syntax
'Declaration
 
Public ReadOnly Property Sheet As SheetView
'Usage
 
Dim instance As AutoFilteredColumnEventArgs
Dim value As SheetView
 
value = instance.Sheet
public SheetView Sheet {get;}

Property Value

SheetView object containing the sheet
Example
This example changes the background color of the filtered column.
private void fpSpread1_AutoFilteredColumn(object sender, FarPoint.Win.Spread.AutoFilteredColumnEventArgs e) 
{ 
e.Sheet.Columns(e.Column).BackColor = Color.Yellow;
} 
Private Sub FpSpread1_AutoFilteredColumn(ByVal sender As Object, ByVal e As
FarPoint.Win.Spread.AutoFilteredColumnEventArgs) Handles FpSpread1.AutoFilteredColumn
e.Sheet.Columns(e.Column).BackColor = Color.Yellow
End Sub 
See Also

Reference

AutoFilteredColumnEventArgs Class
AutoFilteredColumnEventArgs Members