?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Branch libreoffice-5-0-4
[LibreOffice.git] / include / formula / opcode.hxx
blob806147c7a12c27e6ee29734146be727985757aad
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3 * This file is part of the LibreOffice project.
4 *
5 * This Source Code Form is subject to the terms of the Mozilla Public
6 * License, v. 2.0. If a copy of the MPL was not distributed with this
7 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 *
9 * This file incorporates work covered by the following license notice:
10 *
11 * Licensed to the Apache Software Foundation (ASF) under one or more
12 * contributor license agreements. See the NOTICE file distributed
13 * with this work for additional information regarding copyright
14 * ownership. The ASF licenses this file to you under the Apache
15 * License, Version 2.0 (the "License"); you may not use this file
16 * except in compliance with the License. You may obtain a copy of
17 * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 */
19
20 #ifndef INCLUDED_FORMULA_OPCODE_HXX
21 #define INCLUDED_FORMULA_OPCODE_HXX
22
23 #include <formula/compiler.hrc>
24 #include <sal/types.h>
25
26 enum OpCode : sal_uInt16
27 {
28 // Special commands
29 ocPush = SC_OPCODE_PUSH,
30 ocCall = SC_OPCODE_CALL,
31 ocStop = SC_OPCODE_STOP,
32 ocExternal = SC_OPCODE_EXTERNAL,
33 ocName = SC_OPCODE_NAME,
34 ocExternalRef = SC_OPCODE_EXTERNAL_REF,
35 // Jump commands
36 ocIf = SC_OPCODE_IF,
37 ocIfError = SC_OPCODE_IF_ERROR,
38 ocIfNA = SC_OPCODE_IF_NA,
39 ocChoose = SC_OPCODE_CHOOSE,
40 // Parentheses and separators
41 ocOpen = SC_OPCODE_OPEN,
42 ocClose = SC_OPCODE_CLOSE,
43 ocTableRefOpen = SC_OPCODE_TABLE_REF_OPEN,
44 ocTableRefClose = SC_OPCODE_TABLE_REF_CLOSE,
45 ocSep = SC_OPCODE_SEP,
46 ocArrayOpen = SC_OPCODE_ARRAY_OPEN,
47 ocArrayClose = SC_OPCODE_ARRAY_CLOSE,
48 ocArrayRowSep = SC_OPCODE_ARRAY_ROW_SEP,
49 ocArrayColSep = SC_OPCODE_ARRAY_COL_SEP,
50 // Special OpCodes
51 ocMissing = SC_OPCODE_MISSING,
52 ocBad = SC_OPCODE_BAD,
53 ocStringXML = SC_OPCODE_STRINGXML,
54 ocSpaces = SC_OPCODE_SPACES,
55 ocMatRef = SC_OPCODE_MAT_REF,
56 ocTableRefItemAll = SC_OPCODE_TABLE_REF_ITEM_ALL,
57 ocTableRefItemHeaders = SC_OPCODE_TABLE_REF_ITEM_HEADERS,
58 ocTableRefItemData = SC_OPCODE_TABLE_REF_ITEM_DATA,
59 ocTableRefItemTotals = SC_OPCODE_TABLE_REF_ITEM_TOTALS,
60 ocTableRefItemThisRow = SC_OPCODE_TABLE_REF_ITEM_THIS_ROW,
61 ocSkip = SC_OPCODE_SKIP,
62 // Access commands
63 ocDBArea = SC_OPCODE_DB_AREA,
64 ocTableRef = SC_OPCODE_TABLE_REF,
65 ocMacro = SC_OPCODE_MACRO,
66 ocColRowName = SC_OPCODE_COL_ROW_NAME,
67 ocColRowNameAuto = SC_OPCODE_COL_ROW_NAME_AUTO,
68 // Percent operator _follows_ value
69 ocPercentSign = SC_OPCODE_PERCENT_SIGN,
70 // Error constants
71 ocErrNull = SC_OPCODE_ERROR_NULL,
72 ocErrDivZero = SC_OPCODE_ERROR_DIVZERO,
73 ocErrValue = SC_OPCODE_ERROR_VALUE,
74 ocErrRef = SC_OPCODE_ERROR_REF,
75 ocErrName = SC_OPCODE_ERROR_NAME,
76 ocErrNum = SC_OPCODE_ERROR_NUM,
77 ocErrNA = SC_OPCODE_ERROR_NA,
78 // Binary operators
79 ocAdd = SC_OPCODE_ADD,
80 ocSub = SC_OPCODE_SUB,
81 ocMul = SC_OPCODE_MUL,
82 ocDiv = SC_OPCODE_DIV,
83 ocAmpersand = SC_OPCODE_AMPERSAND,
84 ocPow = SC_OPCODE_POW,
85 ocEqual = SC_OPCODE_EQUAL,
86 ocNotEqual = SC_OPCODE_NOT_EQUAL,
87 ocLess = SC_OPCODE_LESS,
88 ocGreater = SC_OPCODE_GREATER,
89 ocLessEqual = SC_OPCODE_LESS_EQUAL,
90 ocGreaterEqual = SC_OPCODE_GREATER_EQUAL,
91 ocAnd = SC_OPCODE_AND,
92 ocOr = SC_OPCODE_OR,
93 ocXor = SC_OPCODE_XOR,
94 ocIntersect = SC_OPCODE_INTERSECT,
95 ocUnion = SC_OPCODE_UNION,
96 ocRange = SC_OPCODE_RANGE,
97 // Unary operators
98 ocNot = SC_OPCODE_NOT,
99 ocNeg = SC_OPCODE_NEG,
100 ocNegSub = SC_OPCODE_NEG_SUB,
101 // Functions with no parameters
102 ocPi = SC_OPCODE_PI,
103 ocRandom = SC_OPCODE_RANDOM,
104 ocTrue = SC_OPCODE_TRUE,
105 ocFalse = SC_OPCODE_FALSE,
106 ocGetActDate = SC_OPCODE_GET_ACT_DATE,
107 ocGetActTime = SC_OPCODE_GET_ACT_TIME,
108 ocNotAvail = SC_OPCODE_NO_VALUE,
109 ocCurrent = SC_OPCODE_CURRENT,
110 // Functions with one parameter
111 ocDeg = SC_OPCODE_DEG,
112 ocRad = SC_OPCODE_RAD,
113 ocSin = SC_OPCODE_SIN,
114 ocCos = SC_OPCODE_COS,
115 ocTan = SC_OPCODE_TAN,
116 ocCot = SC_OPCODE_COT,
117 ocArcSin = SC_OPCODE_ARC_SIN,
118 ocArcCos = SC_OPCODE_ARC_COS,
119 ocArcTan = SC_OPCODE_ARC_TAN,
120 ocArcCot = SC_OPCODE_ARC_COT,
121 ocSinHyp = SC_OPCODE_SIN_HYP,
122 ocCosHyp = SC_OPCODE_COS_HYP,
123 ocTanHyp = SC_OPCODE_TAN_HYP,
124 ocCotHyp = SC_OPCODE_COT_HYP,
125 ocArcSinHyp = SC_OPCODE_ARC_SIN_HYP,
126 ocArcCosHyp = SC_OPCODE_ARC_COS_HYP,
127 ocArcTanHyp = SC_OPCODE_ARC_TAN_HYP,
128 ocArcCotHyp = SC_OPCODE_ARC_COT_HYP,
129 ocCosecant = SC_OPCODE_COSECANT,
130 ocSecant = SC_OPCODE_SECANT,
131 ocCosecantHyp = SC_OPCODE_COSECANT_HYP,
132 ocSecantHyp = SC_OPCODE_SECANT_HYP,
133 ocExp = SC_OPCODE_EXP,
134 ocLn = SC_OPCODE_LN,
135 ocSqrt = SC_OPCODE_SQRT,
136 ocFact = SC_OPCODE_FACT,
137 ocGetYear = SC_OPCODE_GET_YEAR,
138 ocGetMonth = SC_OPCODE_GET_MONTH,
139 ocGetDay = SC_OPCODE_GET_DAY,
140 ocGetHour = SC_OPCODE_GET_HOUR,
141 ocGetMin = SC_OPCODE_GET_MIN,
142 ocGetSec = SC_OPCODE_GET_SEC,
143 ocPlusMinus = SC_OPCODE_PLUS_MINUS,
144 ocAbs = SC_OPCODE_ABS,
145 ocInt = SC_OPCODE_INT,
146 ocPhi = SC_OPCODE_PHI,
147 ocGauss = SC_OPCODE_GAUSS,
148 ocIsEmpty = SC_OPCODE_IS_EMPTY,
149 ocIsString = SC_OPCODE_IS_STRING,
150 ocIsNonString = SC_OPCODE_IS_NON_STRING,
151 ocIsLogical = SC_OPCODE_IS_LOGICAL,
152 ocType = SC_OPCODE_TYPE,
153 ocCell = SC_OPCODE_CELL,
154 ocIsRef = SC_OPCODE_IS_REF,
155 ocIsValue = SC_OPCODE_IS_VALUE,
156 ocIsFormula = SC_OPCODE_IS_FORMULA,
157 ocIsNA = SC_OPCODE_IS_NV,
158 ocIsErr = SC_OPCODE_IS_ERR,
159 ocIsError = SC_OPCODE_IS_ERROR,
160 ocIsEven = SC_OPCODE_IS_EVEN,
161 ocIsOdd = SC_OPCODE_IS_ODD,
162 ocN = SC_OPCODE_N,
163 // String functions
164 ocGetDateValue = SC_OPCODE_GET_DATE_VALUE,
165 ocGetTimeValue = SC_OPCODE_GET_TIME_VALUE,
166 ocCode = SC_OPCODE_CODE,
167 ocTrim = SC_OPCODE_TRIM,
168 ocUpper = SC_OPCODE_UPPER,
169 ocProper = SC_OPCODE_PROPER,
170 ocLower = SC_OPCODE_LOWER,
171 ocLen = SC_OPCODE_LEN,
172 ocT = SC_OPCODE_T,
173 ocValue = SC_OPCODE_VALUE,
174 ocClean = SC_OPCODE_CLEAN,
175 ocChar = SC_OPCODE_CHAR,
176 ocLog10 = SC_OPCODE_LOG10,
177 ocEven = SC_OPCODE_EVEN,
178 ocOdd = SC_OPCODE_ODD,
179 ocStdNormDist = SC_OPCODE_STD_NORM_DIST,
180 ocStdNormDist_MS = SC_OPCODE_STD_NORM_DIST_MS,
181 ocFisher = SC_OPCODE_FISHER,
182 ocFisherInv = SC_OPCODE_FISHER_INV,
183 ocSNormInv = SC_OPCODE_S_NORM_INV,
184 ocSNormInv_MS = SC_OPCODE_S_NORM_INV_MS,
185 ocGammaLn = SC_OPCODE_GAMMA_LN,
186 ocGammaLn_MS = SC_OPCODE_GAMMA_LN_MS,
187 ocGamma = SC_OPCODE_GAMMA,
188 ocErrorType = SC_OPCODE_ERROR_TYPE,
189 ocErrorType_ODF = SC_OPCODE_ERROR_TYPE_ODF,
190 ocFormula = SC_OPCODE_FORMULA,
191 ocArabic = SC_OPCODE_ARABIC,
192 ocInfo = SC_OPCODE_INFO,
193 ocBahtText = SC_OPCODE_BAHTTEXT,
194 ocJis = SC_OPCODE_JIS,
195 ocAsc = SC_OPCODE_ASC,
196 ocUnicode = SC_OPCODE_UNICODE,
197 ocUnichar = SC_OPCODE_UNICHAR,
198 // Functions with more than one parameters
199 ocArcTan2 = SC_OPCODE_ARC_TAN_2,
200 ocCeil = SC_OPCODE_CEIL,
201 ocCeil_MS = SC_OPCODE_CEIL_MS,
202 ocCeil_Precise = SC_OPCODE_CEIL_PRECISE,
203 ocCeil_ISO = SC_OPCODE_CEIL_ISO,
204 ocCeil_Math = SC_OPCODE_CEIL_MATH,
205 ocFloor = SC_OPCODE_FLOOR,
206 ocFloor_MS = SC_OPCODE_FLOOR_MS,
207 ocFloor_Math = SC_OPCODE_FLOOR_MATH,
208 ocFloor_Precise = SC_OPCODE_FLOOR_PRECISE,
209 ocRound = SC_OPCODE_ROUND,
210 ocRoundUp = SC_OPCODE_ROUND_UP,
211 ocRoundDown = SC_OPCODE_ROUND_DOWN,
212 ocTrunc = SC_OPCODE_TRUNC,
213 ocLog = SC_OPCODE_LOG,
214 ocPower = SC_OPCODE_POWER,
215 ocGCD = SC_OPCODE_GCD,
216 ocLCM = SC_OPCODE_LCM,
217 ocMod = SC_OPCODE_MOD,
218 ocSumProduct = SC_OPCODE_SUM_PRODUCT,
219 ocSumSQ = SC_OPCODE_SUM_SQ,
220 ocSumX2MY2 = SC_OPCODE_SUM_X2MY2,
221 ocSumX2DY2 = SC_OPCODE_SUM_X2DY2,
222 ocSumXMY2 = SC_OPCODE_SUM_XMY2,
223 ocGetDate = SC_OPCODE_GET_DATE,
224 ocGetTime = SC_OPCODE_GET_TIME,
225 ocGetDiffDate = SC_OPCODE_GET_DIFF_DATE,
226 ocGetDiffDate360 = SC_OPCODE_GET_DIFF_DATE_360,
227 ocGetDateDif = SC_OPCODE_GET_DATEDIF,
228 ocMin = SC_OPCODE_MIN,
229 ocMax = SC_OPCODE_MAX,
230 ocSum = SC_OPCODE_SUM,
231 ocProduct = SC_OPCODE_PRODUCT,
232 ocAverage = SC_OPCODE_AVERAGE,
233 ocCount = SC_OPCODE_COUNT,
234 ocCount2 = SC_OPCODE_COUNT_2,
235 ocNPV = SC_OPCODE_NPV,
236 ocIRR = SC_OPCODE_IRR,
237 ocMIRR = SC_OPCODE_MIRR,
238 ocISPMT = SC_OPCODE_ISPMT,
239 ocVar = SC_OPCODE_VAR,
240 ocVarP = SC_OPCODE_VAR_P,
241 ocVarP_MS = SC_OPCODE_VAR_P_MS,
242 ocVarS = SC_OPCODE_VAR_S,
243 ocStDev = SC_OPCODE_ST_DEV,
244 ocStDevP = SC_OPCODE_ST_DEV_P,
245 ocStDevP_MS = SC_OPCODE_ST_DEV_P_MS,
246 ocStDevS = SC_OPCODE_ST_DEV_S,
247 ocB = SC_OPCODE_B,
248 ocNormDist = SC_OPCODE_NORM_DIST,
249 ocNormDist_MS = SC_OPCODE_NORM_DIST_MS,
250 ocExpDist = SC_OPCODE_EXP_DIST,
251 ocExpDist_MS = SC_OPCODE_EXP_DIST_MS,
252 ocBinomDist = SC_OPCODE_BINOM_DIST,
253 ocBinomDist_MS = SC_OPCODE_BINOM_DIST_MS,
254 ocBinomInv = SC_OPCODE_BINOM_INV,
255 ocPoissonDist = SC_OPCODE_POISSON_DIST,
256 ocPoissonDist_MS = SC_OPCODE_POISSON_DIST_MS,
257 ocCombin = SC_OPCODE_COMBIN,
258 ocCombinA = SC_OPCODE_COMBIN_A,
259 ocPermut = SC_OPCODE_PERMUT,
260 ocPermutationA = SC_OPCODE_PERMUTATION_A,
261 ocPV = SC_OPCODE_PV,
262 ocSYD = SC_OPCODE_SYD,
263 ocDDB = SC_OPCODE_DDB,
264 ocDB = SC_OPCODE_DB,
265 ocVBD = SC_OPCODE_VBD,
266 ocDuration = SC_OPCODE_DURATION,
267 ocSLN = SC_OPCODE_SLN,
268 ocPMT = SC_OPCODE_PMT,
269 ocColumns = SC_OPCODE_COLUMNS,
270 ocRows = SC_OPCODE_ROWS,
271 ocColumn = SC_OPCODE_COLUMN,
272 ocRow = SC_OPCODE_ROW,
273 ocRRI = SC_OPCODE_RRI,
274 ocFV = SC_OPCODE_FV,
275 ocNper = SC_OPCODE_NPER,
276 ocRate = SC_OPCODE_RATE,
277 ocIpmt = SC_OPCODE_IPMT,
278 ocPpmt = SC_OPCODE_PPMT,
279 ocCumIpmt = SC_OPCODE_CUM_IPMT,
280 ocCumPrinc = SC_OPCODE_CUM_PRINC,
281 ocEffective = SC_OPCODE_EFFECTIVE,
282 ocNominal = SC_OPCODE_NOMINAL,
283 ocSubTotal = SC_OPCODE_SUB_TOTAL,
284 // Database functions
285 ocDBSum = SC_OPCODE_DB_SUM,
286 ocDBCount = SC_OPCODE_DB_COUNT,
287 ocDBCount2 = SC_OPCODE_DB_COUNT_2,
288 ocDBAverage = SC_OPCODE_DB_AVERAGE,
289 ocDBGet = SC_OPCODE_DB_GET,
290 ocDBMax = SC_OPCODE_DB_MAX,
291 ocDBMin = SC_OPCODE_DB_MIN,
292 ocDBProduct = SC_OPCODE_DB_PRODUCT,
293 ocDBStdDev = SC_OPCODE_DB_STD_DEV,
294 ocDBStdDevP = SC_OPCODE_DB_STD_DEV_P,
295 ocDBVar = SC_OPCODE_DB_VAR,
296 ocDBVarP = SC_OPCODE_DB_VAR_P,
297 // Management functions
298 ocIndirect = SC_OPCODE_INDIRECT,
299 ocIndirectXL = SC_OPCODE_INDIRECT_XL,
300 ocAddress = SC_OPCODE_ADDRESS,
301 ocAddressXL = SC_OPCODE_ADDRESS_XL,
302 ocMatch = SC_OPCODE_MATCH,
303 ocCountEmptyCells = SC_OPCODE_COUNT_EMPTY_CELLS,
304 ocCountIf = SC_OPCODE_COUNT_IF,
305 ocSumIf = SC_OPCODE_SUM_IF,
306 ocAverageIf = SC_OPCODE_AVERAGE_IF,
307 ocSumIfs = SC_OPCODE_SUM_IFS,
308 ocAverageIfs = SC_OPCODE_AVERAGE_IFS,
309 ocCountIfs = SC_OPCODE_COUNT_IFS,
310 ocLookup = SC_OPCODE_LOOKUP,
311 ocVLookup = SC_OPCODE_V_LOOKUP,
312 ocHLookup = SC_OPCODE_H_LOOKUP,
313 ocMultiArea = SC_OPCODE_MULTI_AREA,
314 ocOffset = SC_OPCODE_OFFSET,
315 ocIndex = SC_OPCODE_INDEX,
316 ocAreas = SC_OPCODE_AREAS,
317 // String functions
318 ocCurrency = SC_OPCODE_CURRENCY,
319 ocReplace = SC_OPCODE_REPLACE,
320 ocFixed = SC_OPCODE_FIXED,
321 ocFind = SC_OPCODE_FIND,
322 ocExact = SC_OPCODE_EXACT,
323 ocLeft = SC_OPCODE_LEFT,
324 ocRight = SC_OPCODE_RIGHT,
325 ocSearch = SC_OPCODE_SEARCH,
326 ocMid = SC_OPCODE_MID,
327 ocText = SC_OPCODE_TEXT,
328 ocSubstitute = SC_OPCODE_SUBSTITUTE,
329 ocRept = SC_OPCODE_REPT,
330 ocConcat = SC_OPCODE_CONCAT,
331 ocLenB = SC_OPCODE_LENB,
332 ocRightB = SC_OPCODE_RIGHTB,
333 ocLeftB = SC_OPCODE_LEFTB,
334 ocMidB = SC_OPCODE_MIDB,
335 ocNumberValue = SC_OPCODE_NUMBERVALUE,
336 // Matrix functions
337 ocMatValue = SC_OPCODE_MAT_VALUE,
338 ocMatDet = SC_OPCODE_MAT_DET,
339 ocMatInv = SC_OPCODE_MAT_INV,
340 ocMatMult = SC_OPCODE_MAT_MULT,
341 ocMatTrans = SC_OPCODE_MAT_TRANS,
342 ocMatrixUnit = SC_OPCODE_MATRIX_UNIT,
343 // BackSolver
344 ocBackSolver = SC_OPCODE_BACK_SOLVER,
345 // Statistical functions
346 ocHypGeomDist = SC_OPCODE_HYP_GEOM_DIST,
347 ocHypGeomDist_MS = SC_OPCODE_HYP_GEOM_DIST_MS,
348 ocLogNormDist = SC_OPCODE_LOG_NORM_DIST,
349 ocLogNormDist_MS = SC_OPCODE_LOG_NORM_DIST_MS,
350 ocTDist = SC_OPCODE_T_DIST,
351 ocTDist_MS = SC_OPCODE_T_DIST_MS,
352 ocTDist_RT = SC_OPCODE_T_DIST_RT,
353 ocTDist_2T = SC_OPCODE_T_DIST_2T,
354 ocFDist = SC_OPCODE_F_DIST,
355 ocFDist_LT = SC_OPCODE_F_DIST_LT,
356 ocFDist_RT = SC_OPCODE_F_DIST_RT,
357 ocChiDist = SC_OPCODE_CHI_DIST,
358 ocChiDist_MS = SC_OPCODE_CHI_DIST_MS,
359 ocChiSqDist = SC_OPCODE_CHISQ_DIST,
360 ocChiSqDist_MS = SC_OPCODE_CHISQ_DIST_MS,
361 ocChiSqInv = SC_OPCODE_CHISQ_INV,
362 ocChiSqInv_MS = SC_OPCODE_CHISQ_INV_MS,
363 ocWeibull = SC_OPCODE_WEIBULL,
364 ocWeibull_MS = SC_OPCODE_WEIBULL_MS,
365 ocNegBinomVert = SC_OPCODE_NEG_BINOM_VERT,
366 ocNegBinomDist_MS = SC_OPCODE_NEG_BINOM_DIST_MS,
367 ocCritBinom = SC_OPCODE_CRIT_BINOM,
368 ocKurt = SC_OPCODE_KURT,
369 ocHarMean = SC_OPCODE_HAR_MEAN,
370 ocGeoMean = SC_OPCODE_GEO_MEAN,
371 ocStandard = SC_OPCODE_STANDARD,
372 ocAveDev = SC_OPCODE_AVE_DEV,
373 ocSkew = SC_OPCODE_SKEW,
374 ocSkewp = SC_OPCODE_SKEWP,
375 ocDevSq = SC_OPCODE_DEV_SQ,
376 ocMedian = SC_OPCODE_MEDIAN,
377 ocModalValue = SC_OPCODE_MODAL_VALUE,
378 ocModalValue_MS = SC_OPCODE_MODAL_VALUE_MS,
379 ocModalValue_Multi = SC_OPCODE_MODAL_VALUE_MULTI,
380 ocZTest = SC_OPCODE_Z_TEST,
381 ocZTest_MS = SC_OPCODE_Z_TEST_MS,
382 ocAggregate = SC_OPCODE_AGGREGATE,
383 ocTTest = SC_OPCODE_T_TEST,
384 ocTTest_MS = SC_OPCODE_T_TEST_MS,
385 ocRank = SC_OPCODE_RANK,
386 ocPercentile = SC_OPCODE_PERCENTILE,
387 ocPercentrank = SC_OPCODE_PERCENT_RANK,
388 ocPercentile_Inc = SC_OPCODE_PERCENTILE_INC,
389 ocPercentrank_Inc = SC_OPCODE_PERCENT_RANK_INC,
390 ocQuartile_Inc = SC_OPCODE_QUARTILE_INC,
391 ocRank_Eq = SC_OPCODE_RANK_EQ,
392 ocPercentile_Exc = SC_OPCODE_PERCENTILE_EXC,
393 ocPercentrank_Exc = SC_OPCODE_PERCENT_RANK_EXC,
394 ocQuartile_Exc = SC_OPCODE_QUARTILE_EXC,
395 ocRank_Avg = SC_OPCODE_RANK_AVG,
396 ocLarge = SC_OPCODE_LARGE,
397 ocSmall = SC_OPCODE_SMALL,
398 ocFrequency = SC_OPCODE_FREQUENCY,
399 ocQuartile = SC_OPCODE_QUARTILE,
400 ocNormInv = SC_OPCODE_NORM_INV,
401 ocNormInv_MS = SC_OPCODE_NORM_INV_MS,
402 ocConfidence = SC_OPCODE_CONFIDENCE,
403 ocConfidence_N = SC_OPCODE_CONFIDENCE_N,
404 ocConfidence_T = SC_OPCODE_CONFIDENCE_T,
405 ocFTest = SC_OPCODE_F_TEST,
406 ocFTest_MS = SC_OPCODE_F_TEST_MS,
407 ocTrimMean = SC_OPCODE_TRIM_MEAN,
408 ocProb = SC_OPCODE_PROB,
409 ocCorrel = SC_OPCODE_CORREL,
410 ocCovar = SC_OPCODE_COVAR,
411 ocCovarianceP = SC_OPCODE_COVARIANCE_P,
412 ocCovarianceS = SC_OPCODE_COVARIANCE_S,
413 ocPearson = SC_OPCODE_PEARSON,
414 ocRSQ = SC_OPCODE_RSQ,
415 ocSTEYX = SC_OPCODE_STEYX,
416 ocSlope = SC_OPCODE_SLOPE,
417 ocIntercept = SC_OPCODE_INTERCEPT,
418 ocTrend = SC_OPCODE_TREND,
419 ocGrowth = SC_OPCODE_GROWTH,
420 ocLinest = SC_OPCODE_LINEST,
421 ocLogest = SC_OPCODE_LOGEST,
422 ocForecast = SC_OPCODE_FORECAST,
423 ocChiInv = SC_OPCODE_CHI_INV,
424 ocChiInv_MS = SC_OPCODE_CHI_INV_MS,
425 ocGammaDist = SC_OPCODE_GAMMA_DIST,
426 ocGammaDist_MS = SC_OPCODE_GAMMA_DIST_MS,
427 ocGammaInv = SC_OPCODE_GAMMA_INV,
428 ocGammaInv_MS = SC_OPCODE_GAMMA_INV_MS,
429 ocTInv = SC_OPCODE_T_INV,
430 ocTInv_2T = SC_OPCODE_T_INV_2T,
431 ocTInv_MS = SC_OPCODE_T_INV_MS,
432 ocFInv = SC_OPCODE_F_INV,
433 ocFInv_LT = SC_OPCODE_F_INV_LT,
434 ocFInv_RT = SC_OPCODE_F_INV_RT,
435 ocChiTest = SC_OPCODE_CHI_TEST,
436 ocChiTest_MS = SC_OPCODE_CHI_TEST_MS,
437 ocLogInv = SC_OPCODE_LOG_INV,
438 ocLogInv_MS = SC_OPCODE_LOG_INV_MS,
439 ocTableOp = SC_OPCODE_TABLE_OP,
440 ocBetaDist = SC_OPCODE_BETA_DIST,
441 ocBetaInv = SC_OPCODE_BETA_INV,
442 ocBetaDist_MS = SC_OPCODE_BETA_DIST_MS,
443 ocBetaInv_MS = SC_OPCODE_BETA_INV_MS,
444 // Bit functions
445 ocBitAnd = SC_OPCODE_BITAND,
446 ocBitOr = SC_OPCODE_BITOR,
447 ocBitXor = SC_OPCODE_BITXOR,
448 ocBitRshift = SC_OPCODE_BITRSHIFT,
449 ocBitLshift = SC_OPCODE_BITLSHIFT,
450 // miscellaneous
451 ocWeek = SC_OPCODE_WEEK,
452 ocGetDayOfWeek = SC_OPCODE_GET_DAY_OF_WEEK,
453 ocNetWorkdays = SC_OPCODE_NETWORKDAYS,
454 ocNetWorkdays_MS = SC_OPCODE_NETWORKDAYS_MS,
455 ocWorkday_MS = SC_OPCODE_WORKDAY_MS,
456 ocNoName = SC_OPCODE_NO_NAME,
457 ocStyle = SC_OPCODE_STYLE,
458 ocDde = SC_OPCODE_DDE,
459 ocBase = SC_OPCODE_BASE,
460 ocSheet = SC_OPCODE_SHEET,
461 ocSheets = SC_OPCODE_SHEETS,
462 ocMinA = SC_OPCODE_MIN_A,
463 ocMaxA = SC_OPCODE_MAX_A,
464 ocAverageA = SC_OPCODE_AVERAGE_A,
465 ocStDevA = SC_OPCODE_ST_DEV_A,
466 ocStDevPA = SC_OPCODE_ST_DEV_P_A,
467 ocVarA = SC_OPCODE_VAR_A,
468 ocVarPA = SC_OPCODE_VAR_P_A,
469 ocEasterSunday = SC_OPCODE_EASTERSUNDAY,
470 ocDecimal = SC_OPCODE_DECIMAL,
471 ocConvert = SC_OPCODE_CONVERT,
472 ocRoman = SC_OPCODE_ROMAN,
473 ocHyperLink = SC_OPCODE_HYPERLINK,
474 ocGetPivotData = SC_OPCODE_GET_PIVOT_DATA,
475 ocEuroConvert = SC_OPCODE_EUROCONVERT,
476 ocFilterXML = SC_OPCODE_FILTERXML,
477 ocWebservice = SC_OPCODE_WEBSERVICE,
478 ocColor = SC_OPCODE_COLOR,
479 ocErf_MS = SC_OPCODE_ERF_MS,
480 ocErfc_MS = SC_OPCODE_ERFC_MS,
481 ocEncodeURL = SC_OPCODE_ENCODEURL,
482 // internal stuff
483 ocInternalBegin = SC_OPCODE_INTERNAL_BEGIN,
484 ocTTT = SC_OPCODE_TTT,
485 ocDebugVar = SC_OPCODE_DEBUG_VAR,
486 ocInternalEnd = SC_OPCODE_INTERNAL_END,
487 // from here on ExtraData
488 ocDataToken1 = SC_OPCODE_DATA_TOKEN_1,
489 // no OpCode
490 ocNone = SC_OPCODE_NONE
491 };
492
493 #endif
494
495 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE