Known token on a formula. They are not supposed to be localized, but they can be by editing formulamsg.resx
Syntax
Unit: 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 |
'%%'; |
| fmAnd |
28 |
'&'; |
| fmLT |
29 |
'<'; |
| fmLE |
30 |
'<='; |
| fmEQ |
31 |
'='; |
| fmGE |
32 |
'>='; |
| fmGT |
33 |
'>'; |
| fmNE |
34 |
'<>'; |
| fmR1C1_R |
35 |
'R' in R1C1 notation as in R1C2 |
| fmR1C1_C |
36 |
'C' in R1C1 notation as in R1C2 |
| fmR1C1RelativeRefStart |
37 |
'[' in R1C1 notation as in R[1]C[-2] |
| fmR1C1RelativeRefEnd |
38 |
']' in R1C1 notation as in R[1]C[-2] |