DataValidationCriteria Enumeration

Determines what types of cell values are allowed and how the cell value is validated against the constraint(s).

Syntax

Visual Basic

'Declaration
 
Public Enum DataValidationCriteria 
   Inherits System.Enum

C#

public enum DataValidationCriteria : System.Enum 

Members

Member	Description
Date	Dates with or without time portions are allowed as well as numbers equivalent to valid dates. When comparing against constraints, the cell value is used.
Decimal	Only numbers are allowed. When comparing against constraints, the cell value is used.
TextLength	Non-error values are allowed. When comparing against constraints, the length of the cell value's text equivalent is used.
Time	Times are allowed are well as numbers equivalent to valid times without a date portion. When comparing against constraints, the cell value is used.
WholeNumber	Only numbers are allowed and they cannot have a fractional part. When comparing against constraints, the cell value is used.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2