Spread WPF Documentation
EditChange Event (GcSpreadSheet)
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class : EditChange Event
Occurs when a cell is in edit mode and the text is changed.
Syntax
'Declaration
 
Public Event EditChange As System.EventHandler(Of EditCellEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of EditCellEventArgs)
 
AddHandler instance.EditChange, handler
public event System.EventHandler<EditCellEventArgs> EditChange
Event Data

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

PropertyDescription
Gets the cell column index.  
Gets the cell row index.  
Example
This example uses the EditChange event.
private void gcSpreadSheet1_EditChange(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

private void gcSpreadSheet1_EditEnd(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

private void gcSpreadSheet1_EditStarting(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellStartingEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

private void gcSpreadSheet1_ExcelError(object sender, GrapeCity.Windows.SpreadSheet.Data.ExcelErrorEventArgs e)
        {
            listBox1.Items.Add(e.ExcelWarning.Code.ToString());
        }
Private Sub GcSpreadSheet1_EditChange(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs) Handles GcSpreadSheet1.EditChange
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

Private Sub GcSpreadSheet1_EditEnd(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs) Handles GcSpreadSheet1.EditEnd
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

Private Sub GcSpreadSheet1_EditStarting(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellStartingEventArgs) Handles GcSpreadSheet1.EditStarting
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

Private Sub GcSpreadSheet1_ExcelError(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.Data.ExcelErrorEventArgs) Handles GcSpreadSheet1.ExcelError
        ListBox1.Items.Add(e.ExcelWarning.Code.ToString())
    End Sub
See Also