Represents a named reference defined in the workbook.
Constructors
Section titled "Constructors"NamedReference
new NamedReference(a: number, b: NamedReferenceCollection, c: any): NamedReferenceReturns NamedReference
Properties
Section titled "Properties"$t: Typecomment
Section titled "comment"Inherited from: NamedReferenceBase
comment: stringInherited from: NamedReferenceBase
name: stringAccessors
Section titled "Accessors"formula
Section titled "formula"Gets the formula which defines the named reference. The formula which defines the named reference.
get formula(): stringReturns string
isSimpleReferenceFormula
Section titled "isSimpleReferenceFormula"Gets the value indicating whether the [[formula]] is a simple formula referring to a single cell, a single region, or multiple regions in the same workbook as the named reference.
get isSimpleReferenceFormula(): booleanReturns boolean
referencedCell
Section titled "referencedCell"Gets the [[WorksheetCell]] referenced by the [[formula]].
get referencedCell(): WorksheetCellReturns WorksheetCell
referencedRegion
Section titled "referencedRegion"Gets the [[WorksheetRegion]] referenced by the [[formula]].
get referencedRegion(): WorksheetRegionReturns WorksheetRegion
referencedRegions
Section titled "referencedRegions"Gets the array of [[WorksheetRegion]] instances referenced by the [[formula]].
get referencedRegions(): WorksheetRegion[]Returns WorksheetRegion[]
scope
Section titled "scope"Inherited from: NamedReferenceBase
Gets the scope of the named reference.
get scope(): anyReturns any
Methods
Section titled "Methods"setFormula
Section titled "setFormula"Sets the formula for a named reference.
setFormula(formula: string): voidParameters
- formula:
stringThe string containing the formula value.
Returns void
toString
Section titled "toString"Gets the string representation of the named reference.
toString(): string