Spire.XLS API

XlsValidation Class

Represents data validation for a worksheet range.

Inheritance Hierarchy

System Object
Spire.Xls.Core.Spreadsheet XlsValidation

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public class XlsValidation : IDataValidation, 
	IExcelApplication, IOptimizedUpdate, ICloneParent

Public Class XlsValidation
	Implements IDataValidation, IExcelApplication, IOptimizedUpdate, ICloneParent

public ref class XlsValidation : IDataValidation, 
	IExcelApplication, IOptimizedUpdate, ICloneParent

type XlsValidation =
class
interface IDataValidation
interface IExcelApplication
interface IOptimizedUpdate
interface ICloneParent
end

The XlsValidation type exposes the following members.

Properties

	Name	Description
	AlertStyle	Style of the error.
	AllowType	Type of the allowed data.
	CompareOperator	Compare operator used.
	DataRange	Range of possible values.
	DateTime1	First formula's DateTime value.
	DateTime2	Second formula's DateTime value.
	ErrorMessage	Text of the error message.
	ErrorTitle	Title of the error box.
	Formula1	Value of the first formula.
	Formula2	Value of the second formula.
	IgnoreBlank	Indicates whether empty cell is allowed.
	InputMessage	Text of the prompt box.
	InputTitle	Title of the prompt box.
	IsInputPositionFixed	Indicates whether position of the prompt box is fixed.
	IsInputVisible	Indicates whether prompt box is visible.
	IsListInFormula	Indicates whether formula contains list of values.
	IsSuppressDropDownArrow	Indicates whether to suppress drop-down arrow.
	Parent	Parent object for this object.
	ParentCollection	Gets / sets parent data validation collection.
	PromptBoxHPosition	Horizontal position of the prompt box.
	PromptBoxVPosition	Vertical position of the prompt box.
	ShapesCount	Gets number of required shapes objects.
	ShowError	Indicates whether to show error box.
	ShowInput	Indicates whether to show prompt box.
	Values	If this is data validation list, then gets / sets array of all possible values.
	Worksheet	Parent worksheet.

Methods

	Name	Description
	AddRange(XlsRange)	Adds range to the collection.
	AddRange(XlsValidation)	Adds the validation ranges.
	BeginUpdate	Obsolete. This method should be called before several updates to the object will take place.
	Clone	Clones current instance.
	ContainsCell	Indicates whether this object contains data validation settings for cell with specified index.
	EndUpdate	Obsolete. This method should be called after several updates to the object took place.
	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 the default hash function. (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 .)
	RemoveRange( Rectangle )	Removes ranges from collection. Ranges to remove.
	RemoveRange(XlsRange)	Removes range from collection.
	ToString	Returns a string that represents the current object. (Inherited from Object .)