'Declaration<System.ComponentModel.CategoryAttribute("Data")> <System.ComponentModel.DescriptionAttribute("Occurs when edit mode begins.")> Public Event CellBeginEdit As CellBeginEditEventHandler
'UsageDim instance As WorkbookView Dim handler As CellBeginEditEventHandler AddHandler instance.CellBeginEdit, handler
[System.ComponentModel.Category("Data")] [System.ComponentModel.Description("Occurs when edit mode begins.")] public event CellBeginEditEventHandler CellBeginEdit
The event handler receives an argument of type CellBeginEditEventArgs containing data related to this event. The following CellBeginEditEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Cancel | Gets or sets the value which specifies whether the event should be canceled. |
| Entry | Gets or sets the edit entry text. |
| Reason | Gets the reason for the event. |
The CellBeginEdit event occurs when edit mode is being initiated, and provides the event handler with the ability to modify the text to be edited or cancel edit mode.
The CellBeginEdit event is always invoked on the thread which created the workbook view control, and a lock is always acquired on the workbook set associated with the workbook view control before CellBeginEdit is invoked.
/* * Sets the initial entry text to "Jim" when entry mode is initiated for cell B1. * * Cancels entry mode for any cell other than B1. */ private void workbookView_CellBeginEdit(object sender, CellBeginEditEventArgs e) { // Acquire a workbook set lock. workbookView.GetLock(); try { // Get a reference to the active worksheet's cells. SpreadsheetGear.IRange cells = WorkbookView.ActiveWorksheet.Cells; // Check if the correct cell is selected. if (workbookView.RangeSelection.Equals(cells["B1"])) // Change the entry text to "Jim". e.Entry = "Jim"; else // Cancel CellBeginEdit. e.Cancel = true; } finally { // Release the workbook set lock. workbookView.ReleaseLock(); } }
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