Class FormulaRangeAddress
Represents a range address
Inherited Members
Object.Equals(Object)
Object.Equals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, 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 | |
| Int32 | wsIx | |
| Int32 | fromRow | |
| Int32 | fromCol | |
| Int32 | toRow | |
| Int32 | 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 FromColField Value
| Type | Description |
|---|---|
| Int32 |
FromRow
From row and column. To row and to column
Declaration
public int FromRowField Value
| Type | Description |
|---|---|
| Int32 |
ToCol
From row and column. To row and to column
Declaration
public int ToColField Value
| Type | Description |
|---|---|
| Int32 |
ToRow
From row and column. To row and to column
Declaration
public int ToRowField Value
| Type | Description |
|---|---|
| Int32 |
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 |
|---|---|
| Boolean |
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 |
|---|---|
| Int32 |
ToString()
ToString() returns the full address as a string
Declaration
public override string ToString()Returns
| Type | Description |
|---|---|
| String |
Overrides
System.Object.ToString()
Implements
System.IComparable<T>