Spread Windows Forms 10.0 Product Documentation
CellChanged Event
Example 


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
ColumnGets the column index.  
ColumnCountGets the number of columns.  
RowGets the row index.  
RowCountGets 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
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetView Class
SheetView Members
RaiseCellChanged Method

 

 


Copyright © GrapeCity, inc. All rights reserved.