Represents a named reference defined in the workbook.
Inheritance
object
Properties
Section titled "Properties"Comment
Section titled "Comment"Inherited from: NamedReferenceBase
Gets or sets the comment associated with the named reference or table.
public string Comment { get; set; }Inherited from: NamedReferenceBase
Gets or sets the name of the reference.
public string Name { get; set; }Scope
Section titled "Scope"Inherited from: NamedReferenceBase
Gets the scope of the named reference.
public object Scope { get; }Formula
Section titled "Formula"Gets the formula which defines the named reference.
public string Formula { get; }IsSimpleReferenceFormula
Section titled "IsSimpleReferenceFormula"Gets the value indicating whether the is a simple formula referring to a single cell, a single region, or multiple regions in the same workbook as the named reference.
public bool IsSimpleReferenceFormula { get; }ReferencedCell
Section titled "ReferencedCell"Gets the referenced by the .
public WorksheetCell ReferencedCell { get; }ReferencedRegion
Section titled "ReferencedRegion"Gets the referenced by the .
public WorksheetRegion ReferencedRegion { get; }ReferencedRegions
Section titled "ReferencedRegions"Gets the array of instances referenced by the .
public WorksheetRegion[] ReferencedRegions { get; }Methods
Section titled "Methods"SetFormula(string)
Section titled "SetFormula(string)"Sets the formula for a named reference.
public void SetFormula(string formula)Parameters
- formula:
string
Returns any
SetFormula(string, CellReferenceMode)
Section titled "SetFormula(string, CellReferenceMode)"Sets the formula for a named reference.
public void SetFormula(string formula, CellReferenceMode cellReferenceMode)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode
Returns any
SetFormula(string, CellReferenceMode, CultureInfo)
Section titled "SetFormula(string, CellReferenceMode, CultureInfo)"Sets the formula for a named reference.
public void SetFormula(string formula, CellReferenceMode cellReferenceMode, CultureInfo culture)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo
Returns any
ToString()
Section titled "ToString()"Gets the string representation of the named reference.
public override string ToString()