Version

Search Results

LimitedValueDataValidationRule Class Members

Public Properties Public Methods

AllowNull Property

Gets or sets the value which indicates whether a null, or blank, value is allowed to be set on a cell. Syntax Property Value True if a null value can be set on the cell; False otherwise.

IsEquivalentTo Method (LimitedValueDataValidationRule)

Indicates if this rule is structurally equivalent to another. Syntax Parameters other The rule to compare against Return Value Returns true if the specified other has the same settings as this rule.

ListDataValidationRule Class

Represents a data validation rule which allows a value from a list of accepted values to be applied to a cell. Syntax

ListDataValidationRule Class Members

Public Constructors Public Properties Public Methods

GetValuesFormula(String) Method

Gets the formula which specifies the accepted values. Syntax Parameters address The address of the cell or region that serves as the basis for relative references, or null to use the top-left cell of the worksheet. Return Value A formula used to validate the value applied to a cell. Exceptions Exception Descriptio...