Spread Windows Forms 11.0 Product Documentation
CellChanged Event
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : CellChanged Event
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