SpreadsheetSheetRowCellValidationSettingsTagHelper

Example

Razor

<validation/>

Attributes

Attribute	Type	Description
allow-nulls	Boolean	Specifies whether to allow null values.
comparer-type	String	Defines the comparer type that is used to validate the cell value.The supported values are: greaterThan; lessThan; between; equalTo; notEqualTo; greaterThanOrEqualTo; lessThanOrEqualTo; notBetween or custom.
data-type	String	Defines the data type of the cell value.
from	String	Defines a formula or a value that is used for the comparison process. Used as the only compare value if the comparer type does not require a second argument. Mandatory for validation to work.
message-template	String	Defines the hint message that will be displayed if the value is invalid.The template provides access to the following variables: from{0}; to{1}; fromFormula{2}; toFormula{3}; dataType{4}; type{5} or comparerType{6}.
message-template-handler	String	Defines the hint message that will be displayed if the value is invalid.The template provides access to the following variables: from{0}; to{1}; fromFormula{2}; toFormula{3}; dataType{4}; type{5} or comparerType{6}.
message-template-id	String	Defines the hint message that will be displayed if the value is invalid.The template provides access to the following variables: from{0}; to{1}; fromFormula{2}; toFormula{3}; dataType{4}; type{5} or comparerType{6}.
message-template-view	IHtmlContent	Defines the hint message that will be displayed if the value is invalid.The template provides access to the following variables: from{0}; to{1}; fromFormula{2}; toFormula{3}; dataType{4}; type{5} or comparerType{6}.
show-button	Boolean	A Boolean value which indicates if a button for selecting list items will be displayed (dataType set to list).
title-template	String	Defines the hint title that will be displayed if the value is invalid.
title-template-handler	String	Defines the hint title that will be displayed if the value is invalid.
title-template-id	String	Defines the hint title that will be displayed if the value is invalid.
title-template-view	IHtmlContent	Defines the hint title that will be displayed if the value is invalid.
to	String	Defines a formula or a value that is used for the comparison process. Will be used if the comparer type requires a second argument.
type	String	Defines the validation type.The supported options are: reject or warning (default).