Struct FormulaCellAddress
Formula Cell address
Inherited Members
Namespace: OfficeOpenXml.FormulaParsing.LexicalAnalysis
Assembly: EPPlus.dll
Syntax
public struct FormulaCellAddressConstructors
FormulaCellAddress(int, int, int)
Constructor cell address
Declaration
public FormulaCellAddress(int wsIx, int row, int column)Parameters
| Type | Name | Description |
|---|---|---|
| int | wsIx | |
| int | row | |
| int | column |
Fields
Column
The column number
Declaration
public int ColumnField Value
| Type | Description |
|---|---|
| int |
Row
The row number
Declaration
public int RowField Value
| Type | Description |
|---|---|
| int |
WorksheetIx
Worksheet index in the package. -1 - Non-existing worksheet int.MinValue - Not set.
Declaration
public int WorksheetIxField Value
| Type | Description |
|---|---|
| int |
Properties
Address
The address
Declaration
public string Address { get; }Property Value
| Type | Description |
|---|---|
| string |
CellId
The cell id for the address. The cell Id is an ulong with the worksheet shifted as
((ushort)sheetId) | (((ulong)col) << 16) | (((ulong)row) << 30)Declaration
public ulong CellId { get; }Property Value
| Type | Description |
|---|---|
| ulong |