Click or drag to resize

XlsValidationWrapper Properties

The XlsValidationWrapper type exposes the following members.

Properties
Name Description
Public property AlertStyle
Style of the error.
Public property AllowType
Gets or sets the type of data that is allowed in the cell range associated with the data validation.
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.
Public property DataRange
Range of possible values.
Public property DateTime1
First formula's DateTime value.
Public property DateTime2
Second formula's DateTime value.
Public property ErrorMessage
Message of the error box.
Public property ErrorTitle
Title of the error box.
Public property Formula1
Gets or sets the first formula associated with data validation.
Public property Formula2
Gets or sets the second formula associated with data validation.
Public property IgnoreBlank
Indicates whether empty cell is allowed.
Public property InputMessage
Message of the input box.
Public property InputTitle
Title of the input box.
Public property IsInputPositionFixed
Indicates whether position of the prompt box is fixed.
Public property IsInputVisible
Indicates whether prompt box is visible.
Public property IsListInFormula
Indicates whether formula contains list of values.
Public property IsSuppressDropDownArrow
Indicates whether to suppress drop-down arrow.
Public property Parent
Gets the parent object of the current data validation instance.
Public property PromptBoxHPosition
Horizontal position of the prompt box.
Public property PromptBoxVPosition
Vertical position of the prompt box.
Public property ShowError
Indicates whether to show error box.
Public property ShowInput
Indicates whether to show prompt box.
Public property Values
Array of possible values (when values in list are entered manually)
Top
See Also