Cell.Validation Property

Gets an IValidation object that can be used to specify validation rules for the data in the cell.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public IValidation Validation { get; }

Visual Basic

Public ReadOnly Property Validation As IValidation

 Property Value

An IValidation instance.

 Example

The following example illustrates how to set a cell validation.

C#

var validation = worksheet.Cells["J10"].Validation;
validation.Type = ValidationType.List;
validation.First = "Apples,Bananas,Plums,Strawberries";

Visual Basic

Dim validation = worksheet.Cells("J10").Validation
validation.Type = ValidationType.List
validation.First = "Apples,Bananas,Plums,Strawberries"