Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ChildWorkbookCreatedEventHandler Delegate
Source of the event
Event data
ExampleExample


In This Topic
    ChildWorkbookCreatedEventHandler Delegate
    In This Topic
    Represents a defined method that handles the ChildWorkbookCreated event for the Spread component.
    Syntax
    'Declaration
     
    Public Delegate Sub ChildWorkbookCreatedEventHandler( _
       ByVal sender As Object, _
       ByVal e As ChildWorkbookCreatedEventArgs _
    ) 
    'Usage
     
    Dim instance As New ChildWorkbookCreatedEventHandler(AddressOf HandlerMethod)
    public delegate void ChildWorkbookCreatedEventHandler( 
       object sender,
       ChildWorkbookCreatedEventArgs e
    )

    Parameters

    sender
    Source of the event
    e
    Event data
    Remarks
    For information on the event, refer to the FpSpread ChildWorkbookCreated event.
    Example
    This example changes the background color of the alternating rows in the workbook.
    fpSpread1.ChildWorkbookCreated += new FarPoint.Win.Spread.ChildWorkbookCreatedEventHandler(fpSpread1ChildWorkbookCreated);
    
    private void fpSpread1ChildWorkbookCreated(object sender, FarPoint.Win.Spread.ChildWorkbookCreatedEventArgs e)
    {
          e.Workbook.Sheets[e.Workbook.ActiveSheetIndex].AlternatingRows[0].BackColor = Color.Yellow;
    }
    
    Dim eh As FarPoint.Win.Spread.ChildWorkbookCreatedEventHandler = AddressOf FpSpread1ChildWorkbookCreated
    AddHandler FpSpread1.ChildWorkbookCreated, eh
    
    Private Sub FpSpread1ChildWorkbookCreated(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ChildWorkbookCreatedEventArgs)
    Handles FpSpread1.ChildWorkbookCreated
          e.Workbook.Sheets(e.Workbook.ActiveSheetIndex).AlternatingRows(0).BackColor = Color.Yellow
    End Sub
    See Also