Class ListDataValidationRule

Validates that cell input matches one of the values in a specified list or range.

Inheritance
System.Object
DataValidationRuleBase
SingleArgumentDataValidationRuleBase
ListDataValidationRule
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Model.DataValidation
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public sealed class ListDataValidationRule : SingleArgumentDataValidationRuleBase, IDataValidationRule

Constructors

ListDataValidationRule(ListDataValidationRuleContext)

Initializes a new ListDataValidationRule with the specified list source and dropdown settings.

Declaration
public ListDataValidationRule(ListDataValidationRuleContext context)
Parameters
ListDataValidationRuleContext context

The context.

Properties

InCellDropdown

Controls whether a dropdown arrow appears in the cell to display available list values.

Declaration
public bool InCellDropdown { get; set; }
Property Value
System.Boolean

The a value indicating if an cell dropdown should be shown.

Methods

Equals(Object)

Determines whether the specified System.Object is equal to the current System.Object.

Declaration
public override bool Equals(object obj)
Parameters
System.Object obj

The System.Object to compare with the current System.Object.
Returns
System.Boolean

true if the specified System.Object is equal to the current System.Object; otherwise, false.
Overrides

EvaluateOverride(Worksheet, Int32, Int32, ICellValue)

Evaluates whether the specified cell value matches any item in the list.

Declaration
protected override bool EvaluateOverride(Worksheet worksheet, int rowIndex, int columnIndex, ICellValue cellValue)
Parameters
Worksheet worksheet

The worksheet.
System.Int32 rowIndex

Index of the row.
System.Int32 columnIndex

Index of the column.
ICellValue cellValue

The cell value.
Returns
System.Boolean

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

ExtractListItems(Worksheet, Int32, Int32)

Extracts the list items defined by this rule for the specified cell location.

Declaration
public IEnumerable<string> ExtractListItems(Worksheet worksheet, int rowIndex, int columnIndex)
Parameters
Worksheet worksheet

The worksheet.
System.Int32 rowIndex

Index of the row.
System.Int32 columnIndex

Index of the column.
Returns
System.Collections.Generic.IEnumerable<System.String>

ExtractListItems(Worksheet, CellIndex)

Extracts the list items defined by this rule for the specified cell location.

Declaration
public IEnumerable<string> ExtractListItems(Worksheet worksheet, CellIndex cellIndex)
Parameters
Worksheet worksheet

The worksheet.
CellIndex cellIndex

Index of the cell.
Returns
System.Collections.Generic.IEnumerable<System.String>

GetHashCode()

Serves as a hash function for a particular type.

Declaration
public override int GetHashCode()
Returns
System.Int32

A hash code for the current System.Object.
Overrides