Spread Windows Forms 6.0 Product Documentation
EditChange Event
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : EditChange Event


Glossary Item Box

Occurs when the user changes the text in a cell in edit mode.

Syntax

Visual Basic (Declaration) 
Public Event EditChange As EditorNotifyEventHandler
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim handler As EditorNotifyEventHandler
 
AddHandler instance.EditChange, handler
C# 
public event EditorNotifyEventHandler EditChange

Event Data

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

PropertyDescription
Column Gets the column index of the cell with the editor that raised the event.
EditingControl Gets the Control object that raises the event.
Row Gets the row index of the cell with the editor that raised the event.
View Gets the view that contains the cell with the editor that raised the event.

Remarks

This event is raised by the OnEditChange method when the user changes the text in a cell in edit mode.

For more details on the individual event arguments, refer to EditorNotifyEventArgs members.

Example

This example raises the EditChange event when the user changes the text in a cell when in Edit mode.
C#Copy Code
fpSpread1.ActiveSheet.SetValue(0, 0, "ChangeMe");
Label1.Text = "Put the cell in edit mode and change the text.  This will fire the event";

private void fpSpread1_EditChange(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e)
{
     ListBox1.Items.Add("EditChange event fired!");
}
Visual BasicCopy Code
FpSpread1.ActiveSheet.SetValue(0, 0, "ChangeMe")
Label1.Text = "Put the cell in edit mode and change the text.  This will fire the event"

Private Sub FpSpread1_EditChange(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EditorNotifyEventArgs) Handles FpSpread1.EditChange
     ListBox1.Items.Add("EditChange event fired!")
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.