Version

Search Results

IsEquivalentTo Method (CustomDataValidationRule)

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.

SetFormula(String,String) Method

Sets the formula used to validate the value applied to a cell. Syntax Parameters formula 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 System....

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

Sets the formula used to validate the value applied to a cell. Syntax Parameters formula 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 which to ...

SetFormula Method (CustomDataValidationRule)

Sets the formula used to validate the value applied to a cell. Overload List

CustomDataValidationRule Constructor

Creates a new CustomDataValidationRule instance. Syntax

CustomTableStyleCollection Class

A collection of custom WorksheetTableStyle instances which can be applied to a WorksheetTable in the Workbook. Syntax

CustomTableStyleCollection Class Members

Public Properties Public Methods

Add Method (CustomTableStyleCollection)

Adds a custom WorksheetTableStyle to the collection. Syntax Parameters style The custom table style to add to the collection. Exceptions Exception Description System.ArgumentNullException style is null. System.ArgumentException style is a standard table style. System.ArgumentException style is already in a CustomT...