Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / AutoSortingColumnEventArgs Class / Sheet Property
Example


In This Topic
    Sheet Property (AutoSortingColumnEventArgs)
    In This Topic
    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