XLValidationType Enumeration

In This Topic

Specifies the type of validation test to be performed in conjunction with values.

Syntax

'Declaration
 
Public Enum XLValidationType 
   Inherits System.Enum

public enum XLValidationType : System.Enum

Members

Member	Description
Custom	Specifies that the data validation uses a custom formula to check the cell value.
Date	Specifies that the data validation checks for and allows date values that meet the given condition.
Decimal	Specifies that the data validation checks for and allows decimal values that meet the given condition.
List	Specifies that the data validation checks for and allows a value that matches one in a list of values.
None	Specifies that the data validation allows any type of value and does not check for a type or range of values.
TextLength	Specifies that the data validation checks for and allows text values whose length meet the given condition.
Time	Specifies that the data validation checks for and allows time values that meet the given condition.
Whole	Specifies that the data validation checks for and allows whole number values that meet the given condition.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         C1.Excel.XLValidationType