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.
Sets the constraint value used to validate the cell value. Syntax Parameters value The constraint value used to compare against the cell value. Exceptions Exception Description System.ArgumentException Occurs when value cannot be represented as a date in Excel. Remarks The way in which the cell value is compared t...
Sets the constraint value used to validate the cell value. Syntax Parameters value The constraint value used to compare against the cell value. Remarks The way in which the cell value is compared to the constraint value is determined by the ValidationOperator as well as the ValueConstraintDataValidationRule.Valida...
Sets the constraint value used to validate the cell value. Syntax Parameters value The constraint value used to compare against the cell value. Remarks The way in which the cell value is compared to the constraint value is determined by the ValidationOperator as well as the ValueConstraintDataValidationRule.Valida...
Sets the constraint value used to validate the cell value. Overload List
Sets the constraint formula used to validate the cell value. Syntax Parameters constraintFormula The validation formula to use for the rule.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. Exceptions Exception Description...
Sets the constraint formula used to validate the cell value. Syntax Parameters constraintFormula The validation formula to use for the rule.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.format The workbook format with w...
Sets the constraint formula used to validate the cell value. Overload List
Tries to obtain the value of the constraint. Syntax Parameters value When the method returns, will be the value of the constraint or DateTime.MinValue if the value could not be obtained. Return Value True if the constraint value could be obtained; False otherwise. Remarks The constraint value can only be obtained ...
Tries to obtain the value of the constraint. Syntax Parameters value When the method returns, will be the value of the constraint or 0 if the value could not be obtained. Return Value True if the constraint value could be obtained; False otherwise. Remarks The constraint value can only be obtained if it was set wi...