'Declaration <DescriptionAttribute("Raised when the value of the cell does not pass the validation process.")> <CategoryAttribute("Data")> Public Event ValidationError As CellValidationErrorEventHandler
'Usage Dim instance As Cell Dim handler As CellValidationErrorEventHandler AddHandler instance.ValidationError, handler
[Description("Raised when the value of the cell does not pass the validation process.")] [Category("Data")] public event CellValidationErrorEventHandler ValidationError
The event handler receives an argument of type CellValidationErrorEventArgs containing data related to this event. The following CellValidationErrorEventArgs properties provide information specific to this event.
Property | Description |
---|---|
CancelEdit | Gets or sets a boolean value indicating if the cell whould exit edit mode. |
Exception | Gets the exception that was thrown. |
Value | Gets the value that failed the validation process. |
Setting e.CancelEdit to false in the ValidationError event will prevent the cell from leaving edit mode in the case where the its value fails the validation process.
Custom validation can be provided in the LeavingEdit event. In this event, if the validation process fails, setting e.Cancel to true will cause the ValidationError event to be raised.
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