Class FormulaRangeAddress

Represents a range address

Inheritance
System.Object
FormulaAddressBase
FormulaRangeAddress
FormulaTableAddress
Implements
System.IComparable<FormulaRangeAddress>
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
Namespace: OfficeOpenXml.FormulaParsing.LexicalAnalysis
Assembly: EPPlus.dll
Syntax
public class FormulaRangeAddress : FormulaAddressBase, IAddressInfo, IComparable<FormulaRangeAddress>

Constructors

FormulaRangeAddress()

Constructor

Declaration
public FormulaRangeAddress()

FormulaRangeAddress(ParsingContext)

Constructor

Declaration
public FormulaRangeAddress(ParsingContext ctx)
Parameters
Type Name Description
ParsingContext ctx

FormulaRangeAddress(ParsingContext, ExcelAddressBase)

Formula range address

Declaration
public FormulaRangeAddress(ParsingContext ctx, ExcelAddressBase address)
Parameters
Type Name Description
ParsingContext ctx
ExcelAddressBase address

FormulaRangeAddress(ParsingContext, Int32, Int32, Int32, Int32, Int32)

Formula range address

Declaration
public FormulaRangeAddress(ParsingContext context, int wsIx, int fromRow, int fromCol, int toRow, int toCol)
Parameters
Type Name Description
ParsingContext context
System.Int32 wsIx
System.Int32 fromRow
System.Int32 fromCol
System.Int32 toRow
System.Int32 toCol

FormulaRangeAddress(ParsingContext, String)

Constructor

Declaration
public FormulaRangeAddress(ParsingContext ctx, string address)
Parameters
Type Name Description
ParsingContext ctx
System.String address

Fields

FromCol

From row and column. To row and to column

Declaration
public int FromCol
Field Value
Type Description
System.Int32

FromRow

From row and column. To row and to column

Declaration
public int FromRow
Field Value
Type Description
System.Int32

ToCol

From row and column. To row and to column

Declaration
public int ToCol
Field Value
Type Description
System.Int32

ToRow

From row and column. To row and to column

Declaration
public int ToRow
Field Value
Type Description
System.Int32

Properties

Address

Address

Declaration
public FormulaRangeAddress Address { get; }
Property Value
Type Description
FormulaRangeAddress

Empty

Empty

Declaration
public static FormulaRangeAddress Empty { get; }
Property Value
Type Description
FormulaRangeAddress

IsSingleCell

Is single cell

Declaration
public bool IsSingleCell { get; }
Property Value
Type Description
System.Boolean

WorksheetAddress

Address of the range on the worksheet (i.e. worksheet name is excluded).

Declaration
public string WorksheetAddress { get; }
Property Value
Type Description
System.String

WorksheetName

Worksheet name of the address

Declaration
public string WorksheetName { get; }
Property Value
Type Description
System.String

Methods

Clone()

Clone

Declaration
public virtual FormulaRangeAddress Clone()
Returns
Type Description
FormulaRangeAddress

CompareTo(FormulaRangeAddress)

Compare to

Declaration
public int CompareTo(FormulaRangeAddress other)
Parameters
Type Name Description
FormulaRangeAddress other
Returns
Type Description
System.Int32

ToString()

ToString() returns the full address as a string

Declaration
public override string ToString()
Returns
Type Description
System.String
Overrides
System.Object.ToString()

Implements

System.IComparable<T>