Table of Contents

Struct FormulaCellAddress

Namespace
OfficeOpenXml.FormulaParsing.LexicalAnalysis
Assembly
EPPlus.dll

Formula Cell address

public struct FormulaCellAddress
Inherited Members

Constructors

FormulaCellAddress(int, int, int)

Constructor cell address

public FormulaCellAddress(int wsIx, int row, int column)

Parameters

wsIx int
row int
column int

Fields

Column

The column number

public int Column

Field Value

int

Row

The row number

public int Row

Field Value

int

WorksheetIx

Worksheet index in the package. -1 - Non-existing worksheet int.MinValue - Not set.

public int WorksheetIx

Field Value

int

Properties

Address

The address

public string Address { get; }

Property Value

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)
public ulong CellId { get; }

Property Value

ulong