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

Visual Basic
C#

'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.

Property	Description
Column	Gets the column index.
ColumnCount	Gets the number of columns.
Row	Gets the row index.
RowCount	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());        
}

Visual Basic

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

Reference

SheetView Class
SheetView Members
RaiseCellChanged Method