LibreOffice Module sc (master)  1
xlformula.cxx
Go to the documentation of this file.
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 #include <xlformula.hxx>
21 
22 #include <refdata.hxx>
23 #include <tokenarray.hxx>
24 #include <xestream.hxx>
25 #include <xistream.hxx>
26 #include <xlroot.hxx>
27 
28 #include <comphelper/string.hxx>
29 #include <svl/sharedstringpool.hxx>
30 
31 using namespace ::formula;
32 
33 // Function data ==============================================================
34 
35 OUString XclFunctionInfo::GetMacroFuncName() const
36 {
37  if( IsMacroFunc() )
38  return OUString( mpcMacroName, strlen(mpcMacroName), RTL_TEXTENCODING_UTF8 );
39  return OUString();
40 }
41 
42 OUString XclFunctionInfo::GetAddInEquivalentFuncName() const
43 {
44  if( IsAddInEquivalent() )
45  return OUString( mpcMacroName, strlen(mpcMacroName), RTL_TEXTENCODING_UTF8 );
46  return OUString();
47 }
48 
49 // abbreviations for function return token class
50 const sal_uInt8 R = EXC_TOKCLASS_REF;
51 const sal_uInt8 V = EXC_TOKCLASS_VAL;
52 const sal_uInt8 A = EXC_TOKCLASS_ARR;
53 
54 // abbreviations for parameter infos
55 #define RO { EXC_PARAM_REGULAR, EXC_PARAMCONV_ORG, false }
56 #define RA { EXC_PARAM_REGULAR, EXC_PARAMCONV_ARR, false }
57 #define RR { EXC_PARAM_REGULAR, EXC_PARAMCONV_RPT, false }
58 #define RX { EXC_PARAM_REGULAR, EXC_PARAMCONV_RPX, false }
59 #define VO { EXC_PARAM_REGULAR, EXC_PARAMCONV_ORG, true }
60 #define VV { EXC_PARAM_REGULAR, EXC_PARAMCONV_VAL, true }
61 #define VA { EXC_PARAM_REGULAR, EXC_PARAMCONV_ARR, true }
62 #define VR { EXC_PARAM_REGULAR, EXC_PARAMCONV_RPT, true }
63 #define VX { EXC_PARAM_REGULAR, EXC_PARAMCONV_RPX, true }
64 #define RO_E { EXC_PARAM_EXCELONLY, EXC_PARAMCONV_ORG, false }
65 #define VR_E { EXC_PARAM_EXCELONLY, EXC_PARAMCONV_RPT, true }
66 #define C { EXC_PARAM_CALCONLY, EXC_PARAMCONV_ORG, false }
67 
68 const sal_uInt16 NOID = SAL_MAX_UINT16;
69 const sal_uInt8 MX = 30;
70 
71 #define EXC_FUNCNAME( ascii ) "_xlfn." ascii
72 #define EXC_FUNCNAME_ODF( ascii ) "_xlfnodf." ascii
73 #define EXC_FUNCNAME_ADDIN( ascii ) "com.sun.star.sheet.addin." ascii
74 
76 const XclFunctionInfo saFuncTable_2[] =
77 {
78  { ocCount, 0, 0, MX, V, { RX }, 0, nullptr },
79  { ocIf, 1, 2, 3, R, { VO, RO }, 0, nullptr },
80  { ocIsNA, 2, 1, 1, V, { VR }, 0, nullptr },
81  { ocIsError, 3, 1, 1, V, { VR }, 0, nullptr },
82  { ocSum, 4, 0, MX, V, { RX }, 0, nullptr },
83  { ocAverage, 5, 1, MX, V, { RX }, 0, nullptr },
84  { ocMin, 6, 1, MX, V, { RX }, 0, nullptr },
85  { ocMax, 7, 1, MX, V, { RX }, 0, nullptr },
86  { ocRow, 8, 0, 1, V, { RO }, 0, nullptr },
87  { ocColumn, 9, 0, 1, V, { RO }, 0, nullptr },
88  { ocNotAvail, 10, 0, 0, V, {}, 0, nullptr },
89  { ocNPV, 11, 2, MX, V, { VR, RX }, 0, nullptr },
90  { ocStDev, 12, 1, MX, V, { RX }, 0, nullptr },
91  { ocCurrency, 13, 1, 2, V, { VR }, 0, nullptr },
92  { ocFixed, 14, 1, 2, V, { VR, VR, C }, 0, nullptr },
93  { ocSin, 15, 1, 1, V, { VR }, 0, nullptr },
94  { ocCosecant, 15, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
95  { ocCos, 16, 1, 1, V, { VR }, 0, nullptr },
96  { ocSecant, 16, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
97  { ocTan, 17, 1, 1, V, { VR }, 0, nullptr },
98  { ocCot, 17, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
99  { ocArcTan, 18, 1, 1, V, { VR }, 0, nullptr },
100  { ocArcCot, 18, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
101  { ocPi, 19, 0, 0, V, {}, 0, nullptr },
102  { ocSqrt, 20, 1, 1, V, { VR }, 0, nullptr },
103  { ocExp, 21, 1, 1, V, { VR }, 0, nullptr },
104  { ocLn, 22, 1, 1, V, { VR }, 0, nullptr },
105  { ocLog10, 23, 1, 1, V, { VR }, 0, nullptr },
106  { ocAbs, 24, 1, 1, V, { VR }, 0, nullptr },
107  { ocInt, 25, 1, 1, V, { VR }, 0, nullptr },
108  { ocPlusMinus, 26, 1, 1, V, { VR }, 0, nullptr },
109  { ocRound, 27, 2, 2, V, { VR }, 0, nullptr },
110  { ocLookup, 28, 2, 3, V, { VR, RA }, 0, nullptr },
111  { ocIndex, 29, 2, 4, R, { RA, VV }, 0, nullptr },
112  { ocRept, 30, 2, 2, V, { VR }, 0, nullptr },
113  { ocMid, 31, 3, 3, V, { VR }, 0, nullptr },
114  { ocLen, 32, 1, 1, V, { VR }, 0, nullptr },
115  { ocValue, 33, 1, 1, V, { VR }, 0, nullptr },
116  { ocTrue, 34, 0, 0, V, {}, 0, nullptr },
117  { ocFalse, 35, 0, 0, V, {}, 0, nullptr },
118  { ocAnd, 36, 1, MX, V, { RX }, 0, nullptr },
119  { ocOr, 37, 1, MX, V, { RX }, 0, nullptr },
120  { ocNot, 38, 1, 1, V, { VR }, 0, nullptr },
121  { ocMod, 39, 2, 2, V, { VR }, 0, nullptr },
122  { ocDBCount, 40, 3, 3, V, { RO, RR }, 0, nullptr },
123  { ocDBSum, 41, 3, 3, V, { RO, RR }, 0, nullptr },
124  { ocDBAverage, 42, 3, 3, V, { RO, RR }, 0, nullptr },
125  { ocDBMin, 43, 3, 3, V, { RO, RR }, 0, nullptr },
126  { ocDBMax, 44, 3, 3, V, { RO, RR }, 0, nullptr },
127  { ocDBStdDev, 45, 3, 3, V, { RO, RR }, 0, nullptr },
128  { ocVar, 46, 1, MX, V, { RX }, 0, nullptr },
129  { ocDBVar, 47, 3, 3, V, { RO, RR }, 0, nullptr },
130  { ocText, 48, 2, 2, V, { VR }, 0, nullptr },
131  { ocLinest, 49, 1, 2, A, { RA, RA, C, C }, 0, nullptr },
132  { ocTrend, 50, 1, 3, A, { RA, RA, RA, C }, 0, nullptr },
133  { ocLogest, 51, 1, 2, A, { RA, RA, C, C }, 0, nullptr },
134  { ocGrowth, 52, 1, 3, A, { RA, RA, RA, C }, 0, nullptr },
135  { ocPV, 56, 3, 5, V, { VR }, 0, nullptr },
136  { ocFV, 57, 3, 5, V, { VR }, 0, nullptr },
137  { ocNper, 58, 3, 5, V, { VR }, 0, nullptr },
138  { ocPMT, 59, 3, 5, V, { VR }, 0, nullptr },
139  { ocRate, 60, 3, 6, V, { VR }, 0, nullptr },
140  { ocMIRR, 61, 3, 3, V, { RA, VR }, 0, nullptr },
141  { ocIRR, 62, 1, 2, V, { RA, VR }, 0, nullptr },
142  { ocRandom, 63, 0, 0, V, {}, EXC_FUNCFLAG_VOLATILE, nullptr },
143  { ocMatch, 64, 2, 3, V, { VR, RX, RR }, 0, nullptr },
144  { ocGetDate, 65, 3, 3, V, { VR }, 0, nullptr },
145  { ocGetTime, 66, 3, 3, V, { VR }, 0, nullptr },
146  { ocGetDay, 67, 1, 1, V, { VR }, 0, nullptr },
147  { ocGetMonth, 68, 1, 1, V, { VR }, 0, nullptr },
148  { ocGetYear, 69, 1, 1, V, { VR }, 0, nullptr },
149  { ocGetDayOfWeek, 70, 1, 1, V, { VR, C }, 0, nullptr },
150  { ocGetHour, 71, 1, 1, V, { VR }, 0, nullptr },
151  { ocGetMin, 72, 1, 1, V, { VR }, 0, nullptr },
152  { ocGetSec, 73, 1, 1, V, { VR }, 0, nullptr },
153  { ocGetActTime, 74, 0, 0, V, {}, EXC_FUNCFLAG_VOLATILE, nullptr },
154  { ocAreas, 75, 1, 1, V, { RO }, 0, nullptr },
155  { ocRows, 76, 1, 1, V, { RO }, 0, nullptr },
156  { ocColumns, 77, 1, 1, V, { RO }, 0, nullptr },
157  { ocOffset, 78, 3, 5, R, { RO, VR }, EXC_FUNCFLAG_VOLATILE, nullptr },
158  { ocSearch, 82, 2, 3, V, { VR }, 0, nullptr },
159  { ocMatTrans, 83, 1, 1, A, { VO }, 0, nullptr },
160  { ocType, 86, 1, 1, V, { VX }, 0, nullptr },
161  { ocArcTan2, 97, 2, 2, V, { VR }, 0, nullptr },
162  { ocArcSin, 98, 1, 1, V, { VR }, 0, nullptr },
163  { ocArcCos, 99, 1, 1, V, { VR }, 0, nullptr },
164  { ocChoose, 100, 2, MX, R, { VO, RO }, 0, nullptr },
165  { ocHLookup, 101, 3, 3, V, { VV, RO, RO, C }, 0, nullptr },
166  { ocVLookup, 102, 3, 3, V, { VV, RO, RO, C }, 0, nullptr },
167  { ocIsRef, 105, 1, 1, V, { RX }, 0, nullptr },
168  { ocLog, 109, 1, 2, V, { VR }, 0, nullptr },
169  { ocChar, 111, 1, 1, V, { VR }, 0, nullptr },
170  { ocLower, 112, 1, 1, V, { VR }, 0, nullptr },
171  { ocUpper, 113, 1, 1, V, { VR }, 0, nullptr },
172  { ocProper, 114, 1, 1, V, { VR }, 0, nullptr },
173  { ocLeft, 115, 1, 2, V, { VR }, 0, nullptr },
174  { ocRight, 116, 1, 2, V, { VR }, 0, nullptr },
175  { ocExact, 117, 2, 2, V, { VR }, 0, nullptr },
176  { ocTrim, 118, 1, 1, V, { VR }, 0, nullptr },
177  { ocReplace, 119, 4, 4, V, { VR }, 0, nullptr },
178  { ocSubstitute, 120, 3, 4, V, { VR }, 0, nullptr },
179  { ocCode, 121, 1, 1, V, { VR }, 0, nullptr },
180  { ocFind, 124, 2, 3, V, { VR }, 0, nullptr },
181  { ocCell, 125, 1, 2, V, { VV, RO }, EXC_FUNCFLAG_VOLATILE, nullptr },
182  { ocIsErr, 126, 1, 1, V, { VR }, 0, nullptr },
183  { ocIsString, 127, 1, 1, V, { VR }, 0, nullptr },
184  { ocIsValue, 128, 1, 1, V, { VR }, 0, nullptr },
185  { ocIsEmpty, 129, 1, 1, V, { VR }, 0, nullptr },
186  { ocT, 130, 1, 1, V, { RO }, 0, nullptr },
187  { ocN, 131, 1, 1, V, { RO }, 0, nullptr },
188  { ocGetDateValue, 140, 1, 1, V, { VR }, 0, nullptr },
189  { ocGetTimeValue, 141, 1, 1, V, { VR }, 0, nullptr },
190  { ocSLN, 142, 3, 3, V, { VR }, 0, nullptr },
191  { ocSYD, 143, 4, 4, V, { VR }, 0, nullptr },
192  { ocDDB, 144, 4, 5, V, { VR }, 0, nullptr },
193  { ocIndirect, 148, 1, 2, R, { VR }, EXC_FUNCFLAG_VOLATILE, nullptr },
194  { ocClean, 162, 1, 1, V, { VR }, 0, nullptr },
195  { ocMatDet, 163, 1, 1, V, { VA }, 0, nullptr },
196  { ocMatInv, 164, 1, 1, A, { VA }, 0, nullptr },
197  { ocMatMult, 165, 2, 2, A, { VA }, 0, nullptr },
198  { ocIpmt, 167, 4, 6, V, { VR }, 0, nullptr },
199  { ocPpmt, 168, 4, 6, V, { VR }, 0, nullptr },
200  { ocCount2, 169, 0, MX, V, { RX }, 0, nullptr },
201  { ocProduct, 183, 0, MX, V, { RX }, 0, nullptr },
202  { ocFact, 184, 1, 1, V, { VR }, 0, nullptr },
203  { ocDBProduct, 189, 3, 3, V, { RO, RR }, 0, nullptr },
204  { ocIsNonString, 190, 1, 1, V, { VR }, 0, nullptr },
205  { ocStDevP, 193, 1, MX, V, { RX }, 0, nullptr },
206  { ocVarP, 194, 1, MX, V, { RX }, 0, nullptr },
207  { ocDBStdDevP, 195, 3, 3, V, { RO, RR }, 0, nullptr },
208  { ocDBVarP, 196, 3, 3, V, { RO, RR }, 0, nullptr },
209  { ocTrunc, 197, 1, 1, V, { VR, C }, 0, nullptr },
210  { ocIsLogical, 198, 1, 1, V, { VR }, 0, nullptr },
211  { ocDBCount2, 199, 3, 3, V, { RO, RR }, 0, nullptr },
212  { ocCurrency, 204, 1, 2, V, { VR }, EXC_FUNCFLAG_IMPORTONLY, nullptr },
213  { ocFindB, 205, 2, 3, V, { VR }, 0, nullptr },
214  { ocSearchB, 206, 2, 3, V, { VR }, 0, nullptr },
215  { ocReplaceB, 207, 4, 4, V, { VR }, 0, nullptr },
216  { ocLeftB, 208, 1, 2, V, { VR }, 0, nullptr },
217  { ocRightB, 209, 1, 2, V, { VR }, 0, nullptr },
218  { ocMidB, 210, 3, 3, V, { VR }, 0, nullptr },
219  { ocLenB, 211, 1, 1, V, { VR }, 0, nullptr },
220  { ocRoundUp, 212, 2, 2, V, { VR }, 0, nullptr },
221  { ocRoundDown, 213, 2, 2, V, { VR }, 0, nullptr },
222  { ocExternal, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_IMPORTONLY, nullptr }
223 };
224 
226 const XclFunctionInfo saFuncTable_3[] =
227 {
228  { ocLinest, 49, 1, 4, A, { RA, RA, VV }, 0, nullptr }, // BIFF2: 1-2, BIFF3: 1-4
229  { ocTrend, 50, 1, 4, A, { RA, RA, RA, VV }, 0, nullptr }, // BIFF2: 1-3, BIFF3: 1-4
230  { ocLogest, 51, 1, 4, A, { RA, RA, VV }, 0, nullptr }, // BIFF2: 1-2, BIFF3: 1-4
231  { ocGrowth, 52, 1, 4, A, { RA, RA, RA, VV }, 0, nullptr }, // BIFF2: 1-3, BIFF3: 1-4
232  { ocTrunc, 197, 1, 2, V, { VR }, 0, nullptr }, // BIFF2: 1, BIFF3: 1-2
233  { ocAddress, 219, 2, 5, V, { VR }, 0, nullptr },
234  { ocGetDiffDate360, 220, 2, 2, V, { VR, VR, C }, 0, nullptr },
235  { ocGetActDate, 221, 0, 0, V, {}, EXC_FUNCFLAG_VOLATILE, nullptr },
236  { ocVBD, 222, 5, 7, V, { VR }, 0, nullptr },
237  { ocMedian, 227, 1, MX, V, { RX }, 0, nullptr },
238  { ocSumProduct, 228, 1, MX, V, { VA }, 0, nullptr },
239  { ocSinHyp, 229, 1, 1, V, { VR }, 0, nullptr },
240  { ocCosecantHyp, 229, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
241  { ocCosHyp, 230, 1, 1, V, { VR }, 0, nullptr },
242  { ocSecantHyp, 230, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
243  { ocTanHyp, 231, 1, 1, V, { VR }, 0, nullptr },
244  { ocCotHyp, 231, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
245  { ocArcSinHyp, 232, 1, 1, V, { VR }, 0, nullptr },
246  { ocArcCosHyp, 233, 1, 1, V, { VR }, 0, nullptr },
247  { ocArcTanHyp, 234, 1, 1, V, { VR }, 0, nullptr },
248  { ocArcCotHyp, 234, 1, 1, V, { VR }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
249  { ocDBGet, 235, 3, 3, V, { RO, RR }, 0, nullptr },
250  { ocInfo, 244, 1, 1, V, { VR }, EXC_FUNCFLAG_VOLATILE, nullptr }
251 };
252 
254 const XclFunctionInfo saFuncTable_4[] =
255 {
256  { ocFixed, 14, 1, 3, V, { VR }, 0, nullptr }, // BIFF2-3: 1-2, BIFF4: 1-3
257  { ocAsc, 214, 1, 1, V, { VR }, 0, nullptr },
258  { ocJis, 215, 1, 1, V, { VR }, 0, nullptr },
259  { ocRank, 216, 2, 3, V, { VR, RO, VR }, 0, nullptr },
260  { ocDB, 247, 4, 5, V, { VR }, 0, nullptr },
261  { ocFrequency, 252, 2, 2, A, { RA }, 0, nullptr },
262  { ocErrorType_ODF, 261, 1, 1, V, { VR }, 0, nullptr },
263  { ocAveDev, 269, 1, MX, V, { RX }, 0, nullptr },
264  { ocBetaDist, 270, 3, 5, V, { VR }, 0, nullptr },
265  { ocGammaLn, 271, 1, 1, V, { VR }, 0, nullptr },
266  { ocBetaInv, 272, 3, 5, V, { VR }, 0, nullptr },
267  { ocBinomDist, 273, 4, 4, V, { VR }, 0, nullptr },
268  { ocChiDist, 274, 2, 2, V, { VR }, 0, nullptr },
269  { ocChiInv, 275, 2, 2, V, { VR }, 0, nullptr },
270  { ocCombin, 276, 2, 2, V, { VR }, 0, nullptr },
271  { ocConfidence, 277, 3, 3, V, { VR }, 0, nullptr },
272  { ocCritBinom, 278, 3, 3, V, { VR }, 0, nullptr },
273  { ocEven, 279, 1, 1, V, { VR }, 0, nullptr },
274  { ocExpDist, 280, 3, 3, V, { VR }, 0, nullptr },
275  { ocFDist, 281, 3, 3, V, { VR }, 0, nullptr },
276  { ocFInv, 282, 3, 3, V, { VR }, 0, nullptr },
277  { ocFisher, 283, 1, 1, V, { VR }, 0, nullptr },
278  { ocFisherInv, 284, 1, 1, V, { VR }, 0, nullptr },
279  { ocFloor_MS, 285, 2, 2, V, { VR }, 0, nullptr },
280  { ocGammaDist, 286, 4, 4, V, { VR }, 0, nullptr },
281  { ocGammaInv, 287, 3, 3, V, { VR }, 0, nullptr },
282  { ocCeil_MS, 288, 2, 2, V, { VR }, 0, nullptr },
283  { ocHypGeomDist, 289, 4, 4, V, { VR }, 0, nullptr },
284  { ocLogNormDist, 290, 3, 3, V, { VR }, 0, nullptr },
285  { ocLogInv, 291, 3, 3, V, { VR }, 0, nullptr },
286  { ocNegBinomVert, 292, 3, 3, V, { VR }, 0, nullptr },
287  { ocNormDist, 293, 4, 4, V, { VR }, 0, nullptr },
288  { ocStdNormDist, 294, 1, 1, V, { VR }, 0, nullptr },
289  { ocNormInv, 295, 3, 3, V, { VR }, 0, nullptr },
290  { ocSNormInv, 296, 1, 1, V, { VR }, 0, nullptr },
291  { ocStandard, 297, 3, 3, V, { VR }, 0, nullptr },
292  { ocOdd, 298, 1, 1, V, { VR }, 0, nullptr },
293  { ocPermut, 299, 2, 2, V, { VR }, 0, nullptr },
294  { ocPoissonDist, 300, 3, 3, V, { VR }, 0, nullptr },
295  { ocTDist, 301, 3, 3, V, { VR }, 0, nullptr },
296  { ocWeibull, 302, 4, 4, V, { VR }, 0, nullptr },
297  { ocSumXMY2, 303, 2, 2, V, { VA }, 0, nullptr },
298  { ocSumX2MY2, 304, 2, 2, V, { VA }, 0, nullptr },
299  { ocSumX2DY2, 305, 2, 2, V, { VA }, 0, nullptr },
300  { ocChiTest, 306, 2, 2, V, { VA }, 0, nullptr },
301  { ocCorrel, 307, 2, 2, V, { VA }, 0, nullptr },
302  { ocCovar, 308, 2, 2, V, { VA }, 0, nullptr },
303  { ocForecast, 309, 3, 3, V, { VR, VA }, 0, nullptr },
304  { ocFTest, 310, 2, 2, V, { VA }, 0, nullptr },
305  { ocIntercept, 311, 2, 2, V, { VA }, 0, nullptr },
306  { ocPearson, 312, 2, 2, V, { VA }, 0, nullptr },
307  { ocRSQ, 313, 2, 2, V, { VA }, 0, nullptr },
308  { ocSTEYX, 314, 2, 2, V, { VA }, 0, nullptr },
309  { ocSlope, 315, 2, 2, V, { VA }, 0, nullptr },
310  { ocTTest, 316, 4, 4, V, { VA, VA, VR }, 0, nullptr },
311  { ocProb, 317, 3, 4, V, { VA, VA, VR }, 0, nullptr },
312  { ocDevSq, 318, 1, MX, V, { RX }, 0, nullptr },
313  { ocGeoMean, 319, 1, MX, V, { RX }, 0, nullptr },
314  { ocHarMean, 320, 1, MX, V, { RX }, 0, nullptr },
315  { ocSumSQ, 321, 0, MX, V, { RX }, 0, nullptr },
316  { ocKurt, 322, 1, MX, V, { RX }, 0, nullptr },
317  { ocSkew, 323, 1, MX, V, { RX }, 0, nullptr },
318  { ocZTest, 324, 2, 3, V, { RX, VR }, 0, nullptr },
319  { ocLarge, 325, 2, 2, V, { RX, VR }, 0, nullptr },
320  { ocSmall, 326, 2, 2, V, { RX, VR }, 0, nullptr },
321  { ocQuartile, 327, 2, 2, V, { RX, VR }, 0, nullptr },
322  { ocPercentile, 328, 2, 2, V, { RX, VR }, 0, nullptr },
323  { ocPercentrank, 329, 2, 3, V, { RX, VR, VR_E }, 0, nullptr },
324  { ocModalValue, 330, 1, MX, V, { VA }, 0, nullptr },
325  { ocTrimMean, 331, 2, 2, V, { RX, VR }, 0, nullptr },
326  { ocTInv, 332, 2, 2, V, { VR }, 0, nullptr },
327  // Functions equivalent to add-in functions, use same parameters as
328  // ocExternal but add programmatical function name (here without
329  // "com.sun.star.sheet.addin.") so it can be looked up and stored as
330  // add-in, as older Excel versions only know them as add-in.
331  { ocIsEven, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getIseven" ) },
332  { ocIsOdd, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getIsodd" ) },
333  { ocGCD, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getGcd" ) },
334  { ocLCM, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getLcm" ) },
335  { ocEffect, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getEffect" ) },
336  { ocCumPrinc, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getCumprinc" ) },
337  { ocCumIpmt, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getCumipmt" ) },
338  { ocNominal, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getNominal" ) },
339  { ocNetWorkdays, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY | EXC_FUNCFLAG_ADDINEQUIV, EXC_FUNCNAME_ADDIN( "Analysis.getNetworkdays" ) }
340 };
341 
343 const XclFunctionInfo saFuncTable_5[] =
344 {
345  { ocGetDayOfWeek, 70, 1, 2, V, { VR }, 0, nullptr }, // BIFF2-4: 1, BIFF5: 1-2
346  { ocHLookup, 101, 3, 4, V, { VV, RO, RO, VV }, 0, nullptr }, // BIFF2-4: 3, BIFF5: 3-4
347  { ocVLookup, 102, 3, 4, V, { VV, RO, RO, VV }, 0, nullptr }, // BIFF2-4: 3, BIFF5: 3-4
348  { ocGetDiffDate360, 220, 2, 3, V, { VR }, 0, nullptr }, // BIFF3-4: 2, BIFF5: 2-3
349  { ocMacro, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
350  { ocExternal, 255, 1, MX, R, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY, nullptr },
351  { ocConcat, 336, 0, MX, V, { VR }, 0, nullptr },
352  { ocPower, 337, 2, 2, V, { VR }, 0, nullptr },
353  { ocRad, 342, 1, 1, V, { VR }, 0, nullptr },
354  { ocDeg, 343, 1, 1, V, { VR }, 0, nullptr },
355  { ocSubTotal, 344, 2, MX, V, { VR, RO }, 0, nullptr },
356  { ocSumIf, 345, 2, 3, V, { RO, VR, RO }, 0, nullptr },
357  { ocCountIf, 346, 2, 2, V, { RO, VR }, 0, nullptr },
358  { ocCountEmptyCells, 347, 1, 1, V, { RO }, 0, nullptr },
359  { ocISPMT, 350, 4, 4, V, { VR }, 0, nullptr },
360  { ocGetDateDif, 351, 3, 3, V, { VR }, 0, nullptr },
361  { ocNoName, 352, 1, 1, V, { VR }, EXC_FUNCFLAG_IMPORTONLY, nullptr }, // DATESTRING
362  { ocNoName, 353, 2, 2, V, { VR }, EXC_FUNCFLAG_IMPORTONLY, nullptr }, // NUMBERSTRING
363  { ocRoman, 354, 1, 2, V, { VR }, 0, nullptr }
364 };
365 
367 const XclFunctionInfo saFuncTable_8[] =
368 {
369  { ocGetPivotData, 358, 2, MX, V, { RR, RR, VR }, 0, nullptr },
370  { ocHyperLink, 359, 1, 2, V, { VV, VO }, 0, nullptr },
371  { ocNoName, 360, 1, 1, V, { RO }, EXC_FUNCFLAG_IMPORTONLY, nullptr }, // PHONETIC
372  { ocAverageA, 361, 1, MX, V, { RX }, 0, nullptr },
373  { ocMaxA, 362, 1, MX, V, { RX }, 0, nullptr },
374  { ocMinA, 363, 1, MX, V, { RX }, 0, nullptr },
375  { ocStDevPA, 364, 1, MX, V, { RX }, 0, nullptr },
376  { ocVarPA, 365, 1, MX, V, { RX }, 0, nullptr },
377  { ocStDevA, 366, 1, MX, V, { RX }, 0, nullptr },
378  { ocVarA, 367, 1, MX, V, { RX }, 0, nullptr },
379  { ocBahtText, 368, 1, 1, V, { VR }, EXC_FUNCFLAG_IMPORTONLY, EXC_FUNCNAME( "BAHTTEXT" ) },
380  { ocBahtText, 255, 2, 2, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY, EXC_FUNCNAME( "BAHTTEXT" ) },
381  { ocEuroConvert, 255, 4, 6, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY, "EUROCONVERT" }
382 };
383 
384 #define EXC_FUNCENTRY_V_VR( opcode, minparam, maxparam, flags, asciiname ) \
385  { opcode, NOID, minparam, maxparam, V, { VR }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }, \
386  { opcode, 255, (minparam)+1, (maxparam)+1, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
387 
389 const XclFunctionInfo saFuncTable_Oox[] =
390 {
391  { ocCountIfs, NOID, 2, MX, V, { RO, VR }, EXC_FUNCFLAG_IMPORTONLY|EXC_FUNCFLAG_PARAMPAIRS, EXC_FUNCNAME( "COUNTIFS" ) },
392  { ocCountIfs, 255, 3, MX, V, { RO_E, RO, VR }, EXC_FUNCFLAG_EXPORTONLY|EXC_FUNCFLAG_PARAMPAIRS, EXC_FUNCNAME( "COUNTIFS" ) },
393  { ocSumIfs, NOID, 3, MX, V, { RO, RO, VR }, EXC_FUNCFLAG_IMPORTONLY|EXC_FUNCFLAG_PARAMPAIRS, EXC_FUNCNAME( "SUMIFS" ) },
394  { ocSumIfs, 255, 4, MX, V, { RO_E, RO, RO, VR }, EXC_FUNCFLAG_EXPORTONLY|EXC_FUNCFLAG_PARAMPAIRS, EXC_FUNCNAME( "SUMIFS" ) },
395  { ocAverageIf, NOID, 2, 3, V, { RO, VR, RO }, EXC_FUNCFLAG_IMPORTONLY, EXC_FUNCNAME( "AVERAGEIF" ) },
396  { ocAverageIf, 255, 3, 4, V, { RO_E, RO, VR, RO }, EXC_FUNCFLAG_EXPORTONLY, EXC_FUNCNAME( "AVERAGEIF" ) },
397  { ocAverageIfs, NOID, 3, MX, V, { RO, RO, VR }, EXC_FUNCFLAG_IMPORTONLY|EXC_FUNCFLAG_PARAMPAIRS, EXC_FUNCNAME( "AVERAGEIFS" ) },
398  { ocAverageIfs, 255, 4, MX, V, { RO_E, RO, RO, VR }, EXC_FUNCFLAG_EXPORTONLY|EXC_FUNCFLAG_PARAMPAIRS, EXC_FUNCNAME( "AVERAGEIFS" ) },
399  { ocIfError, NOID, 2, 2, V, { VO, RO }, EXC_FUNCFLAG_IMPORTONLY, EXC_FUNCNAME( "IFERROR" ) },
400  { ocIfError, 255, 3, 3, V, { RO_E, VO, RO }, EXC_FUNCFLAG_EXPORTONLY, EXC_FUNCNAME( "IFERROR" ) },
401  { ocNetWorkdays_MS, NOID, 2, 4, V, { VR, VR, RO, RO }, EXC_FUNCFLAG_IMPORTONLY, EXC_FUNCNAME( "NETWORKDAYS.INTL" ) },
402  { ocNetWorkdays_MS, 255, 3, 5, V, { RO_E, VR, VR, RO, RO }, EXC_FUNCFLAG_EXPORTONLY, EXC_FUNCNAME( "NETWORKDAYS.INTL" ) },
403  { ocWorkday_MS, NOID, 2, 4, V, { VR, VR, VR, RO }, EXC_FUNCFLAG_IMPORTONLY, EXC_FUNCNAME( "WORKDAY.INTL" ) },
404  { ocWorkday_MS, 255, 3, 5, V, { RO_E, VR, VR, VR, RO }, EXC_FUNCFLAG_EXPORTONLY, EXC_FUNCNAME( "WORKDAY.INTL" ) },
405  EXC_FUNCENTRY_V_VR( ocCeil_ISO, 1, 2, 0, "ISO.CEILING" )
406 };
407 
408 #define EXC_FUNCENTRY_V_VR_IMPORT( opcode, minparam, maxparam, flags, asciiname ) \
409  { opcode, NOID, minparam, maxparam, V, { VR }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
410 
411 #define EXC_FUNCENTRY_V_RO_EXPORT( opcode, minparam, maxparam, flags, asciiname ) \
412  { opcode, 255, (minparam)+1, (maxparam)+1, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
413 
414 #define EXC_FUNCENTRY_A_VR( opcode, minparam, maxparam, flags, asciiname ) \
415  { opcode, NOID, minparam, maxparam, A, { VR }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }, \
416  { opcode, 255, (minparam)+1, (maxparam)+1, A, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
417 
418 #define EXC_FUNCENTRY_V_RO( opcode, minparam, maxparam, flags, asciiname ) \
419  { opcode, NOID, minparam, maxparam, V, { RO }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }, \
420  { opcode, 255, (minparam)+1, (maxparam)+1, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
421 
422 // implicit maxparam=MX
423 #define EXC_FUNCENTRY_V_RX( opcode, minparam, maxparam, flags, asciiname ) \
424  { opcode, NOID, minparam, MX, V, { RX }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }, \
425  { opcode, 255, (minparam)+1, MX, V, { RO_E, RX }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
426 
427 #define EXC_FUNCENTRY_V_VA( opcode, minparam, maxparam, flags, asciiname ) \
428  { opcode, NOID, minparam, maxparam, V, { VA }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }, \
429  { opcode, 255, (minparam)+1, (maxparam)+1, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
430 
438 const XclFunctionInfo saFuncTable_2010[] =
439 {
440  EXC_FUNCENTRY_V_VA( ocCovarianceP, 2, 2, 0, "COVARIANCE.P" ),
441  EXC_FUNCENTRY_V_VA( ocCovarianceS, 2, 2, 0, "COVARIANCE.S" ),
442  EXC_FUNCENTRY_V_RX( ocStDevP_MS, 1, MX, 0, "STDEV.P" ),
443  EXC_FUNCENTRY_V_RX( ocStDevS, 1, MX, 0, "STDEV.S" ),
444  EXC_FUNCENTRY_V_RX( ocVarP_MS, 1, MX, 0, "VAR.P" ),
445  EXC_FUNCENTRY_V_RX( ocVarS, 1, MX, 0, "VAR.S" ),
446  EXC_FUNCENTRY_V_VR( ocBetaDist_MS, 4, 6, 0, "BETA.DIST" ),
447  EXC_FUNCENTRY_V_VR( ocBetaInv_MS, 3, 5, 0, "BETA.INV" ),
448  EXC_FUNCENTRY_V_VR( ocBinomDist_MS, 4, 4, 0, "BINOM.DIST" ),
449  EXC_FUNCENTRY_V_VR( ocBinomInv, 3, 3, 0, "BINOM.INV" ),
450  EXC_FUNCENTRY_V_VR( ocChiSqDist_MS, 3, 3, 0, "CHISQ.DIST" ),
451  EXC_FUNCENTRY_V_VR( ocChiSqInv_MS, 2, 2, 0, "CHISQ.INV" ),
452  EXC_FUNCENTRY_V_VR( ocChiDist_MS, 2, 2, 0, "CHISQ.DIST.RT" ),
453  EXC_FUNCENTRY_V_VR( ocChiInv_MS, 2, 2, 0, "CHISQ.INV.RT" ),
454  EXC_FUNCENTRY_V_VR( ocChiTest_MS, 2, 2, 0, "CHISQ.TEST" ),
455  EXC_FUNCENTRY_V_VR( ocConfidence_N, 3, 3, 0, "CONFIDENCE.NORM" ),
456  EXC_FUNCENTRY_V_VR( ocConfidence_T, 3, 3, 0, "CONFIDENCE.T" ),
457  EXC_FUNCENTRY_V_VR( ocFDist_LT, 4, 4, 0, "F.DIST" ),
458  EXC_FUNCENTRY_V_VR( ocFDist_RT, 3, 3, 0, "F.DIST.RT" ),
459  EXC_FUNCENTRY_V_VR( ocFInv_LT, 3, 3, 0, "F.INV" ),
460  EXC_FUNCENTRY_V_VR( ocFInv_RT, 3, 3, 0, "F.INV.RT" ),
461  EXC_FUNCENTRY_V_VR( ocFTest_MS, 2, 2, 0, "F.TEST" ),
462  EXC_FUNCENTRY_V_VR( ocExpDist_MS, 3, 3, 0, "EXPON.DIST" ),
463  EXC_FUNCENTRY_V_VR( ocHypGeomDist_MS, 5, 5, 0, "HYPGEOM.DIST" ),
464  EXC_FUNCENTRY_V_VR( ocPoissonDist_MS, 3, 3, 0, "POISSON.DIST" ),
465  EXC_FUNCENTRY_V_VR( ocWeibull_MS, 4, 4, 0, "WEIBULL.DIST" ),
466  EXC_FUNCENTRY_V_VR( ocGammaDist_MS, 4, 4, 0, "GAMMA.DIST" ),
467  EXC_FUNCENTRY_V_VR( ocGammaInv_MS, 3, 3, 0, "GAMMA.INV" ),
468  EXC_FUNCENTRY_V_VR( ocGammaLn_MS, 1, 1, 0, "GAMMALN.PRECISE" ),
469  EXC_FUNCENTRY_V_VR( ocLogNormDist_MS, 4, 4, 0, "LOGNORM.DIST" ),
470  EXC_FUNCENTRY_V_VR( ocLogInv_MS, 3, 3, 0, "LOGNORM.INV" ),
471  EXC_FUNCENTRY_V_VR( ocNormDist_MS, 4, 4, 0, "NORM.DIST" ),
472  EXC_FUNCENTRY_V_VR( ocNormInv_MS, 3, 3, 0, "NORM.INV" ),
473  EXC_FUNCENTRY_V_VR( ocStdNormDist_MS, 2, 2, 0, "NORM.S.DIST" ),
474  EXC_FUNCENTRY_V_VR( ocSNormInv_MS, 1, 1, 0, "NORM.S.INV" ),
475  EXC_FUNCENTRY_V_VR( ocTDist_2T, 2, 2, 0, "T.DIST.2T" ),
476  EXC_FUNCENTRY_V_VR( ocTDist_MS, 3, 3, 0, "T.DIST" ),
477  EXC_FUNCENTRY_V_VR( ocTDist_RT, 2, 2, 0, "T.DIST.RT" ),
478  EXC_FUNCENTRY_V_VR( ocTInv_2T, 2, 2, 0, "T.INV.2T" ),
479  EXC_FUNCENTRY_V_VR( ocTInv_MS, 2, 2, 0, "T.INV" ),
480  EXC_FUNCENTRY_V_VR( ocTTest_MS, 4, 4, 0, "T.TEST" ),
481  EXC_FUNCENTRY_V_VR( ocPercentile_Inc, 2, 2, 0, "PERCENTILE.INC" ),
482  EXC_FUNCENTRY_V_VR( ocPercentrank_Inc, 2, 3, 0, "PERCENTRANK.INC" ),
483  EXC_FUNCENTRY_V_VR( ocQuartile_Inc, 2, 2, 0, "QUARTILE.INC" ),
484  EXC_FUNCENTRY_V_VR( ocRank_Eq, 2, 3, 0, "RANK.EQ" ),
485  EXC_FUNCENTRY_V_VR( ocPercentile_Exc, 2, 2, 0, "PERCENTILE.EXC" ),
486  EXC_FUNCENTRY_V_VR( ocPercentrank_Exc, 2, 3, 0, "PERCENTRANK.EXC" ),
487  EXC_FUNCENTRY_V_VR( ocQuartile_Exc, 2, 2, 0, "QUARTILE.EXC" ),
488  EXC_FUNCENTRY_V_VR( ocRank_Avg, 2, 3, 0, "RANK.AVG" ),
489  EXC_FUNCENTRY_V_RX( ocModalValue_MS, 1, MX, 0, "MODE.SNGL" ),
490  EXC_FUNCENTRY_V_RX( ocModalValue_Multi, 1, MX, 0, "MODE.MULT" ),
491  EXC_FUNCENTRY_V_VR( ocNegBinomDist_MS, 4, 4, 0, "NEGBINOM.DIST" ),
492  EXC_FUNCENTRY_V_VR( ocZTest_MS, 2, 3, 0, "Z.TEST" ),
493  EXC_FUNCENTRY_V_VR( ocCeil_Precise, 1, 2, 0, "CEILING.PRECISE" ),
494  EXC_FUNCENTRY_V_VR( ocFloor_Precise, 1, 2, 0, "FLOOR.PRECISE" ),
495  EXC_FUNCENTRY_V_VR( ocErf_MS, 1, 1, 0, "ERF.PRECISE" ),
496  EXC_FUNCENTRY_V_VR( ocErfc_MS, 1, 1, 0, "ERFC.PRECISE" ),
497  EXC_FUNCENTRY_V_RX( ocAggregate, 3, MX, 0, "AGGREGATE" ),
498 };
499 
517 const XclFunctionInfo saFuncTable_2013[] =
518 {
519  EXC_FUNCENTRY_V_VR_IMPORT( ocArcCot, 1, 1, 0, "ACOT" ),
520  EXC_FUNCENTRY_V_VR_IMPORT( ocArcCotHyp, 1, 1, 0, "ACOTH" ),
521  EXC_FUNCENTRY_V_VR( ocArabic, 1, 1, 0, "ARABIC" ),
522  EXC_FUNCENTRY_V_VR( ocBase, 2, 3, 0, "BASE" ),
523  EXC_FUNCENTRY_V_VR( ocB, 3, 4, 0, "BINOM.DIST.RANGE" ),
524  EXC_FUNCENTRY_V_VR( ocBitAnd, 2, 2, 0, "BITAND" ),
525  EXC_FUNCENTRY_V_VR( ocBitLshift, 2, 2, 0, "BITLSHIFT" ),
526  EXC_FUNCENTRY_V_VR( ocBitOr, 2, 2, 0, "BITOR" ),
527  EXC_FUNCENTRY_V_VR( ocBitRshift, 2, 2, 0, "BITRSHIFT" ),
528  EXC_FUNCENTRY_V_VR( ocBitXor, 2, 2, 0, "BITXOR" ),
529  EXC_FUNCENTRY_V_VR( ocCeil_Math, 1, 3, 0, "CEILING.MATH" ),
530  EXC_FUNCENTRY_V_RO_EXPORT( ocCeil, 1, 3, 0, "CEILING.MATH" ),
531  EXC_FUNCENTRY_V_VR( ocCombinA, 2, 2, 0, "COMBINA" ),
532  EXC_FUNCENTRY_V_VR_IMPORT( ocCot, 1, 1, 0, "COT" ),
533  EXC_FUNCENTRY_V_VR_IMPORT( ocCotHyp, 1, 1, 0, "COTH" ),
534  EXC_FUNCENTRY_V_VR_IMPORT( ocCosecant, 1, 1, 0, "CSC" ),
535  EXC_FUNCENTRY_V_VR_IMPORT( ocCosecantHyp, 1, 1, 0, "CSCH" ),
536  EXC_FUNCENTRY_V_VR( ocGetDiffDate, 2, 2, 0, "DAYS" ),
537  EXC_FUNCENTRY_V_VR( ocDecimal, 2, 2, 0, "DECIMAL" ),
538  EXC_FUNCENTRY_V_VR( ocEncodeURL, 1, 1, 0, "ENCODEURL" ),
539  // NOTE: this FDIST is not our LEGACY.FDIST
540  EXC_FUNCENTRY_V_VR( ocNoName, 3, 4, 0, "FDIST" ),
541  // NOTE: this FINV is not our LEGACY.FINV
542  EXC_FUNCENTRY_V_VR( ocNoName, 3, 3, 0, "FINV" ),
543  EXC_FUNCENTRY_V_VR( ocFilterXML, 2, 2, 0, "FILTERXML" ),
544  EXC_FUNCENTRY_V_VR( ocFloor_Math, 1, 3, 0, "FLOOR.MATH" ),
545  EXC_FUNCENTRY_V_RO_EXPORT( ocFloor, 1, 3, 0, "FLOOR.MATH" ),
546  EXC_FUNCENTRY_V_RO( ocFormula, 1, 1, 0, "FORMULATEXT" ),
547  EXC_FUNCENTRY_V_VR( ocGamma, 1, 1, 0, "GAMMA" ),
548  EXC_FUNCENTRY_V_VR( ocGauss, 1, 1, 0, "GAUSS" ),
549  { ocIfNA, NOID, 2, 2, V, { VO, RO }, EXC_FUNCFLAG_IMPORTONLY, EXC_FUNCNAME( "IFNA" ) },
550  { ocIfNA, 255, 3, 3, V, { RO_E, VO, RO }, EXC_FUNCFLAG_EXPORTONLY, EXC_FUNCNAME( "IFNA" ) },
551  // IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH and IMTAN are
552  // implemented in the Analysis Add-In.
553  EXC_FUNCENTRY_V_RO( ocIsFormula, 1, 1, 0, "ISFORMULA" ),
554  EXC_FUNCENTRY_V_VR( ocWeek, 1, 2, 0, "WEEKNUM" ),
555  EXC_FUNCENTRY_V_VR( ocIsoWeeknum, 1, 1, 0, "ISOWEEKNUM" ),
556  EXC_FUNCENTRY_A_VR( ocMatrixUnit, 1, 1, 0, "MUNIT" ),
557  EXC_FUNCENTRY_V_VR( ocNumberValue, 1, 3, 0, "NUMBERVALUE" ),
558  EXC_FUNCENTRY_V_VR( ocPDuration, 3, 3, 0, "PDURATION" ),
559  EXC_FUNCENTRY_V_VR( ocPermutationA, 2, 2, 0, "PERMUTATIONA" ),
560  EXC_FUNCENTRY_V_VR( ocPhi, 1, 1, 0, "PHI" ),
561  EXC_FUNCENTRY_V_VR( ocRRI, 3, 3, 0, "RRI" ),
562  EXC_FUNCENTRY_V_VR_IMPORT( ocSecant, 1, 1, 0, "SEC" ),
563  EXC_FUNCENTRY_V_VR_IMPORT( ocSecantHyp, 1, 1, 0, "SECH" ),
564  EXC_FUNCENTRY_V_RO( ocSheet, 0, 1, 0, "SHEET" ),
565  EXC_FUNCENTRY_V_RO( ocSheets, 0, 1, 0, "SHEETS" ),
566  EXC_FUNCENTRY_V_RX( ocSkewp, 1, MX, 0, "SKEW.P" ),
567  EXC_FUNCENTRY_V_VR( ocUnichar, 1, 1, 0, "UNICHAR" ),
568  EXC_FUNCENTRY_V_VR( ocUnicode, 1, 1, 0, "UNICODE" ),
569  EXC_FUNCENTRY_V_VR( ocWebservice, 1, 1, 0, "WEBSERVICE" ),
570  EXC_FUNCENTRY_V_RX( ocXor, 1, MX, 0, "XOR" ),
571  EXC_FUNCENTRY_V_VR( ocErrorType_ODF, 1, 1, 0, "ERROR.TYPE" )
572 };
573 
581 const XclFunctionInfo saFuncTable_2016[] =
582 {
583  EXC_FUNCENTRY_V_VR( ocForecast_ETS_ADD, 3, 6, 0, "FORECAST.ETS" ),
584  EXC_FUNCENTRY_V_VR( ocForecast_ETS_PIA, 3, 7, 0, "FORECAST.ETS.CONFINT" ),
585  EXC_FUNCENTRY_V_VR( ocForecast_ETS_SEA, 2, 4, 0, "FORECAST.ETS.SEASONALITY" ),
586  EXC_FUNCENTRY_V_VR( ocForecast_ETS_STA, 3, 6, 0, "FORECAST.ETS.STAT" ),
587  EXC_FUNCENTRY_V_VR( ocForecast_LIN, 3, 3, 0, "FORECAST.LINEAR" ),
588  EXC_FUNCENTRY_V_VR( ocConcat_MS, 1, MX, 0, "CONCAT" ),
589  EXC_FUNCENTRY_V_VR( ocTextJoin_MS, 3, MX, 0, "TEXTJOIN" ),
590  EXC_FUNCENTRY_V_VR( ocIfs_MS, 2, MX, 0, "IFS" ),
591  EXC_FUNCENTRY_V_VR( ocSwitch_MS, 3, MX, 0, "SWITCH" ),
592  EXC_FUNCENTRY_V_VR( ocMinIfs_MS, 3, MX, 0, "MINIFS" ),
593  EXC_FUNCENTRY_V_VR( ocMaxIfs_MS, 3, MX, 0, "MAXIFS" )
594 };
595 
596 #define EXC_FUNCENTRY_ODF( opcode, minparam, maxparam, flags, asciiname ) \
597  { opcode, NOID, minparam, maxparam, V, { VR }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME_ODF( asciiname ) }, \
598  { opcode, 255, (minparam)+1, (maxparam)+1, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME_ODF( asciiname ) }
599 
601 const XclFunctionInfo saFuncTable_Odf[] =
602 {
603  EXC_FUNCENTRY_ODF( ocChiSqDist, 2, 3, 0, "CHISQDIST" ),
604  EXC_FUNCENTRY_ODF( ocChiSqInv, 2, 2, 0, "CHISQINV" )
605 };
606 
607 #undef EXC_FUNCENTRY_ODF
608 
609 #define EXC_FUNCENTRY_OOO( opcode, minparam, maxparam, flags, asciiname ) \
610  { opcode, NOID, minparam, maxparam, V, { VR }, EXC_FUNCFLAG_IMPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }, \
611  { opcode, 255, (minparam)+1, (maxparam)+1, V, { RO_E, RO }, EXC_FUNCFLAG_EXPORTONLY|(flags), EXC_FUNCNAME( asciiname ) }
612 
613 // Import Broken Raw ... even without leading _xlfn.
614 #define EXC_FUNCENTRY_OOO_IBR( opcode, minparam, maxparam, flags, asciiname ) \
615  { opcode, NOID, minparam, maxparam, V, { VR }, EXC_FUNCFLAG_IMPORTONLY|(flags), asciiname }
616 
618 const XclFunctionInfo saFuncTable_OOoLO[] =
619 {
620  EXC_FUNCENTRY_OOO( ocErrorType, 1, 1, 0, "ORG.OPENOFFICE.ERRORTYPE" ),
621  EXC_FUNCENTRY_OOO_IBR( ocErrorType, 1, 1, 0, "ERRORTYPE" ), // was written wrongly, read it
622  EXC_FUNCENTRY_OOO( ocMultiArea, 1, MX, 0, "ORG.OPENOFFICE.MULTIRANGE" ),
623  EXC_FUNCENTRY_OOO_IBR( ocMultiArea, 1, MX, 0, "MULTIRANGE" ), // was written wrongly, read it
624  EXC_FUNCENTRY_OOO( ocBackSolver, 3, 3, 0, "ORG.OPENOFFICE.GOALSEEK" ),
625  EXC_FUNCENTRY_OOO_IBR( ocBackSolver,3, 3, 0, "GOALSEEK" ), // was written wrongly, read it
626  EXC_FUNCENTRY_OOO( ocEasterSunday, 1, 1, 0, "ORG.OPENOFFICE.EASTERSUNDAY" ),
627  EXC_FUNCENTRY_OOO_IBR( ocEasterSunday,1,1, 0, "EASTERSUNDAY" ), // was written wrongly, read it
628  EXC_FUNCENTRY_OOO( ocCurrent, 0, 0, 0, "ORG.OPENOFFICE.CURRENT" ),
629  EXC_FUNCENTRY_OOO_IBR( ocCurrent, 0, 0, 0, "CURRENT" ), // was written wrongly, read it
630  EXC_FUNCENTRY_OOO( ocStyle, 1, 3, 0, "ORG.OPENOFFICE.STYLE" ),
631  EXC_FUNCENTRY_OOO_IBR( ocStyle, 1, 3, 0, "STYLE" ), // was written wrongly, read it
632  EXC_FUNCENTRY_OOO( ocConvertOOo, 3, 3, 0, "ORG.OPENOFFICE.CONVERT" ),
633  EXC_FUNCENTRY_OOO( ocColor, 3, 4, 0, "ORG.LIBREOFFICE.COLOR" ),
634  EXC_FUNCENTRY_OOO( ocRawSubtract, 2, MX, 0, "ORG.LIBREOFFICE.RAWSUBTRACT" ),
635  EXC_FUNCENTRY_OOO( ocWeeknumOOo, 2, 2, 0, "ORG.LIBREOFFICE.WEEKNUM_OOO" ),
636  EXC_FUNCENTRY_OOO( ocForecast_ETS_MUL, 3, 6, 0, "ORG.LIBREOFFICE.FORECAST.ETS.MULT" ),
637  EXC_FUNCENTRY_OOO( ocForecast_ETS_PIM, 3, 7, 0, "ORG.LIBREOFFICE.FORECAST.ETS.PI.MULT" ),
638  EXC_FUNCENTRY_OOO( ocForecast_ETS_STM, 3, 6, 0, "ORG.LIBREOFFICE.FORECAST.ETS.STAT.MULT" ),
639  EXC_FUNCENTRY_OOO( ocRoundSig, 2, 2, 0, "ORG.LIBREOFFICE.ROUNDSIG" ),
640  EXC_FUNCENTRY_OOO( ocRegex, 2, 4, 0, "ORG.LIBREOFFICE.REGEX" ),
641  EXC_FUNCENTRY_OOO( ocFourier, 2, 5, 0, "ORG.LIBREOFFICE.FOURIER" ),
642  EXC_FUNCENTRY_OOO( ocRandomNV, 0, 0, 0, "ORG.LIBREOFFICE.RAND.NV" ),
643  EXC_FUNCENTRY_OOO( ocRandbetweenNV, 2, 2, 0, "ORG.LIBREOFFICE.RANDBETWEEN.NV" )
644 };
645 
646 #undef EXC_FUNCENTRY_OOO_IBR
647 #undef EXC_FUNCENTRY_OOO
648 
649 XclFunctionProvider::XclFunctionProvider( const XclRoot& rRoot )
650 {
651  void (XclFunctionProvider::*pFillFunc)( const XclFunctionInfo*, const XclFunctionInfo* ) =
652  rRoot.IsImport() ? &XclFunctionProvider::FillXclFuncMap : &XclFunctionProvider::FillScFuncMap;
653 
654  /* Only read/write functions supported in the current BIFF version.
655  Function tables from later BIFF versions may overwrite single functions
656  from earlier tables. */
657  XclBiff eBiff = rRoot.GetBiff();
658  if( eBiff >= EXC_BIFF2 )
659  (this->*pFillFunc)(saFuncTable_2, saFuncTable_2 + SAL_N_ELEMENTS(saFuncTable_2));
660  if( eBiff >= EXC_BIFF3 )
661  (this->*pFillFunc)(saFuncTable_3, saFuncTable_3 + SAL_N_ELEMENTS(saFuncTable_3));
662  if( eBiff >= EXC_BIFF4 )
663  (this->*pFillFunc)(saFuncTable_4, saFuncTable_4 + SAL_N_ELEMENTS(saFuncTable_4));
664  if( eBiff >= EXC_BIFF5 )
665  (this->*pFillFunc)(saFuncTable_5, saFuncTable_5 + SAL_N_ELEMENTS(saFuncTable_5));
666  if( eBiff >= EXC_BIFF8 )
667  (this->*pFillFunc)(saFuncTable_8, saFuncTable_8 + SAL_N_ELEMENTS(saFuncTable_8));
668  (this->*pFillFunc)(saFuncTable_Oox, saFuncTable_Oox + SAL_N_ELEMENTS(saFuncTable_Oox));
669  (this->*pFillFunc)(saFuncTable_2010, saFuncTable_2010 + SAL_N_ELEMENTS(saFuncTable_2010));
670  (this->*pFillFunc)(saFuncTable_2013, saFuncTable_2013 + SAL_N_ELEMENTS(saFuncTable_2013));
671  (this->*pFillFunc)(saFuncTable_2016, saFuncTable_2016 + SAL_N_ELEMENTS(saFuncTable_2016));
672  (this->*pFillFunc)(saFuncTable_Odf, saFuncTable_Odf + SAL_N_ELEMENTS(saFuncTable_Odf));
673  (this->*pFillFunc)(saFuncTable_OOoLO, saFuncTable_OOoLO + SAL_N_ELEMENTS(saFuncTable_OOoLO));
674 }
675 
676 const XclFunctionInfo* XclFunctionProvider::GetFuncInfoFromXclFunc( sal_uInt16 nXclFunc ) const
677 {
678  // only in import filter allowed
679  OSL_ENSURE( !maXclFuncMap.empty(), "XclFunctionProvider::GetFuncInfoFromXclFunc - wrong filter" );
680  XclFuncMap::const_iterator aIt = maXclFuncMap.find( nXclFunc );
681  return (aIt == maXclFuncMap.end()) ? nullptr : aIt->second;
682 }
683 
684 const XclFunctionInfo* XclFunctionProvider::GetFuncInfoFromXclMacroName( const OUString& rXclMacroName ) const
685 {
686  // only in import filter allowed, but do not test maXclMacroNameMap, it may be empty for old BIFF versions
687  OSL_ENSURE( !maXclFuncMap.empty(), "XclFunctionProvider::GetFuncInfoFromXclMacroName - wrong filter" );
688  XclMacroNameMap::const_iterator aIt = maXclMacroNameMap.find( rXclMacroName );
689  return (aIt == maXclMacroNameMap.end()) ? nullptr : aIt->second;
690 }
691 
692 const XclFunctionInfo* XclFunctionProvider::GetFuncInfoFromOpCode( OpCode eOpCode ) const
693 {
694  // only in export filter allowed
695  OSL_ENSURE( !maScFuncMap.empty(), "XclFunctionProvider::GetFuncInfoFromOpCode - wrong filter" );
696  ScFuncMap::const_iterator aIt = maScFuncMap.find( eOpCode );
697  return (aIt == maScFuncMap.end()) ? nullptr : aIt->second;
698 }
699 
700 void XclFunctionProvider::FillXclFuncMap( const XclFunctionInfo* pBeg, const XclFunctionInfo* pEnd )
701 {
702  for( const XclFunctionInfo* pIt = pBeg; pIt != pEnd; ++pIt )
703  {
704  if( !::get_flag( pIt->mnFlags, EXC_FUNCFLAG_EXPORTONLY ) )
705  {
706  if( pIt->mnXclFunc != NOID )
707  maXclFuncMap[ pIt->mnXclFunc ] = pIt;
708  if( pIt->IsMacroFunc() )
709  maXclMacroNameMap[ pIt->GetMacroFuncName() ] = pIt;
710  }
711  }
712 }
713 
714 void XclFunctionProvider::FillScFuncMap( const XclFunctionInfo* pBeg, const XclFunctionInfo* pEnd )
715 {
716  for( const XclFunctionInfo* pIt = pBeg; pIt != pEnd; ++pIt )
717  if( !::get_flag( pIt->mnFlags, EXC_FUNCFLAG_IMPORTONLY ) )
718  maScFuncMap[ pIt->meOpCode ] = pIt;
719 }
720 
721 // Token array ================================================================
722 
723 XclTokenArray::XclTokenArray( bool bVolatile ) :
724  mbVolatile( bVolatile )
725 {
726 }
727 
728 XclTokenArray::XclTokenArray( ScfUInt8Vec& rTokVec, ScfUInt8Vec& rExtDataVec, bool bVolatile ) :
729  mbVolatile( bVolatile )
730 {
731  maTokVec.swap( rTokVec );
732  maExtDataVec.swap( rExtDataVec );
733 }
734 
735 sal_uInt16 XclTokenArray::GetSize() const
736 {
737  OSL_ENSURE( maTokVec.size() <= 0xFFFF, "XclTokenArray::GetSize - array too long" );
738  return limit_cast< sal_uInt16 >( maTokVec.size() );
739 }
740 
741 sal_uInt16 XclTokenArray::ReadSize(XclImpStream& rStrm)
742 {
743  return rStrm.ReaduInt16();
744 }
745 
746 void XclTokenArray::ReadArray(sal_uInt16 nSize, XclImpStream& rStrm)
747 {
748  maTokVec.resize(0);
749 
750  const std::size_t nMaxBuffer = 4096;
751  std::size_t nBytesLeft = nSize;
752  std::size_t nTotalRead = 0;
753 
754  while (true)
755  {
756  if (!nBytesLeft)
757  break;
758  std::size_t nReadRequest = o3tl::sanitizing_min(nBytesLeft, nMaxBuffer);
759  maTokVec.resize(maTokVec.size() + nReadRequest);
760  auto nRead = rStrm.Read(maTokVec.data() + nTotalRead, nReadRequest);
761  nTotalRead += nRead;
762  if (nRead != nReadRequest)
763  {
764  maTokVec.resize(nTotalRead);
765  break;
766  }
767  nBytesLeft -= nRead;
768  }
769 }
770 
771 void XclTokenArray::Read( XclImpStream& rStrm )
772 {
773  ReadArray(ReadSize(rStrm), rStrm);
774 }
775 
776 void XclTokenArray::WriteSize( XclExpStream& rStrm ) const
777 {
778  rStrm << GetSize();
779 }
780 
781 void XclTokenArray::WriteArray( XclExpStream& rStrm ) const
782 {
783  if( !maTokVec.empty() )
784  rStrm.Write(maTokVec.data(), GetSize());
785  if( !maExtDataVec.empty() )
786  rStrm.Write(maExtDataVec.data(), maExtDataVec.size());
787 }
788 
789 void XclTokenArray::Write( XclExpStream& rStrm ) const
790 {
791  WriteSize( rStrm );
792  WriteArray( rStrm );
793 }
794 
795 bool XclTokenArray::operator==( const XclTokenArray& rTokArr ) const
796 {
797  return (mbVolatile == rTokArr.mbVolatile) && (maTokVec == rTokArr.maTokVec) && (maExtDataVec == rTokArr.maExtDataVec);
798 }
799 
800 XclImpStream& operator>>( XclImpStream& rStrm, XclTokenArray& rTokArr )
801 {
802  rTokArr.Read( rStrm );
803  return rStrm;
804 }
805 
806 XclExpStream& operator<<( XclExpStream& rStrm, const XclTokenArray& rTokArr )
807 {
808  rTokArr.Write( rStrm );
809  return rStrm;
810 }
811 
812 XclExpStream& operator<<( XclExpStream& rStrm, const XclTokenArrayRef& rxTokArr )
813 {
814  if( rxTokArr )
815  rxTokArr->Write( rStrm );
816  else
817  rStrm << sal_uInt16( 0 );
818  return rStrm;
819 }
820 
821 XclTokenArrayIterator::XclTokenArrayIterator() :
822  mppScTokenBeg( nullptr ),
823  mppScTokenEnd( nullptr ),
824  mppScToken( nullptr ),
825  mbSkipSpaces( false )
826 {
827 }
828 
829 XclTokenArrayIterator::XclTokenArrayIterator( const ScTokenArray& rScTokArr, bool bSkipSpaces )
830 {
831  Init( rScTokArr, bSkipSpaces );
832 }
833 
834 XclTokenArrayIterator::XclTokenArrayIterator( const XclTokenArrayIterator& rTokArrIt, bool bSkipSpaces ) :
835  mppScTokenBeg( rTokArrIt.mppScTokenBeg ),
836  mppScTokenEnd( rTokArrIt.mppScTokenEnd ),
837  mppScToken( rTokArrIt.mppScToken ),
838  mbSkipSpaces( bSkipSpaces )
839 {
840  SkipSpaces();
841 }
842 
843 void XclTokenArrayIterator::Init( const ScTokenArray& rScTokArr, bool bSkipSpaces )
844 {
845  sal_uInt16 nTokArrLen = rScTokArr.GetLen();
846  mppScTokenBeg = static_cast< const FormulaToken* const* >( nTokArrLen ? rScTokArr.GetArray() : nullptr );
847  mppScTokenEnd = mppScTokenBeg ? (mppScTokenBeg + nTokArrLen) : nullptr;
848  mppScToken = (mppScTokenBeg != mppScTokenEnd) ? mppScTokenBeg : nullptr;
849  mbSkipSpaces = bSkipSpaces;
850  SkipSpaces();
851 }
852 
853 XclTokenArrayIterator& XclTokenArrayIterator::operator++()
854 {
855  NextRawToken();
856  SkipSpaces();
857  return *this;
858 }
859 
860 void XclTokenArrayIterator::NextRawToken()
861 {
862  if( mppScToken )
863  if( (++mppScToken == mppScTokenEnd) || !*mppScToken )
864  mppScToken = nullptr;
865 }
866 
867 void XclTokenArrayIterator::SkipSpaces()
868 {
869  if( mbSkipSpaces )
870  while( Is() && ((*this)->GetOpCode() == ocSpaces) )
871  NextRawToken();
872 }
873 
874 // strings and string lists ---------------------------------------------------
875 
876 bool XclTokenArrayHelper::GetTokenString( OUString& rString, const FormulaToken& rScToken )
877 {
878  bool bIsStr = (rScToken.GetType() == svString) && (rScToken.GetOpCode() == ocPush);
879  if( bIsStr ) rString = rScToken.GetString().getString();
880  return bIsStr;
881 }
882 
883 bool XclTokenArrayHelper::GetString( OUString& rString, const ScTokenArray& rScTokArr )
884 {
885  XclTokenArrayIterator aIt( rScTokArr, true );
886  // something is following the string token -> error
887  return aIt.Is() && GetTokenString( rString, *aIt ) && !++aIt;
888 }
889 
890 bool XclTokenArrayHelper::GetStringList( OUString& rStringList, const ScTokenArray& rScTokArr, sal_Unicode cSep )
891 {
892  bool bRet = true;
893  XclTokenArrayIterator aIt( rScTokArr, true );
894  enum { STATE_START, STATE_STR, STATE_SEP, STATE_END } eState = STATE_START;
895  while( eState != STATE_END ) switch( eState )
896  {
897  case STATE_START:
898  eState = aIt.Is() ? STATE_STR : STATE_END;
899  break;
900  case STATE_STR:
901  {
902  OUString aString;
903  bRet = GetTokenString( aString, *aIt );
904  if( bRet ) rStringList += aString ;
905  eState = (bRet && (++aIt).Is()) ? STATE_SEP : STATE_END;
906  break;
907  }
908  case STATE_SEP:
909  bRet = aIt->GetOpCode() == ocSep;
910  if( bRet ) rStringList += OUStringChar(cSep);
911  eState = (bRet && (++aIt).Is()) ? STATE_STR : STATE_END;
912  break;
913  default:;
914  }
915  return bRet;
916 }
917 
918 void XclTokenArrayHelper::ConvertStringToList(
919  ScTokenArray& rScTokArr, svl::SharedStringPool& rSPool, sal_Unicode cStringSep )
920 {
921  OUString aString;
922  if( !GetString( aString, rScTokArr ) )
923  return;
924 
925  rScTokArr.Clear();
926  if (aString.isEmpty())
927  return;
928  sal_Int32 nStringIx = 0;
929  for (;;)
930  {
931  OUString aToken( aString.getToken( 0, cStringSep, nStringIx ) );
932  rScTokArr.AddString(rSPool.intern(comphelper::string::stripStart(aToken, ' ')));
933  if (nStringIx<0)
934  break;
935  rScTokArr.AddOpCode( ocSep );
936  }
937 }
938 
939 // multiple operations --------------------------------------------------------
940 
941 namespace {
942 
943 bool lclGetAddress( const ScDocument& rDoc, ScAddress& rAddress, const FormulaToken& rToken, const ScAddress& rPos )
944 {
945  OpCode eOpCode = rToken.GetOpCode();
946  bool bIsSingleRef = (eOpCode == ocPush) && (rToken.GetType() == svSingleRef);
947  if( bIsSingleRef )
948  {
949  const ScSingleRefData& rRef = *rToken.GetSingleRef();
950  rAddress = rRef.toAbs(rDoc, rPos);
951  bIsSingleRef = !rRef.IsDeleted();
952  }
953  return bIsSingleRef;
954 }
955 
956 } // namespace
957 
958 bool XclTokenArrayHelper::GetMultipleOpRefs(
959  const ScDocument& rDoc,
960  XclMultipleOpRefs& rRefs, const ScTokenArray& rScTokArr, const ScAddress& rScPos )
961 {
962  rRefs.mbDblRefMode = false;
963  enum
964  {
965  stBegin, stTableOp, stOpen, stFormula, stFormulaSep,
966  stColFirst, stColFirstSep, stColRel, stColRelSep,
967  stRowFirst, stRowFirstSep, stRowRel, stClose, stError
968  } eState = stBegin; // last read token
969  for( XclTokenArrayIterator aIt( rScTokArr, true ); aIt.Is() && (eState != stError); ++aIt )
970  {
971  OpCode eOpCode = aIt->GetOpCode();
972  bool bIsSep = eOpCode == ocSep;
973  switch( eState )
974  {
975  case stBegin:
976  eState = (eOpCode == ocTableOp) ? stTableOp : stError;
977  break;
978  case stTableOp:
979  eState = (eOpCode == ocOpen) ? stOpen : stError;
980  break;
981  case stOpen:
982  eState = lclGetAddress(rDoc, rRefs.maFmlaScPos, *aIt, rScPos) ? stFormula : stError;
983  break;
984  case stFormula:
985  eState = bIsSep ? stFormulaSep : stError;
986  break;
987  case stFormulaSep:
988  eState = lclGetAddress(rDoc, rRefs.maColFirstScPos, *aIt, rScPos) ? stColFirst : stError;
989  break;
990  case stColFirst:
991  eState = bIsSep ? stColFirstSep : stError;
992  break;
993  case stColFirstSep:
994  eState = lclGetAddress(rDoc, rRefs.maColRelScPos, *aIt, rScPos) ? stColRel : stError;
995  break;
996  case stColRel:
997  eState = bIsSep ? stColRelSep : ((eOpCode == ocClose) ? stClose : stError);
998  break;
999  case stColRelSep:
1000  eState = lclGetAddress(rDoc, rRefs.maRowFirstScPos, *aIt, rScPos) ? stRowFirst : stError;
1001  rRefs.mbDblRefMode = true;
1002  break;
1003  case stRowFirst:
1004  eState = bIsSep ? stRowFirstSep : stError;
1005  break;
1006  case stRowFirstSep:
1007  eState = lclGetAddress(rDoc, rRefs.maRowRelScPos, *aIt, rScPos) ? stRowRel : stError;
1008  break;
1009  case stRowRel:
1010  eState = (eOpCode == ocClose) ? stClose : stError;
1011  break;
1012  default:
1013  eState = stError;
1014  }
1015  }
1016  return eState == stClose;
1017 }
1018 
1019 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
XclFunctionProvider::GetFuncInfoFromXclMacroName
const XclFunctionInfo * GetFuncInfoFromXclMacroName(const OUString &rXclMacroName) const
Returns the function data for an Excel function simulated by a macro call, or 0 on error...
Definition: xlformula.cxx:684
ocChoose
ocChoose
ocFloor_MS
ocFloor_MS
EXC_FUNCFLAG_VOLATILE
const sal_uInt8 EXC_FUNCFLAG_VOLATILE
Number of parameter info entries.
Definition: xlformula.hxx:288
ocDBCount
ocDBCount
ocProb
ocProb
ocStDevP
ocStDevP
ocN
ocN
svString
svString
ocWeeknumOOo
ocWeeknumOOo
ocVarPA
ocVarPA
ocSqrt
ocSqrt
ScfUInt8Vec
::std::vector< sal_uInt8 > ScfUInt8Vec
Definition: ftools.hxx:253
ocBitAnd
ocBitAnd
ocPermutationA
ocPermutationA
ocBinomDist
ocBinomDist
XclExpStream::Write
std::size_t Write(const void *pData, std::size_t nBytes)
Writes nBytes bytes from memory.
Definition: xestream.cxx:217
ocLeft
ocLeft
saFuncTable_Odf
const XclFunctionInfo saFuncTable_Odf[]
Functions defined by OpenFormula, but not supported by Calc (ocNoName) or by Excel (defined op-code)...
Definition: xlformula.cxx:601
XclFunctionProvider::GetFuncInfoFromXclFunc
const XclFunctionInfo * GetFuncInfoFromXclFunc(sal_uInt16 nXclFunc) const
Returns the function data for an Excel function index, or 0 on error.
Definition: xlformula.cxx:676
ocEven
ocEven
XclTokenArrayIterator::Is
bool Is() const
Definition: xlformula.hxx:448
XclBiff
XclBiff
An enumeration for all Excel file format types (BIFF types).
Definition: xlconst.hxx:29
ocHypGeomDist_MS
ocHypGeomDist_MS
ocCell
ocCell
svl::SharedStringPool::intern
SharedString intern(const OUString &rStr)
EXC_FUNCENTRY_V_VR
#define EXC_FUNCENTRY_V_VR(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:384
XclTokenArray::ReadSize
static sal_uInt16 ReadSize(XclImpStream &rStrm)
Reads the size field of the token array.
Definition: xlformula.cxx:741
ocConfidence_T
ocConfidence_T
XclMultipleOpRefs::maRowFirstScPos
ScAddress maRowFirstScPos
Definition: xlformula.hxx:473
ocRawSubtract
ocRawSubtract
ocLenB
ocLenB
ocErrorType_ODF
ocErrorType_ODF
ocSumSQ
ocSumSQ
V
const sal_uInt8 V
Definition: xlformula.cxx:51
ocArcCotHyp
ocArcCotHyp
XclExpStream
This class is used to export Excel record streams.
Definition: xestream.hxx:72
ocCosecantHyp
ocCosecantHyp
ocVar
ocVar
ocNetWorkdays
ocNetWorkdays
ocPi
ocPi
ocCeil_Precise
ocCeil_Precise
ocForecast_ETS_ADD
ocForecast_ETS_ADD
ocDevSq
ocDevSq
ocChiSqDist
ocChiSqDist
ScSingleRefData
Single reference (one address) into the sheet.
Definition: refdata.hxx:29
ocFixed
ocFixed
ocRank
ocRank
ocCos
ocCos
XclFunctionProvider::FillXclFuncMap
void FillXclFuncMap(const XclFunctionInfo *pBeg, const XclFunctionInfo *pEnd)
Definition: xlformula.cxx:700
ocPDuration
ocPDuration
ocTInv
ocTInv
EXC_TOKCLASS_REF
const sal_uInt8 EXC_TOKCLASS_REF
00-1F: Base tokens.
Definition: xlformula.hxx:43
ocNormInv_MS
ocNormInv_MS
ocUpper
ocUpper
ocGrowth
ocGrowth
ocCovarianceP
ocCovarianceP
ocWeek
ocWeek
ScSingleRefData::toAbs
ScAddress toAbs(const ScSheetLimits &rLimits, const ScAddress &rPos) const
Definition: refdata.cxx:193
ocPpmt
ocPpmt
ocDBMin
ocDBMin
ocErrorType
ocErrorType
ocWorkday_MS
ocWorkday_MS
ocIntercept
ocIntercept
ocGeoMean
ocGeoMean
EXC_FUNCFLAG_PARAMPAIRS
const sal_uInt8 EXC_FUNCFLAG_PARAMPAIRS
Only used in export filter.
Definition: xlformula.hxx:291
ocDBAverage
ocDBAverage
ocCurrent
ocCurrent
ocRept
ocRept
ocOffset
ocOffset
ocB
ocB
ocMatch
ocMatch
ocClean
ocClean
ocSubTotal
ocSubTotal
ocForecast_ETS_STM
ocForecast_ETS_STM
ocOpen
ocOpen
ocEncodeURL
ocEncodeURL
ocCosecant
ocCosecant
XclImpStream::Read
std::size_t Read(void *pData, std::size_t nBytes)
Reads nBytes bytes to the existing(!) buffer pData.
Definition: xistream.cxx:721
NOID
const sal_uInt16 NOID
Definition: xlformula.cxx:68
ocGetActTime
ocGetActTime
XclFunctionInfo::IsMacroFunc
bool IsMacroFunc() const
Returns true, if the function is simulated by a macro call.
Definition: xlformula.hxx:332
ocDBSum
ocDBSum
XclTokenArrayHelper::GetStringList
static bool GetStringList(OUString &rStringList, const ScTokenArray &rScTokArr, sal_Unicode cSep)
Parses the passed formula and tries to find a string token list, i.e.
Definition: xlformula.cxx:890
ocExp
ocExp
ocIfNA
ocIfNA
ocBackSolver
ocBackSolver
ocSLN
ocSLN
ocType
ocType
EXC_TOKCLASS_ARR
const sal_uInt8 EXC_TOKCLASS_ARR
40-5F: Value class tokens.
Definition: xlformula.hxx:45
XclTokenArrayHelper::GetTokenString
static bool GetTokenString(OUString &rString, const ::formula::FormulaToken &rScToken)
Tries to extract a string from the passed token.
Definition: xlformula.cxx:876
ocTrend
ocTrend
ocLogNormDist
ocLogNormDist
ocFInv_LT
ocFInv_LT
ocLogNormDist_MS
ocLogNormDist_MS
ocGetSec
ocGetSec
ocPV
ocPV
ocProduct
ocProduct
ocConvertOOo
ocConvertOOo
XclTokenArray::GetSize
sal_uInt16 GetSize() const
Returns the size of the token array in bytes.
Definition: xlformula.cxx:735
formula::FormulaToken::GetOpCode
OpCode GetOpCode() const
XclTokenArray::Write
void Write(XclExpStream &rStrm) const
Writes size field and the tokens.
Definition: xlformula.cxx:789
ocPearson
ocPearson
limit_cast
ReturnType limit_cast(Type nValue, ReturnType nMin, ReturnType nMax)
Returns the value, if it is not less than nMin and not greater than nMax, otherwise one of the limits...
Definition: ftools.hxx:63
ocErfc_MS
ocErfc_MS
EXC_FUNCENTRY_OOO
#define EXC_FUNCENTRY_OOO(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:609
ocChiDist_MS
ocChiDist_MS
ocIsString
ocIsString
ocQuartile
ocQuartile
ocDBGet
ocDBGet
ocSpaces
ocSpaces
ocCount
ocCount
ocChiInv
ocChiInv
EXC_FUNCENTRY_V_VA
#define EXC_FUNCENTRY_V_VA(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:427
ocRad
ocRad
ocMin
ocMin
ocChiTest_MS
ocChiTest_MS
ocVBD
ocVBD
ocGauss
ocGauss
ocModalValue_MS
ocModalValue_MS
ocText
ocText
ocSinHyp
ocSinHyp
EXC_FUNCENTRY_OOO_IBR
#define EXC_FUNCENTRY_OOO_IBR(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:614
ocRoman
ocRoman
ocLookup
ocLookup
XclTokenArray::WriteSize
void WriteSize(XclExpStream &rStrm) const
Writes the size field of the token array.
Definition: xlformula.cxx:776
ocAddress
ocAddress
ocCount2
ocCount2
ocUnichar
ocUnichar
EXC_FUNCFLAG_IMPORTONLY
const sal_uInt8 EXC_FUNCFLAG_IMPORTONLY
Result is volatile (e.g. NOW() function).
Definition: xlformula.hxx:289
ocRow
ocRow
ocGetPivotData
ocGetPivotData
ocFInv
ocFInv
ocSTEYX
ocSTEYX
ocRegex
ocRegex
ocIf
ocIf
ocLogInv
ocLogInv
XclTokenArray::ReadArray
void ReadArray(sal_uInt16 nSize, XclImpStream &rStrm)
Reads the tokens of the token array (without size field).
Definition: xlformula.cxx:746
ScSingleRefData::IsDeleted
bool IsDeleted() const
Definition: refdata.cxx:125
ocLogest
ocLogest
ocGetTimeValue
ocGetTimeValue
ocGammaDist
ocGammaDist
ocQuartile_Exc
ocQuartile_Exc
ocSYD
ocSYD
ocCumIpmt
ocCumIpmt
ocGammaInv
ocGammaInv
ocFisherInv
ocFisherInv
ocLower
ocLower
A
const sal_uInt8 A
Definition: xlformula.cxx:52
ocHLookup
ocHLookup
ScTokenArray::Clear
virtual void Clear() override
Definition: token.cxx:1905
ocStDevS
ocStDevS
sal_Unicode
sal_uInt16 sal_Unicode
ocIndex
ocIndex
ocForecast_ETS_STA
ocForecast_ETS_STA
ocPhi
ocPhi
ocGammaInv_MS
ocGammaInv_MS
ocForecast_LIN
ocForecast_LIN
ocDBProduct
ocDBProduct
VR_E
#define VR_E
Definition: xlformula.cxx:65
VX
#define VX
Definition: xlformula.cxx:63
ocMaxIfs_MS
ocMaxIfs_MS
saFuncTable_8
const XclFunctionInfo saFuncTable_8[]
Functions new in BIFF8.
Definition: xlformula.cxx:367
ocMinIfs_MS
ocMinIfs_MS
operator>>
XclImpStream & operator>>(XclImpStream &rStrm, XclTokenArray &rTokArr)
Calls the Read() function at the passed token array.
Definition: xlformula.cxx:800
ocChiSqDist_MS
ocChiSqDist_MS
ocRSQ
ocRSQ
ocCeil_ISO
ocCeil_ISO
EXC_BIFF5
MS Excel 4.0.
Definition: xlconst.hxx:34
SAL_MAX_UINT16
#define SAL_MAX_UINT16
ocBetaDist
ocBetaDist
ocRound
ocRound
XclMultipleOpRefs::maFmlaScPos
ScAddress maFmlaScPos
Definition: xlformula.hxx:470
ocGetMin
ocGetMin
OpCode
OpCode
ocSumProduct
ocSumProduct
ocAbs
ocAbs
ocStDevA
ocStDevA
ocForecast
ocForecast
XclTokenArray::WriteArray
void WriteArray(XclExpStream &rStrm) const
Writes the tokens of the token array (without size field).
Definition: xlformula.cxx:781
ocWeibull
ocWeibull
ocIsoWeeknum
ocIsoWeeknum
ocVarP_MS
ocVarP_MS
ocGetTime
ocGetTime
ocSNormInv
ocSNormInv
ocFInv_RT
ocFInv_RT
ocIsOdd
ocIsOdd
ocSearch
ocSearch
ocArabic
ocArabic
ocReplace
ocReplace
EXC_FUNCFLAG_ADDINEQUIV
const sal_uInt8 EXC_FUNCFLAG_ADDINEQUIV
Optional parameters are expected to appear in pairs.
Definition: xlformula.hxx:292
ocIsValue
ocIsValue
ocNot
ocNot
ocSearchB
ocSearchB
ocFrequency
ocFrequency
VV
#define VV
Definition: xlformula.cxx:60
XclMultipleOpRefs::maColRelScPos
ScAddress maColRelScPos
Definition: xlformula.hxx:472
ocGetDay
ocGetDay
ocMid
ocMid
ocBinomDist_MS
ocBinomDist_MS
ocMedian
ocMedian
ocConfidence_N
ocConfidence_N
EXC_FUNCNAME
#define EXC_FUNCNAME(ascii)
Maximum parameter count.
Definition: xlformula.cxx:71
ocTrim
ocTrim
ocCot
ocCot
ocCorrel
ocCorrel
ocCode
ocCode
ocBitLshift
ocBitLshift
ocFTest_MS
ocFTest_MS
ocT
ocT
ocIfError
ocIfError
ocGammaDist_MS
ocGammaDist_MS
ocCovarianceS
ocCovarianceS
XclFunctionProvider::maXclMacroNameMap
XclMacroNameMap maXclMacroNameMap
Maps Excel function indexes to function data.
Definition: xlformula.hxx:366
ocDDB
ocDDB
XclTokenArrayIterator::mbSkipSpaces
bool mbSkipSpaces
Pointer to current token pointer of token array.
Definition: xlformula.hxx:464
ocColumns
ocColumns
formula::FormulaTokenArray::GetLen
sal_uInt16 GetLen() const
ocLinest
ocLinest
saFuncTable_OOoLO
const XclFunctionInfo saFuncTable_OOoLO[]
Functions defined by Calc, but not in OpenFormula nor supported by Excel.
Definition: xlformula.cxx:618
MX
const sal_uInt8 MX
No BIFF/OOBIN function identifier available.
Definition: xlformula.cxx:69
ocFourier
ocFourier
RA
#define RA
Definition: xlformula.cxx:56
XclTokenArrayIterator::mppScTokenEnd
const ::formula::FormulaToken *const * mppScTokenEnd
Pointer to first token pointer of token array.
Definition: xlformula.hxx:462
ocSep
ocSep
VO
#define VO
Definition: xlformula.cxx:59
ocFloor_Math
ocFloor_Math
SAL_N_ELEMENTS
#define SAL_N_ELEMENTS(arr)
ocVarP
ocVarP
ocCurrency
ocCurrency
ocRank_Avg
ocRank_Avg
ocPercentrank_Exc
ocPercentrank_Exc
ocInfo
ocInfo
EXC_FUNCFLAG_EXPORTONLY
const sal_uInt8 EXC_FUNCFLAG_EXPORTONLY
Only used in import filter.
Definition: xlformula.hxx:290
ocIsNonString
ocIsNonString
ocChiTest
ocChiTest
ocSumIfs
ocSumIfs
ocArcTanHyp
ocArcTanHyp
ocHypGeomDist
ocHypGeomDist
ocPercentile_Inc
ocPercentile_Inc
ocFisher
ocFisher
ocSumX2MY2
ocSumX2MY2
ocEffect
ocEffect
ocDBMax
ocDBMax
ocAverageA
ocAverageA
ocPower
ocPower
ocNormInv
ocNormInv
EXC_BIFF8
MS Excel 5.0, MS Excel 7.0 (95)
Definition: xlconst.hxx:35
ocChiSqInv_MS
ocChiSqInv_MS
ocBitOr
ocBitOr
ocBinomInv
ocBinomInv
XclFunctionInfo
Represents information for a spreadsheet function for import and export.
Definition: xlformula.hxx:310
ocFTest
ocFTest
ocFind
ocFind
o3tl::sanitizing_min
T sanitizing_min(T a, T b)
ocArcCos
ocArcCos
ocLog
ocLog
ocFV
ocFV
XclFunctionInfo::GetAddInEquivalentFuncName
OUString GetAddInEquivalentFuncName() const
Returns the programmatical name of the Add-In function as string.
Definition: xlformula.cxx:42
ocPlusMinus
ocPlusMinus
saFuncTable_3
const XclFunctionInfo saFuncTable_3[]
Functions new in BIFF3.
Definition: xlformula.cxx:226
ocWeibull_MS
ocWeibull_MS
ocSkew
ocSkew
ocTDist_MS
ocTDist_MS
ocChiInv_MS
ocChiInv_MS
ocNPV
ocNPV
ocTableOp
ocTableOp
EXC_FUNCENTRY_A_VR
#define EXC_FUNCENTRY_A_VR(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:414
ocMatDet
ocMatDet
ocColor
ocColor
ocCosHyp
ocCosHyp
ocArcCosHyp
ocArcCosHyp
ocPercentile
ocPercentile
ocQuartile_Inc
ocQuartile_Inc
ocPercentrank
ocPercentrank
XclFunctionProvider::GetFuncInfoFromOpCode
const XclFunctionInfo * GetFuncInfoFromOpCode(OpCode eOpCode) const
Returns the function data for a Calc opcode, or 0 on error.
Definition: xlformula.cxx:692
ocMatInv
ocMatInv
ocSheet
ocSheet
XclTokenArray::maExtDataVec
ScfUInt8Vec maExtDataVec
Byte vector containing token data.
Definition: xlformula.hxx:412
ocGetMonth
ocGetMonth
ocDBVar
ocDBVar
ocErf_MS
ocErf_MS
ocPush
ocPush
ocStyle
ocStyle
XclFunctionProvider::maScFuncMap
ScFuncMap maScFuncMap
Maps macro function names to function data.
Definition: xlformula.hxx:367
ocTDist
ocTDist
ocRank_Eq
ocRank_Eq
VR
#define VR
Definition: xlformula.cxx:62
ocForecast_ETS_PIM
ocForecast_ETS_PIM
ocRoundSig
ocRoundSig
ocSecantHyp
ocSecantHyp
ocFloor
ocFloor
ocPoissonDist
ocPoissonDist
ocMIRR
ocMIRR
XclTokenArray::XclTokenArray
XclTokenArray(bool bVolatile=false)
Creates an empty token array.
Definition: xlformula.cxx:723
ocSlope
ocSlope
ocNotAvail
ocNotAvail
ocExternal
ocExternal
ocAverageIfs
ocAverageIfs
ocMaxA
ocMaxA
get_flag
bool get_flag(Type nBitField, Type nMask)
Returns true, if at least one of the bits set in nMask is set in nBitField.
Definition: ftools.hxx:75
ocIsFormula
ocIsFormula
ocLog10
ocLog10
ocAreas
ocAreas
EXC_BIFF4
MS Excel 3.0.
Definition: xlconst.hxx:33
ocBetaDist_MS
ocBetaDist_MS
ocSubstitute
ocSubstitute
formula::FormulaTokenArray::GetArray
FormulaToken ** GetArray() const
ocCeil
ocCeil
ocLCM
ocLCM
ocMax
ocMax
ocGetDate
ocGetDate
ocLogInv_MS
ocLogInv_MS
ocInt
ocInt
ocHyperLink
ocHyperLink
ocForecast_ETS_PIA
ocForecast_ETS_PIA
ocExpDist_MS
ocExpDist_MS
ocForecast_ETS_MUL
ocForecast_ETS_MUL
saFuncTable_2010
const XclFunctionInfo saFuncTable_2010[]
Functions new in Excel 2010.
Definition: xlformula.cxx:438
ocDBStdDevP
ocDBStdDevP
ocSkewp
ocSkewp
ocNormDist_MS
ocNormDist_MS
ocSin
ocSin
ocSwitch_MS
ocSwitch_MS
ocRows
ocRows
ocCumPrinc
ocCumPrinc
ocGetDateDif
ocGetDateDif
ocVarS
ocVarS
ocChar
ocChar
EXC_FUNCENTRY_ODF
#define EXC_FUNCENTRY_ODF(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:596
ocVLookup
ocVLookup
ocCritBinom
ocCritBinom
ocRate
ocRate
XclFunctionProvider::FillScFuncMap
void FillScFuncMap(const XclFunctionInfo *pBeg, const XclFunctionInfo *pEnd)
Definition: xlformula.cxx:714
XclFunctionInfo::mpcMacroName
const char * mpcMacroName
Additional flags (EXC_FUNCFLAG_* constants).
Definition: xlformula.hxx:319
XclImpStream::ReaduInt16
sal_uInt16 ReaduInt16()
Definition: xistream.cxx:649
ocGetDateValue
ocGetDateValue
XclTokenArrayRef
std::shared_ptr< XclTokenArray > XclTokenArrayRef
Definition: xlformula.hxx:416
XclFunctionProvider
Provides access to function info structs for all available functions.
Definition: xlformula.hxx:344
svSingleRef
svSingleRef
ocPoissonDist_MS
ocPoissonDist_MS
ocIsEmpty
ocIsEmpty
ocTTest_MS
ocTTest_MS
ocCountEmptyCells
ocCountEmptyCells
ocChiDist
ocChiDist
ocFalse
ocFalse
ocNegBinomVert
ocNegBinomVert
RX
#define RX
Definition: xlformula.cxx:58
ocSumIf
ocSumIf
EXC_TOKCLASS_VAL
const sal_uInt8 EXC_TOKCLASS_VAL
20-3F: Reference class tokens.
Definition: xlformula.hxx:44
ocGetHour
ocGetHour
ocWebservice
ocWebservice
ocMatMult
ocMatMult
ocLarge
ocLarge
ocVarA
ocVarA
ocIsError
ocIsError
ocISPMT
ocISPMT
ocDBCount2
ocDBCount2
ocBetaInv
ocBetaInv
ocOdd
ocOdd
ocIndirect
ocIndirect
ocIsLogical
ocIsLogical
ocOr
ocOr
ScTokenArray::AddOpCode
virtual formula::FormulaToken * AddOpCode(OpCode eCode) override
Definition: token.cxx:2187
ocNumberValue
ocNumberValue
ocBitRshift
ocBitRshift
ocIsRef
ocIsRef
XclTokenArrayIterator::operator++
XclTokenArrayIterator & operator++()
Definition: xlformula.cxx:853
XclTokenArray
Binary representation of an Excel token array.
Definition: xlformula.hxx:376
ocCotHyp
ocCotHyp
ocFloor_Precise
ocFloor_Precise
ocTrue
ocTrue
ocNetWorkdays_MS
ocNetWorkdays_MS
ocFact
ocFact
ocMatrixUnit
ocMatrixUnit
ocRandomNV
ocRandomNV
ocMidB
ocMidB
ocMultiArea
ocMultiArea
ocCombin
ocCombin
ocSheets
ocSheets
ocRoundUp
ocRoundUp
XclMultipleOpRefs
Contains all cell references that can be extracted from a multiple operations formula.
Definition: xlformula.hxx:468
ocStDevPA
ocStDevPA
ocPercentrank_Inc
ocPercentrank_Inc
ocNoName
ocNoName
C
#define C
Definition: xlformula.cxx:66
ocSumX2DY2
ocSumX2DY2
saFuncTable_4
const XclFunctionInfo saFuncTable_4[]
Functions new in BIFF4.
Definition: xlformula.cxx:254
ocArcTan
ocArcTan
ocForecast_ETS_SEA
ocForecast_ETS_SEA
RO
#define RO
Definition: xlformula.cxx:55
ocDB
ocDB
ocAverage
ocAverage
ocHarMean
ocHarMean
ocMod
ocMod
EXC_FUNCENTRY_V_RO_EXPORT
#define EXC_FUNCENTRY_V_RO_EXPORT(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:411
ocStDevP_MS
ocStDevP_MS
formula::FormulaTokenArray::AddString
FormulaToken * AddString(const svl::SharedString &rStr)
ocAggregate
ocAggregate
ocRightB
ocRightB
ocEasterSunday
ocEasterSunday
ocFindB
ocFindB
sal_uInt8
unsigned char sal_uInt8
comphelper::string::stripStart
OString stripStart(std::string_view rIn, char c)
ocRandom
ocRandom
XclMultipleOpRefs::maRowRelScPos
ScAddress maRowRelScPos
Definition: xlformula.hxx:474
ocDBVarP
ocDBVarP
ocEuroConvert
ocEuroConvert
ocArcSin
ocArcSin
ocTrimMean
ocTrimMean
ocNper
ocNper
XclTokenArrayIterator::mppScToken
const ::formula::FormulaToken *const * mppScToken
Pointer behind last token pointer of token array.
Definition: xlformula.hxx:463
XclTokenArray::Read
void Read(XclImpStream &rStrm)
Reads size field and the tokens.
Definition: xlformula.cxx:771
saFuncTable_2
const XclFunctionInfo saFuncTable_2[]
Functions new in BIFF2.
Definition: xlformula.cxx:76
ocSNormInv_MS
ocSNormInv_MS
ocAnd
ocAnd
ocRandbetweenNV
ocRandbetweenNV
ocConcat_MS
ocConcat_MS
RR
#define RR
Definition: xlformula.cxx:57
ocArcCot
ocArcCot
ocJis
ocJis
ocLn
ocLn
ocStdNormDist
ocStdNormDist
ocMatTrans
ocMatTrans
ocPercentile_Exc
ocPercentile_Exc
ocAsc
ocAsc
ocCountIfs
ocCountIfs
ocZTest_MS
ocZTest_MS
ocGetActDate
ocGetActDate
saFuncTable_2013
const XclFunctionInfo saFuncTable_2013[]
Functions new in Excel 2013.
Definition: xlformula.cxx:517
ocSmall
ocSmall
ocModalValue_Multi
ocModalValue_Multi
ocFilterXML
ocFilterXML
ocGammaLn
ocGammaLn
ocRoundDown
ocRoundDown
EXC_FUNCNAME_ADDIN
#define EXC_FUNCNAME_ADDIN(ascii)
Definition: xlformula.cxx:73
XclRoot::GetBiff
XclBiff GetBiff() const
Returns the current BIFF version of the importer/exporter.
Definition: xlroot.hxx:140
ocRRI
ocRRI
ocBahtText
ocBahtText
ocBitXor
ocBitXor
ocSumXMY2
ocSumXMY2
ocStandard
ocStandard
EXC_FUNCENTRY_V_VR_IMPORT
#define EXC_FUNCENTRY_V_VR_IMPORT(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:408
ocCeil_MS
ocCeil_MS
ocGammaLn_MS
ocGammaLn_MS
ocAveDev
ocAveDev
ocTextJoin_MS
ocTextJoin_MS
ocNegBinomDist_MS
ocNegBinomDist_MS
ocFDist_LT
ocFDist_LT
XclTokenArray::operator==
bool operator==(const XclTokenArray &rTokArr) const
Compares this token array with the passed.
Definition: xlformula.cxx:795
EXC_FUNCENTRY_V_RO
#define EXC_FUNCENTRY_V_RO(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:418
XclTokenArrayHelper::ConvertStringToList
static void ConvertStringToList(ScTokenArray &rScTokArr, svl::SharedStringPool &rSPool, sal_Unicode cStringSep)
Tries to convert a formula that consists of a single string token to a list of strings.
Definition: xlformula.cxx:918
ocGamma
ocGamma
ocTInv_MS
ocTInv_MS
ocFormula
ocFormula
ocTrunc
ocTrunc
ocMacro
ocMacro
XclTokenArrayHelper::GetString
static bool GetString(OUString &rString, const ScTokenArray &rScTokArr)
Parses the passed formula and tries to find a single string token, i.e.
Definition: xlformula.cxx:883
ocFDist_RT
ocFDist_RT
RO_E
#define RO_E
Definition: xlformula.cxx:64
ocIRR
ocIRR
ocCeil_Math
ocCeil_Math
ocNormDist
ocNormDist
ocSecant
ocSecant
XclRoot::IsImport
bool IsImport() const
Returns true, if currently a document is imported.
Definition: xlroot.hxx:144
ocDecimal
ocDecimal
ocGetDiffDate360
ocGetDiffDate360
ocPMT
ocPMT
ocDeg
ocDeg
ocFDist
ocFDist
ocPermut
ocPermut
ocTanHyp
ocTanHyp
ocBetaInv_MS
ocBetaInv_MS
ocGetYear
ocGetYear
ocBase
ocBase
ocValue
ocValue
ocChiSqInv
ocChiSqInv
ocConcat
ocConcat
ocConfidence
ocConfidence
EXC_BIFF3
MS Excel 2.1.
Definition: xlconst.hxx:32
XclImpStream
This class is used to import record oriented streams.
Definition: xistream.hxx:277
XclTokenArrayIterator::Init
void Init(const ScTokenArray &rScTokArr, bool bSkipSpaces)
Definition: xlformula.cxx:843
ocIpmt
ocIpmt
ocIfs_MS
ocIfs_MS
VA
#define VA
Definition: xlformula.cxx:61
ocCovar
ocCovar
ocTTest
ocTTest
XclFunctionInfo::IsAddInEquivalent
bool IsAddInEquivalent() const
Returns true, if the function is stored as an add-in call.
Definition: xlformula.hxx:334
ocAverageIf
ocAverageIf
ocCountIf
ocCountIf
ocIsEven
ocIsEven
ocRight
ocRight
XclFunctionProvider::maXclFuncMap
XclFuncMap maXclFuncMap
Definition: xlformula.hxx:365
ocTDist_RT
ocTDist_RT
ocTDist_2T
ocTDist_2T
ocGCD
ocGCD
ocIsNA
ocIsNA
saFuncTable_Oox
const XclFunctionInfo saFuncTable_Oox[]
Functions new in OOXML.
Definition: xlformula.cxx:389
ocNominal
ocNominal
ocKurt
ocKurt
ocXor
ocXor
ocTan
ocTan
XclTokenArrayIterator
Special token array iterator for the Excel filters.
Definition: xlformula.hxx:438
XclTokenArrayIterator::mppScTokenBeg
const ::formula::FormulaToken *const * mppScTokenBeg
Definition: xlformula.hxx:461
saFuncTable_5
const XclFunctionInfo saFuncTable_5[]
Functions new in BIFF5/BIFF7.
Definition: xlformula.cxx:343
ocZTest
ocZTest
XclRoot
Access to global data for a filter object (imported or exported document) from other classes...
Definition: xlroot.hxx:126
ocModalValue
ocModalValue
ocDBStdDev
ocDBStdDev
XclTokenArray::mbVolatile
bool mbVolatile
Byte vector containing extended data (arrays, stacked NLRs).
Definition: xlformula.hxx:413
XclFunctionProvider::XclFunctionProvider
XclFunctionProvider(const XclRoot &rRoot)
Definition: xlformula.cxx:649
ocIsErr
ocIsErr
XclTokenArray::maTokVec
ScfUInt8Vec maTokVec
Definition: xlformula.hxx:411
ocLeftB
ocLeftB
ocClose
ocClose
ocReplaceB
ocReplaceB
ocCombinA
ocCombinA
XclTokenArrayHelper::GetMultipleOpRefs
static bool GetMultipleOpRefs(const ScDocument &rDoc, XclMultipleOpRefs &rRefs, const ScTokenArray &rScTokArr, const ScAddress &rScPos)
Parses the passed formula and tries to extract references of a multiple operation.
Definition: xlformula.cxx:958
ocUnicode
ocUnicode
ocLen
ocLen
saFuncTable_2016
const XclFunctionInfo saFuncTable_2016[]
Functions new in Excel 2016.
Definition: xlformula.cxx:581
ocMinA
ocMinA
EXC_FUNCENTRY_V_RX
#define EXC_FUNCENTRY_V_RX(opcode, minparam, maxparam, flags, asciiname)
Definition: xlformula.cxx:423
XclMultipleOpRefs::maColFirstScPos
ScAddress maColFirstScPos
Position of the (first) formula cell.
Definition: xlformula.hxx:471
operator<<
XclExpStream & operator<<(XclExpStream &rStrm, const XclTokenArray &rTokArr)
Calls the Write() function at the passed token array.
Definition: xlformula.cxx:806
ocExpDist
ocExpDist
XclFunctionInfo::GetMacroFuncName
OUString GetMacroFuncName() const
Returns the name of the external function as string.
Definition: xlformula.cxx:35
ocColumn
ocColumn
ocTInv_2T
ocTInv_2T
ocStDev
ocStDev
R
const sal_uInt8 R
Definition: xlformula.cxx:50
ocGetDiffDate
ocGetDiffDate
ocArcTan2
ocArcTan2
ocSum
ocSum
ocExact
ocExact
ocArcSinHyp
ocArcSinHyp
ocGetDayOfWeek
ocGetDayOfWeek
void
typedef void(CALLTYPE *GetFuncDataPtr)(sal_uInt16 &nNo
ocStdNormDist_MS
ocStdNormDist_MS
ocProper
ocProper
Generated on Fri Jul 23 2021 18:17:27 for LibreOffice Module sc (master) by   doxygen 1.8.10