MindFusion.Spreadsheet.Wpf.Column.Validation Property

Introduction

General Information

What's New in this Release

Version History

Licensing

Programming Interface Overview

Reference

MindFusion.Spreadsheet.Wpf

AddItemCommand(T) Class

AdjustmentHandles Enumeration

Annotation Class

AutoFilter Class

AutoFilterOperator Enumeration

BaseMouseEventArgs Class

CalcExporter Class

CalcImporter Class

Cell Class

CellAnnotation Class

CellAnnotationPresenter Class

CellChangedEventArgs Class

CellCollection Class

CellData Class

CellEventArgs Class

CellIndex Class

CellMouseEventArgs Class

CellRange Class

CellRangeCollection Class

CellValidationEventArgs Class

ChangeWorksheetCommand Class

Column Class

Column Members

Column Properties

ConditionalFormats Property

Index Property

IsCollapsed Property

IsHidden Property

OutlineLevel Property

PageBreak Property

Style Property

Tag Property

Title Property

Validation Property

Width Property

ColumnChangedEventArgs Class

ColumnCollection Class

ColumnEventArgs Class

ColumnHeader Class

ColumnMouseEventArgs Class

ColumnRange Class

ColumnRangeEventArgs Class

ColumnRangeMovingEventArgs Class

ColumnRangeResizingEventArgs Class

Command Class

ComparisonOperator Enumeration

CompositeCommand Class

ConditionalFormatType Enumeration

Converter Class

CornerHeader Class

CsvExporter Class

CsvImporter Class

CurrencyCodeInfo Class

CurrencyCodes Class

CursorHint Enumeration

DefaultNumericFormats Class

DisposableCommand Class

Drawing Class

DynamicFilterType Enumeration

ExcelExporter Class

ExcelImporter Class

FillDate Enumeration

FillDirection Enumeration

FillType Enumeration

Filter Class

FindWithin Enumeration

FormattedText Class

HatchBrush Class

HatchStyle Enumeration

Header Class

HorizontalAlignment Enumeration

Hyperlink Class

HyperlinkType Enumeration

IColumnStyle Interface

IConditionalFormat Interface

IConditionalFormatCollection Interface

IHasName Interface

IInplaceEditable Interface

INotifyCollectionChanged Interface

INotifyPropertyValueChanged Interface

InplaceEditEventArgs Class

InplaceEditValidationEventArgs Class

InteractiveObject Class

InteractiveObjectPresenter Class

IRowStyle Interface

IStyle Interface

IValidation Interface

LookIn Enumeration

Measure Class

MeasureUnit Class

MergedCellsCollection Class

MoveItemCommand(T) Class

NamedCollection(T) Class

NamedRange Class

NamedRangeCollection Class

NotifyCollectionChangedAction Enumeration

NotifyCollectionChangedEventArgs Class

NumericFormatInfo Class

ObjectAnchor Enumeration

ObjectAnchorPosition Enumeration

ObjectEventArgs Class

ObjectInteractionEventArgs Class

ObjectInteractionValidationEventArgs Class

ObjectMouseEventArgs Class

ObjectValidationEventArgs Class

ObservableCollection(T) Class

OutlineEventArgs Class

PageOrder Enumeration

PaginationOptions Class

PdfExporter Class

Picture Class

PicturePresenter Class

PropertyEventArgs Class

PushDirection Enumeration

RemoveItemCommand(T) Class

ReplaceItemCommand(T) Class

ResetCollectionCommand(T) Class

Row Class

RowChangedEventArgs Class

RowCollection Class

RowEventArgs Class

RowHeader Class

RowMouseEventArgs Class

RowRange Class

RowRangeEventArgs Class

RowRangeMovingEventArgs Class

RowRangeResizingEventArgs Class

Run Class

SearchDirection Enumeration

SearchOrder Enumeration

Selection Class

SerializeColumnTagEventArgs Class

SerializeDataEventArgs Class

SerializeRowTagEventArgs Class

SerializeTagEventArgs Class

ShiftDirection Enumeration

SortDirection Enumeration

SortKey Class

SortOptions Class

SortOrder Enumeration

StyleData Class

TrackChangesCommand Class

UndoableCollection(T) Class

UndoEventArgs Class

ValidationErrorAction Enumeration

ValidationFailedEventArgs Class

ValidationType Enumeration

VerticalAlignment Enumeration

Workbook Class

WorkbookPrinter Class

WorkbookView Class

Worksheet Class

WorksheetChangedEventArgs Class

WorksheetCollection Class

WorksheetEventArgs Class

WorksheetMouseEventArgs Class

WorksheetTabMouseEventArgs Class

WorksheetValidationEventArgs Class

XmlContext Class

MindFusion.Spreadsheet.Wpf.Charts

MindFusion.Spreadsheet.Wpf.Expressions

MindFusion.Spreadsheet.Wpf.StandardForms

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# Copy Code
public IValidation Validation { get; }

Visual Basic Copy Code
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# Copy Code
var validation = worksheet.Columns[10].Validation; validation.Type = ValidationType.List; validation.First = "Apples,Bananas,Plums,Strawberries";

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

Syntax

Property Value

Example

See Also