Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / CellChanged Event
Example


In This Topic
    CellChanged Event
    In This Topic
    Occurs when a change is made to a cell or range of cells on this sheet that may require the cell or range of cells be repainted.
    Syntax
    'Declaration
     
    Public Event CellChanged As SheetViewEventHandler
    'Usage
     
    Dim instance As SheetView
    Dim handler As SheetViewEventHandler
     
    AddHandler instance.CellChanged, handler
    public event SheetViewEventHandler CellChanged
    Event Data

    The event handler receives an argument of type SheetViewEventArgs containing data related to this event. The following SheetViewEventArgs properties provide information specific to this event.

    PropertyDescription
    Gets the column index.  
    Gets the number of columns.  
    Gets the row index.  
    Gets the number of rows.  
    Remarks
    This occurs if any content in or formatting of this cell has changed.
    Example
    This example illustrates the use of the event by returning the column when the cell changes.
    private void sheetView1_CellChanged(object sender, FarPoint.Win.Spread.SheetViewEventArgs e)
    {
        listBox1.Items.Add(e.Column.ToString());        
    }
    Private Sub SheetView1_CellChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SheetViewEventArgs) Handles SheetView1.CellChanged
        ListBox1.Items.Add(e.Column.ToString())
    End Sub
    
    See Also