Specifies the type of data validation used to validate user input.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 35.0.30.1025

Syntax

C#
public enum DataValidationType

Visual Basic
Public Enumeration DataValidationType

Members

	Member name	Value	Description
	None	0	No data validation.
	WholeNumber	1	Data validation which checks for whole number values satisfying the given condition.
	Decimal	2	Data validation which checks for decimal values satisfying the given condition.
	List	3	Data validation which checks for a value matching one of list of values.
	Date	4	Data validation which checks for date values satisfying the given condition.
	Time	5	Data validation which checks for time values satisfying the given condition.
	TextLength	6	Data validation which checks for text values, whose length satisfies the given condition.
	Custom	7	Data validation which uses a custom formula to check the cell value.

See Also

GemBox.Spreadsheet Namespace