Class FormulaRangeAddress

Represents a range address

Inheritance
object
FormulaAddressBase
FormulaRangeAddress
FormulaTableAddress
Implements
Inherited Members
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, int, int, int, int, int)

Formula range address

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

FormulaRangeAddress(ParsingContext, string)

Constructor

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

Fields

FromCol

From row and column. To row and to column

Declaration
public int FromCol
Field Value
Type Description
int

FromRow

From row and column. To row and to column

Declaration
public int FromRow
Field Value
Type Description
int

ToCol

From row and column. To row and to column

Declaration
public int ToCol
Field Value
Type Description
int

ToRow

From row and column. To row and to column

Declaration
public int ToRow
Field Value
Type Description
int

Properties

Address

Address

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

Addresses

If the address contains multiple comma separated addresses, the individual addresses are stored here.

Declaration
public FormulaRangeAddress[] Addresses { 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
bool

WorksheetAddress

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

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

WorksheetName

Worksheet name of the address

Declaration
public string WorksheetName { get; }
Property Value
Type Description
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
int

ToString()

ToString() returns the full address as a string

Declaration
public override string ToString()
Returns
Type Description
string
Overrides

Implements