Back to all docs
API Reference / Telerik.Windows.Documents.Spreadsheet.Model.DataValidation / CustomDataValidationRule
New to Telerik Document Processing? Start a free 30-day trial

CustomDataValidationRule

Class

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:
C#
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.

C#
public CustomDataValidationRule(SingleArgumentDataValidationRuleContext context)
Parameters:contextSingleArgumentDataValidationRuleContext

The context.

Methods

EvaluateOverride(Worksheet, int, int, ICellValue)

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

C#
protected override bool EvaluateOverride(Worksheet worksheet, int rowIndex, int columnIndex, ICellValue cellValue)
Parameters:worksheetWorksheet

The worksheet.

rowIndexint

Index of the row.

columnIndexint

Index of the column.

cellValueICellValue

The cell value.

Returns:

bool

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

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

In this article
DefinitionConstructorsCustomDataValidationRule(SingleArgumentDataValidationRuleContext)MethodsEvaluateOverride(Worksheet, int, int, ICellValue)
Not finding the help you need?
Contact Support