Enum TokenType

Namespace

OfficeOpenXml.FormulaParsing.LexicalAnalysis

Assembly

EPPlus.dll

Token types in the context of formula parsing.

[Flags]
public enum TokenType : ulong

Fields

Array = 1099511627776

An array

Boolean = 65536

The parsed token represents a boolean value

CellAddress = 68719476736

Represents a cell address.

CircularReference = 268435456

The parsed token represents a circular reference

ClosingBracket = 128

The parsed token represents a closing bracket (']')

ClosingEnumerable = 32

The parsed token represents a closing enumerable ('}')

ClosingParenthesis = 8

The parsed token represents a clising parenthesis

Colon = 536870912

The parsed token represents a colon (address separator). Used for handling the offset function adress handling

Comma = 512

The parsed token represents a comma

Decimal = 131072

The parsed token represents a decimal value

Enumerable = 256

The parsed token represents an enumerable

ExcelAddress = 1048576

The parsed token represents an excel address

ExcelAddressR1C1 = 134217728

The parsed token represents an R1C1 address

ExternalReference = 4294967296

Represents an external reference

FullColumnAddress = 137438953472

Alphnumeric characters representing a full column

FullRowAddress = 274877906944

An integer representing a full row

Function = 524288

The parsed token represents an excel function

HashMark = 8796093022208

Represents a hash mark

Integer = 32768

The parsed token represents an integer value

InvalidReference = 4194304

The parsed token represents an InvalidReference error (#REF)

NAError = 2199023255552

Represents a N/A error

NameError = 70368744177664

Represents a name error

NameValue = 2097152

The parsed token represents a NameValue

Negator = 2

The parsed token represents an negator (negates a numeric expression)

Null = 33554432

The parsed token represents the NULL value

NumericError = 8388608

The parsed token represents a Numeric error (#NUM)

OpeningBracket = 64

The parsed token represents an opening bracket ('[')

OpeningEnumerable = 16

The parsed token represents a opening enumerable ('{')

OpeningParenthesis = 4

The parsed token represents an opening parenthesis

Operator = 1

The parsed token represents an operator

ParameterVariable = 140737488355328

Represents a parameter variable in functions such as LET or LAMBDA

ParameterVariableDeclaration = 35184372088832

Represents a parameter variable declaration in functions such as LET or LAMBDA

Percent = 262144

The parsed token represents a percentage value

PivotField = 17592186044416

Represents a pivot field in a pivot field formula

RangeOffset = 1073741824

The parsed token represents an address with the OFFSET function, either before, after or on both sides of the colon.

SemiColon = 1024

The parsed token represents a semicolon

SingleQuote = 4398046511104

Represents a single quote.

StartFunctionArguments = 549755813888

Reprensenting a the start of a function argument

String = 2048

The parsed token represents a string

StringContent = 4096

The parsed token represents content within a string

TableColumn = 34359738368

Represents a table column name in an address.

TableName = 8589934592

Refrence a table name in an address

TablePart = 17179869184

Represents a table part in an address, for example "#this row"

Unrecognized = 67108864

The parsed token represent an unrecognized value

ValueDataTypeError = 16777216

The parsed tokens represents an Value error (#VAL)

WhiteSpace = 2147483648

White space - Intersect operator will be set a operatar with the value " "

WorksheetName = 8192

The parsed token represents a worksheet name

WorksheetNameContent = 16384

The parsed token represents the content of a worksheet name