ExcelDataValidator Class

Winnovative Excel Library Documentation

Represents a data type validator for a range of cells.

Inheritance Hierarchy

SystemObject
Winnovative.ExcelLibExcelDataValidator

Namespace: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)

Syntax

public class ExcelDataValidator

Public Class ExcelDataValidator

public ref class ExcelDataValidator

type ExcelDataValidator =  class end

The ExcelDataValidator type exposes the following members.

Properties

	Name	Description
	AllowedDataType	Gets or sets the data type of the values allowed by this validator.
	AllowedValues	Gets or sets the list of possible string values for a cell.
	ErrorAlertStyle	Gets or sets the style of the error alert.
	ErrorAlertText	Gets or sets the text of the error alert to be shown when user enters invalid data.
	ErrorAlertTitle	Gets or sets the title of the error alert to be shown when user enters invalid data.
	InCellDropDown	Gets or sets a flag indicating if the drop down list with allowed values is displayed in cell. Default value is true.
	InputMessageText	Gets or sets the text of the input message to be shown when the cell to be validated is selected.
	InputMessageTitle	Gets or sets the title of the input message to be shown when the cell to be validated is selected.
	Operator	Gets or sets the operator for data validation.
	ShowErrorAlert	Gets or sets a flag indicating if the error alert is shown when user enters invalid data.
	ShowInputMessage	Gets or sets a flag indicating if the input message is shown when the cell to be validated is selected.
	Value1	Gets or sets the first value or expression for data validation.
	Value2	Gets or sets the second value or expression for data validation.

Methods

	Name	Description
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)