ExternalReferenceExpression Class

Represents the abstract class from which all external reference expression types derive.

Object Model

Syntax

Visual Basic
C#

'Declaration
 
Public MustInherit Class ExternalReferenceExpression 
   Inherits Expression

'Usage
 
Dim instance As ExternalReferenceExpression

public abstract class ExternalReferenceExpression : Expression

Remarks

An external reference is a reference to a cell (or range of cells) that explicitly states the sheet name, so that the reference can be to a location on a different sheet. While the reference may be to a sheet external to the one on which the reference appears, it does not have to be. By adding the sheet name to the reference, the external reference allows cross-sheet references of cells and ranges.

External references can be cell references (for individual cells) and range references (for a contiguous range of cells).

For references within a sheet, use references; for more information refer to the ReferenceExpression class.

For more information about expressions and formulas, refer to the Formula Overview.

Inheritance Hierarchy

System.Object
   FarPoint.CalcEngine.Expression
      FarPoint.CalcEngine.ExternalReferenceExpression
         FarPoint.CalcEngine.ExternalCellExpression
         FarPoint.CalcEngine.ExternalRangeExpression

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ExternalReferenceExpression Members
FarPoint.CalcEngine Namespace
ReferenceExpression Class
Expression Class
Formula Overview