Abstract base class for a named reference defined in the workbook.

Hierarchy

Hierarchy

Constructors

  • Parameters

    • a: any
    • b: boolean

    Returns NamedReferenceBase

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get comment(): string
  • Gets or sets the comment associated with the named reference or table. The comment associated with the named reference or table.

    Throws

    [[ArgumentException]] The value assigned is greater than 255 characters in length.

    Returns string

  • set comment(a): void
  • Parameters

    • a: string

    Returns void

  • get name(): string
  • Gets or sets the name of the reference.

    See the overview on [[scope]] for details on how to access a named reference by name in formulas.

    The name of the reference.

    Throws

    [[ArgumentNullException]] The value assigned is null or empty.

    Throws

    [[ArgumentException]] The value assigned is longer than 255 characters.

    Throws

    [[ArgumentException]] The value assigned is not a valid named reference. 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).

    Throws

    [[InvalidOperationException]] The value assigned is the name of another named reference with the same Scope. Names are compared case-insensitively.

    Returns string

  • set name(a): void
  • Parameters

    • a: string

    Returns void

  • get scope(): any
  • Gets the scope of the named reference.

    This can either be the workbook which the named reference belongs to or one of the worksheets in the workbook.

    The scope determines how formulas need to preface a name in order to use the named reference.

    If the scope is the workbook, formulas in any cell in the workbook can reference the named reference by specifying just the name or the workbook's file name, an exclamation point, and the name: =MyWorkbookName ='C:\MyWorkbook.xls'!MyWorkbookName When cells in other workbook's want to reference the named reference, they must use the second format by first specifying the file name when the workbook-scoped named reference exists.

    If the scope is a worksheet, formulas in cells of the worksheet can reference the named reference by specifying just the name. In addition, they can fully qualify the named reference with the worksheet name and, optionally, the workbook file name: =MyWorksheetName =Sheet1!MyWorksheetName ='C:\[MyWorkbook.xls]Sheet1'!MyWorksheetName Formulas in cells of other worksheets in the same workbook can use the named reference as well, but they must specify the worksheet name and, optionally, the workbook file name: =Sheet2!OtherWorksheetName ='C:\[MyWorkbook.xls]Sheet2'!OtherWorksheetName Formulas in cells of other workbooks can also used the named reference, but they must specify the workbook file name, worksheet name, and named reference name.

    The scope of the named reference.

    Returns any

Methods

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Returns Base

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean