Validation Class |
Namespace: Spire.Xls
The Validation type exposes the following members.
Name | Description | |
---|---|---|
![]() |
AlertStyle |
Style of the error.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
AllowType |
Gets or sets the type of data that is allowed in the cell range associated with the data validation.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
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.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
DataRange |
Returns data type validation for a range
|
![]() |
DateTime1 |
First formula's DateTime value.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
DateTime2 |
Second formula's DateTime value.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
ErrorMessage |
Message of the error box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
ErrorTitle |
Title of the error box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
Formula1 |
Gets or sets the first formula associated with data validation.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
Formula2 |
Gets or sets the second formula associated with data validation.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
IgnoreBlank |
Indicates whether empty cell is allowed.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
InputMessage |
Message of the input box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
InputTitle |
Title of the input box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
IsInputPositionFixed |
Indicates whether position of the prompt box is fixed.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
IsInputVisible |
Indicates whether prompt box is visible.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
IsListInFormula |
Indicates whether formula contains list of values.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
IsSuppressDropDownArrow |
Indicates whether to suppress drop-down arrow.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
Parent |
Gets the parent object of the current data validation instance.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
PromptBoxHPosition |
Horizontal position of the prompt box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
PromptBoxVPosition |
Vertical position of the prompt box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
ShowError |
Indicates whether to show error box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
ShowInput |
Indicates whether to show prompt box.
(Inherited from
XlsValidationWrapper
.)
|
![]() |
Values |
Array of possible values (when values in list are entered manually)
(Inherited from
XlsValidationWrapper
.)
|
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
.)
|