Version

Search Results

ToString Method (NamedReference)

Gets the string representation of the named reference. Overload List

ObjectDisplayStyle Enumeration

Represents the various way objects and shapes are displayed in the workbook. Syntax Members Member Description HideAll No objects or shapes are shown. ShowAll All object are be shown. ShowPlaceholders Placeholders are shown in place of objects.

OneConstraintDataValidationOperator Enumeration

Represents the various operators which can be used when validating the cell value against a constraint. Syntax Members Member Description EqualTo Only allows the cell value if it or its text length, depending on the validation criteria, is equal to the constraint applied to the validation rule. GreaterThan Only al...

OneConstraintDataValidationRule Class

Represents a data validation rule which can validate the cell value against a single constraint value or formula. Syntax

OneConstraintDataValidationRule Class Members

Public Constructors Public Properties Public Methods

GetConstraintFormula(String) Method

Gets the 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 Exception Des...

GetConstraintFormula(String,WorkbookFormat,CellReferenceMode,CultureInfo) Method

Gets the 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 reference mo...

GetConstraintFormula Method

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