blob: fea9b5d7b46b94e1f2ca5033f4421736804f38ab (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
|
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
package org.openoffice.xmerge.converter.xml.sxc.pexcel.records.formula;
public interface TokenConstants {
// Unary Operator Tokens
public static final int TUPLUS = 0x12;
public static final int TUMINUS = 0x13;
public static final int TPERCENT = 0x14;
public static final int TPAREN = 0x15;
// Binary Operator Tokens
public static final int TADD = 0x03;
public static final int TSUB = 0x04;
public static final int TMUL = 0x05;
public static final int TDIV = 0x06;
public static final int TPOWER = 0x07;
public static final int TCONCAT = 0x08;
//Logical operators
public static final int TLESS = 0x09;
public static final int TLESSEQUALS = 0x0A;
public static final int TEQUALS = 0x0B;
public static final int TGTEQUALS = 0x0C;
public static final int TGREATER = 0x0D;
public static final int TNEQUALS = 0x0E;
// Function Operator Tokens
public static final int TFUNC = 0x41;
public static final int TFUNCVAR = 0x42;
// Constant Operand Tokens
public static final int TSTRING = 0x17;
public static final int TINT = 0x1E;
public static final int TNUM = 0x1F;
// Operand Tokens
public static final int TREF = 0x44;
public static final int TAREA = 0x25;
public static final int TNAME = 0x23;
public static final int TREF3D = 0x3A;
public static final int TAREA3D = 0x3B;
//
public static final int TARGSEP = 0x1001;
public static final int TCLOSEPAREN = 0x1002;
// Variable argument Functions
// Math and Trig
public static final int TSUM = 0x04;
public static final int TPRODUCT = 0xB7;
public static final int TSUMIF = 0x0159;
public static final int TLOG = 0x6D;
public static final int TRUNC = 0xC5;
// Financial
public static final int TDDB = 0x90;
public static final int TFV = 0x39;
public static final int TIRR = 0x3E;
public static final int TNPER = 0x3A;
public static final int TNPV = 0x0B;
public static final int TPMT = 0x3B;
public static final int TPV = 0x38;
public static final int TRATE = 0x3C;
// Statistical
public static final int TAVERAGE = 0x05;
public static final int TCOUNT = 0x00;
public static final int TCOUNTA = 0xA9;
public static final int TMAX = 0x07;
public static final int TMIN = 0x06;
public static final int TSTDEV = 0x0C;
public static final int TSTDEVP = 0xC1;
public static final int TVAR = 0x2E;
public static final int TVARP = 0xC2;
// Lookup
public static final int TCHOOSE = 0x64;
public static final int THLOOKUP = 0x65;
public static final int TINDEX = 0x1D;
public static final int TMATCH = 0x40;
public static final int TVLOOKUP = 0x66;
// Text
public static final int TRIGHT = 0x74;
public static final int TSUBSTITUTE = 0x78;
public static final int TFIND = 0x7c;
public static final int TLEFT = 0x73;
// Logical
public static final int TAND = 0x24; // 42
public static final int TIF = 0x01; // 42
public static final int TOR = 0x25; // 42
// Fixed argument Functions
// Math and Trig
public static final int TABS = 0x18;
public static final int TACOS = 0x63;
public static final int TASIN = 0x62;
public static final int TATAN = 0x12;
public static final int TATAN2 = 0x61;
public static final int TCOS = 0x10;
public static final int TSIN = 0x0F;
public static final int TCOUNTIF = 0x015A;
public static final int TDEGREES = 0x0157;
public static final int TEXP = 0x15;
public static final int TFACT = 0xB8;
public static final int TINTE = 0x19;
public static final int TLN = 0x16;
public static final int TLOG10 = 0x17;
public static final int TMOD = 0x27;
public static final int TPI = 0x13;
public static final int TPOWERF = 0x0151;
public static final int TRADIANS = 0x0156;
public static final int TRAND = 0x3F;
public static final int TROUND = 0x1B;
public static final int TSQRT = 0x14;
public static final int TTAN = 0x11;
public static final int TSLN = 0x8E;
public static final int TSYD = 0x8F;
// Date and Time
public static final int TDATE = 0x41;
public static final int TDATEVALUE = 0x8C;
public static final int TDAY = 0x43;
public static final int THOUR = 0x47;
public static final int TMINUTE = 0x48;
public static final int TMONTH = 0x44;
public static final int TNOW = 0x4A;
public static final int TSECOND = 0x49;
public static final int TTIME = 0x42;
public static final int TTIMEVALUE = 0x8D;
public static final int TYEAR = 0x45;
// Statistical
public static final int TCOUNTBLANK = 0x015B ;
// lookup
public static final int TCOLUMNS = 0x4D;
public static final int TROWS = 0x4C;
// Database
public static final int TDAVAERAGE = 0x2A;
public static final int TDCOUNT = 0x28;
public static final int TDCOUNTA = 0xC7;
public static final int TDGET = 0xEB;
public static final int TDMAX = 0x2C;
public static final int TDMIN = 0x2B;
public static final int TDPRODUCT = 0xBD;
public static final int TDSTDEV = 0x2D;
public static final int TDSTDEVP = 0xC3;
public static final int TDSUM = 0x29;
public static final int TDVAR = 0x2F;
public static final int TDVARP = 0xC4;
// Text
public static final int TEXACT = 0x75;
public static final int TLEN = 0x20;
public static final int TLOWER = 0x70;
public static final int TMID = 0x1F; // ??????
public static final int TPROPER = 0x72;
public static final int TREPLACE = 0x77;
public static final int TREPT = 0x1E;
public static final int TT = 0x82;
public static final int TRIM = 0x76;
public static final int TUPPER = 0x71;
public static final int TVALUE = 0x21;
// Logical
public static final int TFALSE = 0x23;
public static final int TNOT = 0x26;
public static final int TTRUE = 0x22;
// Informational
public static final int TERRORTYPE = 0x05;
public static final int TISBLANK = 0x81;
public static final int TISERR = 0x7E;
public static final int TISERROR = 0x03;
public static final int TISLOGICAL = 0xC6;
public static final int TISNA = 0x02;
public static final int TISNONTEXT = 0xBE;
public static final int TISNUMBER = 0x80;
public static final int TISTEXT = 0x7F;
public static final int TN = 0x83;
public static final int TNA = 0x0A;
}
|
