Click or drag to resize

Validation Class

Represents a class for handling validation.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet CommonWrapper
Spire.Xls.Core.Spreadsheet XlsValidationWrapper
Spire.Xls Validation

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public class Validation : XlsValidationWrapper

The Validation type exposes the following members.

Properties
Name Description
Public property AlertStyle
Style of the error.
(Inherited from XlsValidationWrapper .)
Public property AllowType
Gets or sets the type of data that is allowed in the cell range associated with the data validation.
(Inherited from XlsValidationWrapper .)
Protected property BeginCallsCount
Returns number of begin update calls that have no corresponding end update. Read-only.
(Inherited from CommonWrapper .)
Public property CompareOperator
Gets or sets the comparison operator used in data validation.
(Inherited from XlsValidationWrapper .)
Public property DataRange
Returns data type validation for a range
Public property DateTime1
First formula's DateTime value.
(Inherited from XlsValidationWrapper .)
Public property DateTime2
Second formula's DateTime value.
(Inherited from XlsValidationWrapper .)
Public property ErrorMessage
Message of the error box.
(Inherited from XlsValidationWrapper .)
Public property ErrorTitle
Title of the error box.
(Inherited from XlsValidationWrapper .)
Public property Formula1
Gets or sets the first formula associated with data validation.
(Inherited from XlsValidationWrapper .)
Public property Formula2
Gets or sets the second formula associated with data validation.
(Inherited from XlsValidationWrapper .)
Public property IgnoreBlank
Indicates whether empty cell is allowed.
(Inherited from XlsValidationWrapper .)
Public property InputMessage
Message of the input box.
(Inherited from XlsValidationWrapper .)
Public property InputTitle
Title of the input box.
(Inherited from XlsValidationWrapper .)
Public property IsInputPositionFixed
Indicates whether position of the prompt box is fixed.
(Inherited from XlsValidationWrapper .)
Public property IsInputVisible
Indicates whether prompt box is visible.
(Inherited from XlsValidationWrapper .)
Public property IsListInFormula
Indicates whether formula contains list of values.
(Inherited from XlsValidationWrapper .)
Public property IsSuppressDropDownArrow
Indicates whether to suppress drop-down arrow.
(Inherited from XlsValidationWrapper .)
Public property Parent
Gets the parent object of the current data validation instance.
(Inherited from XlsValidationWrapper .)
Public property PromptBoxHPosition
Horizontal position of the prompt box.
(Inherited from XlsValidationWrapper .)
Public property PromptBoxVPosition
Vertical position of the prompt box.
(Inherited from XlsValidationWrapper .)
Public property ShowError
Indicates whether to show error box.
(Inherited from XlsValidationWrapper .)
Public property ShowInput
Indicates whether to show prompt box.
(Inherited from XlsValidationWrapper .)
Public property Values
Array of possible values (when values in list are entered manually)
(Inherited from XlsValidationWrapper .)
Top
Methods
Name Description
Public method BeginUpdate
This method should be called before several updates to the object will take place.
(Inherited from CommonWrapper .)
Public method Clone
Creates a copy of the current object.
(Inherited from CommonWrapper .)
Public method EndUpdate
This method should be called after several updates to the object.
(Inherited from CommonWrapper .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also