Formula tokens containing the op-code obtained from this offset
describe a formula operand token that will be pushed onto the formula
stack while the formula is interpreted.
Formula tokens containing the op-code obtained from this offset
describe the reference to an external function (e.g. add-in function)
used in formulas.
Formula tokens containing the op-code obtained from this offset
describe a formula operand token that will be pushed onto the formula
stack while the formula is interpreted.
The FormulaToken::Data member shall contain one of
the following values:
A value of type double for literal floating-point
constants.
A string for literal text.
A any[][] for a literal array. The contained
values shall be of type double or string.
Floating-point values and strings may occur together in an array.
A struct of type SingleReference for a reference to a
single cell in the own document.
A struct of type ComplexReference for a reference to
a range of cells in the own document.
A struct of type ExternalReference for a reference to
a cell, a range of cells, or a defined name in an external document.
Formula tokens containing the op-code obtained from this offset
describe the reference to an external function (e.g. add-in function)
used in formulas.
The FormulaToken::Data member shall contain a
string with the programmatical name of the function, e.g.
"com.sun.star.sheet.addin.Analysis.getEomonth" for the EOMONTH
function from the Analsysis add-in.
Formula tokens containing the op-code obtained from this offset
describe the reference to a defined name (also known as named range)
used in formulas.
The FormulaToken::Data member shall contain an
integer value of type long specifying the index of the
defined name. This index can be obtained from the defined name using
its NamedRange::TokenIndex property.
Formula tokens containing the op-code obtained from this offset
describe whitespace characters within the string representation of a
formula.
Whitespace characters in formulas are used for readability and do
not affect the result of the formula.
The FormulaToken::Data member shall contain a
positive integer value of type long specifying the number
of space characters.
Attention: This may change in next versions to support other
characters than simple space characters (e.g. line feeds, horizontal
tabulators, non-breakable spaces).
Formula tokens containing the op-code obtained from this offset
describe the reference to a database range used in formulas.
The FormulaToken::Data member shall contain an
integer value of type long specifying the index of the
database range. This index can be obtained from the database range
using its DatabaseRange::TokenIndex property.