Gets the upper constraint formula used to validate the cell value. 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 Excepti...
Gets the upper constraint formula used to validate the cell value. 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.format The workbook format with which to parse address.cellReferenceMode The cell refere...
Gets the upper constraint formula used to validate the cell value. Overload List
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 lower constraint value used to validate the cell value. Syntax Parameters value The lower 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. System.ArgumentException Occurs when the ...
Sets the lower constraint value used to validate the cell value. Syntax Parameters value The lower constraint value used to compare against the cell value. Exceptions Exception Description System.ArgumentException Occurs when the specified value is greater than the upper constraint value. If the upper constraint f...
Sets the lower constraint value used to validate the cell value. Syntax Parameters value The lower constraint value used to compare against the cell value. Exceptions Exception Description System.ArgumentException Occurs when the specified value is greater than the upper constraint value. If the upper constraint f...
Sets the lower constraint value used to validate the cell value. Overload List
Gets the lower constraint formula used to validate the cell value. Syntax Parameters lowerConstraintFormula The lower constraint 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 Exce...
Gets the lower constraint formula used to validate the cell value. Syntax Parameters lowerConstraintFormula The lower constraint 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 workb...