Cell validating cancel

31-Oct-2020 12:42

However, the editor will be closed in this case and the value will be committed to the underlying data source.

Here is a list of all validation events: Cell Validating: Fires when a cell loses input focus, enabling content validation.

For example, when style is set to "Stop", invalid data triggers a window with a message, and the input is not allowed.

It will show an error indicator at the row header when you set this property to a non empty string.

For example, with the Decimal option configured to allow values between 0 and 3, values like .5, 2.5, and 3.1 are all allowed.

List - only values from a predefined list are allowed.

The table below summarizes behavior for each error alert option. When a data validation rule is created, there are eight options available to validate user input: Any Value - no validation is performed.

Note: if data validation was previously applied with a set Input Message, the message will still display when the cell is selected, even when Any Value is selected. Once the whole number option is selected, other options become available to further limit input.You can handle this case by subscribing to the Data Error event.