Version

Add(String,String,CellReferenceMode) Method

Adds a named reference with a scope of the collection's associated Workbook to the collection.
Syntax

Parameters

name
The name to give the named reference.
formula
The formula to give the named reference.
cellReferenceMode
The mode used to interpret cell references in the formula.

Return Value

The named reference which was added to the collection.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionname is null or empty.
System.ArgumentExceptionname is longer than 255 characters.
System.ArgumentExceptionname is invalid. The name must begin with a letter, underscore (_), or a backslash (\). All other characters in the name must be letters, numbers, periods, underscores (_), or backslashes (\). The name cannot be a an A1 cell reference (1 to 3 letters followed by 1 to 6 numbers). In addition, the name cannot be 'r', 'R', 'c', or 'C' or start with a row or column reference in R1C1 cell reference mode ('R' followed by 1 to 6 numbers or 'C' followed by 1 to 6 numbers).
System.InvalidOperationExceptionname is used by another named reference which also has a scope of the workbook. Named reference names are compared case-insensitively.
System.ArgumentNullExceptionformula is null or empty.
System.ArgumentExceptionformula is not a valid formula. The inner exception will contain the FormulaParseException describing the reason the formula was not valid.
Infragistics.Documents.Excel.MockClasses.InvalidEnumArgumentExceptioncellReferenceMode is not defined in the CellReferenceMode enumeration.
Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also