Class FormulaRangeAddress¶

Namespace: OfficeOpenXml.FormulaParsing.LexicalAnalysis
Assembly: EPPlus.dll

Represents a range address

public class FormulaRangeAddress : FormulaAddressBase, IAddressInfo, IComparable<FormulaRangeAddress>

Inheritance¶

object ← FormulaAddressBase ← FormulaRangeAddress

Derived¶

FormulaTableAddress

Implements¶

IAddressInfo
IComparable<FormulaRangeAddress>

Inherited Members¶

FormulaAddressBase.ExternalReferenceIx
FormulaAddressBase.WorksheetIx
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

FormulaRangeAddress()¶

Constructor

public FormulaRangeAddress()

FormulaRangeAddress(ParsingContext)¶

Constructor

public FormulaRangeAddress(ParsingContext ctx)

Parameters¶

ctx ParsingContext

FormulaRangeAddress(ParsingContext, string)¶

Constructor

public FormulaRangeAddress(ParsingContext ctx, string address)

Parameters¶

ctx ParsingContext

address string

FormulaRangeAddress(ParsingContext, ExcelAddressBase)¶

public FormulaRangeAddress(ParsingContext ctx, ExcelAddressBase address)

Parameters¶

ctx ParsingContext

address ExcelAddressBase

FormulaRangeAddress(ParsingContext, int, int, int, int, int)¶

public FormulaRangeAddress(ParsingContext context, int wsIx, int fromRow, int fromCol, int toRow, int toCol)

Parameters¶

context ParsingContext

wsIx int

fromRow int

fromCol int

toRow int

toCol int

Fields¶

FromCol¶

public int FromCol

Field Value¶

int

FromRow¶

public int FromRow

Field Value¶

int

ToCol¶

public int ToCol

Field Value¶

int

ToRow¶

public int ToRow

Field Value¶

int

Properties¶

Address¶

The address.

public FormulaRangeAddress Address { get; }

Property Value¶

FormulaRangeAddress

Empty¶

public static FormulaRangeAddress Empty { get; }

Property Value¶

FormulaRangeAddress

IsSingleCell¶

public bool IsSingleCell { get; }

Property Value¶

bool

WorksheetAddress¶

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

public string WorksheetAddress { get; }

Property Value¶

string

WorksheetName¶

Worksheet name of the address

public string WorksheetName { get; }

Property Value¶

string

Methods¶

Clone()¶

public virtual FormulaRangeAddress Clone()

Returns¶

FormulaRangeAddress

CompareTo(FormulaRangeAddress)¶

public int CompareTo(FormulaRangeAddress other)

Parameters¶

other FormulaRangeAddress

Returns¶

int

ToString()¶

ToString() returns the full address as a string

public override string ToString()

Returns¶

string