Spread Windows Forms 9.0 Product Documentation
EditError Event
Example 


Occurs when the user performs an invalid input operation.
Syntax
'Declaration
 
Public Event EditError As EditErrorEventHandler
'Usage
 
Dim instance As FpSpread
Dim handler As EditErrorEventHandler
 
AddHandler instance.EditError, handler
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.

PropertyDescription
ColumnGets the column index of the cell with the editor that raised the event.  
EditErrorGets the type of edit error.  
RowGets the row index of the cell with the editor that raised the event.  
ViewGets 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:

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.
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());
}
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FpSpread Class
FpSpread Members
EditErrorEventArgs Class

 

 


Copyright © GrapeCity, inc. All rights reserved.