'Declaration Public Event EditChange As EventHandler(Of EditCellEventArgs)
'Usage Dim instance As GcSpreadSheet Dim handler As EventHandler(Of EditCellEventArgs) AddHandler instance.EditChange, handler
public event 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.
Property | Description |
---|---|
Column | Gets the cell column index. |
Row | Gets the cell row index. |
Example
This example uses the EditChange event.
private void gcSpreadSheet1_EditChange(object sender, GrapeCity.Xaml.SpreadSheet.UI.EditCellEventArgs e) { listBox1.Items.Add(e.Column.ToString()); listBox1.Items.Add(e.Row.ToString()); } private void gcSpreadSheet1_EditEnd(object sender, GrapeCity.Xaml.SpreadSheet.UI.EditCellEventArgs e) { listBox1.Items.Add(e.Column.ToString()); listBox1.Items.Add(e.Row.ToString()); } private void gcSpreadSheet1_EditStarting(object sender, GrapeCity.Xaml.SpreadSheet.UI.EditCellStartingEventArgs e) { listBox1.Items.Add(e.Column.ToString()); listBox1.Items.Add(e.Row.ToString()); } private void gcSpreadSheet1_ExcelError(object sender, GrapeCity.Xaml.SpreadSheet.Data.ExcelErrorEventArgs e) { listBox1.Items.Add(e.ExcelWarning.Code.ToString()); } private void gcSpreadSheet1_InvalidOperation(object sender, GrapeCity.Xaml.SpreadSheet.UI.InvalidOperationEventArgs e) { listBox1.Items.Add(e.Message.ToString()); } private void gcSpreadSheet1_LeaveCell(object sender, GrapeCity.Xaml.SpreadSheet.UI.LeaveCellEventArgs e) { listBox1.Items.Add(e.Column.ToString()); listBox1.Items.Add(e.Row.ToString()); }
Private Sub GcSpreadSheet1_EditChange(sender As Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.SpreadSheet.Data.ExcelErrorEventArgs) Handles GcSpreadSheet1.ExcelError ListBox1.Items.Add(e.ExcelWarning.Code.ToString()) End Sub Private Sub GcSpreadSheet1_InvalidOperation(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.InvalidOperationEventArgs) Handles GcSpreadSheet1.InvalidOperation ListBox1.Items.Add(e.Message.ToString()) End Sub Private Sub GcSpreadSheet1_LeaveCell(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.LeaveCellEventArgs) Handles GcSpreadSheet1.LeaveCell ListBox1.Items.Add(e.Column.ToString()) ListBox1.Items.Add(e.Row.ToString()) End Sub
See Also