Class
CustomDataValidationRule

Validation rule using a custom formula expression that returns a boolean result determining cell validity.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model.DataValidation

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

cs-api-definition
public sealed class CustomDataValidationRule : SingleArgumentDataValidationRuleBase, IDataValidationRule

Inheritance: objectDataValidationRuleBaseSingleArgumentDataValidationRuleBaseCustomDataValidationRule

Implements: IDataValidationRule

Inherited Members SingleArgumentDataValidationRuleBase.Equals(object)SingleArgumentDataValidationRuleBase.GetHashCode()SingleArgumentDataValidationRuleBase.IgnoreBlankSingleArgumentDataValidationRuleBase.CellIndexSingleArgumentDataValidationRuleBase.Argument1DataValidationRuleBase.Evaluate(Worksheet, int, int, ICellValue)DataValidationRuleBase.ShowInputMessageDataValidationRuleBase.InputMessageTitleDataValidationRuleBase.InputMessageContentDataValidationRuleBase.ShowErrorMessageDataValidationRuleBase.ErrorStyleDataValidationRuleBase.ErrorAlertTitleDataValidationRuleBase.ErrorAlertContent

Constructors

CustomDataValidationRule(SingleArgumentDataValidationRuleContext)

Initializes a new CustomDataValidationRule with a formula expression that determines validity.

Declaration

cs-api-definition
public CustomDataValidationRule(SingleArgumentDataValidationRuleContext context)

Parameters

context

SingleArgumentDataValidationRuleContext

The context.

Methods

EvaluateOverride(Worksheet, int, int, ICellValue)

Evaluates the custom formula expression and returns true if the result is a boolean true value.

Declaration

cs-api-definition
protected override bool EvaluateOverride(Worksheet worksheet, int rowIndex, int columnIndex, ICellValue cellValue)

Parameters

worksheet

Worksheet

The worksheet.

rowIndex

int

Index of the row.

columnIndex

int

Index of the column.

cellValue

ICellValue

The cell value.

Returns

bool

Retrurns True if the rule is satisfied, else returns False.

Overrides DataValidationRuleBase.EvaluateOverride(Worksheet, int, int, ICellValue)