Spire.XLS API

XlsValidationWrapper Class

Represents a wrapper class for Excel validation.

Inheritance Hierarchy

System Object
Spire.Xls.Core.Spreadsheet CommonWrapper
Spire.Xls.Core.Spreadsheet XlsValidationWrapper
Spire.Xls Validation

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

Syntax

public class XlsValidationWrapper : CommonWrapper, 
	IDataValidation, IExcelApplication, IOptimizedUpdate

Public Class XlsValidationWrapper
	Inherits CommonWrapper
	Implements IDataValidation, IExcelApplication, IOptimizedUpdate

public ref class XlsValidationWrapper : public CommonWrapper, 
	IDataValidation, IExcelApplication, IOptimizedUpdate

type XlsValidationWrapper =
class
inherit CommonWrapper
interface IDataValidation
interface IExcelApplication
interface IOptimizedUpdate
end

The XlsValidationWrapper type exposes the following members.

Constructors

	Name	Description
	XlsValidationWrapper(XlsRange, XlsValidation)	Initializes a new instance of the XlsValidationWrapper class with the specified range and validation,.
	XlsValidationWrapper(XlsRange, XlsValidation, Boolean)	Initializes a new instance of the XlsValidationWrapper class. If the provided XlsValidation object is null, it creates a new validation for the specified range and sets it up based on the read-only flag.

Properties

	Name	Description
	AlertStyle	Style of the error.
	AllowType	Gets or sets the type of data that is allowed in the cell range associated with the data validation.
	BeginCallsCount	Returns number of begin update calls that have no corresponding end update. Read-only. (Inherited from CommonWrapper .)
	CompareOperator	Gets or sets the comparison operator used in data validation.
	DataRange	Range of possible values.
	DateTime1	First formula's DateTime value.
	DateTime2	Second formula's DateTime value.
	ErrorMessage	Message of the error box.
	ErrorTitle	Title of the error box.
	Formula1	Gets or sets the first formula associated with data validation.
	Formula2	Gets or sets the second formula associated with data validation.
	IgnoreBlank	Indicates whether empty cell is allowed.
	InputMessage	Message of the input box.
	InputTitle	Title of the input 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	Gets the parent object of the current data validation instance.
	PromptBoxHPosition	Horizontal position of the prompt box.
	PromptBoxVPosition	Vertical position of the prompt box.
	ShowError	Indicates whether to show error box.
	ShowInput	Indicates whether to show prompt box.
	Values	Array of possible values (when values in list are entered manually)

Methods

	Name	Description
	BeginUpdate	This method should be called before several updates to the object will take place. (Inherited from CommonWrapper .)
	Clone	Creates a copy of the current object. (Inherited from CommonWrapper .)
	EndUpdate	This method should be called after several updates to the object. (Inherited from CommonWrapper .)
	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 .)
	ToString	Returns a string that represents the current object. (Inherited from Object .)