Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Event EditError As EditErrorEventHandler | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As FpSpread Dim handler As EditErrorEventHandler AddHandler instance.EditError, handler | |
| C# | |
|---|---|
public event EditErrorEventHandler EditError | |
Event Data
The event handler receives an argument of type EditErrorEventArgs containing data related to this event. The following EditErrorEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Column | Gets the column index of the cell with the editor that raised the event. |
| EditError | Gets the type of edit error. |
| 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 OnEditError method when the user performs an invalid input operation.
An error can occur when the user attempts any of the following:
- Interacts with a locked cell
- Moves the focus to a restricted column
- Moves the focus to a restricted row
- Moves the focus to a cell that is located in both a restricted row and column
- Types invalid data into a cell (in which case the event is sent when the user leaves the cell.)
- Types in a check box cell
For more details on the individual event arguments, refer to EditErrorEventArgs members.
Example
This example raises the EditError event when the user performs an invalid input operation.
| C# | Copy Code |
|---|---|
fpSpread1.ActiveSheet.Cells[0, 0].Locked = true; fpSpread1.ActiveSheet.Cells[0, 0].BackColor = Color.Black; Label1.Text = "Double-click on the black cell. It is locked. This will fire the event"; private void fpSpread1_EditError(object sender, FarPoint.Win.Spread.EditErrorEventArgs e) { ListBox1.Items.Add(e.EditError.ToString()); } | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.ActiveSheet.Cells(0, 0).Locked = True FpSpread1.ActiveSheet.Cells(0, 0).BackColor = Color.Black Label1.Text = "Double-click on the black cell. It is locked. This will fire the event" Private Sub FpSpread1_EditError(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EditErrorEventArgs) Handles FpSpread1.EditError ListBox1.Items.Add(e.EditError.ToString()) End Sub | |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8