Class NameInfo

Namespace

OfficeOpenXml.FormulaParsing.Ranges

Assembly

EPPlus.dll

EPPlus implementation of the INameInfo interface

public class NameInfo : INameInfo

Inheritance

object

NameInfo

Implements

INameInfo

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

NameInfo(ExcelNamedRange)

Nameinfo

public NameInfo(ExcelNamedRange nameItem)

Parameters

nameItem ExcelNamedRange

Properties

Formula

Formula of the name

public string Formula { get; }

Property Value

string

Id

Id

public ulong Id { get; }

Property Value

ulong

IsRelative

public bool IsRelative { get; }

Property Value

bool

Name

The name

public string Name { get; }

Property Value

string

Tokens

Tokens

public IList<Token> Tokens { get; }

Property Value

IList<Token>

Value

Value

public object Value { get; set; }

Property Value

object

wsIx

Worksheet name

public int wsIx { get; }

Property Value

int

Methods

GetRelativeFormula(int, int)

Gets the forumla relative to a row and column.

public string GetRelativeFormula(int row, int col)

Parameters

row int

The row

col int

The column

Returns

string

GetRelativeRange(IRangeInfo, FormulaCellAddress)

Returns the range relative to the cell for a named range with a relative address.

public IRangeInfo GetRelativeRange(IRangeInfo ri, FormulaCellAddress currentCell)

Parameters

ri IRangeInfo

currentCell FormulaCellAddress

Returns

IRangeInfo

GetValue(FormulaCellAddress)

Get the value relative to the current cell.

public object GetValue(FormulaCellAddress currentCell)

Parameters

currentCell FormulaCellAddress

Returns

object