GrapeCity.Xaml.SpreadSheet.UI
EditStarting Event (GcSpreadSheet)
Example 


Occurs when a cell goes in edit mode.
Syntax
'Declaration
 
Public Event EditStarting As EventHandler(Of EditCellStartingEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of EditCellStartingEventArgs)
 
AddHandler instance.EditStarting, handler
public event EventHandler<EditCellStartingEventArgs> EditStarting
Event Data

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

PropertyDescription
Cancel (Inherited from System.ComponentModel.CancelEventArgs)
Column Gets the column index of the cell.  
Row Gets the row index of the cell.  
Example
This example uses the EditStarting 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
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options