Table of Contents

TFormulaToken Enumeration

Known token on a formula. They are not supposed to be localized, but they can be by editing formulamsg.resx

Syntax

Namespace: FlexCel.Core

Members

Name Value Description
fmErrStart 0 '#';
fmTrue 1 'TRUE';
fmFalse 2 'FALSE';
fmStartFormula 3 '=' // as in =a1*2 or {=1+2}
fmFormulaDecimal 4 '.' as in '1.2'
fmFormulaThousands 5 ',' as in '1,300'
fmFunctionSep 6 ',' Argument separator on a function.
For example, if fmFunctionSep=';' we should write "Max(a1;a2)" If you want to localize this, you could use fmFunctionSep=ListSeparator
fmUnion 7 ',' as in "=a1, b2"
fmIntersect 8 ' ' as in a1 a2
fmOpenArray 9 '{';
fmCloseArray 10 '}';
fmOpenParen 11 '(';
fmCloseParen 12 ')';
fmArrayRowSep 13 '/' Separates 2 rows on an array. It is '\' in spanish
fmArrayColSep 14 ',' Separates 2 columns on an array. Ex: {1,2}. It is ';' in spanish If you want to localize this, you could use fmArrayColSep=ListSeparator
fmAbsoluteRef 15 '$' as in $A$3
fmRangeSep 16 ':' as in A1:A3
fmSingleQuote 17 ' (as in 'Sheet 1'!A1
fmExternalRef 18 '!' as in Sheet1!a1
fmWorkbookOpen 19 '[' as in c:\[book1.xls]Sheet1!a1
fmWorkbookClose 20 ']';
fmTableText 21 'TABLE';
fmPlus 22 '+';
fmMinus 23 '-';
fmMul 24 '*';
fmDiv 25 '/';
fmPower 26 '^';
fmPercent 27 '%';
fmStr 28 '"';
fmAnd 29 '&';
fmLT 30 '<';
fmLE 31 '<=';
fmEQ 32 '=';
fmGE 33 '>=';
fmGT 34 '>';
fmNE 35 '<>';
fmR1C1_R 36 'R' in R1C1 notation as in R1C2
fmR1C1_C 37 'C' in R1C1 notation as in R1C2
fmR1C1RelativeRefStart 38 '[' in R1C1 notation as in R[1]C[-2]
fmR1C1RelativeRefEnd 39 ']' in R1C1 notation as in R[1]C[-2]