Cell Validation
Cell value validation can be enabled by entering Cell Validation Rules. Cell Validation Rules uses the formula syntax to address the cell to validate and the expression used for evaluating whether the value of the cell passes validation or not.
Name
The name of the validation rule. This property is used for management purposes only.
Disabled
Specifies whether the validation rule is enabled or disabled. Mainly used for temporarily disabling validation rules while debugging or configuring the grid.
Rule Type
Specifies whether the validation rule is a critical (ValidationError) or not-critical (ValidationWarning) rule. A validation error sets a red border around a cell, while a warning sets a yellow border. Also, if validation is set up to execute from a Workbook context, a toast notification will appear if there are any validation errors. You can specify both a warning and error validation for the same cells.
Target
The address of the cells to mark as invalid if the validation Statement fails (returns false). Cells are addressed using standard formula syntax.
Statement
The formula used for evaluating whether the validation fails or not.
The statement should return true if the validation succeeds, otherwise false.
Example
To verify that cells in the Amount column contains values greater than 500, specify the following Target and Statement properties:
Target: @Amount[]
Statement : @Amount[] > 500
Validation Failure Message
The message displayed to the user if the validation failes.
Validation Failure Message Expression
A C#.NET expression returning a string displayed to the user if the validation fails.