getAllowBlankCells

Gets a value indicating whether the validation should be skipped for blank cells.

getErrorAction

Gets the action to perform when the validation fails.

getErrorMessage

Gets the error message.

getErrorTitle

Gets the title of the error message.

getFirst

Gets the first value of the validation. This value is interpreted differently depending on the type of the validation.

getFirstInvariant

For internal use.

getInputMessage

Gets the input message.

getInputTitle

Gets the title of the input message.

getOperator

Gets the comparison operator, for validation types that require an operator.

getOriginColumn

Gets the origin column of this validation. All relative references in expressions associated with this validation are calculated based on this value.

getOriginRow

Gets the origin row of this validation. All relative references in expressions associated with this validation are calculated based on this value.

getSecond

Gets the second value of the validation. This value is interpreted differently depending on the type of the validation.

getSecondInvariant

For internal use.

getShowDropdownList

Gets a value indicating whether to display drop-down list when a cell in the validated range is selected and the validation type is set to List.

getShowError

Gets a value indicating whether to display error messages when the validation fails.

getShowInputMessage

Gets a value indicating whether to display information message when a cell in the validated range is selected.

getSortListEntries

Gets a value indicating whether to sort the entries in the drop-down list.

getType

Gets the validation type.

getWorksheet

Gets the worksheet this validation is associated with.

reset

Resets the validation to the default.

setAllowBlankCells

Sets a value indicating whether the validation should be skipped for blank cells.

setErrorAction

Sets the action to perform when the validation fails.

setErrorMessage

Sets the error message.

setErrorTitle

Sets the title of the error message.

setFirst

Sets the first value of the validation. This value is interpreted differently depending on the type of the validation.

setFirstInvariant

For internal use.

setInputMessage

Sets the input message.

setInputTitle

Sets the title of the input message.

setOperator

Sets the comparison operator, for validation types that require an operator.

setOriginColumn

Sets the origin column of this validation. All relative references in expressions associated with this validation are calculated based on this value.

setOriginRow

Sets the origin row of this validation. All relative references in expressions associated with this validation are calculated based on this value.

setSecond

Sets the second value of the validation. This value is interpreted differently depending on the type of the validation.

setSecondInvariant

For internal use.

setShowDropdownList

Sets a value indicating whether to display drop-down list when a cell in the validated range is selected and the validation type is set to List.

setShowError

Sets a value indicating whether to display error messages when the validation fails.

setShowInputMessage

Sets a value indicating whether to display information message when a cell in the validated range is selected.

setSortListEntries

Sets a value indicating whether to sort the entries in the drop-down list.

setType

Sets the validation type.