IDataValidation Interface |
Contains a condition and the formatting attributes applied
to the cells, if the condition is met.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The IDataValidation 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 |
Gets the parent object of the current instance.
(Inherited from
IExcelApplication
.)
|
|
|
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
IOptimizedUpdate
.)
|
|
|
EndUpdate |
This method should be called after several updates to the object took place.
(Inherited from
IOptimizedUpdate
.)
|
See Also
