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] |