Column.Validation Property

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

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 validation for the cells in a column.

C#

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

Visual Basic

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