LibreOffice Module sc (master)  1
funcdesc.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 <funcdesc.hxx>
21 
22 #include <addincol.hxx>
23 #include <appoptio.hxx>
24 #include <callform.hxx>
25 #include <compiler.hxx>
26 #include <compiler.hrc>
27 #include <global.hxx>
28 #include <scfuncs.hrc>
29 #include <scmod.hxx>
30 #include <scresid.hxx>
31 #include <helpids.h>
32 
33 #include <rtl/ustring.hxx>
34 #include <rtl/ustrbuf.hxx>
35 #include <unotools/collatorwrapper.hxx>
36 #include <formula/funcvarargs.h>
37 #include <osl/diagnose.h>
38 
39 #include <memory>
40 
41 namespace {
42 
43 struct ScFuncDescCore
44 {
45  /*
46  * An opcode from include/formula/compiler.hxx
47  */
48  sal_uInt16 nOpCode;
49  /*
50  * Pointer to list of strings
51  */
52  const TranslateId* pResource;
53  /*
54  * Count of list of strings
55  */
56  size_t nResourceLen;
57  /*
58  * 16-bit value:
59  *
60  * Bit 1: boolean flag whether function is suppressed. Usually 0. This
61  * may be used to add UI string resources before UI freeze if
62  * implementation isn't ready yet without displaying them in the
63  * function wizard, most recent used list and other UI elements. Also
64  * not available via API then.
65  *
66  * Bit 2: boolean flag whether function is hidden in the Function
67  * Wizard unless used in an expression.
68  */
69  sal_uInt16 nFunctionFlags;
70  /*
71  * Function group (text, math, ...), one of ID_FUNCTION_GRP_...
72  */
73  sal_uInt16 nCategory;
74  /*
75  * Help ID, HID_FUNC_...
76  */
77  const char* pHelpId;
78  /*
79  * Number of parameters. VAR_ARGS if variable number, or
80  * VAR_ARGS+number if number of fixed parameters and variable
81  * arguments following. Or PAIRED_VAR_ARGS if variable number of
82  * paired parameters, or PAIRED_VAR_ARGS+number if number of fixed
83  * parameters and variable paired arguments following.
84  */
85  sal_uInt16 nArgs;
86  /*
87  * For every parameter:
88  * Boolean flag whether the parameter is optional.
89  */
90  sal_uInt8 aOptionalArgs[7];
91  /*
92  * Limited number of maximum (variable) parameters, or 0 if no specific
93  * limit other than the general VAR_ARGS-1 value.
94  */
95  sal_uInt16 nVarArgsLimit;
96 };
97 
98 }
99 
100 static void ScFuncRes(const ScFuncDescCore &rEntry, ScFuncDesc*, bool& rbSuppressed);
101 
102 ScFuncDesc::ScFuncDesc() :
103  pDefArgFlags (nullptr),
104  nFIndex (0),
105  nCategory (0),
106  nArgCount (0),
107  nVarArgsStart (0),
108  nVarArgsLimit (0),
109  bIncomplete (false),
110  mbHidden (false)
111 {}
112 
113 ScFuncDesc::~ScFuncDesc()
114 {
115  Clear();
116 }
117 
118 void ScFuncDesc::Clear()
119 {
120  sal_uInt16 nArgs = nArgCount;
121  if (nArgs >= PAIRED_VAR_ARGS)
122  nArgs -= PAIRED_VAR_ARGS - 2;
123  else if (nArgs >= VAR_ARGS)
124  nArgs -= VAR_ARGS - 1;
125  if (nArgs)
126  {
127  delete [] pDefArgFlags;
128  }
129  nArgCount = 0;
130  nVarArgsStart = 0;
131  nVarArgsLimit = 0;
132  maDefArgNames.clear();
133  maDefArgDescs.clear();
134  pDefArgFlags = nullptr;
135 
136  mxFuncName.reset();
137  mxFuncDesc.reset();
138 
139  nFIndex = 0;
140  nCategory = 0;
141  sHelpId.clear();
142  bIncomplete = false;
143  mbHidden = false;
144 }
145 
146 OUString ScFuncDesc::GetParamList() const
147 {
148  OUString sep(ScCompiler::GetNativeSymbol(ocSep));
149 
150  OUStringBuffer aSig;
151 
152  if ( nArgCount > 0 )
153  {
154  if ( nArgCount < VAR_ARGS )
155  {
156  sal_uInt16 nLastSuppressed = nArgCount;
157  sal_uInt16 nLastAdded = nArgCount;
158  for ( sal_uInt16 i=0; i<nArgCount; i++ )
159  {
160  nLastAdded = i;
161  aSig.append(maDefArgNames[i]);
162  if ( i != nArgCount-1 )
163  {
164  aSig.append(sep);
165  aSig.append( " " );
166  }
167  }
168  // If only suppressed parameters follow the last added parameter,
169  // remove one "; "
170  if (nLastSuppressed < nArgCount && nLastAdded < nLastSuppressed &&
171  aSig.getLength() >= 2)
172  aSig.setLength(aSig.getLength() - 2);
173  }
174  else if ( nArgCount < PAIRED_VAR_ARGS)
175  {
176  for ( sal_uInt16 nArg = 0; nArg < nVarArgsStart; nArg++ )
177  {
178  aSig.append(maDefArgNames[nArg]);
179  aSig.append(sep);
180  aSig.append( " " );
181  }
182  /* NOTE: Currently there are no suppressed var args parameters. If
183  * there were, we'd have to cope with it here and above for the fix
184  * parameters. For now parameters are always added, so no special
185  * treatment of a trailing "; " necessary. */
186  aSig.append(maDefArgNames[nVarArgsStart]);
187  aSig.append('1');
188  aSig.append(sep);
189  aSig.append(' ');
190  aSig.append(maDefArgNames[nVarArgsStart]);
191  aSig.append('2');
192  aSig.append(sep);
193  aSig.append(" ... ");
194  }
195  else
196  {
197  for ( sal_uInt16 nArg = 0; nArg < nVarArgsStart; nArg++ )
198  {
199  aSig.append(maDefArgNames[nArg]);
200  aSig.append(sep);
201  aSig.append( " " );
202  }
203 
204  aSig.append(maDefArgNames[nVarArgsStart]);
205  aSig.append('1');
206  aSig.append(sep);
207  aSig.append(maDefArgNames[nVarArgsStart+1]);
208  aSig.append('1');
209  aSig.append(sep);
210  aSig.append( " " );
211  aSig.append(maDefArgNames[nVarArgsStart]);
212  aSig.append('2');
213  aSig.append(sep);
214  aSig.append(maDefArgNames[nVarArgsStart+1]);
215  aSig.append('2');
216  aSig.append(sep);
217  aSig.append( " ... " );
218  }
219  }
220 
221  return aSig.makeStringAndClear();
222 }
223 
224 OUString ScFuncDesc::getSignature() const
225 {
226  OUStringBuffer aSig;
227 
228  if(mxFuncName)
229  {
230  aSig.append(*mxFuncName);
231 
232  OUString aParamList = GetParamList();
233  if( !aParamList.isEmpty() )
234  {
235  aSig.append( "( " );
236  aSig.append(aParamList);
237  // U+00A0 (NBSP) prevents automatic line break
238  aSig.append( u'\x00A0' );
239  aSig.append( ")" );
240  }
241  else
242  aSig.append( "()" );
243  }
244  return aSig.makeStringAndClear();
245 }
246 
247 OUString ScFuncDesc::getFormula( const ::std::vector< OUString >& _aArguments ) const
248 {
249  OUString sep = ScCompiler::GetNativeSymbol(ocSep);
250 
251  OUStringBuffer aFormula;
252 
253  if(mxFuncName)
254  {
255  aFormula.append( *mxFuncName );
256 
257  aFormula.append( "(" );
258  if ( nArgCount > 0 && !_aArguments.empty() && !_aArguments[0].isEmpty())
259  {
260  ::std::vector< OUString >::const_iterator aIter = _aArguments.begin();
261  ::std::vector< OUString >::const_iterator aEnd = _aArguments.end();
262 
263  aFormula.append( *aIter );
264  ++aIter;
265  while( aIter != aEnd && !aIter->isEmpty() )
266  {
267  aFormula.append( sep );
268  aFormula.append( *aIter );
269  ++aIter;
270  }
271  }
272 
273  aFormula.append( ")" );
274  }
275  return aFormula.makeStringAndClear();
276 }
277 
278 sal_uInt16 ScFuncDesc::GetSuppressedArgCount() const
279 {
280  return nArgCount;
281 }
282 
283 OUString ScFuncDesc::getFunctionName() const
284 {
285  OUString sRet;
286  if ( mxFuncName )
287  sRet = *mxFuncName;
288  return sRet;
289 }
290 
291 const formula::IFunctionCategory* ScFuncDesc::getCategory() const
292 {
293  return ScGlobal::GetStarCalcFunctionMgr()->getCategory(nCategory - 1);
294 }
295 
296 OUString ScFuncDesc::getDescription() const
297 {
298  OUString sRet;
299  if ( mxFuncDesc )
300  sRet = *mxFuncDesc;
301  return sRet;
302 }
303 
304 sal_Int32 ScFuncDesc::getSuppressedArgumentCount() const
305 {
306  return GetSuppressedArgCount();
307 }
308 
309 void ScFuncDesc::fillVisibleArgumentMapping(::std::vector<sal_uInt16>& _rArguments) const
310 {
311  _rArguments.resize( nArgCount);
312  sal_uInt16 value = 0;
313  for (auto & argument : _rArguments)
314  argument = value++;
315 
316  sal_uInt16 nArgs = nArgCount;
317  if (nArgs >= PAIRED_VAR_ARGS)
318  nArgs -= PAIRED_VAR_ARGS - 2;
319  else if (nArgs >= VAR_ARGS)
320  nArgs -= VAR_ARGS - 1;
321  for (sal_uInt16 i=0; i < nArgs; ++i)
322  {
323  _rArguments.push_back(i);
324  }
325 }
326 
327 void ScFuncDesc::initArgumentInfo() const
328 {
329  // get the full argument description
330  // (add-in has to be instantiated to get the type information)
331 
332  if ( !(bIncomplete && mxFuncName) )
333  return;
334 
335  ScUnoAddInCollection& rAddIns = *ScGlobal::GetAddInCollection();
336  OUString aIntName(rAddIns.FindFunction( *mxFuncName, true )); // pFuncName is upper-case
337 
338  if ( !aIntName.isEmpty() )
339  {
340  // GetFuncData with bComplete=true loads the component and updates
341  // the global function list if needed.
342 
343  rAddIns.GetFuncData( aIntName, true );
344  }
345 
346  if ( bIncomplete )
347  {
348  OSL_FAIL( "couldn't initialize add-in function" );
349  const_cast<ScFuncDesc*>(this)->bIncomplete = false; // even if there was an error, don't try again
350  }
351 }
352 
353 OString ScFuncDesc::getHelpId() const
354 {
355  return sHelpId;
356 }
357 
358 bool ScFuncDesc::isHidden() const
359 {
360  return mbHidden;
361 }
362 
363 sal_uInt32 ScFuncDesc::getParameterCount() const
364 {
365  return nArgCount;
366 }
367 
368 sal_uInt32 ScFuncDesc::getVarArgsStart() const
369 {
370  return nVarArgsStart;
371 }
372 
373 sal_uInt32 ScFuncDesc::getVarArgsLimit() const
374 {
375  return nVarArgsLimit;
376 }
377 
378 OUString ScFuncDesc::getParameterName(sal_uInt32 _nPos) const
379 {
380  return maDefArgNames[_nPos];
381 }
382 
383 OUString ScFuncDesc::getParameterDescription(sal_uInt32 _nPos) const
384 {
385  return maDefArgDescs[_nPos];
386 }
387 
388 bool ScFuncDesc::isParameterOptional(sal_uInt32 _nPos) const
389 {
390  return pDefArgFlags[_nPos].bOptional;
391 }
392 
393 bool ScFuncDesc::compareByName(const ScFuncDesc* a, const ScFuncDesc* b)
394 {
395  return (ScGlobal::GetCaseCollator().compareString(*a->mxFuncName, *b->mxFuncName ) < 0);
396 }
397 
398 #define ENTRY(CODE) CODE, SAL_N_ELEMENTS(CODE)
399 
400 ScFunctionList::ScFunctionList()
401 {
402  sal_Int32 nMaxFuncNameLen = 0; // Length of longest function name
403 
404  // See ScFuncDescCore definition for format details.
405  // This list must be sorted in order of the opcode, dbgutil builds enable _GLIBCXX_DEBUG
406  // which will concept check that the list is sorted on first use to ensure this holds
407  static const ScFuncDescCore aDescs[] =
408  {
409  { SC_OPCODE_IF, ENTRY(SC_OPCODE_IF_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_WENN, 3, { 0, 1, 1 }, 0 },
410  { SC_OPCODE_IF_ERROR, ENTRY(SC_OPCODE_IF_ERROR_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_IFERROR, 2, { 0, 0 }, 0 },
411  { SC_OPCODE_IF_NA, ENTRY(SC_OPCODE_IF_NA_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_IFNA, 2, { 0, 0 }, 0 },
412  { SC_OPCODE_CHOOSE, ENTRY(SC_OPCODE_CHOOSE_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_WAHL, VAR_ARGS+1, { 0, 0 }, 31 },
413  { SC_OPCODE_AND, ENTRY(SC_OPCODE_AND_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_UND, VAR_ARGS, { 0 }, 0 },
414  { SC_OPCODE_OR, ENTRY(SC_OPCODE_OR_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_ODER, VAR_ARGS, { 0 }, 0 },
415  { SC_OPCODE_PI, ENTRY(SC_OPCODE_PI_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_PI, 0, { }, 0 },
416  { SC_OPCODE_RANDOM, ENTRY(SC_OPCODE_RANDOM_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ZUFALLSZAHL, 0, { }, 0 },
417  { SC_OPCODE_TRUE, ENTRY(SC_OPCODE_TRUE_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_WAHR, 0, { }, 0 },
418  { SC_OPCODE_FALSE, ENTRY(SC_OPCODE_FALSE_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_FALSCH, 0, { }, 0 },
419  { SC_OPCODE_GET_ACT_DATE, ENTRY(SC_OPCODE_GET_ACT_DATE_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_HEUTE, 0, { }, 0 },
420  { SC_OPCODE_GET_ACT_TIME, ENTRY(SC_OPCODE_GET_ACT_TIME_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_JETZT, 0, { }, 0 },
421  { SC_OPCODE_NO_VALUE, ENTRY(SC_OPCODE_NO_VALUE_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_NV, 0, { }, 0 },
422  { SC_OPCODE_CURRENT, ENTRY(SC_OPCODE_CURRENT_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_AKTUELL, 0, { }, 0 },
423  { SC_OPCODE_RANDOM_NV, ENTRY(SC_OPCODE_RANDOM_NV_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_RAND_NV, 0, { }, 0 },
424  { SC_OPCODE_DEG, ENTRY(SC_OPCODE_DEG_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_DEG, 1, { 0 }, 0 },
425  { SC_OPCODE_RAD, ENTRY(SC_OPCODE_RAD_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_RAD, 1, { 0 }, 0 },
426  { SC_OPCODE_SIN, ENTRY(SC_OPCODE_SIN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_SIN, 1, { 0 }, 0 },
427  { SC_OPCODE_COS, ENTRY(SC_OPCODE_COS_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_COS, 1, { 0 }, 0 },
428  { SC_OPCODE_TAN, ENTRY(SC_OPCODE_TAN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_TAN, 1, { 0 }, 0 },
429  { SC_OPCODE_COT, ENTRY(SC_OPCODE_COT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_COT, 1, { 0 }, 0 },
430  { SC_OPCODE_ARC_SIN, ENTRY(SC_OPCODE_ARC_SIN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARCSIN, 1, { 0 }, 0 },
431  { SC_OPCODE_ARC_COS, ENTRY(SC_OPCODE_ARC_COS_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARCCOS, 1, { 0 }, 0 },
432  { SC_OPCODE_ARC_TAN, ENTRY(SC_OPCODE_ARC_TAN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARCTAN, 1, { 0 }, 0 },
433  { SC_OPCODE_ARC_COT, ENTRY(SC_OPCODE_ARC_COT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARCCOT, 1, { 0 }, 0 },
434  { SC_OPCODE_SIN_HYP, ENTRY(SC_OPCODE_SIN_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_SINHYP, 1, { 0 }, 0 },
435  { SC_OPCODE_COS_HYP, ENTRY(SC_OPCODE_COS_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_COSHYP, 1, { 0 }, 0 },
436  { SC_OPCODE_TAN_HYP, ENTRY(SC_OPCODE_TAN_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_TANHYP, 1, { 0 }, 0 },
437  { SC_OPCODE_COT_HYP, ENTRY(SC_OPCODE_COT_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_COTHYP, 1, { 0 }, 0 },
438  { SC_OPCODE_ARC_SIN_HYP, ENTRY(SC_OPCODE_ARC_SIN_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARSINHYP, 1, { 0 }, 0 },
439  { SC_OPCODE_ARC_COS_HYP, ENTRY(SC_OPCODE_ARC_COS_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARCOSHYP, 1, { 0 }, 0 },
440  { SC_OPCODE_ARC_TAN_HYP, ENTRY(SC_OPCODE_ARC_TAN_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARTANHYP, 1, { 0 }, 0 },
441  { SC_OPCODE_ARC_COT_HYP, ENTRY(SC_OPCODE_ARC_COT_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARCOTHYP, 1, { 0 }, 0 },
442  { SC_OPCODE_COSECANT, ENTRY(SC_OPCODE_COSECANT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_COSECANT, 1, { 0 }, 0 },
443  { SC_OPCODE_SECANT, ENTRY(SC_OPCODE_SECANT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_SECANT, 1, { 0 }, 0 },
444  { SC_OPCODE_COSECANT_HYP, ENTRY(SC_OPCODE_COSECANT_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_COSECANTHYP, 1, { 0 }, 0 },
445  { SC_OPCODE_SECANT_HYP, ENTRY(SC_OPCODE_SECANT_HYP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_SECANTHYP, 1, { 0 }, 0 },
446  { SC_OPCODE_EXP, ENTRY(SC_OPCODE_EXP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_EXP, 1, { 0 }, 0 },
447  { SC_OPCODE_LN, ENTRY(SC_OPCODE_LN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_LN, 1, { 0 }, 0 },
448  { SC_OPCODE_SQRT, ENTRY(SC_OPCODE_SQRT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_WURZEL, 1, { 0 }, 0 },
449  { SC_OPCODE_FACT, ENTRY(SC_OPCODE_FACT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_FAKULTAET, 1, { 0 }, 0 },
450  { SC_OPCODE_GET_YEAR, ENTRY(SC_OPCODE_GET_YEAR_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_JAHR, 1, { 0 }, 0 },
451  { SC_OPCODE_GET_MONTH, ENTRY(SC_OPCODE_GET_MONTH_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_MONAT, 1, { 0 }, 0 },
452  { SC_OPCODE_GET_DAY, ENTRY(SC_OPCODE_GET_DAY_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_TAG, 1, { 0 }, 0 },
453  { SC_OPCODE_GET_HOUR, ENTRY(SC_OPCODE_GET_HOUR_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_STUNDE, 1, { 0 }, 0 },
454  { SC_OPCODE_GET_MIN, ENTRY(SC_OPCODE_GET_MIN_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_MINUTE, 1, { 0 }, 0 },
455  { SC_OPCODE_GET_SEC, ENTRY(SC_OPCODE_GET_SEC_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_SEKUNDE, 1, { 0 }, 0 },
456  { SC_OPCODE_PLUS_MINUS, ENTRY(SC_OPCODE_PLUS_MINUS_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_VORZEICHEN, 1, { 0 }, 0 },
457  { SC_OPCODE_ABS, ENTRY(SC_OPCODE_ABS_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ABS, 1, { 0 }, 0 },
458  { SC_OPCODE_INT, ENTRY(SC_OPCODE_INT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_GANZZAHL, 1, { 0 }, 0 },
459  { SC_OPCODE_PHI, ENTRY(SC_OPCODE_PHI_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_PHI, 1, { 0 }, 0 },
460  { SC_OPCODE_GAUSS, ENTRY(SC_OPCODE_GAUSS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAUSS, 1, { 0 }, 0 },
461  { SC_OPCODE_IS_EMPTY, ENTRY(SC_OPCODE_IS_EMPTY_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTLEER, 1, { 0 }, 0 },
462  { SC_OPCODE_IS_STRING, ENTRY(SC_OPCODE_IS_STRING_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTTEXT, 1, { 0 }, 0 },
463  { SC_OPCODE_IS_NON_STRING, ENTRY(SC_OPCODE_IS_NON_STRING_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTKTEXT, 1, { 0 }, 0 },
464  { SC_OPCODE_IS_LOGICAL, ENTRY(SC_OPCODE_IS_LOGICAL_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTLOG, 1, { 0 }, 0 },
465  { SC_OPCODE_TYPE, ENTRY(SC_OPCODE_TYPE_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_TYP, 1, { 0 }, 0 },
466  { SC_OPCODE_IS_REF, ENTRY(SC_OPCODE_IS_REF_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTBEZUG, 1, { 0 }, 0 },
467  { SC_OPCODE_IS_VALUE, ENTRY(SC_OPCODE_IS_VALUE_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTZAHL, 1, { 0 }, 0 },
468  { SC_OPCODE_IS_FORMULA, ENTRY(SC_OPCODE_IS_FORMULA_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTFORMEL, 1, { 0 }, 0 },
469  { SC_OPCODE_IS_NV, ENTRY(SC_OPCODE_IS_NV_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTNV, 1, { 0 }, 0 },
470  { SC_OPCODE_IS_ERR, ENTRY(SC_OPCODE_IS_ERR_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTFEHL, 1, { 0 }, 0 },
471  { SC_OPCODE_IS_ERROR, ENTRY(SC_OPCODE_IS_ERROR_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTFEHLER, 1, { 0 }, 0 },
472  { SC_OPCODE_IS_EVEN, ENTRY(SC_OPCODE_IS_EVEN_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTGERADE, 1, { 0 }, 0 },
473  { SC_OPCODE_IS_ODD, ENTRY(SC_OPCODE_IS_ODD_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ISTUNGERADE, 1, { 0 }, 0 },
474  { SC_OPCODE_N, ENTRY(SC_OPCODE_N_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_N, 1, { 0 }, 0 },
475  { SC_OPCODE_GET_DATE_VALUE, ENTRY(SC_OPCODE_GET_DATE_VALUE_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_DATWERT, 1, { 0 }, 0 },
476  { SC_OPCODE_GET_TIME_VALUE, ENTRY(SC_OPCODE_GET_TIME_VALUE_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_ZEITWERT, 1, { 0 }, 0 },
477  { SC_OPCODE_CODE, ENTRY(SC_OPCODE_CODE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_CODE, 1, { 0 }, 0 },
478  { SC_OPCODE_TRIM, ENTRY(SC_OPCODE_TRIM_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_GLAETTEN, 1, { 0 }, 0 },
479  { SC_OPCODE_UPPER, ENTRY(SC_OPCODE_UPPER_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_GROSS, 1, { 0 }, 0 },
480  { SC_OPCODE_PROPER, ENTRY(SC_OPCODE_PROPER_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_GROSS2, 1, { 0 }, 0 },
481  { SC_OPCODE_LOWER, ENTRY(SC_OPCODE_LOWER_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_KLEIN, 1, { 0 }, 0 },
482  { SC_OPCODE_LEN, ENTRY(SC_OPCODE_LEN_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_LAENGE, 1, { 0 }, 0 },
483  { SC_OPCODE_T, ENTRY(SC_OPCODE_T_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_T, 1, { 0 }, 0 },
484  { SC_OPCODE_VALUE, ENTRY(SC_OPCODE_VALUE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_WERT, 1, { 0 }, 0 },
485  { SC_OPCODE_CLEAN, ENTRY(SC_OPCODE_CLEAN_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_SAEUBERN, 1, { 0 }, 0 },
486  { SC_OPCODE_CHAR, ENTRY(SC_OPCODE_CHAR_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_ZEICHEN, 1, { 0 }, 0 },
487  { SC_OPCODE_LOG10, ENTRY(SC_OPCODE_LOG10_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_LOG10, 1, { 0 }, 0 },
488  { SC_OPCODE_EVEN, ENTRY(SC_OPCODE_EVEN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_GERADE, 1, { 0 }, 0 },
489  { SC_OPCODE_ODD, ENTRY(SC_OPCODE_ODD_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_UNGERADE, 1, { 0 }, 0 },
490  { SC_OPCODE_STD_NORM_DIST, ENTRY(SC_OPCODE_STD_NORM_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STANDNORMVERT, 1, { 0 }, 0 },
491  { SC_OPCODE_FISHER, ENTRY(SC_OPCODE_FISHER_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FISHER, 1, { 0 }, 0 },
492  { SC_OPCODE_FISHER_INV, ENTRY(SC_OPCODE_FISHER_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FISHERINV, 1, { 0 }, 0 },
493  { SC_OPCODE_S_NORM_INV, ENTRY(SC_OPCODE_S_NORM_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STANDNORMINV, 1, { 0 }, 0 },
494  { SC_OPCODE_GAMMA_LN, ENTRY(SC_OPCODE_GAMMA_LN_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAMMALN, 1, { 0 }, 0 },
495  { SC_OPCODE_ERROR_TYPE, ENTRY(SC_OPCODE_ERROR_TYPE_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_FEHLERTYP, 1, { 0 }, 0 },
496  { SC_OPCODE_FORMULA, ENTRY(SC_OPCODE_FORMULA_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_FORMEL, 1, { 0 }, 0 },
497  { SC_OPCODE_ARABIC, ENTRY(SC_OPCODE_ARABIC_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_ARABISCH, 1, { 0 }, 0 },
498  { SC_OPCODE_INFO, ENTRY(SC_OPCODE_INFO_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_INFO, 1, { 0 }, 0 },
499  { SC_OPCODE_BAHTTEXT, ENTRY(SC_OPCODE_BAHTTEXT_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_BAHTTEXT, 1, { 0 }, 0 },
500  { SC_OPCODE_JIS, ENTRY(SC_OPCODE_JIS_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_JIS, 1, { 0 }, 0 },
501  { SC_OPCODE_ASC, ENTRY(SC_OPCODE_ASC_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_ASC, 1, { 0 }, 0 },
502  { SC_OPCODE_UNICODE, ENTRY(SC_OPCODE_UNICODE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_UNICODE, 1, { 0 }, 0 },
503  { SC_OPCODE_UNICHAR, ENTRY(SC_OPCODE_UNICHAR_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_UNICHAR, 1, { 0 }, 0 },
504  { SC_OPCODE_GAMMA, ENTRY(SC_OPCODE_GAMMA_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAMMA, 1, { 0 }, 0 },
505  { SC_OPCODE_GAMMA_LN_MS, ENTRY(SC_OPCODE_GAMMA_LN_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAMMALN_MS, 1, { 0 }, 0 },
506  { SC_OPCODE_ERF_MS, ENTRY(SC_OPCODE_ERF_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ERF_MS, 1, { 0 }, 0 },
507  { SC_OPCODE_ERFC_MS, ENTRY(SC_OPCODE_ERFC_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ERFC_MS, 1, { 0 }, 0 },
508  { SC_OPCODE_ERROR_TYPE_ODF, ENTRY(SC_OPCODE_ERROR_TYPE_ODF_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_ERROR_TYPE_ODF, 1, { 0 }, 0 },
509  { SC_OPCODE_ENCODEURL, ENTRY(SC_OPCODE_ENCODEURL_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_ENCODEURL, 1, { 0 }, 0 },
510  { SC_OPCODE_ISOWEEKNUM, ENTRY(SC_OPCODE_ISOWEEKNUM_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_ISOWEEKNUM, 1, { 0 }, 0 },
511  { SC_OPCODE_NOT, ENTRY(SC_OPCODE_NOT_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_NICHT, 1, { 0 }, 0 },
512  { SC_OPCODE_ARC_TAN_2, ENTRY(SC_OPCODE_ARC_TAN_2_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ARCTAN2, 2, { 0, 0 }, 0 },
513  { SC_OPCODE_CEIL, ENTRY(SC_OPCODE_CEIL_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_OBERGRENZE, 3, { 0, 1, 1 }, 0 },
514  { SC_OPCODE_FLOOR, ENTRY(SC_OPCODE_FLOOR_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_UNTERGRENZE, 3, { 0, 1, 1 }, 0 },
515  { SC_OPCODE_ROUND, ENTRY(SC_OPCODE_ROUND_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_RUNDEN, 2, { 0, 1 }, 0 },
516  { SC_OPCODE_ROUND_UP, ENTRY(SC_OPCODE_ROUND_UP_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_AUFRUNDEN, 2, { 0, 1 }, 0 },
517  { SC_OPCODE_ROUND_DOWN, ENTRY(SC_OPCODE_ROUND_DOWN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ABRUNDEN, 2, { 0, 1 }, 0 },
518  { SC_OPCODE_TRUNC, ENTRY(SC_OPCODE_TRUNC_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_KUERZEN, 2, { 0, 0 }, 0 },
519  { SC_OPCODE_LOG, ENTRY(SC_OPCODE_LOG_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_LOG, 2, { 0, 1 }, 0 },
520  { SC_OPCODE_POWER, ENTRY(SC_OPCODE_POWER_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_POTENZ, 2, { 0, 0 }, 0 },
521  { SC_OPCODE_GCD, ENTRY(SC_OPCODE_GCD_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_GGT, VAR_ARGS, { 0 }, 0 },
522  { SC_OPCODE_LCM, ENTRY(SC_OPCODE_LCM_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_KGV, VAR_ARGS, { 0 }, 0 },
523  { SC_OPCODE_MOD, ENTRY(SC_OPCODE_MOD_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_REST, 2, { 0, 0 }, 0 },
524  { SC_OPCODE_SUM_PRODUCT, ENTRY(SC_OPCODE_SUM_PRODUCT_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_SUMMENPRODUKT, VAR_ARGS, { 0 }, 0 },
525  { SC_OPCODE_SUM_SQ, ENTRY(SC_OPCODE_SUM_SQ_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_QUADRATESUMME, VAR_ARGS, { 0 }, 0 },
526  { SC_OPCODE_SUM_X2MY2, ENTRY(SC_OPCODE_SUM_X2MY2_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_SUMMEX2MY2, 2, { 0, 0 }, 0 },
527  { SC_OPCODE_SUM_X2DY2, ENTRY(SC_OPCODE_SUM_X2DY2_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_SUMMEX2PY2, 2, { 0, 0 }, 0 },
528  { SC_OPCODE_SUM_XMY2, ENTRY(SC_OPCODE_SUM_XMY2_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_SUMMEXMY2, 2, { 0, 0 }, 0 },
529  { SC_OPCODE_GET_DATE, ENTRY(SC_OPCODE_GET_DATE_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_DATUM, 3, { 0, 0, 0 }, 0 },
530  { SC_OPCODE_GET_TIME, ENTRY(SC_OPCODE_GET_TIME_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_ZEIT, 3, { 0, 0, 0 }, 0 },
531  { SC_OPCODE_GET_DIFF_DATE, ENTRY(SC_OPCODE_GET_DIFF_DATE_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_TAGE, 2, { 0, 0 }, 0 },
532  { SC_OPCODE_GET_DIFF_DATE_360, ENTRY(SC_OPCODE_GET_DIFF_DATE_360_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_TAGE360, 3, { 0, 0, 1 }, 0 },
533  { SC_OPCODE_MIN, ENTRY(SC_OPCODE_MIN_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MIN, VAR_ARGS, { 0 }, 0 },
534  { SC_OPCODE_MAX, ENTRY(SC_OPCODE_MAX_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MAX, VAR_ARGS, { 0 }, 0 },
535  { SC_OPCODE_SUM, ENTRY(SC_OPCODE_SUM_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_SUMME, VAR_ARGS, { 0 }, 0 },
536  { SC_OPCODE_PRODUCT, ENTRY(SC_OPCODE_PRODUCT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_PRODUKT, VAR_ARGS, { 0 }, 0 },
537  { SC_OPCODE_AVERAGE, ENTRY(SC_OPCODE_AVERAGE_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MITTELWERT, VAR_ARGS, { 0 }, 0 },
538  { SC_OPCODE_COUNT, ENTRY(SC_OPCODE_COUNT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ANZAHL, VAR_ARGS, { 0 }, 0 },
539  { SC_OPCODE_COUNT_2, ENTRY(SC_OPCODE_COUNT_2_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ANZAHL2, VAR_ARGS, { 0 }, 0 },
540  { SC_OPCODE_NPV, ENTRY(SC_OPCODE_NPV_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_NBW, VAR_ARGS+1, { 0, 0 }, 0 },
541  { SC_OPCODE_IRR, ENTRY(SC_OPCODE_IRR_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_IKV, 2, { 0, 1 }, 0 },
542  { SC_OPCODE_VAR, ENTRY(SC_OPCODE_VAR_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VARIANZ, VAR_ARGS, { 0 }, 0 },
543  { SC_OPCODE_VAR_P, ENTRY(SC_OPCODE_VAR_P_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VARIANZEN, VAR_ARGS, { 0 }, 0 },
544  { SC_OPCODE_ST_DEV, ENTRY(SC_OPCODE_ST_DEV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STABW, VAR_ARGS, { 0 }, 0 },
545  { SC_OPCODE_ST_DEV_P, ENTRY(SC_OPCODE_ST_DEV_P_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STABWN, VAR_ARGS, { 0 }, 0 },
546  { SC_OPCODE_B, ENTRY(SC_OPCODE_B_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_B, 4, { 0, 0, 0, 1 }, 0 },
547  { SC_OPCODE_NORM_DIST, ENTRY(SC_OPCODE_NORM_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_NORMVERT, 4, { 0, 0, 0, 1 }, 0 },
548  { SC_OPCODE_EXP_DIST, ENTRY(SC_OPCODE_EXP_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_EXPONVERT, 3, { 0, 0, 0 }, 0 },
549  { SC_OPCODE_BINOM_DIST, ENTRY(SC_OPCODE_BINOM_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BINOMVERT, 4, { 0, 0, 0, 0 }, 0 },
550  { SC_OPCODE_POISSON_DIST, ENTRY(SC_OPCODE_POISSON_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_POISSON, 3, { 0, 0, 1 }, 0 },
551  { SC_OPCODE_COMBIN, ENTRY(SC_OPCODE_COMBIN_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_KOMBINATIONEN, 2, { 0, 0 }, 0 },
552  { SC_OPCODE_COMBIN_A, ENTRY(SC_OPCODE_COMBIN_A_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_KOMBINATIONEN2, 2, { 0, 0 }, 0 },
553  { SC_OPCODE_PERMUT, ENTRY(SC_OPCODE_PERMUT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VARIATIONEN, 2, { 0, 0 }, 0 },
554  { SC_OPCODE_PERMUTATION_A, ENTRY(SC_OPCODE_PERMUTATION_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VARIATIONEN2, 2, { 0, 0 }, 0 },
555  { SC_OPCODE_PV, ENTRY(SC_OPCODE_PV_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_BW, 5, { 0, 0, 0, 1, 1 }, 0 },
556  { SC_OPCODE_SYD, ENTRY(SC_OPCODE_SYD_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_DIA, 4, { 0, 0, 0, 0 }, 0 },
557  { SC_OPCODE_DDB, ENTRY(SC_OPCODE_DDB_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_GDA, 5, { 0, 0, 0, 0, 1 }, 0 },
558  { SC_OPCODE_DB, ENTRY(SC_OPCODE_DB_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_GDA2, 5, { 0, 0, 0, 0, 1 }, 0 },
559  { SC_OPCODE_VBD , ENTRY(SC_OPCODE_VBD_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_VDB, 7, { 0, 0, 0, 0, 0, 1, 1 }, 0 },
560  { SC_OPCODE_PDURATION, ENTRY(SC_OPCODE_PDURATION_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_LAUFZEIT, 3, { 0, 0, 0 }, 0 },
561  { SC_OPCODE_SLN, ENTRY(SC_OPCODE_SLN_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_LIA, 3, { 0, 0, 0 }, 0 },
562  { SC_OPCODE_PMT, ENTRY(SC_OPCODE_PMT_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_RMZ, 5, { 0, 0, 0, 1, 1 }, 0 },
563  { SC_OPCODE_COLUMNS, ENTRY(SC_OPCODE_COLUMNS_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_SPALTEN, 1, { 0 }, 0 },
564  { SC_OPCODE_ROWS, ENTRY(SC_OPCODE_ROWS_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_ZEILEN, 1, { 0 }, 0 },
565  { SC_OPCODE_COLUMN, ENTRY(SC_OPCODE_COLUMN_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_SPALTE, 1, { 1 }, 0 },
566  { SC_OPCODE_ROW, ENTRY(SC_OPCODE_ROW_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_ZEILE, 1, { 1 }, 0 },
567  { SC_OPCODE_RRI, ENTRY(SC_OPCODE_RRI_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_ZGZ, 3, { 0, 0, 0 }, 0 },
568  { SC_OPCODE_FV, ENTRY(SC_OPCODE_FV_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_ZW, 5, { 0, 0, 0, 1, 1 }, 0 },
569  { SC_OPCODE_NPER, ENTRY(SC_OPCODE_NPER_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_ZZR, 5, { 0, 0, 0, 1, 1 }, 0 },
570  { SC_OPCODE_RATE, ENTRY(SC_OPCODE_RATE_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_ZINS, 6, { 0, 0, 0, 1, 1, 1 }, 0 },
571  { SC_OPCODE_IPMT, ENTRY(SC_OPCODE_IPMT_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_ZINSZ, 6, { 0, 0, 0, 0, 1, 1 }, 0 },
572  { SC_OPCODE_PPMT, ENTRY(SC_OPCODE_PPMT_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_KAPZ, 6, { 0, 0, 0, 0, 1, 1 }, 0 },
573  { SC_OPCODE_CUM_IPMT, ENTRY(SC_OPCODE_CUM_IPMT_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_KUMZINSZ, 6, { 0, 0, 0, 0, 0, 0 }, 0 },
574  { SC_OPCODE_CUM_PRINC, ENTRY(SC_OPCODE_CUM_PRINC_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_KUMKAPITAL, 6, { 0, 0, 0, 0, 0, 0 }, 0 },
575  { SC_OPCODE_EFFECT, ENTRY(SC_OPCODE_EFFECT_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_EFFEKTIV, 2, { 0, 0 }, 0 },
576  { SC_OPCODE_NOMINAL, ENTRY(SC_OPCODE_NOMINAL_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_NOMINAL, 2, { 0, 0 }, 0 },
577  { SC_OPCODE_SUB_TOTAL, ENTRY(SC_OPCODE_SUB_TOTAL_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_TEILERGEBNIS, 2, { 0, 0 }, 0 },
578  { SC_OPCODE_DB_SUM, ENTRY(SC_OPCODE_DB_SUM_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBSUMME, 3, { 0, 0, 0 }, 0 },
579  { SC_OPCODE_DB_COUNT, ENTRY(SC_OPCODE_DB_COUNT_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBANZAHL, 3, { 0, 1, 0 }, 0 },
580  { SC_OPCODE_DB_COUNT_2, ENTRY(SC_OPCODE_DB_COUNT_2_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBANZAHL2, 3, { 0, 1, 0 }, 0 },
581  { SC_OPCODE_DB_AVERAGE, ENTRY(SC_OPCODE_DB_AVERAGE_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBMITTELWERT, 3, { 0, 0, 0 }, 0 },
582  { SC_OPCODE_DB_GET, ENTRY(SC_OPCODE_DB_GET_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBAUSZUG, 3, { 0, 0, 0 }, 0 },
583  { SC_OPCODE_DB_MAX, ENTRY(SC_OPCODE_DB_MAX_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBMAX, 3, { 0, 0, 0 }, 0 },
584  { SC_OPCODE_DB_MIN, ENTRY(SC_OPCODE_DB_MIN_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBMIN, 3, { 0, 0, 0 }, 0 },
585  { SC_OPCODE_DB_PRODUCT, ENTRY(SC_OPCODE_DB_PRODUCT_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBPRODUKT, 3, { 0, 0, 0 }, 0 },
586  { SC_OPCODE_DB_STD_DEV, ENTRY(SC_OPCODE_DB_STD_DEV_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBSTDABW, 3, { 0, 0, 0 }, 0 },
587  { SC_OPCODE_DB_STD_DEV_P, ENTRY(SC_OPCODE_DB_STD_DEV_P_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBSTDABWN, 3, { 0, 0, 0 }, 0 },
588  { SC_OPCODE_DB_VAR, ENTRY(SC_OPCODE_DB_VAR_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBVARIANZ, 3, { 0, 0, 0 }, 0 },
589  { SC_OPCODE_DB_VAR_P, ENTRY(SC_OPCODE_DB_VAR_P_ARY), 0, ID_FUNCTION_GRP_DATABASE, HID_FUNC_DBVARIANZEN, 3, { 0, 0, 0 }, 0 },
590  { SC_OPCODE_INDIRECT, ENTRY(SC_OPCODE_INDIRECT_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_INDIREKT, 2, { 0, 1 }, 0 },
591  { SC_OPCODE_ADDRESS, ENTRY(SC_OPCODE_ADDRESS_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_ADRESSE, 5, { 0, 0, 1, 1, 1 }, 0 },
592  { SC_OPCODE_MATCH, ENTRY(SC_OPCODE_MATCH_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_VERGLEICH, 3, { 0, 0, 1 }, 0 },
593  { SC_OPCODE_COUNT_EMPTY_CELLS, ENTRY(SC_OPCODE_COUNT_EMPTY_CELLS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ANZAHLLEEREZELLEN, 1, { 0 }, 0 },
594  { SC_OPCODE_COUNT_IF, ENTRY(SC_OPCODE_COUNT_IF_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ZAEHLENWENN, 2, { 0, 0 }, 0 },
595  { SC_OPCODE_SUM_IF, ENTRY(SC_OPCODE_SUM_IF_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_SUMMEWENN, 3, { 0, 0, 1 }, 0 },
596  { SC_OPCODE_LOOKUP, ENTRY(SC_OPCODE_LOOKUP_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_VERWEIS, 3, { 0, 0, 1 }, 0 },
597  { SC_OPCODE_V_LOOKUP, ENTRY(SC_OPCODE_V_LOOKUP_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_SVERWEIS, 4, { 0, 0, 0, 1 }, 0 },
598  { SC_OPCODE_H_LOOKUP, ENTRY(SC_OPCODE_H_LOOKUP_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_WVERWEIS, 4, { 0, 0, 0, 1 }, 0 },
599  { SC_OPCODE_OFFSET, ENTRY(SC_OPCODE_OFFSET_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_VERSCHIEBUNG, 5, { 0, 0, 0, 1, 1 }, 0 },
600  { SC_OPCODE_INDEX, ENTRY(SC_OPCODE_INDEX_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_INDEX, 4, { 0, 1, 1, 1 }, 0 },
601  { SC_OPCODE_AREAS, ENTRY(SC_OPCODE_AREAS_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_BEREICHE, 1, { 0 }, 0 },
602  { SC_OPCODE_CURRENCY, ENTRY(SC_OPCODE_CURRENCY_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_DM, 2, { 0, 1 }, 0 },
603  { SC_OPCODE_REPLACE, ENTRY(SC_OPCODE_REPLACE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_ERSETZEN, 4, { 0, 0, 0, 0 }, 0 },
604  { SC_OPCODE_FIXED, ENTRY(SC_OPCODE_FIXED_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_FEST, 3, { 0, 0, 1 }, 0 },
605  { SC_OPCODE_FIND, ENTRY(SC_OPCODE_FIND_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_FINDEN, 3, { 0, 0, 1 }, 0 },
606  { SC_OPCODE_EXACT, ENTRY(SC_OPCODE_EXACT_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_IDENTISCH, 2, { 0, 0 }, 0 },
607  { SC_OPCODE_LEFT, ENTRY(SC_OPCODE_LEFT_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_LINKS, 2, { 0, 1 }, 0 },
608  { SC_OPCODE_RIGHT, ENTRY(SC_OPCODE_RIGHT_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_RECHTS, 2, { 0, 1 }, 0 },
609  { SC_OPCODE_SEARCH, ENTRY(SC_OPCODE_SEARCH_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_SUCHEN, 3, { 0, 0, 1 }, 0 },
610  { SC_OPCODE_MID, ENTRY(SC_OPCODE_MID_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_TEIL, 3, { 0, 0, 0 }, 0 },
611  { SC_OPCODE_TEXT, ENTRY(SC_OPCODE_TEXT_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_TEXT, 2, { 0, 0 }, 0 },
612  { SC_OPCODE_SUBSTITUTE, ENTRY(SC_OPCODE_SUBSTITUTE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_WECHSELN, 4, { 0, 0, 0, 1 }, 0 },
613  { SC_OPCODE_REPT, ENTRY(SC_OPCODE_REPT_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_WIEDERHOLEN, 2, { 0, 0 }, 0 },
614  { SC_OPCODE_CONCAT, ENTRY(SC_OPCODE_CONCAT_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_VERKETTEN, VAR_ARGS, { 0 }, 0 },
615  { SC_OPCODE_MAT_DET, ENTRY(SC_OPCODE_MAT_DET_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_MDET, 1, { 0 }, 0 },
616  { SC_OPCODE_MAT_INV, ENTRY(SC_OPCODE_MAT_INV_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_MINV, 1, { 0 }, 0 },
617  { SC_OPCODE_MAT_MULT, ENTRY(SC_OPCODE_MAT_MULT_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_MMULT, 2, { 0, 0 }, 0 },
618  { SC_OPCODE_MAT_TRANS, ENTRY(SC_OPCODE_MAT_TRANS_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_MTRANS, 1, { 0 }, 0 },
619  { SC_OPCODE_MATRIX_UNIT, ENTRY(SC_OPCODE_MATRIX_UNIT_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_EINHEITSMATRIX, 1, { 0 }, 0 },
620  { SC_OPCODE_HYP_GEOM_DIST, ENTRY(SC_OPCODE_HYP_GEOM_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_HYPGEOMVERT, 5, { 0, 0, 0, 0, 1 }, 0 },
621  { SC_OPCODE_LOG_NORM_DIST, ENTRY(SC_OPCODE_LOG_NORM_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_LOGNORMVERT, 4, { 0, 1, 1, 1 }, 0 },
622  { SC_OPCODE_T_DIST, ENTRY(SC_OPCODE_T_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TVERT, 3, { 0, 0, 0 }, 0 },
623  { SC_OPCODE_F_DIST, ENTRY(SC_OPCODE_F_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FVERT, 3, { 0, 0, 0 }, 0 },
624  { SC_OPCODE_CHI_DIST, ENTRY(SC_OPCODE_CHI_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHIVERT, 2, { 0, 0 }, 0 },
625  { SC_OPCODE_WEIBULL, ENTRY(SC_OPCODE_WEIBULL_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_WEIBULL, 4, { 0, 0, 0, 0 }, 0 },
626  { SC_OPCODE_NEG_BINOM_VERT, ENTRY(SC_OPCODE_NEG_BINOM_VERT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_NEGBINOMVERT, 3, { 0, 0, 0 }, 0 },
627  { SC_OPCODE_CRIT_BINOM, ENTRY(SC_OPCODE_CRIT_BINOM_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_KRITBINOM, 3, { 0, 0, 0 }, 0 },
628  { SC_OPCODE_KURT, ENTRY(SC_OPCODE_KURT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_KURT, VAR_ARGS, { 0 }, 0 },
629  { SC_OPCODE_HAR_MEAN, ENTRY(SC_OPCODE_HAR_MEAN_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_HARMITTEL, VAR_ARGS, { 0 }, 0 },
630  { SC_OPCODE_GEO_MEAN, ENTRY(SC_OPCODE_GEO_MEAN_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GEOMITTEL, VAR_ARGS, { 0 }, 0 },
631  { SC_OPCODE_STANDARD, ENTRY(SC_OPCODE_STANDARD_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STANDARDISIERUNG, 3, { 0, 0, 0 }, 0 },
632  { SC_OPCODE_AVE_DEV, ENTRY(SC_OPCODE_AVE_DEV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MITTELABW, VAR_ARGS, { 0 }, 0 },
633  { SC_OPCODE_SKEW, ENTRY(SC_OPCODE_SKEW_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_SCHIEFE, VAR_ARGS, { 0 }, 0 },
634  { SC_OPCODE_DEV_SQ, ENTRY(SC_OPCODE_DEV_SQ_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_SUMQUADABW, VAR_ARGS, { 0 }, 0 },
635  { SC_OPCODE_MEDIAN, ENTRY(SC_OPCODE_MEDIAN_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MEDIAN, VAR_ARGS, { 0 }, 0 },
636  { SC_OPCODE_MODAL_VALUE, ENTRY(SC_OPCODE_MODAL_VALUE_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MODALWERT, VAR_ARGS, { 0 }, 0 },
637  { SC_OPCODE_Z_TEST, ENTRY(SC_OPCODE_Z_TEST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GTEST, 3, { 0, 0, 1 }, 0 },
638  { SC_OPCODE_T_TEST, ENTRY(SC_OPCODE_T_TEST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TTEST, 4, { 0, 0, 0, 0 }, 0 },
639  { SC_OPCODE_RANK, ENTRY(SC_OPCODE_RANK_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_RANG, 3, { 0, 0, 1 }, 0 },
640  { SC_OPCODE_PERCENTILE, ENTRY(SC_OPCODE_PERCENTILE_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_QUANTIL, 2, { 0, 0 }, 0 },
641  { SC_OPCODE_PERCENT_RANK, ENTRY(SC_OPCODE_PERCENT_RANK_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_QUANTILSRANG, 3, { 0, 0, 1 }, 0 },
642  { SC_OPCODE_LARGE, ENTRY(SC_OPCODE_LARGE_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_KGROESSTE, 2, { 0, 0 }, 0 },
643  { SC_OPCODE_SMALL, ENTRY(SC_OPCODE_SMALL_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_KKLEINSTE, 2, { 0, 0 }, 0 },
644  { SC_OPCODE_FREQUENCY, ENTRY(SC_OPCODE_FREQUENCY_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_HAEUFIGKEIT, 2, { 0, 0 }, 0 },
645  { SC_OPCODE_QUARTILE, ENTRY(SC_OPCODE_QUARTILE_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_QUARTILE, 2, { 0, 0 }, 0 },
646  { SC_OPCODE_NORM_INV, ENTRY(SC_OPCODE_NORM_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_NORMINV, 3, { 0, 0, 0 }, 0 },
647  { SC_OPCODE_CONFIDENCE, ENTRY(SC_OPCODE_CONFIDENCE_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_KONFIDENZ, 3, { 0, 0, 0 }, 0 },
648  { SC_OPCODE_F_TEST, ENTRY(SC_OPCODE_F_TEST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FTEST, 2, { 0, 0 }, 0 },
649  { SC_OPCODE_TRIM_MEAN, ENTRY(SC_OPCODE_TRIM_MEAN_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GESTUTZTMITTEL, 2, { 0, 0 }, 0 },
650  { SC_OPCODE_PROB, ENTRY(SC_OPCODE_PROB_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_WAHRSCHBEREICH, 4, { 0, 0, 0, 1 }, 0 },
651  { SC_OPCODE_CORREL, ENTRY(SC_OPCODE_CORREL_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_KORREL, 2, { 0, 0 }, 0 },
652  { SC_OPCODE_COVAR, ENTRY(SC_OPCODE_COVAR_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_KOVAR, 2, { 0, 0 }, 0 },
653  { SC_OPCODE_PEARSON, ENTRY(SC_OPCODE_PEARSON_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_PEARSON, 2, { 0, 0 }, 0 },
654  { SC_OPCODE_RSQ, ENTRY(SC_OPCODE_RSQ_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BESTIMMTHEITSMASS, 2, { 0, 0 }, 0 },
655  { SC_OPCODE_STEYX, ENTRY(SC_OPCODE_STEYX_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STFEHLERYX, 2, { 0, 0 }, 0 },
656  { SC_OPCODE_SLOPE, ENTRY(SC_OPCODE_SLOPE_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STEIGUNG, 2, { 0, 0 }, 0 },
657  { SC_OPCODE_INTERCEPT, ENTRY(SC_OPCODE_INTERCEPT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ACHSENABSCHNITT, 2, { 0, 0 }, 0 },
658  { SC_OPCODE_TREND, ENTRY(SC_OPCODE_TREND_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_TREND, 4, { 0, 1, 1, 1 }, 0 },
659  { SC_OPCODE_GROWTH, ENTRY(SC_OPCODE_GROWTH_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_VARIATION, 4, { 0, 1, 1, 1 }, 0 },
660  { SC_OPCODE_LINEST, ENTRY(SC_OPCODE_LINEST_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_RGP, 4, { 0, 1, 1, 1 }, 0 },
661  { SC_OPCODE_LOGEST, ENTRY(SC_OPCODE_LOGEST_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_RKP, 4, { 0, 1, 1, 1 }, 0 },
662  { SC_OPCODE_FORECAST, ENTRY(SC_OPCODE_FORECAST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_SCHAETZER, 3, { 0, 0, 0 }, 0 },
663  { SC_OPCODE_CHI_INV, ENTRY(SC_OPCODE_CHI_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHIINV, 2, { 0, 0 }, 0 },
664  { SC_OPCODE_GAMMA_DIST, ENTRY(SC_OPCODE_GAMMA_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAMMAVERT, 4, { 0, 0, 0, 1 }, 0 },
665  { SC_OPCODE_GAMMA_INV, ENTRY(SC_OPCODE_GAMMA_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAMMAINV, 3, { 0, 0, 0 }, 0 },
666  { SC_OPCODE_T_INV, ENTRY(SC_OPCODE_T_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TINV, 2, { 0, 0 }, 0 },
667  { SC_OPCODE_F_INV, ENTRY(SC_OPCODE_F_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FINV, 3, { 0, 0, 0 }, 0 },
668  { SC_OPCODE_CHI_TEST, ENTRY(SC_OPCODE_CHI_TEST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHITEST, 2, { 0, 0 }, 0 },
669  { SC_OPCODE_LOG_INV, ENTRY(SC_OPCODE_LOG_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_LOGINV, 3, { 0, 1, 1 }, 0 },
670  { SC_OPCODE_BETA_DIST, ENTRY(SC_OPCODE_BETA_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BETAVERT, 6, { 0, 0, 0, 1, 1, 1 }, 0 },
671  { SC_OPCODE_BETA_INV, ENTRY(SC_OPCODE_BETA_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BETAINV, 5, { 0, 0, 0, 1, 1 }, 0 },
672  { SC_OPCODE_WEEK, ENTRY(SC_OPCODE_WEEK_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_KALENDERWOCHE, 2, { 0, 1 }, 0 },
673  { SC_OPCODE_GET_DAY_OF_WEEK, ENTRY(SC_OPCODE_GET_DAY_OF_WEEK_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_WOCHENTAG, 2, { 0, 1 }, 0 },
674  { SC_OPCODE_STYLE, ENTRY(SC_OPCODE_STYLE_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_VORLAGE, 3, { 0, 1, 1 }, 0 },
675  { SC_OPCODE_DDE, ENTRY(SC_OPCODE_DDE_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_DDE, 4, { 0, 0, 0, 1 }, 0 },
676  { SC_OPCODE_BASE, ENTRY(SC_OPCODE_BASE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_BASIS, 3, { 0, 0, 1 }, 0 },
677  { SC_OPCODE_SHEET, ENTRY(SC_OPCODE_SHEET_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_TABELLE, 1, { 1 }, 0 },
678  { SC_OPCODE_SHEETS, ENTRY(SC_OPCODE_SHEETS_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_TABELLEN, 1, { 1 }, 0 },
679  { SC_OPCODE_MIN_A, ENTRY(SC_OPCODE_MIN_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MINA, VAR_ARGS, { 0 }, 0 },
680  { SC_OPCODE_MAX_A, ENTRY(SC_OPCODE_MAX_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MAXA, VAR_ARGS, { 0 }, 0 },
681  { SC_OPCODE_AVERAGE_A, ENTRY(SC_OPCODE_AVERAGE_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MITTELWERTA, VAR_ARGS, { 0 }, 0 },
682  { SC_OPCODE_ST_DEV_A, ENTRY(SC_OPCODE_ST_DEV_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STABWA, VAR_ARGS, { 0 }, 0 },
683  { SC_OPCODE_ST_DEV_P_A, ENTRY(SC_OPCODE_ST_DEV_P_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STABWNA, VAR_ARGS, { 0 }, 0 },
684  { SC_OPCODE_VAR_A, ENTRY(SC_OPCODE_VAR_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VARIANZA, VAR_ARGS, { 0 }, 0 },
685  { SC_OPCODE_VAR_P_A, ENTRY(SC_OPCODE_VAR_P_A_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VARIANZENA, VAR_ARGS, { 0 }, 0 },
686  { SC_OPCODE_EASTERSUNDAY, ENTRY(SC_OPCODE_EASTERSUNDAY_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_OSTERSONNTAG, 1, { 0 }, 0 },
687  { SC_OPCODE_DECIMAL, ENTRY(SC_OPCODE_DECIMAL_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_DEZIMAL, 2, { 0, 0 }, 0 },
688  { SC_OPCODE_CONVERT_OOO, ENTRY(SC_OPCODE_CONVERT_OOO_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_UMRECHNEN, 3, { 0, 0, 0 }, 0 },
689  { SC_OPCODE_ROMAN, ENTRY(SC_OPCODE_ROMAN_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_ROEMISCH, 2, { 0, 1 }, 0 },
690  { SC_OPCODE_MIRR, ENTRY(SC_OPCODE_MIRR_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_QIKV, 3, { 0, 0, 0 }, 0 },
691  { SC_OPCODE_CELL, ENTRY(SC_OPCODE_CELL_ARY), 0, ID_FUNCTION_GRP_INFO, HID_FUNC_ZELLE, 2, { 0, 1 }, 0 },
692  { SC_OPCODE_ISPMT, ENTRY(SC_OPCODE_ISPMT_ARY), 0, ID_FUNCTION_GRP_FINANCIAL, HID_FUNC_ISPMT, 4, { 0, 0, 0, 0 }, 0 },
693  { SC_OPCODE_HYPERLINK, ENTRY(SC_OPCODE_HYPERLINK_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_HYPERLINK, 2, { 0, 1 }, 0 },
694  { SC_OPCODE_GET_PIVOT_DATA, ENTRY(SC_OPCODE_GET_PIVOT_DATA_ARY), 0, ID_FUNCTION_GRP_TABLE, HID_FUNC_GETPIVOTDATA, VAR_ARGS+2, { 0, 0, 1 }, 0 },
695  { SC_OPCODE_EUROCONVERT, ENTRY(SC_OPCODE_EUROCONVERT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_EUROCONVERT, 5, { 0, 0, 0, 1, 1 }, 0 },
696  { SC_OPCODE_NUMBERVALUE, ENTRY(SC_OPCODE_NUMBERVALUE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_NUMBERVALUE, 3, { 0, 1, 1 }, 0 },
697  { SC_OPCODE_CHISQ_DIST, ENTRY(SC_OPCODE_CHISQ_DIST_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHISQDIST, 3, { 0, 0, 1 }, 0 },
698  { SC_OPCODE_CHISQ_INV, ENTRY(SC_OPCODE_CHISQ_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHISQINV, 2, { 0, 0 }, 0 },
699  { SC_OPCODE_BITAND, ENTRY(SC_OPCODE_BITAND_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_BITAND, 2, { 0, 0 }, 0 },
700  { SC_OPCODE_BITOR, ENTRY(SC_OPCODE_BITOR_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_BITOR, 2, { 0, 0 }, 0 },
701  { SC_OPCODE_BITXOR, ENTRY(SC_OPCODE_BITXOR_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_BITXOR, 2, { 0, 0 }, 0 },
702  { SC_OPCODE_BITRSHIFT, ENTRY(SC_OPCODE_BITRSHIFT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_BITRSHIFT, 2, { 0, 0 }, 0 },
703  { SC_OPCODE_BITLSHIFT, ENTRY(SC_OPCODE_BITLSHIFT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_BITLSHIFT, 2, { 0, 0 }, 0 },
704  { SC_OPCODE_GET_DATEDIF, ENTRY(SC_OPCODE_GET_DATEDIF_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_DATEDIF, 3, { 0, 0, 0 }, 0 },
705  { SC_OPCODE_XOR, ENTRY(SC_OPCODE_XOR_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_XOR, VAR_ARGS, { 0 }, 0 },
706  { SC_OPCODE_AVERAGE_IF, ENTRY(SC_OPCODE_AVERAGE_IF_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_AVERAGEIF, 3, { 0, 0, 1 }, 0 },
707  { SC_OPCODE_SUM_IFS, ENTRY(SC_OPCODE_SUM_IFS_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_SUMIFS, PAIRED_VAR_ARGS+1, { 0, 0, 0 }, 0 },
708  { SC_OPCODE_AVERAGE_IFS, ENTRY(SC_OPCODE_AVERAGE_IFS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_AVERAGEIFS, PAIRED_VAR_ARGS+1, { 0, 0, 0 }, 0 },
709  { SC_OPCODE_COUNT_IFS, ENTRY(SC_OPCODE_COUNT_IFS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_COUNTIFS, PAIRED_VAR_ARGS, { 0, 0 }, 0 },
710  { SC_OPCODE_SKEWP, ENTRY(SC_OPCODE_SKEWP_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_SKEWP, VAR_ARGS, { 0 }, 0 },
711  { SC_OPCODE_LENB, ENTRY(SC_OPCODE_LENB_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_LENB, 1, { 0 }, 0 },
712  { SC_OPCODE_RIGHTB, ENTRY(SC_OPCODE_RIGHTB_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_RIGHTB, 2, { 0, 1 }, 0 },
713  { SC_OPCODE_LEFTB, ENTRY(SC_OPCODE_LEFTB_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_LEFTB, 2, { 0, 1 }, 0 },
714  { SC_OPCODE_MIDB, ENTRY(SC_OPCODE_MIDB_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_MIDB, 3, { 0, 0, 0 }, 0 },
715  { SC_OPCODE_FILTERXML, ENTRY(SC_OPCODE_FILTERXML_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_FILTERXML, 2, { 0, 0 }, 0 },
716  { SC_OPCODE_WEBSERVICE, ENTRY(SC_OPCODE_WEBSERVICE_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_WEBSERVICE, 1, { 0, 0 }, 0 },
717  { SC_OPCODE_COVARIANCE_S, ENTRY(SC_OPCODE_COVARIANCE_S_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_COVARIANCE_S, 2, { 0, 0 }, 0 },
718  { SC_OPCODE_COVARIANCE_P, ENTRY(SC_OPCODE_COVARIANCE_P_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_COVARIANCE_P, 2, { 0, 0 }, 0 },
719  { SC_OPCODE_ST_DEV_P_MS, ENTRY(SC_OPCODE_ST_DEV_P_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ST_DEV_P_MS, VAR_ARGS, { 0 }, 0 },
720  { SC_OPCODE_ST_DEV_S, ENTRY(SC_OPCODE_ST_DEV_S_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_ST_DEV_S, VAR_ARGS, { 0 }, 0 },
721  { SC_OPCODE_VAR_P_MS, ENTRY(SC_OPCODE_VAR_P_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VAR_P_MS, VAR_ARGS, { 0 }, 0 },
722  { SC_OPCODE_VAR_S, ENTRY(SC_OPCODE_VAR_S_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_VAR_S, VAR_ARGS, { 0 }, 0 },
723  { SC_OPCODE_BETA_DIST_MS, ENTRY(SC_OPCODE_BETA_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BETADIST_MS, 6, { 0, 0, 0, 0, 1, 1 }, 0 },
724  { SC_OPCODE_BETA_INV_MS, ENTRY(SC_OPCODE_BETA_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BETAINV_MS, 5, { 0, 0, 0, 1, 1 }, 0 },
725  { SC_OPCODE_BINOM_DIST_MS, ENTRY(SC_OPCODE_BINOM_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BINOM_DIST_MS, 4, { 0, 0, 0, 0 }, 0 },
726  { SC_OPCODE_BINOM_INV, ENTRY(SC_OPCODE_BINOM_INV_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_BINOM_INV_MS, 3, { 0, 0, 0 }, 0 },
727  { SC_OPCODE_CHI_DIST_MS, ENTRY(SC_OPCODE_CHI_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHIVERT_MS, 2, { 0, 0 }, 0 },
728  { SC_OPCODE_CHI_INV_MS, ENTRY(SC_OPCODE_CHI_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHIINV_MS, 2, { 0, 0 }, 0 },
729  { SC_OPCODE_CHI_TEST_MS, ENTRY(SC_OPCODE_CHI_TEST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHITEST_MS, 2, { 0, 0 }, 0 },
730  { SC_OPCODE_CHISQ_DIST_MS, ENTRY(SC_OPCODE_CHISQ_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHISQDIST_MS, 3, { 0, 0, 0 }, 0 },
731  { SC_OPCODE_CHISQ_INV_MS, ENTRY(SC_OPCODE_CHISQ_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CHISQINV_MS, 2, { 0, 0 }, 0 },
732  { SC_OPCODE_CONFIDENCE_N, ENTRY(SC_OPCODE_CONFIDENCE_N_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CONFIDENCE_N, 3, { 0, 0, 0 }, 0 },
733  { SC_OPCODE_CONFIDENCE_T, ENTRY(SC_OPCODE_CONFIDENCE_T_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_CONFIDENCE_T, 3, { 0, 0, 0 }, 0 },
734  { SC_OPCODE_F_DIST_LT, ENTRY(SC_OPCODE_F_DIST_LT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_F_DIST_LT, 4, { 0, 0, 0, 1 }, 0 },
735  { SC_OPCODE_F_DIST_RT, ENTRY(SC_OPCODE_F_DIST_RT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_F_DIST_RT, 3, { 0, 0, 0 }, 0 },
736  { SC_OPCODE_F_INV_LT, ENTRY(SC_OPCODE_F_INV_LT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_F_INV_LT, 3, { 0, 0, 0 }, 0 },
737  { SC_OPCODE_F_INV_RT, ENTRY(SC_OPCODE_F_INV_RT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_F_INV_RT, 3, { 0, 0, 0 }, 0 },
738  { SC_OPCODE_F_TEST_MS, ENTRY(SC_OPCODE_F_TEST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_F_TEST_MS, 2, { 0, 0 }, 0 },
739  { SC_OPCODE_EXP_DIST_MS, ENTRY(SC_OPCODE_EXP_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_EXP_DIST_MS, 3, { 0, 0, 0 }, 0 },
740  { SC_OPCODE_HYP_GEOM_DIST_MS, ENTRY(SC_OPCODE_HYP_GEOM_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_HYP_GEOM_DIST_MS, 5, { 0, 0, 0, 0, 0 }, 0 },
741  { SC_OPCODE_POISSON_DIST_MS, ENTRY(SC_OPCODE_POISSON_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_POISSON_DIST_MS, 3, { 0, 0, 1 }, 0 },
742  { SC_OPCODE_WEIBULL_MS, ENTRY(SC_OPCODE_WEIBULL_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_WEIBULL_DIST_MS, 4, { 0, 0, 0, 0 }, 0 },
743  { SC_OPCODE_GAMMA_DIST_MS, ENTRY(SC_OPCODE_GAMMA_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAMMADIST_MS, 4, { 0, 0, 0, 0 }, 0 },
744  { SC_OPCODE_GAMMA_INV_MS, ENTRY(SC_OPCODE_GAMMA_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_GAMMAINV_MS, 3, { 0, 0, 0 }, 0 },
745  { SC_OPCODE_LOG_NORM_DIST_MS, ENTRY(SC_OPCODE_LOG_NORM_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_LOGNORMDIST_MS, 4, { 0, 0, 0, 0 }, 0 },
746  { SC_OPCODE_LOG_INV_MS, ENTRY(SC_OPCODE_LOG_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_LOGINV, 3, { 0, 0, 0 }, 0 },
747  { SC_OPCODE_NORM_DIST_MS, ENTRY(SC_OPCODE_NORM_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_NORMDIST_MS, 4, { 0, 0, 0, 0 }, 0 },
748  { SC_OPCODE_NORM_INV_MS, ENTRY(SC_OPCODE_NORM_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_NORMINV_MS, 3, { 0, 0, 0 }, 0 },
749  { SC_OPCODE_STD_NORM_DIST_MS, ENTRY(SC_OPCODE_STD_NORM_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STD_NORMDIST_MS, 2, { 0, 0 }, 0 },
750  { SC_OPCODE_S_NORM_INV_MS, ENTRY(SC_OPCODE_S_NORM_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_STD_NORMINV_MS, 1, { 0 }, 0 },
751  { SC_OPCODE_T_DIST_MS, ENTRY(SC_OPCODE_T_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TDIST_MS, 3, { 0, 0, 0 }, 0 },
752  { SC_OPCODE_T_DIST_RT, ENTRY(SC_OPCODE_T_DIST_RT_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TDIST_RT, 2, { 0, 0 }, 0 },
753  { SC_OPCODE_T_DIST_2T, ENTRY(SC_OPCODE_T_DIST_2T_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TDIST_2T, 2, { 0, 0 }, 0 },
754  { SC_OPCODE_T_INV_2T, ENTRY(SC_OPCODE_T_INV_2T_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TINV_2T, 2, { 0, 0 }, 0 },
755  { SC_OPCODE_T_INV_MS, ENTRY(SC_OPCODE_T_INV_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TINV_MS, 2, { 0, 0 }, 0 },
756  { SC_OPCODE_T_TEST_MS, ENTRY(SC_OPCODE_T_TEST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_TTEST_MS, 4, { 0, 0, 0, 0 }, 0 },
757  { SC_OPCODE_PERCENTILE_INC, ENTRY(SC_OPCODE_PERCENTILE_INC_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_PERCENTILE_INC, 2, { 0, 0 }, 0 },
758  { SC_OPCODE_PERCENT_RANK_INC, ENTRY(SC_OPCODE_PERCENT_RANK_INC_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_PERCENTRANK_INC, 3, { 0, 0, 1 }, 0 },
759  { SC_OPCODE_QUARTILE_INC, ENTRY(SC_OPCODE_QUARTILE_INC_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_QUARTILE_INC, 2, { 0, 0 }, 0 },
760  { SC_OPCODE_RANK_EQ, ENTRY(SC_OPCODE_RANK_EQ_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_RANK_EQ, 3, { 0, 0, 1 }, 0 },
761  { SC_OPCODE_PERCENTILE_EXC, ENTRY(SC_OPCODE_PERCENTILE_EXC_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_PERCENTILE_EXC, 2, { 0, 0 }, 0 },
762  { SC_OPCODE_PERCENT_RANK_EXC, ENTRY(SC_OPCODE_PERCENT_RANK_EXC_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_PERCENTRANK_EXC, 3, { 0, 0, 1 }, 0 },
763  { SC_OPCODE_QUARTILE_EXC, ENTRY(SC_OPCODE_QUARTILE_EXC_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_QUARTILE_EXC, 2, { 0, 0 }, 0 },
764  { SC_OPCODE_RANK_AVG, ENTRY(SC_OPCODE_RANK_AVG_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_RANK_AVG, 3, { 0, 0, 1 }, 0 },
765  { SC_OPCODE_MODAL_VALUE_MS, ENTRY(SC_OPCODE_MODAL_VALUE_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MODAL_VALUE_MS, VAR_ARGS, { 0 }, 0 },
766  { SC_OPCODE_MODAL_VALUE_MULTI, ENTRY(SC_OPCODE_MODAL_VALUE_MULTI_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MODAL_VALUE_MULTI, VAR_ARGS, { 0 }, 0 },
767  { SC_OPCODE_NEG_BINOM_DIST_MS, ENTRY(SC_OPCODE_NEG_BINOM_DIST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_NEGBINOMDIST_MS, 4, { 0, 0, 0, 0 }, 0 },
768  { SC_OPCODE_Z_TEST_MS, ENTRY(SC_OPCODE_Z_TEST_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_Z_TEST_MS, 3, { 0, 0, 1 }, 0 },
769  { SC_OPCODE_CEIL_MS, ENTRY(SC_OPCODE_CEIL_MS_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_CEIL_MS, 2, { 0, 0 }, 0 },
770  { SC_OPCODE_CEIL_ISO, ENTRY(SC_OPCODE_CEIL_ISO_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_CEIL_ISO, 2, { 0, 1 }, 0 },
771  { SC_OPCODE_FLOOR_MS, ENTRY(SC_OPCODE_FLOOR_MS_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_FLOOR_MS, 2, { 0, 0 }, 0 },
772  { SC_OPCODE_NETWORKDAYS_MS, ENTRY(SC_OPCODE_NETWORKDAYS_MS_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_NETWORKDAYS_MS, 4, { 0, 0, 1, 1 }, 0 },
773  { SC_OPCODE_WORKDAY_MS, ENTRY(SC_OPCODE_WORKDAY_MS_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_WORKDAY_MS, 4, { 0, 0, 1, 1 }, 0 },
774  { SC_OPCODE_AGGREGATE, ENTRY(SC_OPCODE_AGGREGATE_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_AGGREGATE, VAR_ARGS+3, { 0, 0, 0, 1 }, 0 },
775  { SC_OPCODE_COLOR, ENTRY(SC_OPCODE_COLOR_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_COLOR, 4, { 0, 0, 0, 1 }, 0 },
776  { SC_OPCODE_CEIL_MATH, ENTRY(SC_OPCODE_CEIL_MATH_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_CEIL_MATH, 3, { 0, 1, 1 }, 0 },
777  { SC_OPCODE_CEIL_PRECISE, ENTRY(SC_OPCODE_CEIL_PRECISE_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_CEIL_PRECISE, 2, { 0, 1 }, 0 },
778  { SC_OPCODE_NETWORKDAYS, ENTRY(SC_OPCODE_NETWORKDAYS_ARY), 0, ID_FUNCTION_GRP_DATETIME, HID_FUNC_NETWORKDAYS, 4, { 0, 0, 1, 1 }, 0 },
779  { SC_OPCODE_FLOOR_MATH, ENTRY(SC_OPCODE_FLOOR_MATH_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_FLOOR_MATH, 3, { 0, 1, 1 }, 0 },
780  { SC_OPCODE_FLOOR_PRECISE, ENTRY(SC_OPCODE_FLOOR_PRECISE_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_FLOOR_PRECISE, 2, { 0, 1 }, 0 },
781  { SC_OPCODE_RAWSUBTRACT, ENTRY(SC_OPCODE_RAWSUBTRACT_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_RAWSUBTRACT, VAR_ARGS+2, { 0, 0, 1 }, 0 },
782  { SC_OPCODE_WEEKNUM_OOO, ENTRY(SC_OPCODE_WEEKNUM_OOO_ARY), 2, ID_FUNCTION_GRP_DATETIME, HID_FUNC_WEEKNUM_OOO, 2, { 0, 0 }, 0 },
783  { SC_OPCODE_FORECAST_ETS_ADD, ENTRY(SC_OPCODE_FORECAST_ETS_ADD_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_ETS_ADD, 6, { 0, 0, 0, 1, 1, 1 }, 0 },
784  { SC_OPCODE_FORECAST_ETS_SEA, ENTRY(SC_OPCODE_FORECAST_ETS_SEA_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_ETS_SEA, 4, { 0, 0, 1, 1 }, 0 },
785  { SC_OPCODE_FORECAST_ETS_MUL, ENTRY(SC_OPCODE_FORECAST_ETS_MUL_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_ETS_MUL, 6, { 0, 0, 0, 1, 1, 1 }, 0 },
786  { SC_OPCODE_FORECAST_ETS_PIA, ENTRY(SC_OPCODE_FORECAST_ETS_PIA_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_ETS_PIA, 7, { 0, 0, 0, 1, 1, 1, 1 }, 0 },
787  { SC_OPCODE_FORECAST_ETS_PIM, ENTRY(SC_OPCODE_FORECAST_ETS_PIM_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_ETS_PIM, 7, { 0, 0, 0, 1, 1, 1, 1 }, 0 },
788  { SC_OPCODE_FORECAST_ETS_STA, ENTRY(SC_OPCODE_FORECAST_ETS_STA_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_ETS_STA, 6, { 0, 0, 0, 1, 1, 1 }, 0 },
789  { SC_OPCODE_FORECAST_ETS_STM, ENTRY(SC_OPCODE_FORECAST_ETS_STM_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_ETS_STM, 6, { 0, 0, 0, 1, 1, 1 }, 0 },
790  { SC_OPCODE_FORECAST_LIN, ENTRY(SC_OPCODE_FORECAST_LIN_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_FORECAST_LIN, 3, { 0, 0, 0 }, 0 },
791  { SC_OPCODE_CONCAT_MS, ENTRY(SC_OPCODE_CONCAT_MS_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_CONCAT_MS, VAR_ARGS, { 0 }, 0 },
792  { SC_OPCODE_TEXTJOIN_MS, ENTRY(SC_OPCODE_TEXTJOIN_MS_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_TEXTJOIN_MS, VAR_ARGS + 2, { 0, 0, 0 }, 0 },
793  { SC_OPCODE_IFS_MS, ENTRY(SC_OPCODE_IFS_MS_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_IFS_MS, PAIRED_VAR_ARGS, { 0, 0 }, 0 },
794  { SC_OPCODE_SWITCH_MS, ENTRY(SC_OPCODE_SWITCH_MS_ARY), 0, ID_FUNCTION_GRP_LOGIC, HID_FUNC_SWITCH_MS, PAIRED_VAR_ARGS + 1, { 0, 0, 0 }, 0 },
795  { SC_OPCODE_MINIFS_MS, ENTRY(SC_OPCODE_MINIFS_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MINIFS_MS, PAIRED_VAR_ARGS + 1, { 0, 0, 0 }, 0 },
796  { SC_OPCODE_MAXIFS_MS, ENTRY(SC_OPCODE_MAXIFS_MS_ARY), 0, ID_FUNCTION_GRP_STATISTIC, HID_FUNC_MAXIFS_MS, PAIRED_VAR_ARGS + 1, { 0, 0, 0 }, 0 },
797  { SC_OPCODE_ROUNDSIG, ENTRY(SC_OPCODE_ROUNDSIG_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_ROUNDSIG, 2, { 0, 0 }, 0 },
798  { SC_OPCODE_REPLACEB, ENTRY(SC_OPCODE_REPLACEB_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_REPLACEB, 4, { 0, 0, 0, 0 }, 0 },
799  { SC_OPCODE_FINDB, ENTRY(SC_OPCODE_FINDB_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_FINDB, 3, { 0, 0, 1 }, 0 },
800  { SC_OPCODE_SEARCHB, ENTRY(SC_OPCODE_SEARCHB_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_SEARCHB, 3, { 0, 0, 1 }, 0 },
801  { SC_OPCODE_REGEX, ENTRY(SC_OPCODE_REGEX_ARY), 0, ID_FUNCTION_GRP_TEXT, HID_FUNC_REGEX, 4, { 0, 0, 1, 1 }, 0 },
802  { SC_OPCODE_FOURIER, ENTRY(SC_OPCODE_FOURIER_ARY), 0, ID_FUNCTION_GRP_MATRIX, HID_FUNC_FOURIER, 5, { 0, 0, 1, 1, 1 }, 0 },
803  { SC_OPCODE_RANDBETWEEN_NV, ENTRY(SC_OPCODE_RANDBETWEEN_NV_ARY), 0, ID_FUNCTION_GRP_MATH, HID_FUNC_RANDBETWEEN_NV, 2, { 0, 0 }, 0 }
804  };
805 
806  ScFuncDesc* pDesc = nullptr;
807  sal_Int32 nStrLen = 0;
808  ::std::vector<const ScFuncDesc*> tmpFuncVector;
809 
810  // Browse for all possible OpCodes. This is not the fastest method, but
811  // otherwise the sub resources within the resource blocks and the
812  // resource blocks themselves would had to be ordered according to
813  // OpCodes, which is utopian...
814  ScFuncDescCore const * pDescsEnd = aDescs + SAL_N_ELEMENTS(aDescs);
815  for (sal_uInt16 i = 0; i <= SC_OPCODE_LAST_OPCODE_ID; ++i)
816  {
817  const ScFuncDescCore *pEntry = std::lower_bound(aDescs, pDescsEnd, i,
818  [](const ScFuncDescCore &rItem, sal_uInt16 key)
819  {
820  return rItem.nOpCode < key;
821  }
822  );
823 
824  // Opcode Resource available?
825  if (pEntry != pDescsEnd && pEntry->nOpCode == i && pEntry->pResource)
826  {
827  pDesc = new ScFuncDesc;
828  bool bSuppressed = false;
829 
830  ScFuncRes(*pEntry, pDesc, bSuppressed);
831  // Instead of dealing with this exceptional case at 1001 places
832  // we simply don't add an entirely suppressed function to the
833  // list and delete it.
834  if (bSuppressed)
835  delete pDesc;
836  else
837  {
838  pDesc->nFIndex = i;
839  tmpFuncVector.push_back(pDesc);
840 
841  nStrLen = pDesc->mxFuncName->getLength();
842  if (nStrLen > nMaxFuncNameLen)
843  nMaxFuncNameLen = nStrLen;
844  }
845  }
846  }
847 
848  // legacy binary AddIn functions
849 
850  sal_uInt16 nNextId = SC_OPCODE_LAST_OPCODE_ID + 1; // FuncID for AddIn functions
851 
852  // Interpretation of AddIn list
853  OUString aDefArgNameValue = "value";
854  OUString aDefArgNameString = "string";
855  OUString aDefArgNameValues = "values";
856  OUString aDefArgNameStrings = "strings";
857  OUString aDefArgNameCells = "cells";
858  OUString aDefArgNameNone = "none";
859  OUString aDefArgDescValue = "a value";
860  OUString aDefArgDescString = "a string";
861  OUString aDefArgDescValues = "array of values";
862  OUString aDefArgDescStrings = "array of strings";
863  OUString aDefArgDescCells = "range of cells";
864  OUString aDefArgDescNone = "none";
865 
866  OUString aArgName, aArgDesc;
867  const LegacyFuncCollection& rLegacyFuncColl = *ScGlobal::GetLegacyFuncCollection();
868  for (auto const& legacyFunc : rLegacyFuncColl)
869  {
870  const LegacyFuncData *const pLegacyFuncData = legacyFunc.second.get();
871  pDesc = new ScFuncDesc;
872  sal_uInt16 nArgs = pLegacyFuncData->GetParamCount() - 1;
873  pLegacyFuncData->getParamDesc( aArgName, aArgDesc, 0 );
874  pDesc->nFIndex = nNextId++; // ??? OpCode vergeben
875  pDesc->nCategory = ID_FUNCTION_GRP_ADDINS;
876  pDesc->mxFuncName = pLegacyFuncData->GetInternalName().toAsciiUpperCase();
877  pDesc->mxFuncDesc = aArgDesc + "\n"
878  "( AddIn: " + pLegacyFuncData->GetModuleName() + " )";
879  pDesc->nArgCount = nArgs;
880  if (nArgs)
881  {
882  pDesc->maDefArgNames.clear();
883  pDesc->maDefArgNames.resize(nArgs);
884  pDesc->maDefArgDescs.clear();
885  pDesc->maDefArgDescs.resize(nArgs);
886  pDesc->pDefArgFlags = new ScFuncDesc::ParameterFlags[nArgs];
887  for (sal_uInt16 j = 0; j < nArgs; ++j)
888  {
889  pDesc->pDefArgFlags[j].bOptional = false;
890  pLegacyFuncData->getParamDesc( aArgName, aArgDesc, j+1 );
891  if ( !aArgName.isEmpty() )
892  pDesc->maDefArgNames[j] = aArgName;
893  else
894  {
895  switch (pLegacyFuncData->GetParamType(j+1))
896  {
897  case ParamType::PTR_DOUBLE:
898  pDesc->maDefArgNames[j] = aDefArgNameValue;
899  break;
900  case ParamType::PTR_STRING:
901  pDesc->maDefArgNames[j] = aDefArgNameString;
902  break;
903  case ParamType::PTR_DOUBLE_ARR:
904  pDesc->maDefArgNames[j] = aDefArgNameValues;
905  break;
906  case ParamType::PTR_STRING_ARR:
907  pDesc->maDefArgNames[j] = aDefArgNameStrings;
908  break;
909  case ParamType::PTR_CELL_ARR:
910  pDesc->maDefArgNames[j] = aDefArgNameCells;
911  break;
912  default:
913  pDesc->maDefArgNames[j] = aDefArgNameNone;
914  break;
915  }
916  }
917  if ( !aArgDesc.isEmpty() )
918  pDesc->maDefArgDescs[j] = aArgDesc;
919  else
920  {
921  switch (pLegacyFuncData->GetParamType(j+1))
922  {
923  case ParamType::PTR_DOUBLE:
924  pDesc->maDefArgDescs[j] = aDefArgDescValue;
925  break;
926  case ParamType::PTR_STRING:
927  pDesc->maDefArgDescs[j] = aDefArgDescString;
928  break;
929  case ParamType::PTR_DOUBLE_ARR:
930  pDesc->maDefArgDescs[j] = aDefArgDescValues;
931  break;
932  case ParamType::PTR_STRING_ARR:
933  pDesc->maDefArgDescs[j] = aDefArgDescStrings;
934  break;
935  case ParamType::PTR_CELL_ARR:
936  pDesc->maDefArgDescs[j] = aDefArgDescCells;
937  break;
938  default:
939  pDesc->maDefArgDescs[j] = aDefArgDescNone;
940  break;
941  }
942  }
943  }
944  }
945 
946  tmpFuncVector.push_back(pDesc);
947  nStrLen = pDesc->mxFuncName->getLength();
948  if ( nStrLen > nMaxFuncNameLen)
949  nMaxFuncNameLen = nStrLen;
950  }
951 
952  // StarOne AddIns
953 
954  ScUnoAddInCollection* pUnoAddIns = ScGlobal::GetAddInCollection();
955  tools::Long nUnoCount = pUnoAddIns->GetFuncCount();
956  for (tools::Long nFunc=0; nFunc<nUnoCount; nFunc++)
957  {
958  pDesc = new ScFuncDesc;
959  pDesc->nFIndex = nNextId++;
960 
961  if ( pUnoAddIns->FillFunctionDesc( nFunc, *pDesc ) )
962  {
963  tmpFuncVector.push_back(pDesc);
964  nStrLen = pDesc->mxFuncName->getLength();
965  if (nStrLen > nMaxFuncNameLen)
966  nMaxFuncNameLen = nStrLen;
967  }
968  else
969  delete pDesc;
970  }
971 
972  aFunctionList.swap(tmpFuncVector);
973 
974  //Initialize iterator
975  aFunctionListIter = aFunctionList.end();
976 }
977 
978 ScFunctionList::~ScFunctionList()
979 {
980  const ScFuncDesc* pDesc = First();
981  while (pDesc)
982  {
983  delete pDesc;
984  pDesc = Next();
985  }
986 }
987 
988 const ScFuncDesc* ScFunctionList::First()
989 {
990  const ScFuncDesc* pDesc = nullptr;
991  aFunctionListIter = aFunctionList.begin();
992  if(aFunctionListIter != aFunctionList.end())
993  pDesc = *aFunctionListIter;
994 
995  return pDesc;
996 }
997 
998 const ScFuncDesc* ScFunctionList::Next()
999 {
1000  const ScFuncDesc* pDesc = nullptr;
1001  if(aFunctionListIter != aFunctionList.end())
1002  {
1003  if((++aFunctionListIter) != aFunctionList.end())
1004  pDesc = *aFunctionListIter;
1005  }
1006  return pDesc;
1007 }
1008 
1009 const ScFuncDesc* ScFunctionList::GetFunction( sal_uInt32 nIndex ) const
1010 {
1011  const ScFuncDesc* pDesc = nullptr;
1012  if(nIndex < aFunctionList.size())
1013  pDesc = aFunctionList.at(nIndex);
1014 
1015  return pDesc;
1016 }
1017 
1018 
1019 sal_uInt32 ScFunctionCategory::getCount() const
1020 {
1021  return m_rCategory.size();
1022 }
1023 
1024 OUString ScFunctionCategory::getName() const
1025 {
1026  if ( m_sName.isEmpty() )
1027  m_sName = ScFunctionMgr::GetCategoryName(m_nCategory);
1028  return m_sName;
1029 }
1030 
1031 const formula::IFunctionDescription* ScFunctionCategory::getFunction(sal_uInt32 _nPos) const
1032 {
1033  const ScFuncDesc* pDesc = nullptr;
1034  if(_nPos < m_rCategory.size())
1035  pDesc = m_rCategory.at(_nPos);
1036  return pDesc;
1037 }
1038 
1039 sal_uInt32 ScFunctionCategory::getNumber() const
1040 {
1041  return m_nCategory;
1042 }
1043 
1044 
1045 ScFunctionMgr::ScFunctionMgr()
1046 {
1047  ScFunctionList* pFuncList
1048  = ScGlobal::GetStarCalcFunctionList();
1049 
1050  OSL_ENSURE( pFuncList, "Functionlist not found." );
1051  sal_uInt32 catCount[MAX_FUNCCAT] = {0};
1052 
1053  aCatLists[0].reserve(pFuncList->GetCount());
1054 
1055  // Retrieve all functions, store in cumulative ("All") category, and count
1056  // number of functions in each category
1057  for(const ScFuncDesc* pDesc = pFuncList->First(); pDesc; pDesc = pFuncList->Next())
1058  {
1059  OSL_ENSURE((pDesc->nCategory) < MAX_FUNCCAT, "Unknown category");
1060  if ((pDesc->nCategory) < MAX_FUNCCAT)
1061  ++catCount[pDesc->nCategory];
1062  aCatLists[0].push_back(pDesc);
1063  }
1064 
1065  // Sort functions in cumulative category by name
1066  ::std::sort(aCatLists[0].begin(), aCatLists[0].end(), ScFuncDesc::compareByName);
1067 
1068  // Allocate correct amount of space for categories
1069  for (sal_uInt16 i = 1; i < MAX_FUNCCAT; ++i)
1070  {
1071  aCatLists[i].reserve(catCount[i]);
1072  }
1073 
1074  // Fill categories with the corresponding functions (still sorted by name)
1075  for (auto const& elemList : aCatLists[0])
1076  {
1077  if ((elemList->nCategory) < MAX_FUNCCAT)
1078  aCatLists[elemList->nCategory].push_back(elemList);
1079  }
1080 
1081  // Initialize iterators
1082  pCurCatListIter = aCatLists[0].end();
1083  pCurCatListEnd = aCatLists[0].end();
1084 }
1085 
1086 ScFunctionMgr::~ScFunctionMgr()
1087 {
1088 }
1089 
1090 
1091 const ScFuncDesc* ScFunctionMgr::Get( sal_uInt16 nFIndex ) const
1092 {
1093  const ScFuncDesc* pDesc;
1094  for (pDesc = First(); pDesc; pDesc = Next())
1095  if (pDesc->nFIndex == nFIndex)
1096  break;
1097  return pDesc;
1098 }
1099 
1100 const ScFuncDesc* ScFunctionMgr::First( sal_uInt16 nCategory ) const
1101 {
1102  OSL_ENSURE( nCategory < MAX_FUNCCAT, "Unknown category" );
1103  const ScFuncDesc* pDesc = nullptr;
1104  if ( nCategory < MAX_FUNCCAT )
1105  {
1106  pCurCatListIter = aCatLists[nCategory].begin();
1107  pCurCatListEnd = aCatLists[nCategory].end();
1108  pDesc = *pCurCatListIter;
1109  }
1110  else
1111  {
1112  pCurCatListIter = aCatLists[0].end();
1113  pCurCatListEnd = aCatLists[0].end();
1114  }
1115  return pDesc;
1116 }
1117 
1118 const ScFuncDesc* ScFunctionMgr::Next() const
1119 {
1120  const ScFuncDesc* pDesc = nullptr;
1121  if ( pCurCatListIter != pCurCatListEnd )
1122  {
1123  if ( (++pCurCatListIter) != pCurCatListEnd )
1124  {
1125  pDesc = *pCurCatListIter;
1126  }
1127  }
1128  return pDesc;
1129 }
1130 
1131 sal_uInt32 ScFunctionMgr::getCount() const
1132 {
1133  return MAX_FUNCCAT - 1;
1134 }
1135 
1136 const formula::IFunctionCategory* ScFunctionMgr::getCategory(sal_uInt32 nCategory) const
1137 {
1138  if ( nCategory < (MAX_FUNCCAT-1) )
1139  {
1140  if (m_aCategories.find(nCategory) == m_aCategories.end())
1141  m_aCategories[nCategory] = std::make_shared<ScFunctionCategory>(aCatLists[nCategory+1],nCategory); // aCatLists[0] is "all"
1142  return m_aCategories[nCategory].get();
1143  }
1144  return nullptr;
1145 }
1146 
1147 void ScFunctionMgr::fillLastRecentlyUsedFunctions(::std::vector< const formula::IFunctionDescription*>& _rLastRUFunctions) const
1148 {
1149  const ScAppOptions& rAppOpt = SC_MOD()->GetAppOptions();
1150  sal_uInt16 nLRUFuncCount = std::min( rAppOpt.GetLRUFuncListCount(), sal_uInt16(LRU_MAX) );
1151  sal_uInt16* pLRUListIds = rAppOpt.GetLRUFuncList();
1152  _rLastRUFunctions.clear();
1153 
1154  if ( pLRUListIds )
1155  {
1156  for (sal_uInt16 i = 0; i < nLRUFuncCount; ++i)
1157  {
1158  _rLastRUFunctions.push_back( Get( pLRUListIds[i] ) );
1159  }
1160  }
1161 }
1162 
1163 OUString ScFunctionMgr::GetCategoryName(sal_uInt32 _nCategoryNumber )
1164 {
1165  if (_nCategoryNumber >= SC_FUNCGROUP_COUNT)
1166  {
1167  OSL_FAIL("Invalid category number!");
1168  return OUString();
1169  }
1170 
1171  return ScResId(RID_FUNCTION_CATEGORIES[_nCategoryNumber]);
1172 }
1173 
1174 sal_Unicode ScFunctionMgr::getSingleToken(const formula::IFunctionManager::EToken _eToken) const
1175 {
1176  switch(_eToken)
1177  {
1178  case eOk:
1179  return ScCompiler::GetNativeSymbolChar(ocOpen);
1180  case eClose:
1181  return ScCompiler::GetNativeSymbolChar(ocClose);
1182  case eSep:
1183  return ScCompiler::GetNativeSymbolChar(ocSep);
1184  case eArrayOpen:
1185  return ScCompiler::GetNativeSymbolChar(ocArrayOpen);
1186  case eArrayClose:
1187  return ScCompiler::GetNativeSymbolChar(ocArrayClose);
1188  }
1189  return 0;
1190 }
1191 
1192 static void ScFuncRes(const ScFuncDescCore &rEntry, ScFuncDesc* pDesc, bool& rbSuppressed)
1193 {
1194  const sal_uInt16 nOpCode = rEntry.nOpCode;
1195  sal_uInt16 nFunctionFlags = rEntry.nFunctionFlags;
1196  // Bit 1: entirely suppressed
1197  // Bit 2: hidden unless used
1198  rbSuppressed = ((nFunctionFlags & 1) != 0);
1199  pDesc->mbHidden = ((nFunctionFlags & 2) != 0);
1200  pDesc->nCategory = rEntry.nCategory;
1201  pDesc->sHelpId = rEntry.pHelpId;
1202  pDesc->nArgCount = rEntry.nArgs;
1203  sal_uInt16 nArgs = pDesc->nArgCount;
1204  sal_uInt16 nVarArgsSet = 0;
1205  if (nArgs >= PAIRED_VAR_ARGS)
1206  {
1207  nVarArgsSet = 2;
1208  nArgs -= PAIRED_VAR_ARGS - nVarArgsSet;
1209  }
1210  else if (nArgs >= VAR_ARGS)
1211  {
1212  nVarArgsSet = 1;
1213  nArgs -= VAR_ARGS - nVarArgsSet;
1214  }
1215  assert(nArgs <= SAL_N_ELEMENTS(rEntry.aOptionalArgs));
1216  if (nArgs)
1217  {
1218  pDesc->nVarArgsStart = nArgs - nVarArgsSet;
1219  pDesc->nVarArgsLimit = rEntry.nVarArgsLimit;
1220  pDesc->pDefArgFlags = new ScFuncDesc::ParameterFlags[nArgs];
1221  for (sal_uInt16 i = 0; i < nArgs; ++i)
1222  {
1223  pDesc->pDefArgFlags[i].bOptional = static_cast<bool>(rEntry.aOptionalArgs[i]);
1224  }
1225  }
1226 
1227  pDesc->mxFuncName = ScCompiler::GetNativeSymbol(static_cast<OpCode>(nOpCode));
1228  pDesc->mxFuncDesc = ScResId(rEntry.pResource[0]);
1229 
1230  if (!nArgs)
1231  return;
1232 
1233  pDesc->maDefArgNames.clear();
1234  pDesc->maDefArgNames.resize(nArgs);
1235  pDesc->maDefArgDescs.clear();
1236  pDesc->maDefArgDescs.resize(nArgs);
1237  for (sal_uInt16 i = 0; i < nArgs; ++i)
1238  {
1239  size_t nIndex = (i * 2) + 1;
1240  if (nIndex < rEntry.nResourceLen)
1241  pDesc->maDefArgNames[i] = ScResId(rEntry.pResource[nIndex]);
1242  if (nIndex + 1 < rEntry.nResourceLen)
1243  pDesc->maDefArgDescs[i] = ScResId(rEntry.pResource[nIndex + 1]);
1244  // If empty and variable number of arguments and last parameter and
1245  // parameter is optional and the previous is not optional, repeat
1246  // previous parameter name and description.
1247  if ((pDesc->maDefArgNames[i].isEmpty() || pDesc->maDefArgDescs[i].isEmpty()) &&
1248  nVarArgsSet > 0 && i > nVarArgsSet && (i == nArgs-1 || i == nArgs-2) &&
1249  pDesc->pDefArgFlags[i].bOptional)
1250  {
1251  sal_uInt16 nPrev = i - nVarArgsSet;
1252  if (!pDesc->pDefArgFlags[nPrev].bOptional)
1253  {
1254  if (pDesc->maDefArgNames[i].isEmpty())
1255  pDesc->maDefArgNames[i] = pDesc->maDefArgNames[nPrev];
1256  if (pDesc->maDefArgDescs[i].isEmpty())
1257  pDesc->maDefArgDescs[i] = pDesc->maDefArgDescs[nPrev];
1258  // This also means that variable arguments start one
1259  // parameter set earlier.
1260  pDesc->nVarArgsStart -= nVarArgsSet;
1261  }
1262  }
1263  }
1264 }
1265 
1266 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
HID_FUNC_BITLSHIFT
#define HID_FUNC_BITLSHIFT
Definition: helpids.h:500
ScFunctionMgr::getCount
virtual sal_uInt32 getCount() const override
Definition: funcdesc.cxx:1131
ScFunctionCategory::m_nCategory
sal_uInt32 m_nCategory
index number of this category
Definition: funcdesc.hxx:298
HID_FUNC_BITAND
#define HID_FUNC_BITAND
Definition: helpids.h:497
SC_OPCODE_CRIT_BINOM
#define SC_OPCODE_CRIT_BINOM
HID_FUNC_QUANTILSRANG
#define HID_FUNC_QUANTILSRANG
Definition: helpids.h:378
SC_OPCODE_DB_STD_DEV
#define SC_OPCODE_DB_STD_DEV
SC_OPCODE_ABS
#define SC_OPCODE_ABS
SC_OPCODE_REPT
#define SC_OPCODE_REPT
HID_FUNC_COSECANT
#define HID_FUNC_COSECANT
Definition: helpids.h:313
ScFuncDesc::isHidden
virtual bool isHidden() const override
Returns whether function is hidden and not offered in the Function Wizard unless used in an expressio...
Definition: funcdesc.cxx:358
HID_FUNC_F_DIST_LT
#define HID_FUNC_F_DIST_LT
Definition: helpids.h:523
SC_OPCODE_BITXOR
#define SC_OPCODE_BITXOR
ID_FUNCTION_GRP_INFO
#define ID_FUNCTION_GRP_INFO
Definition: scfuncs.hxx:24
HID_FUNC_TTEST
#define HID_FUNC_TTEST
Definition: helpids.h:418
ID_FUNCTION_GRP_ADDINS
#define ID_FUNCTION_GRP_ADDINS
Definition: scfuncs.hxx:31
ScFunctionList
List of spreadsheet functions.
Definition: funcdesc.hxx:241
HID_FUNC_ANZAHLLEEREZELLEN
#define HID_FUNC_ANZAHLLEEREZELLEN
Definition: helpids.h:279
HID_FUNC_MITTELWERTA
#define HID_FUNC_MITTELWERTA
Definition: helpids.h:429
HID_FUNC_MINIFS_MS
#define HID_FUNC_MINIFS_MS
Definition: helpids.h:586
HID_FUNC_QUARTILE
#define HID_FUNC_QUARTILE
Definition: helpids.h:375
SC_OPCODE_SUM_XMY2
#define SC_OPCODE_SUM_XMY2
SC_OPCODE_TRUNC
#define SC_OPCODE_TRUNC
ID_FUNCTION_GRP_DATETIME
#define ID_FUNCTION_GRP_DATETIME
Definition: scfuncs.hxx:22
HID_FUNC_PEARSON
#define HID_FUNC_PEARSON
Definition: helpids.h:423
SC_OPCODE_DB_AVERAGE
#define SC_OPCODE_DB_AVERAGE
SC_OPCODE_CEIL_ISO
#define SC_OPCODE_CEIL_ISO
SC_OPCODE_DB
#define SC_OPCODE_DB
SC_OPCODE_COUNT_EMPTY_CELLS
#define SC_OPCODE_COUNT_EMPTY_CELLS
ScGlobal::GetAddInCollection
static SC_DLLPUBLIC ScUnoAddInCollection * GetAddInCollection()
Definition: global.cxx:279
SC_OPCODE_LENB
#define SC_OPCODE_LENB
HID_FUNC_SUMMENPRODUKT
#define HID_FUNC_SUMMENPRODUKT
Definition: helpids.h:346
SC_OPCODE_LOG
#define SC_OPCODE_LOG
SC_OPCODE_COVARIANCE_P
#define SC_OPCODE_COVARIANCE_P
SC_OPCODE_PROPER
#define SC_OPCODE_PROPER
ScFunctionCategory::m_sName
OUString m_sName
name of this category
Definition: funcdesc.hxx:297
SC_OPCODE_LARGE
#define SC_OPCODE_LARGE
nIndex
sal_Int32 nIndex
HID_FUNC_BINOMVERT
#define HID_FUNC_BINOMVERT
Definition: helpids.h:387
ScFuncDesc::getVarArgsStart
virtual sal_uInt32 getVarArgsStart() const override
Returns start of variable arguments.
Definition: funcdesc.cxx:368
SC_OPCODE_DB_SUM
#define SC_OPCODE_DB_SUM
SC_OPCODE_ARC_SIN_HYP
#define SC_OPCODE_ARC_SIN_HYP
SC_OPCODE_LINEST
#define SC_OPCODE_LINEST
HID_FUNC_KGROESSTE
#define HID_FUNC_KGROESSTE
Definition: helpids.h:376
SC_OPCODE_GET_SEC
#define SC_OPCODE_GET_SEC
ScFunctionMgr::m_aCategories
std::map< sal_uInt32, std::shared_ptr< ScFunctionCategory > > m_aCategories
map of category pos to IFunctionCategory
Definition: funcdesc.hxx:398
SC_OPCODE_LN
#define SC_OPCODE_LN
HID_FUNC_WURZEL
#define HID_FUNC_WURZEL
Definition: helpids.h:290
SC_OPCODE_SUM_X2MY2
#define SC_OPCODE_SUM_X2MY2
HID_FUNC_ISTNV
#define HID_FUNC_ISTNV
Definition: helpids.h:254
SC_OPCODE_ST_DEV
#define SC_OPCODE_ST_DEV
SC_OPCODE_RANK_EQ
#define SC_OPCODE_RANK_EQ
HID_FUNC_FTEST
#define HID_FUNC_FTEST
Definition: helpids.h:417
HID_FUNC_LOG10
#define HID_FUNC_LOG10
Definition: helpids.h:322
LegacyFuncData::GetParamCount
sal_uInt16 GetParamCount() const
Definition: callform.hxx:75
SC_OPCODE_BETA_DIST
#define SC_OPCODE_BETA_DIST
SC_OPCODE_COVARIANCE_S
#define SC_OPCODE_COVARIANCE_S
SC_OPCODE_GET_TIME
#define SC_OPCODE_GET_TIME
PAIRED_VAR_ARGS
#define PAIRED_VAR_ARGS
SC_OPCODE_AVERAGE_IF
#define SC_OPCODE_AVERAGE_IF
HID_FUNC_GAMMA
#define HID_FUNC_GAMMA
Definition: helpids.h:436
ScResId
OUString ScResId(TranslateId aId)
Definition: scdll.cxx:90
HID_FUNC_BINOM_DIST_MS
#define HID_FUNC_BINOM_DIST_MS
Definition: helpids.h:514
ScFuncDesc::GetSuppressedArgCount
sal_uInt16 GetSuppressedArgCount() const
Returns the number of non-suppressed arguments.
Definition: funcdesc.cxx:278
HID_FUNC_LEFTB
#define HID_FUNC_LEFTB
Definition: helpids.h:483
HID_FUNC_SIN
#define HID_FUNC_SIN
Definition: helpids.h:305
HID_FUNC_ACHSENABSCHNITT
#define HID_FUNC_ACHSENABSCHNITT
Definition: helpids.h:420
ScFuncDesc::ParameterFlags::bOptional
bool bOptional
Parameter is optional.
Definition: funcdesc.hxx:211
SC_OPCODE_MID
#define SC_OPCODE_MID
HID_FUNC_ZGZ
#define HID_FUNC_ZGZ
Definition: helpids.h:245
SC_OPCODE_CHISQ_INV_MS
#define SC_OPCODE_CHISQ_INV_MS
HID_FUNC_BETAINV_MS
#define HID_FUNC_BETAINV_MS
Definition: helpids.h:513
HID_FUNC_SUMME
#define HID_FUNC_SUMME
Definition: helpids.h:281
HID_FUNC_TYP
#define HID_FUNC_TYP
Definition: helpids.h:261
SC_OPCODE_CHISQ_INV
#define SC_OPCODE_CHISQ_INV
HID_FUNC_FEST
#define HID_FUNC_FEST
Definition: helpids.h:476
HID_FUNC_TABELLE
#define HID_FUNC_TABELLE
Definition: helpids.h:455
ScFunctionMgr::aCatLists
std::vector< const ScFuncDesc * > aCatLists[MAX_FUNCCAT]
array of all categories, 0 is the cumulative ('All') category
Definition: funcdesc.hxx:397
HID_FUNC_NICHT
#define HID_FUNC_NICHT
Definition: helpids.h:268
HID_FUNC_GAMMADIST_MS
#define HID_FUNC_GAMMADIST_MS
Definition: helpids.h:532
SC_OPCODE_SUM_IF
#define SC_OPCODE_SUM_IF
ScFuncDesc::getSuppressedArgumentCount
virtual sal_Int32 getSuppressedArgumentCount() const override
Definition: funcdesc.cxx:304
SC_OPCODE_VAR_S
#define SC_OPCODE_VAR_S
HID_FUNC_MINV
#define HID_FUNC_MINV
Definition: helpids.h:344
SC_OPCODE_ROMAN
#define SC_OPCODE_ROMAN
HID_FUNC_DIA
#define HID_FUNC_DIA
Definition: helpids.h:235
HID_FUNC_FLOOR_PRECISE
#define HID_FUNC_FLOOR_PRECISE
Definition: helpids.h:571
SC_OPCODE_SHEETS
#define SC_OPCODE_SHEETS
SC_OPCODE_QUARTILE
#define SC_OPCODE_QUARTILE
HID_FUNC_EUROCONVERT
#define HID_FUNC_EUROCONVERT
Definition: helpids.h:339
HID_FUNC_TAG
#define HID_FUNC_TAG
Definition: helpids.h:208
HID_FUNC_DBSUMME
#define HID_FUNC_DBSUMME
Definition: helpids.h:202
HID_FUNC_FORECAST_ETS_ADD
#define HID_FUNC_FORECAST_ETS_ADD
Definition: helpids.h:574
SC_OPCODE_RAD
#define SC_OPCODE_RAD
SC_OPCODE_BETA_INV_MS
#define SC_OPCODE_BETA_INV_MS
SC_OPCODE_F_DIST_LT
#define SC_OPCODE_F_DIST_LT
HID_FUNC_GROSS
#define HID_FUNC_GROSS
Definition: helpids.h:470
SC_OPCODE_FORECAST_ETS_SEA
#define SC_OPCODE_FORECAST_ETS_SEA
SC_OPCODE_DDE
#define SC_OPCODE_DDE
SC_OPCODE_FORECAST_ETS_STA
#define SC_OPCODE_FORECAST_ETS_STA
HID_FUNC_VERSCHIEBUNG
#define HID_FUNC_VERSCHIEBUNG
Definition: helpids.h:451
SC_OPCODE_CHISQ_DIST
#define SC_OPCODE_CHISQ_DIST
SC_OPCODE_IS_NV
#define SC_OPCODE_IS_NV
HID_FUNC_GDA2
#define HID_FUNC_GDA2
Definition: helpids.h:238
HID_FUNC_PRODUKT
#define HID_FUNC_PRODUKT
Definition: helpids.h:283
HID_FUNC_CHISQINV
#define HID_FUNC_CHISQINV
Definition: helpids.h:435
ScUnoAddInCollection::GetFuncData
const ScUnoAddInFuncData * GetFuncData(const OUString &rName, bool bComplete=false)
Only if bComplete is set, the function reference and argument types are initialized (component may ha...
Definition: addincol.cxx:1104
SC_OPCODE_AVERAGE_A
#define SC_OPCODE_AVERAGE_A
SC_OPCODE_VAR_P_MS
#define SC_OPCODE_VAR_P_MS
HID_FUNC_JETZT
#define HID_FUNC_JETZT
Definition: helpids.h:213
HID_FUNC_F_INV_RT
#define HID_FUNC_F_INV_RT
Definition: helpids.h:526
HID_FUNC_INDIREKT
#define HID_FUNC_INDIREKT
Definition: helpids.h:448
ScFunctionMgr::Get
const ScFuncDesc * Get(sal_uInt16 nFIndex) const
Returns function by index.
Definition: funcdesc.cxx:1091
HID_FUNC_ZELLE
#define HID_FUNC_ZELLE
Definition: helpids.h:264
SC_OPCODE_CODE
#define SC_OPCODE_CODE
ScFunctionMgr::Next
const ScFuncDesc * Next() const
Returns the next function of the current category.
Definition: funcdesc.cxx:1118
SC_OPCODE_QUARTILE_INC
#define SC_OPCODE_QUARTILE_INC
HID_FUNC_LAENGE
#define HID_FUNC_LAENGE
Definition: helpids.h:477
HID_FUNC_QUARTILE_INC
#define HID_FUNC_QUARTILE_INC
Definition: helpids.h:550
SC_OPCODE_COS_HYP
#define SC_OPCODE_COS_HYP
SC_OPCODE_GET_DATE_VALUE
#define SC_OPCODE_GET_DATE_VALUE
SC_OPCODE_FORECAST_ETS_PIM
#define SC_OPCODE_FORECAST_ETS_PIM
pDesc
sal_uInt16 char char * pDesc
Definition: callform.cxx:57
HID_FUNC_ISTLEER
#define HID_FUNC_ISTLEER
Definition: helpids.h:252
HID_FUNC_MMULT
#define HID_FUNC_MMULT
Definition: helpids.h:342
HID_FUNC_MODAL_VALUE_MS
#define HID_FUNC_MODAL_VALUE_MS
Definition: helpids.h:554
HID_FUNC_FVERT
#define HID_FUNC_FVERT
Definition: helpids.h:407
SC_OPCODE_T
#define SC_OPCODE_T
SC_OPCODE_ERROR_TYPE
#define SC_OPCODE_ERROR_TYPE
SC_OPCODE_CHI_TEST_MS
#define SC_OPCODE_CHI_TEST_MS
SC_OPCODE_MEDIAN
#define SC_OPCODE_MEDIAN
SC_OPCODE_BITOR
#define SC_OPCODE_BITOR
SC_OPCODE_LOG_INV
#define SC_OPCODE_LOG_INV
SC_OPCODE_DB_COUNT_2
#define SC_OPCODE_DB_COUNT_2
HID_FUNC_NORMDIST_MS
#define HID_FUNC_NORMDIST_MS
Definition: helpids.h:536
ScAppOptions::GetLRUFuncListCount
sal_uInt16 GetLRUFuncListCount() const
Definition: appoptio.hxx:47
SC_OPCODE_FORECAST_ETS_ADD
#define SC_OPCODE_FORECAST_ETS_ADD
HID_FUNC_BASIS
#define HID_FUNC_BASIS
Definition: helpids.h:487
SC_OPCODE_DB_PRODUCT
#define SC_OPCODE_DB_PRODUCT
SC_OPCODE_AREAS
#define SC_OPCODE_AREAS
SC_OPCODE_REGEX
#define SC_OPCODE_REGEX
HID_FUNC_CHIVERT_MS
#define HID_FUNC_CHIVERT_MS
Definition: helpids.h:517
tools::Long
long Long
SC_OPCODE_BETA_INV
#define SC_OPCODE_BETA_INV
HID_FUNC_NORMINV
#define HID_FUNC_NORMINV
Definition: helpids.h:392
SC_OPCODE_FLOOR_MATH
#define SC_OPCODE_FLOOR_MATH
ScFuncDesc::ParameterFlags
Stores whether a parameter is optional or suppressed.
Definition: funcdesc.hxx:209
HID_FUNC_REST
#define HID_FUNC_REST
Definition: helpids.h:324
SC_OPCODE_POWER
#define SC_OPCODE_POWER
ID_FUNCTION_GRP_LOGIC
#define ID_FUNCTION_GRP_LOGIC
Definition: scfuncs.hxx:25
SC_OPCODE_HYP_GEOM_DIST_MS
#define SC_OPCODE_HYP_GEOM_DIST_MS
HID_FUNC_HYPGEOMVERT
#define HID_FUNC_HYPGEOMVERT
Definition: helpids.h:404
HID_FUNC_STUNDE
#define HID_FUNC_STUNDE
Definition: helpids.h:210
SC_OPCODE_ARC_SIN
#define SC_OPCODE_ARC_SIN
HID_FUNC_VARIATIONEN
#define HID_FUNC_VARIATIONEN
Definition: helpids.h:412
SC_OPCODE_COMBIN
#define SC_OPCODE_COMBIN
SC_OPCODE_DEG
#define SC_OPCODE_DEG
HID_FUNC_QUADRATESUMME
#define HID_FUNC_QUADRATESUMME
Definition: helpids.h:282
ScFuncDesc::getVarArgsLimit
virtual sal_uInt32 getVarArgsLimit() const override
Returns maximum number of (variable) arguments.
Definition: funcdesc.cxx:373
ocOpen
ocOpen
HID_FUNC_IDENTISCH
#define HID_FUNC_IDENTISCH
Definition: helpids.h:465
SC_OPCODE_POISSON_DIST
#define SC_OPCODE_POISSON_DIST
HID_FUNC_GGT
#define HID_FUNC_GGT
Definition: helpids.h:336
HID_FUNC_KKLEINSTE
#define HID_FUNC_KKLEINSTE
Definition: helpids.h:377
SC_OPCODE_VAR
#define SC_OPCODE_VAR
HID_FUNC_CHITEST
#define HID_FUNC_CHITEST
Definition: helpids.h:416
HID_FUNC_WEIBULL_DIST_MS
#define HID_FUNC_WEIBULL_DIST_MS
Definition: helpids.h:531
HID_FUNC_WENN
#define HID_FUNC_WENN
Definition: helpids.h:270
SC_OPCODE_CUM_PRINC
#define SC_OPCODE_CUM_PRINC
SC_OPCODE_OR
#define SC_OPCODE_OR
SC_OPCODE_LOOKUP
#define SC_OPCODE_LOOKUP
SC_OPCODE_STEYX
#define SC_OPCODE_STEYX
HID_FUNC_STANDNORMINV
#define HID_FUNC_STANDNORMINV
Definition: helpids.h:394
SC_OPCODE_COUNT_2
#define SC_OPCODE_COUNT_2
HID_FUNC_ARCTAN
#define HID_FUNC_ARCTAN
Definition: helpids.h:301
HID_FUNC_CHITEST_MS
#define HID_FUNC_CHITEST_MS
Definition: helpids.h:518
SC_OPCODE_FLOOR_PRECISE
#define SC_OPCODE_FLOOR_PRECISE
HID_FUNC_RANDBETWEEN_NV
#define HID_FUNC_RANDBETWEEN_NV
Definition: helpids.h:595
SC_OPCODE_S_NORM_INV_MS
#define SC_OPCODE_S_NORM_INV_MS
HID_FUNC_KLEIN
#define HID_FUNC_KLEIN
Definition: helpids.h:471
ScFunctionCategory::getName
virtual OUString getName() const override
Definition: funcdesc.cxx:1024
SC_OPCODE_MATCH
#define SC_OPCODE_MATCH
HID_FUNC_PERCENTRANK_INC
#define HID_FUNC_PERCENTRANK_INC
Definition: helpids.h:549
HID_FUNC_VARIANZENA
#define HID_FUNC_VARIANZENA
Definition: helpids.h:433
SC_OPCODE_NOMINAL
#define SC_OPCODE_NOMINAL
SC_OPCODE_FREQUENCY
#define SC_OPCODE_FREQUENCY
HID_FUNC_BW
#define HID_FUNC_BW
Definition: helpids.h:226
SC_OPCODE_TAN
#define SC_OPCODE_TAN
HID_FUNC_RAWSUBTRACT
#define HID_FUNC_RAWSUBTRACT
Definition: helpids.h:572
ENTRY
#define ENTRY(CODE)
Definition: funcdesc.cxx:398
HID_FUNC_CONCAT_MS
#define HID_FUNC_CONCAT_MS
Definition: helpids.h:582
ScFuncDesc::isParameterOptional
virtual bool isParameterOptional(sal_uInt32 _nPos) const override
Returns true if parameter at given position is optional.
Definition: funcdesc.cxx:388
SC_OPCODE_TRIM_MEAN
#define SC_OPCODE_TRIM_MEAN
SC_OPCODE_NPV
#define SC_OPCODE_NPV
SC_OPCODE_CHI_INV
#define SC_OPCODE_CHI_INV
HID_FUNC_WAHL
#define HID_FUNC_WAHL
Definition: helpids.h:440
SC_OPCODE_GET_YEAR
#define SC_OPCODE_GET_YEAR
SC_OPCODE_CEIL_MS
#define SC_OPCODE_CEIL_MS
SC_OPCODE_MATRIX_UNIT
#define SC_OPCODE_MATRIX_UNIT
HID_FUNC_JAHR
#define HID_FUNC_JAHR
Definition: helpids.h:219
SC_OPCODE_IS_EVEN
#define SC_OPCODE_IS_EVEN
SC_OPCODE_PERCENTILE_INC
#define SC_OPCODE_PERCENTILE_INC
HID_FUNC_DEZIMAL
#define HID_FUNC_DEZIMAL
Definition: helpids.h:488
HID_FUNC_UND
#define HID_FUNC_UND
Definition: helpids.h:274
HID_FUNC_FORECAST_ETS_STA
#define HID_FUNC_FORECAST_ETS_STA
Definition: helpids.h:579
SC_OPCODE_TAN_HYP
#define SC_OPCODE_TAN_HYP
HID_FUNC_ARCSIN
#define HID_FUNC_ARCSIN
Definition: helpids.h:297
SC_OPCODE_EXP_DIST_MS
#define SC_OPCODE_EXP_DIST_MS
SC_OPCODE_ST_DEV_S
#define SC_OPCODE_ST_DEV_S
ScFunctionMgr::getCategory
virtual const formula::IFunctionCategory * getCategory(sal_uInt32 nPos) const override
Returns a category.
Definition: funcdesc.cxx:1136
SC_OPCODE_IS_REF
#define SC_OPCODE_IS_REF
ScFunctionMgr::getSingleToken
virtual sal_Unicode getSingleToken(const formula::IFunctionManager::EToken _eToken) const override
Maps Etoken to character.
Definition: funcdesc.cxx:1174
HID_FUNC_ROUNDSIG
#define HID_FUNC_ROUNDSIG
Definition: helpids.h:588
ScFuncRes
static void ScFuncRes(const ScFuncDescCore &rEntry, ScFuncDesc *, bool &rbSuppressed)
Definition: funcdesc.cxx:1192
HID_FUNC_FORECAST_ETS_SEA
#define HID_FUNC_FORECAST_ETS_SEA
Definition: helpids.h:578
HID_FUNC_N
#define HID_FUNC_N
Definition: helpids.h:259
SC_OPCODE_MAT_DET
#define SC_OPCODE_MAT_DET
ScFunctionCategory::getNumber
virtual sal_uInt32 getNumber() const override
Definition: funcdesc.cxx:1039
HID_FUNC_MITTELABW
#define HID_FUNC_MITTELABW
Definition: helpids.h:366
SC_OPCODE_FISHER_INV
#define SC_OPCODE_FISHER_INV
HID_FUNC_KORREL
#define HID_FUNC_KORREL
Definition: helpids.h:424
HID_FUNC_MITTELWERT
#define HID_FUNC_MITTELWERT
Definition: helpids.h:364
HID_FUNC_DBVARIANZ
#define HID_FUNC_DBVARIANZ
Definition: helpids.h:203
SC_OPCODE_FORECAST_ETS_PIA
#define SC_OPCODE_FORECAST_ETS_PIA
HID_FUNC_HEUTE
#define HID_FUNC_HEUTE
Definition: helpids.h:217
HID_FUNC_AVERAGEIF
#define HID_FUNC_AVERAGEIF
Definition: helpids.h:285
SC_OPCODE_BITAND
#define SC_OPCODE_BITAND
HID_FUNC_DATEDIF
#define HID_FUNC_DATEDIF
Definition: helpids.h:221
ScFunctionMgr::pCurCatListEnd
std::vector< const ScFuncDesc * >::const_iterator pCurCatListEnd
end of current category
Definition: funcdesc.hxx:400
HID_FUNC_ANZAHL2
#define HID_FUNC_ANZAHL2
Definition: helpids.h:357
SC_OPCODE_PROB
#define SC_OPCODE_PROB
HID_FUNC_ZZR
#define HID_FUNC_ZZR
Definition: helpids.h:228
SC_OPCODE_GAMMA_LN_MS
#define SC_OPCODE_GAMMA_LN_MS
SC_OPCODE_ENCODEURL
#define SC_OPCODE_ENCODEURL
ScFuncDesc::getParameterDescription
virtual OUString getParameterDescription(sal_uInt32 _nPos) const override
Returns description of parameter at given position.
Definition: funcdesc.cxx:383
HID_FUNC_SEARCHB
#define HID_FUNC_SEARCHB
Definition: helpids.h:591
HID_FUNC_ST_DEV_S
#define HID_FUNC_ST_DEV_S
Definition: helpids.h:509
HID_FUNC_ISTBEZUG
#define HID_FUNC_ISTBEZUG
Definition: helpids.h:249
HID_FUNC_RAD
#define HID_FUNC_RAD
Definition: helpids.h:318
HID_FUNC_POISSON
#define HID_FUNC_POISSON
Definition: helpids.h:390
SC_OPCODE_CHI_DIST_MS
#define SC_OPCODE_CHI_DIST_MS
HID_FUNC_WECHSELN
#define HID_FUNC_WECHSELN
Definition: helpids.h:486
HID_FUNC_FLOOR_MATH
#define HID_FUNC_FLOOR_MATH
Definition: helpids.h:570
SC_OPCODE_IF_ERROR
#define SC_OPCODE_IF_ERROR
SC_OPCODE_NEG_BINOM_VERT
#define SC_OPCODE_NEG_BINOM_VERT
SC_OPCODE_WEBSERVICE
#define SC_OPCODE_WEBSERVICE
SC_OPCODE_T_TEST_MS
#define SC_OPCODE_T_TEST_MS
HID_FUNC_QUARTILE_EXC
#define HID_FUNC_QUARTILE_EXC
Definition: helpids.h:551
ScFunctionMgr::~ScFunctionMgr
virtual ~ScFunctionMgr()
Definition: funcdesc.cxx:1086
SC_OPCODE_GAMMA
#define SC_OPCODE_GAMMA
HID_FUNC_VERKETTEN
#define HID_FUNC_VERKETTEN
Definition: helpids.h:464
SC_OPCODE_MIN
#define SC_OPCODE_MIN
SC_OPCODE_SUM_IFS
#define SC_OPCODE_SUM_IFS
HID_FUNC_TEILERGEBNIS
#define HID_FUNC_TEILERGEBNIS
Definition: helpids.h:326
SC_OPCODE_MODAL_VALUE
#define SC_OPCODE_MODAL_VALUE
HID_FUNC_GAMMAVERT
#define HID_FUNC_GAMMAVERT
Definition: helpids.h:398
HID_FUNC_TEXT
#define HID_FUNC_TEXT
Definition: helpids.h:473
SC_OPCODE_LCM
#define SC_OPCODE_LCM
HID_FUNC_FORECAST_ETS_MUL
#define HID_FUNC_FORECAST_ETS_MUL
Definition: helpids.h:575
SC_OPCODE_PERCENTILE
#define SC_OPCODE_PERCENTILE
HID_FUNC_QUANTIL
#define HID_FUNC_QUANTIL
Definition: helpids.h:374
SC_FUNCGROUP_COUNT
#define SC_FUNCGROUP_COUNT
Definition: funcdesc.hxx:301
HID_FUNC_ZEITWERT
#define HID_FUNC_ZEITWERT
Definition: helpids.h:216
SC_OPCODE_IRR
#define SC_OPCODE_IRR
SC_OPCODE_RANK
#define SC_OPCODE_RANK
ScFuncDesc::mbHidden
bool mbHidden
Whether function is hidden.
Definition: funcdesc.hxx:228
ScFunctionCategory::getFunction
virtual const formula::IFunctionDescription * getFunction(sal_uInt32 _nPos) const override
Gives the _nPos'th function in this category.
Definition: funcdesc.cxx:1031
HID_FUNC_KOMBINATIONEN2
#define HID_FUNC_KOMBINATIONEN2
Definition: helpids.h:295
SC_OPCODE_COT
#define SC_OPCODE_COT
SC_OPCODE_F_TEST
#define SC_OPCODE_F_TEST
SC_OPCODE_SECANT
#define SC_OPCODE_SECANT
HID_FUNC_ARCOTHYP
#define HID_FUNC_ARCOTHYP
Definition: helpids.h:302
HID_FUNC_COSECANTHYP
#define HID_FUNC_COSECANTHYP
Definition: helpids.h:316
SC_OPCODE_ARC_TAN_HYP
#define SC_OPCODE_ARC_TAN_HYP
HID_FUNC_STABWA
#define HID_FUNC_STABWA
Definition: helpids.h:430
SC_OPCODE_PERCENTILE_EXC
#define SC_OPCODE_PERCENTILE_EXC
HID_FUNC_B
#define HID_FUNC_B
Definition: helpids.h:382
SC_OPCODE_B
#define SC_OPCODE_B
SC_OPCODE_DECIMAL
#define SC_OPCODE_DECIMAL
SC_OPCODE_IS_ERR
#define SC_OPCODE_IS_ERR
SC_OPCODE_CONFIDENCE_T
#define SC_OPCODE_CONFIDENCE_T
SC_OPCODE_MAX_A
#define SC_OPCODE_MAX_A
SC_OPCODE_FISHER
#define SC_OPCODE_FISHER
sal_Unicode
sal_uInt16 sal_Unicode
HID_FUNC_STABWNA
#define HID_FUNC_STABWNA
Definition: helpids.h:431
HID_FUNC_ARCTAN2
#define HID_FUNC_ARCTAN2
Definition: helpids.h:312
SC_OPCODE_PDURATION
#define SC_OPCODE_PDURATION
SC_OPCODE_OFFSET
#define SC_OPCODE_OFFSET
HID_FUNC_TAN
#define HID_FUNC_TAN
Definition: helpids.h:307
SC_OPCODE_CEIL
#define SC_OPCODE_CEIL
SC_OPCODE_SECANT_HYP
#define SC_OPCODE_SECANT_HYP
HID_FUNC_BETAVERT
#define HID_FUNC_BETAVERT
Definition: helpids.h:401
HID_FUNC_UNGERADE
#define HID_FUNC_UNGERADE
Definition: helpids.h:333
HID_FUNC_SUMMEWENN
#define HID_FUNC_SUMMEWENN
Definition: helpids.h:284
HID_FUNC_GAMMALN
#define HID_FUNC_GAMMALN
Definition: helpids.h:400
HID_FUNC_GTEST
#define HID_FUNC_GTEST
Definition: helpids.h:415
HID_FUNC_GDA
#define HID_FUNC_GDA
Definition: helpids.h:237
SC_OPCODE_COMBIN_A
#define SC_OPCODE_COMBIN_A
ocArrayClose
ocArrayClose
HID_FUNC_EXP
#define HID_FUNC_EXP
Definition: helpids.h:319
HID_FUNC_BITOR
#define HID_FUNC_BITOR
Definition: helpids.h:498
HID_FUNC_REPLACEB
#define HID_FUNC_REPLACEB
Definition: helpids.h:589
begin
enumrange< T >::Iterator begin(enumrange< T >)
SC_OPCODE_NEG_BINOM_DIST_MS
#define SC_OPCODE_NEG_BINOM_DIST_MS
SC_OPCODE_LOGEST
#define SC_OPCODE_LOGEST
HID_FUNC_ISTGERADE
#define HID_FUNC_ISTGERADE
Definition: helpids.h:292
SC_OPCODE_CURRENT
#define SC_OPCODE_CURRENT
HID_FUNC_QIKV
#define HID_FUNC_QIKV
Definition: helpids.h:246
HID_FUNC_TVERT
#define HID_FUNC_TVERT
Definition: helpids.h:405
HID_FUNC_NBW
#define HID_FUNC_NBW
Definition: helpids.h:242
SC_OPCODE_PERCENT_RANK_EXC
#define SC_OPCODE_PERCENT_RANK_EXC
HID_FUNC_MONAT
#define HID_FUNC_MONAT
Definition: helpids.h:212
ScFunctionList::First
const ScFuncDesc * First()
Definition: funcdesc.cxx:988
ScAppOptions::GetLRUFuncList
sal_uInt16 * GetLRUFuncList() const
Definition: appoptio.hxx:48
HID_FUNC_CEIL_ISO
#define HID_FUNC_CEIL_ISO
Definition: helpids.h:560
SC_OPCODE_DB_MAX
#define SC_OPCODE_DB_MAX
SC_OPCODE_SWITCH_MS
#define SC_OPCODE_SWITCH_MS
SC_OPCODE_COLOR
#define SC_OPCODE_COLOR
HID_FUNC_DBANZAHL
#define HID_FUNC_DBANZAHL
Definition: helpids.h:193
HID_FUNC_ABS
#define HID_FUNC_ABS
Definition: helpids.h:277
SC_OPCODE_FILTERXML
#define SC_OPCODE_FILTERXML
HID_FUNC_TINV_2T
#define HID_FUNC_TINV_2T
Definition: helpids.h:543
SC_OPCODE_GET_DAY
#define SC_OPCODE_GET_DAY
SC_OPCODE_F_INV_RT
#define SC_OPCODE_F_INV_RT
SC_OPCODE_LOG_INV_MS
#define SC_OPCODE_LOG_INV_MS
SC_OPCODE_COT_HYP
#define SC_OPCODE_COT_HYP
SC_OPCODE_PRODUCT
#define SC_OPCODE_PRODUCT
HID_FUNC_FOURIER
#define HID_FUNC_FOURIER
Definition: helpids.h:593
SC_OPCODE_T_DIST_MS
#define SC_OPCODE_T_DIST_MS
SC_OPCODE_DB_COUNT
#define SC_OPCODE_DB_COUNT
SC_OPCODE_FALSE
#define SC_OPCODE_FALSE
HID_FUNC_MAXIFS_MS
#define HID_FUNC_MAXIFS_MS
Definition: helpids.h:587
SC_OPCODE_GCD
#define SC_OPCODE_GCD
SC_OPCODE_DB_STD_DEV_P
#define SC_OPCODE_DB_STD_DEV_P
SC_OPCODE_MAXIFS_MS
#define SC_OPCODE_MAXIFS_MS
SC_OPCODE_PERCENT_RANK
#define SC_OPCODE_PERCENT_RANK
HID_FUNC_RMZ
#define HID_FUNC_RMZ
Definition: helpids.h:229
HID_FUNC_F_INV_LT
#define HID_FUNC_F_INV_LT
Definition: helpids.h:525
SC_OPCODE_FINDB
#define SC_OPCODE_FINDB
HID_FUNC_VORLAGE
#define HID_FUNC_VORLAGE
Definition: helpids.h:453
HID_FUNC_GLAETTEN
#define HID_FUNC_GLAETTEN
Definition: helpids.h:468
HID_FUNC_FEHLERTYP
#define HID_FUNC_FEHLERTYP
Definition: helpids.h:452
HID_FUNC_NEGBINOMDIST_MS
#define HID_FUNC_NEGBINOMDIST_MS
Definition: helpids.h:556
SC_OPCODE_NORM_DIST
#define SC_OPCODE_NORM_DIST
ScFuncDesc::pDefArgFlags
ParameterFlags * pDefArgFlags
Flags for each parameter.
Definition: funcdesc.hxx:220
HID_FUNC_KALENDERWOCHE
#define HID_FUNC_KALENDERWOCHE
Definition: helpids.h:222
SC_OPCODE_DB_VAR
#define SC_OPCODE_DB_VAR
HID_FUNC_KUERZEN
#define HID_FUNC_KUERZEN
Definition: helpids.h:328
HID_FUNC_FINDB
#define HID_FUNC_FINDB
Definition: helpids.h:590
SC_OPCODE_INT
#define SC_OPCODE_INT
SC_OPCODE_IS_LOGICAL
#define SC_OPCODE_IS_LOGICAL
SC_OPCODE_F_TEST_MS
#define SC_OPCODE_F_TEST_MS
HID_FUNC_HYP_GEOM_DIST_MS
#define HID_FUNC_HYP_GEOM_DIST_MS
Definition: helpids.h:529
HID_FUNC_ISTKTEXT
#define HID_FUNC_ISTKTEXT
Definition: helpids.h:255
SC_OPCODE_MAT_MULT
#define SC_OPCODE_MAT_MULT
SC_OPCODE_IS_EMPTY
#define SC_OPCODE_IS_EMPTY
ScFuncDesc::getFormula
virtual OUString getFormula(const ::std::vector< OUString > &_aArguments) const override
Returns the function signature with parameters from the passed string array.
Definition: funcdesc.cxx:247
ScFuncDesc::GetParamList
OUString GetParamList() const
Returns list of all parameter names.
Definition: funcdesc.cxx:146
SC_OPCODE_QUARTILE_EXC
#define SC_OPCODE_QUARTILE_EXC
formula::FormulaCompiler::GetNativeSymbolChar
static sal_Unicode GetNativeSymbolChar(OpCode eOp)
SC_OPCODE_T_INV
#define SC_OPCODE_T_INV
SC_OPCODE_EVEN
#define SC_OPCODE_EVEN
SC_OPCODE_ROWS
#define SC_OPCODE_ROWS
SC_OPCODE_COLUMN
#define SC_OPCODE_COLUMN
HID_FUNC_KUMKAPITAL
#define HID_FUNC_KUMKAPITAL
Definition: helpids.h:233
SC_OPCODE_GET_DATE
#define SC_OPCODE_GET_DATE
SC_OPCODE_ARC_COT
#define SC_OPCODE_ARC_COT
HID_FUNC_COSHYP
#define HID_FUNC_COSHYP
Definition: helpids.h:308
SC_OPCODE_SLN
#define SC_OPCODE_SLN
SC_OPCODE_CHAR
#define SC_OPCODE_CHAR
SC_OPCODE_PERCENT_RANK_INC
#define SC_OPCODE_PERCENT_RANK_INC
HID_FUNC_REGEX
#define HID_FUNC_REGEX
Definition: helpids.h:592
HID_FUNC_BETADIST_MS
#define HID_FUNC_BETADIST_MS
Definition: helpids.h:512
SC_OPCODE_FORMULA
#define SC_OPCODE_FORMULA
HID_FUNC_ISTFORMEL
#define HID_FUNC_ISTFORMEL
Definition: helpids.h:258
SC_OPCODE_IS_STRING
#define SC_OPCODE_IS_STRING
HID_FUNC_OSTERSONNTAG
#define HID_FUNC_OSTERSONNTAG
Definition: helpids.h:223
SC_OPCODE_PPMT
#define SC_OPCODE_PPMT
HID_FUNC_GANZZAHL
#define HID_FUNC_GANZZAHL
Definition: helpids.h:327
SC_OPCODE_TEXTJOIN_MS
#define SC_OPCODE_TEXTJOIN_MS
HID_FUNC_SEKUNDE
#define HID_FUNC_SEKUNDE
Definition: helpids.h:214
HID_FUNC_COVARIANCE_S
#define HID_FUNC_COVARIANCE_S
Definition: helpids.h:507
HID_FUNC_LINKS
#define HID_FUNC_LINKS
Definition: helpids.h:478
ocSep
ocSep
HID_FUNC_TREND
#define HID_FUNC_TREND
Definition: helpids.h:353
SC_OPCODE_GET_DIFF_DATE
#define SC_OPCODE_GET_DIFF_DATE
SAL_N_ELEMENTS
#define SAL_N_ELEMENTS(arr)
HID_FUNC_BETAINV
#define HID_FUNC_BETAINV
Definition: helpids.h:402
HID_FUNC_UNICHAR
#define HID_FUNC_UNICHAR
Definition: helpids.h:495
HID_FUNC_ZEICHEN
#define HID_FUNC_ZEICHEN
Definition: helpids.h:462
SC_OPCODE_T_DIST_2T
#define SC_OPCODE_T_DIST_2T
HID_FUNC_LOG
#define HID_FUNC_LOG
Definition: helpids.h:320
SC_OPCODE_FIXED
#define SC_OPCODE_FIXED
HID_FUNC_STFEHLERYX
#define HID_FUNC_STFEHLERYX
Definition: helpids.h:422
HID_FUNC_MINUTE
#define HID_FUNC_MINUTE
Definition: helpids.h:211
SC_OPCODE_ARC_TAN_2
#define SC_OPCODE_ARC_TAN_2
SC_OPCODE_AVE_DEV
#define SC_OPCODE_AVE_DEV
SC_OPCODE_ROUND_UP
#define SC_OPCODE_ROUND_UP
HID_FUNC_LAUFZEIT
#define HID_FUNC_LAUFZEIT
Definition: helpids.h:244
SC_OPCODE_CURRENCY
#define SC_OPCODE_CURRENCY
SC_OPCODE_GET_ACT_TIME
#define SC_OPCODE_GET_ACT_TIME
HID_FUNC_TINV_MS
#define HID_FUNC_TINV_MS
Definition: helpids.h:544
HID_FUNC_ISTFEHLER
#define HID_FUNC_ISTFEHLER
Definition: helpids.h:251
HID_FUNC_DBSTDABW
#define HID_FUNC_DBSTDABW
Definition: helpids.h:200
SC_OPCODE_SUM_X2DY2
#define SC_OPCODE_SUM_X2DY2
SC_OPCODE_IS_ODD
#define SC_OPCODE_IS_ODD
SC_OPCODE_CORREL
#define SC_OPCODE_CORREL
HID_FUNC_ZEILE
#define HID_FUNC_ZEILE
Definition: helpids.h:442
HID_FUNC_TTEST_MS
#define HID_FUNC_TTEST_MS
Definition: helpids.h:545
HID_FUNC_GAUSS
#define HID_FUNC_GAUSS
Definition: helpids.h:384
SC_OPCODE_CONFIDENCE
#define SC_OPCODE_CONFIDENCE
SC_OPCODE_RSQ
#define SC_OPCODE_RSQ
HID_FUNC_FISHERINV
#define HID_FUNC_FISHERINV
Definition: helpids.h:386
ScFuncDesc::nCategory
sal_uInt16 nCategory
Function category.
Definition: funcdesc.hxx:222
HID_FUNC_SUMQUADABW
#define HID_FUNC_SUMQUADABW
Definition: helpids.h:365
SC_OPCODE_GET_TIME_VALUE
#define SC_OPCODE_GET_TIME_VALUE
SC_OPCODE_HYP_GEOM_DIST
#define SC_OPCODE_HYP_GEOM_DIST
ocArrayOpen
ocArrayOpen
HID_FUNC_AVERAGEIFS
#define HID_FUNC_AVERAGEIFS
Definition: helpids.h:287
HID_FUNC_ENCODEURL
#define HID_FUNC_ENCODEURL
Definition: helpids.h:504
HID_FUNC_SUCHEN
#define HID_FUNC_SUCHEN
Definition: helpids.h:467
SC_OPCODE_MINIFS_MS
#define SC_OPCODE_MINIFS_MS
ID_FUNCTION_GRP_MATH
#define ID_FUNCTION_GRP_MATH
Definition: scfuncs.hxx:26
SC_OPCODE_SIN
#define SC_OPCODE_SIN
HID_FUNC_SPALTEN
#define HID_FUNC_SPALTEN
Definition: helpids.h:443
HID_FUNC_ISOWEEKNUM
#define HID_FUNC_ISOWEEKNUM
Definition: helpids.h:224
SC_OPCODE_DB_GET
#define SC_OPCODE_DB_GET
SC_OPCODE_ERF_MS
#define SC_OPCODE_ERF_MS
SC_OPCODE_NOT
#define SC_OPCODE_NOT
formula::FormulaCompiler::GetNativeSymbol
static const OUString & GetNativeSymbol(OpCode eOp)
HID_FUNC_VAR_P_MS
#define HID_FUNC_VAR_P_MS
Definition: helpids.h:510
ID_FUNCTION_GRP_TEXT
#define ID_FUNCTION_GRP_TEXT
Definition: scfuncs.hxx:30
HID_FUNC_SUMIFS
#define HID_FUNC_SUMIFS
Definition: helpids.h:286
SC_OPCODE_SKEW
#define SC_OPCODE_SKEW
HID_FUNC_MTRANS
#define HID_FUNC_MTRANS
Definition: helpids.h:341
HID_FUNC_FORECAST_ETS_STM
#define HID_FUNC_FORECAST_ETS_STM
Definition: helpids.h:580
SC_OPCODE_S_NORM_INV
#define SC_OPCODE_S_NORM_INV
SC_OPCODE_EFFECT
#define SC_OPCODE_EFFECT
ScFuncDesc::getSignature
virtual OUString getSignature() const override
Returns the full function signature.
Definition: funcdesc.cxx:224
SC_OPCODE_BITLSHIFT
#define SC_OPCODE_BITLSHIFT
HID_FUNC_DATWERT
#define HID_FUNC_DATWERT
Definition: helpids.h:207
HID_FUNC_NOMINAL
#define HID_FUNC_NOMINAL
Definition: helpids.h:241
SC_OPCODE_EUROCONVERT
#define SC_OPCODE_EUROCONVERT
HID_FUNC_SWITCH_MS
#define HID_FUNC_SWITCH_MS
Definition: helpids.h:585
i
int i
SC_OPCODE_TRIM
#define SC_OPCODE_TRIM
HID_FUNC_HAEUFIGKEIT
#define HID_FUNC_HAEUFIGKEIT
Definition: helpids.h:350
SC_OPCODE_MAX
#define SC_OPCODE_MAX
HID_FUNC_SUMMEX2PY2
#define HID_FUNC_SUMMEX2PY2
Definition: helpids.h:348
SC_OPCODE_SUM
#define SC_OPCODE_SUM
SC_OPCODE_COUNT_IFS
#define SC_OPCODE_COUNT_IFS
SC_OPCODE_GET_PIVOT_DATA
#define SC_OPCODE_GET_PIVOT_DATA
SC_OPCODE_BITRSHIFT
#define SC_OPCODE_BITRSHIFT
HID_FUNC_CONFIDENCE_N
#define HID_FUNC_CONFIDENCE_N
Definition: helpids.h:521
HID_FUNC_VARIATIONEN2
#define HID_FUNC_VARIATIONEN2
Definition: helpids.h:413
HID_FUNC_T
#define HID_FUNC_T
Definition: helpids.h:474
SC_OPCODE_MODAL_VALUE_MULTI
#define SC_OPCODE_MODAL_VALUE_MULTI
SC_OPCODE_GAMMA_DIST_MS
#define SC_OPCODE_GAMMA_DIST_MS
SC_OPCODE_PV
#define SC_OPCODE_PV
HID_FUNC_ADRESSE
#define HID_FUNC_ADRESSE
Definition: helpids.h:438
HID_FUNC_RECHTS
#define HID_FUNC_RECHTS
Definition: helpids.h:479
ScFuncDesc::getParameterCount
virtual sal_uInt32 getParameterCount() const override
Returns number of arguments.
Definition: funcdesc.cxx:363
HID_FUNC_STANDARDISIERUNG
#define HID_FUNC_STANDARDISIERUNG
Definition: helpids.h:411
SC_OPCODE_FOURIER
#define SC_OPCODE_FOURIER
SC_OPCODE_CONCAT_MS
#define SC_OPCODE_CONCAT_MS
HID_FUNC_KOMBINATIONEN
#define HID_FUNC_KOMBINATIONEN
Definition: helpids.h:294
SC_OPCODE_LOG10
#define SC_OPCODE_LOG10
SC_OPCODE_COUNT_IF
#define SC_OPCODE_COUNT_IF
VAR_ARGS
#define VAR_ARGS
SC_OPCODE_STYLE
#define SC_OPCODE_STYLE
ScFuncDesc::maDefArgDescs
std::vector< OUString > maDefArgDescs
Description(s) of parameter(s)
Definition: funcdesc.hxx:219
HID_FUNC_PHI
#define HID_FUNC_PHI
Definition: helpids.h:383
SC_OPCODE_FORECAST_LIN
#define SC_OPCODE_FORECAST_LIN
SC_OPCODE_GET_DATEDIF
#define SC_OPCODE_GET_DATEDIF
HID_FUNC_ARTANHYP
#define HID_FUNC_ARTANHYP
Definition: helpids.h:303
HID_FUNC_COTHYP
#define HID_FUNC_COTHYP
Definition: helpids.h:310
LegacyFuncData::getParamDesc
void getParamDesc(OUString &aName, OUString &aDesc, sal_uInt16 nParam) const
name and description of parameter nParam.
Definition: callform.cxx:342
ScFuncDesc::compareByName
static bool compareByName(const ScFuncDesc *a, const ScFuncDesc *b)
Compares functions by name, respecting special characters.
Definition: funcdesc.cxx:393
HID_FUNC_SECANT
#define HID_FUNC_SECANT
Definition: helpids.h:314
SC_MOD
#define SC_MOD()
Definition: scmod.hxx:249
HID_FUNC_ZINS
#define HID_FUNC_ZINS
Definition: helpids.h:230
SC_OPCODE_GET_MIN
#define SC_OPCODE_GET_MIN
HID_FUNC_GEOMITTEL
#define HID_FUNC_GEOMITTEL
Definition: helpids.h:370
SC_OPCODE_CONFIDENCE_N
#define SC_OPCODE_CONFIDENCE_N
SC_OPCODE_BINOM_DIST
#define SC_OPCODE_BINOM_DIST
HID_FUNC_ISTUNGERADE
#define HID_FUNC_ISTUNGERADE
Definition: helpids.h:293
ScFuncDesc::fillVisibleArgumentMapping
virtual void fillVisibleArgumentMapping(::std::vector< sal_uInt16 > &_rArguments) const override
Fills a mapping with indexes for non-suppressed arguments.
Definition: funcdesc.cxx:309
HID_FUNC_STABW
#define HID_FUNC_STABW
Definition: helpids.h:362
SC_OPCODE_GAMMA_INV
#define SC_OPCODE_GAMMA_INV
HID_FUNC_NV
#define HID_FUNC_NV
Definition: helpids.h:260
HID_FUNC_GAMMALN_MS
#define HID_FUNC_GAMMALN_MS
Definition: helpids.h:534
SC_OPCODE_GET_HOUR
#define SC_OPCODE_GET_HOUR
SC_OPCODE_GAMMA_LN
#define SC_OPCODE_GAMMA_LN
HID_FUNC_HYPERLINK
#define HID_FUNC_HYPERLINK
Definition: helpids.h:457
LegacyFuncData::GetInternalName
const OUString & GetInternalName() const
Definition: callform.hxx:74
HID_FUNC_ISTTEXT
#define HID_FUNC_ISTTEXT
Definition: helpids.h:256
HID_FUNC_Z_TEST_MS
#define HID_FUNC_Z_TEST_MS
Definition: helpids.h:557
HID_FUNC_STD_NORMDIST_MS
#define HID_FUNC_STD_NORMDIST_MS
Definition: helpids.h:538
HID_FUNC_CODE
#define HID_FUNC_CODE
Definition: helpids.h:460
HID_FUNC_DBMITTELWERT
#define HID_FUNC_DBMITTELWERT
Definition: helpids.h:195
SC_OPCODE_DB_MIN
#define SC_OPCODE_DB_MIN
HID_FUNC_HARMITTEL
#define HID_FUNC_HARMITTEL
Definition: helpids.h:371
SC_OPCODE_WEIBULL_MS
#define SC_OPCODE_WEIBULL_MS
SC_OPCODE_NUMBERVALUE
#define SC_OPCODE_NUMBERVALUE
HID_FUNC_EINHEITSMATRIX
#define HID_FUNC_EINHEITSMATRIX
Definition: helpids.h:345
SC_OPCODE_ST_DEV_A
#define SC_OPCODE_ST_DEV_A
SC_OPCODE_ERFC_MS
#define SC_OPCODE_ERFC_MS
SC_OPCODE_WEEK
#define SC_OPCODE_WEEK
SC_OPCODE_TREND
#define SC_OPCODE_TREND
SC_OPCODE_T_TEST
#define SC_OPCODE_T_TEST
HID_FUNC_CEIL_MS
#define HID_FUNC_CEIL_MS
Definition: helpids.h:558
ScGlobal::GetStarCalcFunctionMgr
static ScFunctionMgr * GetStarCalcFunctionMgr()
Definition: global.cxx:629
SC_OPCODE_F_DIST_RT
#define SC_OPCODE_F_DIST_RT
LegacyFuncData::GetParamType
ParamType GetParamType(sal_uInt16 nIndex) const
Definition: callform.hxx:76
u
float u
SC_OPCODE_EXACT
#define SC_OPCODE_EXACT
HID_FUNC_PERCENTILE_INC
#define HID_FUNC_PERCENTILE_INC
Definition: helpids.h:547
SC_OPCODE_F_INV
#define SC_OPCODE_F_INV
SC_OPCODE_LOWER
#define SC_OPCODE_LOWER
HID_FUNC_FINDEN
#define HID_FUNC_FINDEN
Definition: helpids.h:466
HID_FUNC_KGV
#define HID_FUNC_KGV
Definition: helpids.h:337
SC_OPCODE_LOG_NORM_DIST_MS
#define SC_OPCODE_LOG_NORM_DIST_MS
SC_OPCODE_NORM_DIST_MS
#define SC_OPCODE_NORM_DIST_MS
HID_FUNC_FLOOR_MS
#define HID_FUNC_FLOOR_MS
Definition: helpids.h:561
HID_FUNC_FORMEL
#define HID_FUNC_FORMEL
Definition: helpids.h:263
SC_OPCODE_GET_DIFF_DATE_360
#define SC_OPCODE_GET_DIFF_DATE_360
HID_FUNC_ARCCOT
#define HID_FUNC_ARCCOT
Definition: helpids.h:300
SC_OPCODE_V_LOOKUP
#define SC_OPCODE_V_LOOKUP
SC_OPCODE_RRI
#define SC_OPCODE_RRI
HID_FUNC_VERGLEICH
#define HID_FUNC_VERGLEICH
Definition: helpids.h:450
SC_OPCODE_VAR_P
#define SC_OPCODE_VAR_P
SC_OPCODE_IF_NA
#define SC_OPCODE_IF_NA
SC_OPCODE_SLOPE
#define SC_OPCODE_SLOPE
ScFuncDesc::mxFuncDesc
std::optional< OUString > mxFuncDesc
Description of function.
Definition: funcdesc.hxx:217
LRU_MAX
#define LRU_MAX
Definition: funcdesc.hxx:34
SC_OPCODE_FV
#define SC_OPCODE_FV
HID_FUNC_UMRECHNEN
#define HID_FUNC_UMRECHNEN
Definition: helpids.h:338
argument
::boost::spirit::classic::rule< ScannerT > argument
SC_OPCODE_SEARCHB
#define SC_OPCODE_SEARCHB
SC_OPCODE_FIND
#define SC_OPCODE_FIND
HID_FUNC_BEREICHE
#define HID_FUNC_BEREICHE
Definition: helpids.h:439
HID_FUNC_AKTUELL
#define HID_FUNC_AKTUELL
Definition: helpids.h:262
ScFunctionMgr::GetCategoryName
static OUString GetCategoryName(sal_uInt32 _nCategoryNumber)
Returns name of category.
Definition: funcdesc.cxx:1163
SC_OPCODE_LEFT
#define SC_OPCODE_LEFT
HID_FUNC_TDIST_MS
#define HID_FUNC_TDIST_MS
Definition: helpids.h:541
SC_OPCODE_EASTERSUNDAY
#define SC_OPCODE_EASTERSUNDAY
HID_FUNC_ERFC_MS
#define HID_FUNC_ERFC_MS
Definition: helpids.h:566
HID_FUNC_MIDB
#define HID_FUNC_MIDB
Definition: helpids.h:484
SC_OPCODE_EXP
#define SC_OPCODE_EXP
HID_FUNC_MEDIAN
#define HID_FUNC_MEDIAN
Definition: helpids.h:373
HID_FUNC_GAMMAINV_MS
#define HID_FUNC_GAMMAINV_MS
Definition: helpids.h:533
SC_OPCODE_SUBSTITUTE
#define SC_OPCODE_SUBSTITUTE
ScFuncDesc::getHelpId
virtual OString getHelpId() const override
Returns the help id of the function.
Definition: funcdesc.cxx:353
SC_OPCODE_AVERAGE
#define SC_OPCODE_AVERAGE
HID_FUNC_SPALTE
#define HID_FUNC_SPALTE
Definition: helpids.h:441
SC_OPCODE_RANDOM_NV
#define SC_OPCODE_RANDOM_NV
HID_FUNC_STEIGUNG
#define HID_FUNC_STEIGUNG
Definition: helpids.h:421
SC_OPCODE_NETWORKDAYS
#define SC_OPCODE_NETWORKDAYS
SC_OPCODE_SKEWP
#define SC_OPCODE_SKEWP
HID_FUNC_BESTIMMTHEITSMASS
#define HID_FUNC_BESTIMMTHEITSMASS
Definition: helpids.h:419
SC_OPCODE_INDIRECT
#define SC_OPCODE_INDIRECT
SC_OPCODE_ROUNDSIG
#define SC_OPCODE_ROUNDSIG
HID_FUNC_SCHIEFE
#define HID_FUNC_SCHIEFE
Definition: helpids.h:367
HID_FUNC_WOCHENTAG
#define HID_FUNC_WOCHENTAG
Definition: helpids.h:218
HID_FUNC_CEIL_MATH
#define HID_FUNC_CEIL_MATH
Definition: helpids.h:569
SC_OPCODE_MIN_A
#define SC_OPCODE_MIN_A
SC_OPCODE_BASE
#define SC_OPCODE_BASE
SC_OPCODE_VALUE
#define SC_OPCODE_VALUE
HID_FUNC_DBANZAHL2
#define HID_FUNC_DBANZAHL2
Definition: helpids.h:194
HID_FUNC_OBERGRENZE
#define HID_FUNC_OBERGRENZE
Definition: helpids.h:334
HID_FUNC_VAR_S
#define HID_FUNC_VAR_S
Definition: helpids.h:511
SC_OPCODE_CONCAT
#define SC_OPCODE_CONCAT
SC_OPCODE_IPMT
#define SC_OPCODE_IPMT
SC_OPCODE_N
#define SC_OPCODE_N
ScFunctionList::GetFunction
const ScFuncDesc * GetFunction(sal_uInt32 nIndex) const
Definition: funcdesc.cxx:1009
HID_FUNC_VARIATION
#define HID_FUNC_VARIATION
Definition: helpids.h:354
SC_OPCODE_COVAR
#define SC_OPCODE_COVAR
HID_FUNC_RANG
#define HID_FUNC_RANG
Definition: helpids.h:379
HID_FUNC_WEIBULL
#define HID_FUNC_WEIBULL
Definition: helpids.h:403
HID_FUNC_XOR
#define HID_FUNC_XOR
Definition: helpids.h:275
SC_OPCODE_MODAL_VALUE_MS
#define SC_OPCODE_MODAL_VALUE_MS
HID_FUNC_AUFRUNDEN
#define HID_FUNC_AUFRUNDEN
Definition: helpids.h:330
HID_FUNC_GROSS2
#define HID_FUNC_GROSS2
Definition: helpids.h:469
end
enumrange< T >::Iterator end(enumrange< T >)
HID_FUNC_ZAEHLENWENN
#define HID_FUNC_ZAEHLENWENN
Definition: helpids.h:289
HID_FUNC_STD_NORMINV_MS
#define HID_FUNC_STD_NORMINV_MS
Definition: helpids.h:539
HID_FUNC_SCHAETZER
#define HID_FUNC_SCHAETZER
Definition: helpids.h:426
SC_OPCODE_MOD
#define SC_OPCODE_MOD
SC_OPCODE_UNICODE
#define SC_OPCODE_UNICODE
SC_OPCODE_SUM_PRODUCT
#define SC_OPCODE_SUM_PRODUCT
ScFuncDesc::getCategory
virtual const formula::IFunctionCategory * getCategory() const override
Returns the category of the function.
Definition: funcdesc.cxx:291
HID_FUNC_ZEIT
#define HID_FUNC_ZEIT
Definition: helpids.h:215
SC_OPCODE_GAMMA_DIST
#define SC_OPCODE_GAMMA_DIST
SC_OPCODE_T_DIST
#define SC_OPCODE_T_DIST
ScGlobal::GetStarCalcFunctionList
static ScFunctionList * GetStarCalcFunctionList()
Definition: global.cxx:620
SC_OPCODE_RANDOM
#define SC_OPCODE_RANDOM
SC_OPCODE_TRUE
#define SC_OPCODE_TRUE
HID_FUNC_WEBSERVICE
#define HID_FUNC_WEBSERVICE
Definition: helpids.h:503
HID_FUNC_ERSETZEN
#define HID_FUNC_ERSETZEN
Definition: helpids.h:475
SC_OPCODE_PERMUTATION_A
#define SC_OPCODE_PERMUTATION_A
SC_OPCODE_SMALL
#define SC_OPCODE_SMALL
HID_FUNC_NORMINV_MS
#define HID_FUNC_NORMINV_MS
Definition: helpids.h:537
SC_OPCODE_CHI_INV_MS
#define SC_OPCODE_CHI_INV_MS
HID_FUNC_IFNA
#define HID_FUNC_IFNA
Definition: helpids.h:272
HID_FUNC_ODER
#define HID_FUNC_ODER
Definition: helpids.h:273
HID_FUNC_PERCENTRANK_EXC
#define HID_FUNC_PERCENTRANK_EXC
Definition: helpids.h:548
HID_FUNC_INFO
#define HID_FUNC_INFO
Definition: helpids.h:265
ScFunctionCategory::getCount
virtual sal_uInt32 getCount() const override
Definition: funcdesc.cxx:1019
HID_FUNC_COUNTIFS
#define HID_FUNC_COUNTIFS
Definition: helpids.h:288
SC_OPCODE_PMT
#define SC_OPCODE_PMT
ID_FUNCTION_GRP_MATRIX
#define ID_FUNCTION_GRP_MATRIX
Definition: scfuncs.hxx:27
SC_OPCODE_LAST_OPCODE_ID
#define SC_OPCODE_LAST_OPCODE_ID
HID_FUNC_VERWEIS
#define HID_FUNC_VERWEIS
Definition: helpids.h:449
SC_OPCODE_NO_VALUE
#define SC_OPCODE_NO_VALUE
HID_FUNC_SKEWP
#define HID_FUNC_SKEWP
Definition: helpids.h:368
HID_FUNC_NORMVERT
#define HID_FUNC_NORMVERT
Definition: helpids.h:391
HID_FUNC_NETWORKDAYS_MS
#define HID_FUNC_NETWORKDAYS_MS
Definition: helpids.h:563
HID_FUNC_SAEUBERN
#define HID_FUNC_SAEUBERN
Definition: helpids.h:463
HID_FUNC_COLOR
#define HID_FUNC_COLOR
Definition: helpids.h:505
SC_OPCODE_F_INV_LT
#define SC_OPCODE_F_INV_LT
SC_OPCODE_WORKDAY_MS
#define SC_OPCODE_WORKDAY_MS
SC_OPCODE_FORECAST_ETS_STM
#define SC_OPCODE_FORECAST_ETS_STM
SC_OPCODE_CELL
#define SC_OPCODE_CELL
SC_OPCODE_SEARCH
#define SC_OPCODE_SEARCH
HID_FUNC_BITXOR
#define HID_FUNC_BITXOR
Definition: helpids.h:499
HID_FUNC_MAXA
#define HID_FUNC_MAXA
Definition: helpids.h:428
HID_FUNC_EFFEKTIV
#define HID_FUNC_EFFEKTIV
Definition: helpids.h:240
SC_OPCODE_ROW
#define SC_OPCODE_ROW
ScFunctionMgr::fillLastRecentlyUsedFunctions
virtual void fillLastRecentlyUsedFunctions(::std::vector< const formula::IFunctionDescription * > &_rLastRUFunctions) const override
Appends the last recently used functions.
Definition: funcdesc.cxx:1147
SC_OPCODE_COS
#define SC_OPCODE_COS
SC_OPCODE_XOR
#define SC_OPCODE_XOR
HID_FUNC_MDET
#define HID_FUNC_MDET
Definition: helpids.h:343
SC_OPCODE_REPLACEB
#define SC_OPCODE_REPLACEB
HID_FUNC_UNTERGRENZE
#define HID_FUNC_UNTERGRENZE
Definition: helpids.h:335
ScFuncDesc::nVarArgsStart
sal_uInt16 nVarArgsStart
Start of variable arguments, for numbering.
Definition: funcdesc.hxx:224
ScFuncDesc::nVarArgsLimit
sal_uInt16 nVarArgsLimit
Limit maximum of (variable) arguments, for numbering.
Definition: funcdesc.hxx:225
SC_OPCODE_JIS
#define SC_OPCODE_JIS
HID_FUNC_MAX
#define HID_FUNC_MAX
Definition: helpids.h:358
HID_FUNC_CHISQDIST
#define HID_FUNC_CHISQDIST
Definition: helpids.h:434
SC_OPCODE_Z_TEST
#define SC_OPCODE_Z_TEST
SC_OPCODE_BETA_DIST_MS
#define SC_OPCODE_BETA_DIST_MS
HID_FUNC_FILTERXML
#define HID_FUNC_FILTERXML
Definition: helpids.h:502
HID_FUNC_KUMZINSZ
#define HID_FUNC_KUMZINSZ
Definition: helpids.h:234
ScFuncDesc::mxFuncName
std::optional< OUString > mxFuncName
Function name.
Definition: funcdesc.hxx:216
SC_OPCODE_GROWTH
#define SC_OPCODE_GROWTH
HID_FUNC_SUMMEX2MY2
#define HID_FUNC_SUMMEX2MY2
Definition: helpids.h:347
SC_OPCODE_COSECANT_HYP
#define SC_OPCODE_COSECANT_HYP
HID_FUNC_KAPZ
#define HID_FUNC_KAPZ
Definition: helpids.h:232
SC_OPCODE_RANDBETWEEN_NV
#define SC_OPCODE_RANDBETWEEN_NV
ScGlobal::GetLegacyFuncCollection
static LegacyFuncCollection * GetLegacyFuncCollection()
Definition: global.cxx:274
SC_OPCODE_IS_NON_STRING
#define SC_OPCODE_IS_NON_STRING
SC_OPCODE_PEARSON
#define SC_OPCODE_PEARSON
HID_FUNC_ZINSZ
#define HID_FUNC_ZINSZ
Definition: helpids.h:231
HID_FUNC_WERT
#define HID_FUNC_WERT
Definition: helpids.h:472
HID_FUNC_DBVARIANZEN
#define HID_FUNC_DBVARIANZEN
Definition: helpids.h:204
ScGlobal::GetCaseCollator
static CollatorWrapper & GetCaseCollator()
case-sensitive collator
Definition: global.cxx:1066
SC_OPCODE_T_INV_2T
#define SC_OPCODE_T_INV_2T
ID_FUNCTION_GRP_DATABASE
#define ID_FUNCTION_GRP_DATABASE
Definition: scfuncs.hxx:21
HID_FUNC_LN
#define HID_FUNC_LN
Definition: helpids.h:321
HID_FUNC_EXPONVERT
#define HID_FUNC_EXPONVERT
Definition: helpids.h:397
SC_OPCODE_BINOM_INV
#define SC_OPCODE_BINOM_INV
HID_FUNC_STABWN
#define HID_FUNC_STABWN
Definition: helpids.h:363
ScFuncDesc::Clear
void Clear()
Clears the object.
Definition: funcdesc.cxx:118
SC_OPCODE_MAT_INV
#define SC_OPCODE_MAT_INV
SC_OPCODE_GET_MONTH
#define SC_OPCODE_GET_MONTH
ScFunctionMgr::ScFunctionMgr
ScFunctionMgr()
Retrieves all calc functions, generates cumulative ('All') category, and the categories.
Definition: funcdesc.cxx:1045
ID_FUNCTION_GRP_STATISTIC
#define ID_FUNCTION_GRP_STATISTIC
Definition: scfuncs.hxx:28
MAX_FUNCCAT
#define MAX_FUNCCAT
Definition: funcdesc.hxx:33
SC_OPCODE_FORECAST_ETS_MUL
#define SC_OPCODE_FORECAST_ETS_MUL
HID_FUNC_IFS_MS
#define HID_FUNC_IFS_MS
Definition: helpids.h:584
SC_OPCODE_CHISQ_DIST_MS
#define SC_OPCODE_CHISQ_DIST_MS
SC_OPCODE_BINOM_DIST_MS
#define SC_OPCODE_BINOM_DIST_MS
sal_uInt8
unsigned char sal_uInt8
SC_OPCODE_AVERAGE_IFS
#define SC_OPCODE_AVERAGE_IFS
HID_FUNC_TDIST_RT
#define HID_FUNC_TDIST_RT
Definition: helpids.h:542
HID_FUNC_FORECAST_ETS_PIA
#define HID_FUNC_FORECAST_ETS_PIA
Definition: helpids.h:576
ScUnoAddInCollection::FindFunction
OUString FindFunction(const OUString &rUpperName, bool bLocalFirst)
User entered name. rUpperName MUST already be upper case!
Definition: addincol.cxx:1069
ScFunctionMgr::pCurCatListIter
std::vector< const ScFuncDesc * >::const_iterator pCurCatListIter
position in current category
Definition: funcdesc.hxx:399
HID_FUNC_ASC
#define HID_FUNC_ASC
Definition: helpids.h:493
SC_OPCODE_ARC_TAN
#define SC_OPCODE_ARC_TAN
SC_OPCODE_CEIL_MATH
#define SC_OPCODE_CEIL_MATH
HID_FUNC_GESTUTZTMITTEL
#define HID_FUNC_GESTUTZTMITTEL
Definition: helpids.h:380
HID_FUNC_RAND_NV
#define HID_FUNC_RAND_NV
Definition: helpids.h:594
HID_FUNC_DBMIN
#define HID_FUNC_DBMIN
Definition: helpids.h:198
SC_OPCODE_IS_VALUE
#define SC_OPCODE_IS_VALUE
HID_FUNC_STANDNORMVERT
#define HID_FUNC_STANDNORMVERT
Definition: helpids.h:393
SC_OPCODE_SIN_HYP
#define SC_OPCODE_SIN_HYP
SC_OPCODE_GAUSS
#define SC_OPCODE_GAUSS
HID_FUNC_ARCCOS
#define HID_FUNC_ARCCOS
Definition: helpids.h:296
SC_OPCODE_ST_DEV_P_A
#define SC_OPCODE_ST_DEV_P_A
HID_FUNC_GETPIVOTDATA
#define HID_FUNC_GETPIVOTDATA
Definition: helpids.h:458
HID_FUNC_INDEX
#define HID_FUNC_INDEX
Definition: helpids.h:447
HID_FUNC_F_DIST_RT
#define HID_FUNC_F_DIST_RT
Definition: helpids.h:524
SC_OPCODE_PHI
#define SC_OPCODE_PHI
HID_FUNC_TEXTJOIN_MS
#define HID_FUNC_TEXTJOIN_MS
Definition: helpids.h:583
HID_FUNC_FALSCH
#define HID_FUNC_FALSCH
Definition: helpids.h:267
SC_OPCODE_SUB_TOTAL
#define SC_OPCODE_SUB_TOTAL
SC_OPCODE_CLEAN
#define SC_OPCODE_CLEAN
SC_OPCODE_REPLACE
#define SC_OPCODE_REPLACE
SC_OPCODE_AND
#define SC_OPCODE_AND
SC_OPCODE_PERMUT
#define SC_OPCODE_PERMUT
ID_FUNCTION_GRP_FINANCIAL
#define ID_FUNCTION_GRP_FINANCIAL
Definition: scfuncs.hxx:23
if
if(aStr!=aBuf) UpdateName_Impl(m_xFollowLb.get()
HID_FUNC_PI
#define HID_FUNC_PI
Definition: helpids.h:280
HID_FUNC_WAHR
#define HID_FUNC_WAHR
Definition: helpids.h:269
HID_FUNC_TABELLEN
#define HID_FUNC_TABELLEN
Definition: helpids.h:456
SC_OPCODE_PI
#define SC_OPCODE_PI
SC_OPCODE_DEV_SQ
#define SC_OPCODE_DEV_SQ
HID_FUNC_BINOM_INV_MS
#define HID_FUNC_BINOM_INV_MS
Definition: helpids.h:515
SC_OPCODE_MAT_TRANS
#define SC_OPCODE_MAT_TRANS
HID_FUNC_ERF_MS
#define HID_FUNC_ERF_MS
Definition: helpids.h:565
HID_FUNC_TEIL
#define HID_FUNC_TEIL
Definition: helpids.h:480
ScFuncDesc::initArgumentInfo
virtual void initArgumentInfo() const override
Requests function data from AddInCollection.
Definition: funcdesc.cxx:327
SC_OPCODE_NORM_INV_MS
#define SC_OPCODE_NORM_INV_MS
SC_OPCODE_ADDRESS
#define SC_OPCODE_ADDRESS
HID_FUNC_LOGINV
#define HID_FUNC_LOGINV
Definition: helpids.h:396
HID_FUNC_IKV
#define HID_FUNC_IKV
Definition: helpids.h:243
HID_FUNC_TINV
#define HID_FUNC_TINV
Definition: helpids.h:406
HID_FUNC_GAMMAINV
#define HID_FUNC_GAMMAINV
Definition: helpids.h:399
ScFunctionList::Next
const ScFuncDesc * Next()
Definition: funcdesc.cxx:998
HID_FUNC_TDIST_2T
#define HID_FUNC_TDIST_2T
Definition: helpids.h:540
HID_FUNC_ROEMISCH
#define HID_FUNC_ROEMISCH
Definition: helpids.h:489
SC_OPCODE_IF
#define SC_OPCODE_IF
SC_OPCODE_SQRT
#define SC_OPCODE_SQRT
HID_FUNC_JIS
#define HID_FUNC_JIS
Definition: helpids.h:492
SC_OPCODE_ASC
#define SC_OPCODE_ASC
HID_FUNC_NETWORKDAYS
#define HID_FUNC_NETWORKDAYS
Definition: helpids.h:562
SC_OPCODE_AGGREGATE
#define SC_OPCODE_AGGREGATE
SC_OPCODE_UNICHAR
#define SC_OPCODE_UNICHAR
SC_OPCODE_ERROR_TYPE_ODF
#define SC_OPCODE_ERROR_TYPE_ODF
SC_OPCODE_UPPER
#define SC_OPCODE_UPPER
SC_OPCODE_WEIBULL
#define SC_OPCODE_WEIBULL
HID_FUNC_CHISQDIST_MS
#define HID_FUNC_CHISQDIST_MS
Definition: helpids.h:519
HID_FUNC_SECANTHYP
#define HID_FUNC_SECANTHYP
Definition: helpids.h:315
HID_FUNC_UNICODE
#define HID_FUNC_UNICODE
Definition: helpids.h:494
HID_FUNC_KRITBINOM
#define HID_FUNC_KRITBINOM
Definition: helpids.h:389
ScFuncDesc::nFIndex
sal_uInt16 nFIndex
Unique function index.
Definition: funcdesc.hxx:221
HID_FUNC_DDE
#define HID_FUNC_DDE
Definition: helpids.h:454
SC_OPCODE_INFO
#define SC_OPCODE_INFO
HID_FUNC_SVERWEIS
#define HID_FUNC_SVERWEIS
Definition: helpids.h:446
SC_OPCODE_F_DIST
#define SC_OPCODE_F_DIST
HID_FUNC_MINA
#define HID_FUNC_MINA
Definition: helpids.h:427
SC_OPCODE_ROUND_DOWN
#define SC_OPCODE_ROUND_DOWN
value
Any value
HID_FUNC_RUNDEN
#define HID_FUNC_RUNDEN
Definition: helpids.h:329
HID_FUNC_RIGHTB
#define HID_FUNC_RIGHTB
Definition: helpids.h:482
HID_FUNC_DBSTDABWN
#define HID_FUNC_DBSTDABWN
Definition: helpids.h:201
SC_OPCODE_CEIL_PRECISE
#define SC_OPCODE_CEIL_PRECISE
SC_OPCODE_RANK_AVG
#define SC_OPCODE_RANK_AVG
ScFunctionList::GetCount
sal_uInt32 GetCount() const
Definition: funcdesc.hxx:247
SC_OPCODE_LEFTB
#define SC_OPCODE_LEFTB
SC_OPCODE_SHEET
#define SC_OPCODE_SHEET
SC_OPCODE_MIDB
#define SC_OPCODE_MIDB
HID_FUNC_ARCOSHYP
#define HID_FUNC_ARCOSHYP
Definition: helpids.h:298
SC_OPCODE_Z_TEST_MS
#define SC_OPCODE_Z_TEST_MS
HID_FUNC_DEG
#define HID_FUNC_DEG
Definition: helpids.h:317
HID_FUNC_WIEDERHOLEN
#define HID_FUNC_WIEDERHOLEN
Definition: helpids.h:485
ScFuncDesc::getDescription
virtual OUString getDescription() const override
Returns the description of the function.
Definition: funcdesc.cxx:296
HID_FUNC_ZW
#define HID_FUNC_ZW
Definition: helpids.h:227
HID_FUNC_KOVAR
#define HID_FUNC_KOVAR
Definition: helpids.h:425
SC_OPCODE_CHOOSE
#define SC_OPCODE_CHOOSE
HID_FUNC_GERADE
#define HID_FUNC_GERADE
Definition: helpids.h:332
HID_FUNC_VDB
#define HID_FUNC_VDB
Definition: helpids.h:239
ScFuncDesc::sHelpId
OString sHelpId
HelpId of function.
Definition: funcdesc.hxx:226
SC_OPCODE_GAMMA_INV_MS
#define SC_OPCODE_GAMMA_INV_MS
HID_FUNC_VARIANZ
#define HID_FUNC_VARIANZ
Definition: helpids.h:360
HID_FUNC_ISPMT
#define HID_FUNC_ISPMT
Definition: helpids.h:247
HID_FUNC_ARABISCH
#define HID_FUNC_ARABISCH
Definition: helpids.h:490
HID_FUNC_ST_DEV_P_MS
#define HID_FUNC_ST_DEV_P_MS
Definition: helpids.h:508
SC_OPCODE_CONVERT_OOO
#define SC_OPCODE_CONVERT_OOO
HID_FUNC_ZEILEN
#define HID_FUNC_ZEILEN
Definition: helpids.h:444
HID_FUNC_VARIANZEN
#define HID_FUNC_VARIANZEN
Definition: helpids.h:361
SC_OPCODE_COSECANT
#define SC_OPCODE_COSECANT
HID_FUNC_ABRUNDEN
#define HID_FUNC_ABRUNDEN
Definition: helpids.h:331
SC_OPCODE_INTERCEPT
#define SC_OPCODE_INTERCEPT
HID_FUNC_FORECAST_ETS_PIM
#define HID_FUNC_FORECAST_ETS_PIM
Definition: helpids.h:577
SC_OPCODE_STD_NORM_DIST_MS
#define SC_OPCODE_STD_NORM_DIST_MS
SC_OPCODE_CHI_TEST
#define SC_OPCODE_CHI_TEST
SC_OPCODE_GEO_MEAN
#define SC_OPCODE_GEO_MEAN
SC_OPCODE_SYD
#define SC_OPCODE_SYD
SC_OPCODE_ST_DEV_P_MS
#define SC_OPCODE_ST_DEV_P_MS
HID_FUNC_KURT
#define HID_FUNC_KURT
Definition: helpids.h:369
HID_FUNC_CHISQINV_MS
#define HID_FUNC_CHISQINV_MS
Definition: helpids.h:520
SC_OPCODE_VAR_P_A
#define SC_OPCODE_VAR_P_A
SC_OPCODE_TEXT
#define SC_OPCODE_TEXT
HID_FUNC_MODALWERT
#define HID_FUNC_MODALWERT
Definition: helpids.h:372
SC_OPCODE_BAHTTEXT
#define SC_OPCODE_BAHTTEXT
SC_OPCODE_POISSON_DIST_MS
#define SC_OPCODE_POISSON_DIST_MS
SC_OPCODE_HAR_MEAN
#define SC_OPCODE_HAR_MEAN
SC_OPCODE_STD_NORM_DIST
#define SC_OPCODE_STD_NORM_DIST
HID_FUNC_DATUM
#define HID_FUNC_DATUM
Definition: helpids.h:206
HID_FUNC_SUMMEXMY2
#define HID_FUNC_SUMMEXMY2
Definition: helpids.h:349
SC_OPCODE_ARABIC
#define SC_OPCODE_ARABIC
HID_FUNC_BAHTTEXT
#define HID_FUNC_BAHTTEXT
Definition: helpids.h:491
SC_OPCODE_GET_DAY_OF_WEEK
#define SC_OPCODE_GET_DAY_OF_WEEK
SC_OPCODE_SUM_SQ
#define SC_OPCODE_SUM_SQ
HID_FUNC_CHIVERT
#define HID_FUNC_CHIVERT
Definition: helpids.h:409
SC_OPCODE_ODD
#define SC_OPCODE_ODD
SC_OPCODE_NPER
#define SC_OPCODE_NPER
SC_OPCODE_IS_ERROR
#define SC_OPCODE_IS_ERROR
ScFuncDesc::getFunctionName
virtual OUString getFunctionName() const override
Returns the name of the function.
Definition: funcdesc.cxx:283
ScFuncDesc::maDefArgNames
std::vector< OUString > maDefArgNames
Parameter name(s)
Definition: funcdesc.hxx:218
SC_OPCODE_VBD
#define SC_OPCODE_VBD
SC_OPCODE_PLUS_MINUS
#define SC_OPCODE_PLUS_MINUS
HID_FUNC_BITRSHIFT
#define HID_FUNC_BITRSHIFT
Definition: helpids.h:501
SC_OPCODE_ISPMT
#define SC_OPCODE_ISPMT
HID_FUNC_WVERWEIS
#define HID_FUNC_WVERWEIS
Definition: helpids.h:445
HID_FUNC_RANK_AVG
#define HID_FUNC_RANK_AVG
Definition: helpids.h:553
SC_OPCODE_RIGHTB
#define SC_OPCODE_RIGHTB
SC_OPCODE_H_LOOKUP
#define SC_OPCODE_H_LOOKUP
HID_FUNC_POISSON_DIST_MS
#define HID_FUNC_POISSON_DIST_MS
Definition: helpids.h:530
HID_FUNC_CONFIDENCE_T
#define HID_FUNC_CONFIDENCE_T
Definition: helpids.h:522
HID_FUNC_DBPRODUKT
#define HID_FUNC_DBPRODUKT
Definition: helpids.h:199
SC_OPCODE_KURT
#define SC_OPCODE_KURT
SC_OPCODE_RIGHT
#define SC_OPCODE_RIGHT
HID_FUNC_MIN
#define HID_FUNC_MIN
Definition: helpids.h:359
HID_FUNC_TAGE
#define HID_FUNC_TAGE
Definition: helpids.h:220
SC_OPCODE_RATE
#define SC_OPCODE_RATE
HID_FUNC_ISTZAHL
#define HID_FUNC_ISTZAHL
Definition: helpids.h:257
HID_FUNC_CEIL_PRECISE
#define HID_FUNC_CEIL_PRECISE
Definition: helpids.h:559
HID_FUNC_TANHYP
#define HID_FUNC_TANHYP
Definition: helpids.h:311
ScUnoAddInCollection::FillFunctionDesc
bool FillFunctionDesc(tools::Long nFunc, ScFuncDesc &rDesc)
Definition: addincol.cxx:1155
HID_FUNC_VARIANZA
#define HID_FUNC_VARIANZA
Definition: helpids.h:432
HID_FUNC_FINV
#define HID_FUNC_FINV
Definition: helpids.h:408
HID_FUNC_DBMAX
#define HID_FUNC_DBMAX
Definition: helpids.h:197
HID_FUNC_LOGNORMVERT
#define HID_FUNC_LOGNORMVERT
Definition: helpids.h:395
SC_OPCODE_TYPE
#define SC_OPCODE_TYPE
SC_OPCODE_RAWSUBTRACT
#define SC_OPCODE_RAWSUBTRACT
HID_FUNC_POTENZ
#define HID_FUNC_POTENZ
Definition: helpids.h:278
HID_FUNC_KONFIDENZ
#define HID_FUNC_KONFIDENZ
Definition: helpids.h:414
HID_FUNC_COVARIANCE_P
#define HID_FUNC_COVARIANCE_P
Definition: helpids.h:506
HID_FUNC_CHIINV
#define HID_FUNC_CHIINV
Definition: helpids.h:410
SC_OPCODE_WEEKNUM_OOO
#define SC_OPCODE_WEEKNUM_OOO
HID_FUNC_RANK_EQ
#define HID_FUNC_RANK_EQ
Definition: helpids.h:552
HID_FUNC_DBAUSZUG
#define HID_FUNC_DBAUSZUG
Definition: helpids.h:196
HID_FUNC_LOGNORMDIST_MS
#define HID_FUNC_LOGNORMDIST_MS
Definition: helpids.h:535
SC_OPCODE_FLOOR_MS
#define SC_OPCODE_FLOOR_MS
SC_OPCODE_T_DIST_RT
#define SC_OPCODE_T_DIST_RT
ScFunctionList::aFunctionListIter
::std::vector< const ScFuncDesc * >::iterator aFunctionListIter
position in function list
Definition: funcdesc.hxx:258
SC_OPCODE_CHI_DIST
#define SC_OPCODE_CHI_DIST
HID_FUNC_ERROR_TYPE_ODF
#define HID_FUNC_ERROR_TYPE_ODF
Definition: helpids.h:568
SC_OPCODE_ISOWEEKNUM
#define SC_OPCODE_ISOWEEKNUM
HID_FUNC_LIA
#define HID_FUNC_LIA
Definition: helpids.h:236
HID_FUNC_AGGREGATE
#define HID_FUNC_AGGREGATE
Definition: helpids.h:567
HID_FUNC_RKP
#define HID_FUNC_RKP
Definition: helpids.h:352
ScFuncDesc::getParameterName
virtual OUString getParameterName(sal_uInt32 _nPos) const override
Returns name of parameter at given position.
Definition: funcdesc.cxx:378
SC_OPCODE_ARC_COS
#define SC_OPCODE_ARC_COS
HID_FUNC_WEEKNUM_OOO
#define HID_FUNC_WEEKNUM_OOO
Definition: helpids.h:573
HID_FUNC_WORKDAY_MS
#define HID_FUNC_WORKDAY_MS
Definition: helpids.h:564
HID_FUNC_NEGBINOMVERT
#define HID_FUNC_NEGBINOMVERT
Definition: helpids.h:388
HID_FUNC_DM
#define HID_FUNC_DM
Definition: helpids.h:461
ScFuncDesc::bIncomplete
bool bIncomplete
Incomplete argument info (set for add-in info from configuration)
Definition: funcdesc.hxx:227
HID_FUNC_MODAL_VALUE_MULTI
#define HID_FUNC_MODAL_VALUE_MULTI
Definition: helpids.h:555
SC_OPCODE_DB_VAR_P
#define SC_OPCODE_DB_VAR_P
HID_FUNC_PERCENTILE_EXC
#define HID_FUNC_PERCENTILE_EXC
Definition: helpids.h:546
LegacyFuncData::GetModuleName
const OUString & GetModuleName() const
Definition: callform.cxx:337
HID_FUNC_CHIINV_MS
#define HID_FUNC_CHIINV_MS
Definition: helpids.h:516
HID_FUNC_RGP
#define HID_FUNC_RGP
Definition: helpids.h:351
SC_OPCODE_MIRR
#define SC_OPCODE_MIRR
ScFuncDesc
Stores and generates human readable descriptions for spreadsheet-functions, e.g. functions used in fo...
Definition: funcdesc.hxx:40
HID_FUNC_ISTLOG
#define HID_FUNC_ISTLOG
Definition: helpids.h:253
HID_FUNC_COS
#define HID_FUNC_COS
Definition: helpids.h:304
SC_OPCODE_FLOOR
#define SC_OPCODE_FLOOR
HID_FUNC_F_TEST_MS
#define HID_FUNC_F_TEST_MS
Definition: helpids.h:527
SC_OPCODE_CUM_IPMT
#define SC_OPCODE_CUM_IPMT
HID_FUNC_IFERROR
#define HID_FUNC_IFERROR
Definition: helpids.h:271
SC_OPCODE_FORECAST
#define SC_OPCODE_FORECAST
SC_OPCODE_INDEX
#define SC_OPCODE_INDEX
ScFuncDesc::nArgCount
sal_uInt16 nArgCount
All parameter count, suppressed and unsuppressed.
Definition: funcdesc.hxx:223
SC_OPCODE_COUNT
#define SC_OPCODE_COUNT
SC_OPCODE_NORM_INV
#define SC_OPCODE_NORM_INV
HID_FUNC_COT
#define HID_FUNC_COT
Definition: helpids.h:306
HID_FUNC_ARSINHYP
#define HID_FUNC_ARSINHYP
Definition: helpids.h:299
SC_OPCODE_ARC_COT_HYP
#define SC_OPCODE_ARC_COT_HYP
SC_OPCODE_COLUMNS
#define SC_OPCODE_COLUMNS
SC_OPCODE_T_INV_MS
#define SC_OPCODE_T_INV_MS
ocClose
ocClose
SC_OPCODE_VAR_A
#define SC_OPCODE_VAR_A
HID_FUNC_EXP_DIST_MS
#define HID_FUNC_EXP_DIST_MS
Definition: helpids.h:528
SC_OPCODE_ST_DEV_P
#define SC_OPCODE_ST_DEV_P
HID_FUNC_SINHYP
#define HID_FUNC_SINHYP
Definition: helpids.h:309
HID_FUNC_FISHER
#define HID_FUNC_FISHER
Definition: helpids.h:385
HID_FUNC_ANZAHL
#define HID_FUNC_ANZAHL
Definition: helpids.h:356
SC_OPCODE_GET_ACT_DATE
#define SC_OPCODE_GET_ACT_DATE
HID_FUNC_NUMBERVALUE
#define HID_FUNC_NUMBERVALUE
Definition: helpids.h:496
SC_OPCODE_ROUND
#define SC_OPCODE_ROUND
ScUnoAddInCollection::GetFuncCount
tools::Long GetFuncCount()
Definition: addincol.cxx:1147
HID_FUNC_TAGE360
#define HID_FUNC_TAGE360
Definition: helpids.h:209
ScFuncDesc::~ScFuncDesc
virtual ~ScFuncDesc()
Definition: funcdesc.cxx:113
ScFunctionList::aFunctionList
::std::vector< const ScFuncDesc * > aFunctionList
List of functions.
Definition: funcdesc.hxx:257
HID_FUNC_ISTFEHL
#define HID_FUNC_ISTFEHL
Definition: helpids.h:250
HID_FUNC_VORZEICHEN
#define HID_FUNC_VORZEICHEN
Definition: helpids.h:325
SC_OPCODE_EXP_DIST
#define SC_OPCODE_EXP_DIST
SC_OPCODE_IS_FORMULA
#define SC_OPCODE_IS_FORMULA
SC_OPCODE_DDB
#define SC_OPCODE_DDB
SC_OPCODE_STANDARD
#define SC_OPCODE_STANDARD
ID_FUNCTION_GRP_TABLE
#define ID_FUNCTION_GRP_TABLE
Definition: scfuncs.hxx:29
ScFunctionMgr::First
const ScFuncDesc * First(sal_uInt16 nCategory=0) const
Returns the first function in category nCategory.
Definition: funcdesc.cxx:1100
ScFunctionCategory::m_rCategory
const ::std::vector< const ScFuncDesc * > & m_rCategory
list of functions in this category
Definition: funcdesc.hxx:296
SC_OPCODE_ARC_COS_HYP
#define SC_OPCODE_ARC_COS_HYP
HID_FUNC_LENB
#define HID_FUNC_LENB
Definition: helpids.h:481
SC_OPCODE_FACT
#define SC_OPCODE_FACT
SC_OPCODE_HYPERLINK
#define SC_OPCODE_HYPERLINK
SC_OPCODE_IFS_MS
#define SC_OPCODE_IFS_MS
HID_FUNC_WAHRSCHBEREICH
#define HID_FUNC_WAHRSCHBEREICH
Definition: helpids.h:381
HID_FUNC_FAKULTAET
#define HID_FUNC_FAKULTAET
Definition: helpids.h:323
HID_FUNC_FORECAST_LIN
#define HID_FUNC_FORECAST_LIN
Definition: helpids.h:581
false
bool m_bDetectedRangeSegmentation false
SC_OPCODE_NETWORKDAYS_MS
#define SC_OPCODE_NETWORKDAYS_MS
SC_OPCODE_LOG_NORM_DIST
#define SC_OPCODE_LOG_NORM_DIST
SC_OPCODE_LEN
#define SC_OPCODE_LEN
HID_FUNC_ZUFALLSZAHL
#define HID_FUNC_ZUFALLSZAHL
Definition: helpids.h:291
Generated on Tue Jun 21 2022 19:45:23 for LibreOffice Module sc (master) by   doxygen 1.8.10