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


In This Topic
    Sheet Property (DataColumnConfigureEventArgs)
    In This Topic
    Gets the sheet (SheetView object) that is binding to a data source.
    Syntax
    'Declaration
     
    Public ReadOnly Property Sheet As SheetView
    'Usage
     
    Dim instance As DataColumnConfigureEventArgs
    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 first row in the configured column.
    private void fpSpread1DataColumnConfigure(object sender, FarPoint.Win.Spread.DataColumnConfigureEventArgs e) 
    { 
           e.Sheet.Cells[0, e.Column].BackColor = Color.Yellow;
    } 
    
    Private Sub FpSpread1DataColumnConfigure(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.DataColumnConfigureEventArgs)
    Handles FpSpread1.DataColumnConfigure
           e.Sheet.Cells(0, e.Column).BackColor = Color.Yellow
    End Sub
    See Also