Version

Search Results

SetLowerConstraintFormula Method

Gets the lower constraint formula used to validate the cell value. Overload List

SetUpperConstraint(DateTime) Method

Sets the upper 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 ...

SetUpperConstraint(Double) Method

Sets the upper 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 less than the lower constraint value. If the lower constraint form...

SetUpperConstraint(TimeSpan) Method

Sets the upper 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 less than the lower constraint value. If the lower constraint form...

SetUpperConstraint Method

Sets the upper constraint value used to validate the cell value. Overload List

SetUpperConstraintFormula(String,String) Method

Gets the upper constraint formula used to validate the cell value. Syntax Parameters upperConstraintFormula The upper 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...

SetUpperConstraintFormula(String,String,WorkbookFormat,CellReferenceMode,CultureInfo) Method

Gets the upper constraint formula used to validate the cell value. Syntax Parameters upperConstraintFormula The upper 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...

SetUpperConstraintFormula Method

Gets the upper constraint formula used to validate the cell value. Overload List

TryGetLowerConstraint(DateTime) Method

Tries to obtain the value of the lower 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 obt...

TryGetLowerConstraint(Double) Method

Tries to obtain the value of the lower 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 ...