summaryrefslogtreecommitdiff
path: root/sc
diff options
context:
space:
mode:
authorEike Rathke <erack@redhat.com>2017-04-20 15:32:38 +0200
committerEike Rathke <erack@redhat.com>2017-04-20 15:33:07 +0200
commitb15c9ed2c2cb4b6e8b61d80bae284e4ea421aff3 (patch)
tree4a4bad607910d8a88a56afd3b033adb9d1c115e2 /sc
parent16e4d8004f1d6cb53efbaf026eafbea70504b154 (diff)
keep list sorted by alphabetical opcode
Change-Id: I8eafa00cadd6196e4e9dd87a00fd530c3945af2c
Diffstat (limited to 'sc')
-rw-r--r--sc/source/core/tool/parclass.cxx52
1 files changed, 26 insertions, 26 deletions
diff --git a/sc/source/core/tool/parclass.cxx b/sc/source/core/tool/parclass.cxx
index 7c5ffd3aae99..2be37c1bfe6a 100644
--- a/sc/source/core/tool/parclass.cxx
+++ b/sc/source/core/tool/parclass.cxx
@@ -69,6 +69,7 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
{ ocTableOp, {{ Value, Value, Value, Value, Value }, 0 }},
// Operators and functions.
{ ocAdd, {{ Array, Array }, 0 }},
+ { ocAggregate, {{ Value, Value, Reference }, 1 }},
{ ocAmpersand, {{ Array, Array }, 0 }},
{ ocAnd, {{ Reference }, 1 }},
{ ocAreas, {{ Reference }, 0 }},
@@ -105,40 +106,49 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
{ ocDevSq, {{ Reference }, 1 }},
{ ocDiv, {{ Array, Array }, 0 }},
{ ocEqual, {{ Array, Array }, 0 }},
+ { ocFTest, {{ ForceArray, ForceArray }, 0 }},
{ ocForecast, {{ Value, ForceArray, ForceArray }, 0 }},
+ { ocForecast_ETS_ADD, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
+ { ocForecast_ETS_MUL, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
+ { ocForecast_ETS_PIA, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value, Value }, 0 }},
+ { ocForecast_ETS_PIM, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value, Value }, 0 }},
+ { ocForecast_ETS_SEA, {{ ForceArray, ForceArray, Value, Value }, 0 }},
+ { ocForecast_ETS_STA, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
+ { ocForecast_ETS_STM, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
{ ocFormula, {{ Reference }, 0 }},
{ ocFrequency, {{ Reference, Reference }, 0 }},
- { ocFTest, {{ ForceArray, ForceArray }, 0 }},
- { ocGeoMean, {{ Reference }, 1 }},
{ ocGCD, {{ Reference }, 1 }},
+ { ocGeoMean, {{ Reference }, 1 }},
{ ocGreater, {{ Array, Array }, 0 }},
{ ocGreaterEqual, {{ Array, Array }, 0 }},
{ ocGrowth, {{ Reference, Reference, Reference, Value }, 0 }},
- { ocHarMean, {{ Reference }, 1 }},
{ ocHLookup, {{ Value, ReferenceOrForceArray, Value, Value }, 0 }},
+ { ocHarMean, {{ Reference }, 1 }},
{ ocIRR, {{ Reference, Value }, 0 }},
{ ocIndex, {{ Reference, Value, Value, Value }, 0 }},
{ ocIntercept, {{ ForceArray, ForceArray }, 0 }},
{ ocIntersect, {{ Reference, Reference }, 0 }},
{ ocIsRef, {{ Reference }, 0 }},
- { ocLCM, {{ Reference }, 1 }},
{ ocKurt, {{ Reference }, 1 }},
+ { ocLCM, {{ Reference }, 1 }},
{ ocLarge, {{ Reference, Value }, 0 }},
{ ocLess, {{ Array, Array }, 0 }},
{ ocLessEqual, {{ Array, Array }, 0 }},
+ { ocLinest, {{ ForceArray, ForceArray, Value, Value }, 0 }},
+ { ocLogest, {{ ForceArray, ForceArray, Value, Value }, 0 }},
{ ocLookup, {{ Value, ReferenceOrForceArray, ReferenceOrForceArray }, 0 }},
- { ocMatch, {{ Value, ReferenceOrForceArray, Value }, 0 }},
+ { ocMIRR, {{ Reference, Value, Value }, 0 }},
{ ocMatDet, {{ ForceArray }, 0 }},
{ ocMatInv, {{ ForceArray }, 0 }},
{ ocMatMult, {{ ForceArray, ForceArray }, 0 }},
{ ocMatTrans, {{ Array }, 0 }}, // strange, but Xcl doesn't force MatTrans array
{ ocMatValue, {{ Reference, Value, Value }, 0 }},
+ { ocMatch, {{ Value, ReferenceOrForceArray, Value }, 0 }},
{ ocMax, {{ Reference }, 1 }},
{ ocMaxA, {{ Reference }, 1 }},
{ ocMedian, {{ Reference }, 1 }},
{ ocMin, {{ Reference }, 1 }},
{ ocMinA, {{ Reference }, 1 }},
- { ocMIRR, {{ Reference, Value, Value }, 0 }},
{ ocModalValue, {{ ForceArray }, 1 }},
{ ocModalValue_MS, {{ ForceArray }, 1 }},
{ ocModalValue_Multi,{{ ForceArray }, 1 }},
@@ -147,6 +157,8 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
{ ocNPV, {{ Value, Reference }, 1 }},
{ ocNeg, {{ Array }, 0 }},
{ ocNegSub, {{ Array }, 0 }},
+ { ocNetWorkdays, {{ Value, Value, Reference, Reference }, 0 }},
+ { ocNetWorkdays_MS, {{ Value, Value, Value, Reference }, 0 }},
{ ocNot, {{ Array }, 0 }},
{ ocNotEqual, {{ Array, Array }, 0 }},
{ ocOffset, {{ Reference, Value, Value, Value, Value }, 0 }},
@@ -165,14 +177,15 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
{ ocQuartile, {{ Reference, Value }, 0 }},
{ ocQuartile_Exc, {{ Reference, Value }, 0 }},
{ ocQuartile_Inc, {{ Reference, Value }, 0 }},
+ { ocRSQ, {{ ForceArray, ForceArray }, 0 }},
{ ocRank, {{ Value, Reference, Value }, 0 }},
{ ocRank_Avg, {{ Value, Reference, Value }, 0 }},
{ ocRank_Eq, {{ Value, Reference, Value }, 0 }},
- { ocLinest, {{ ForceArray, ForceArray, Value, Value }, 0 }},
- { ocLogest, {{ ForceArray, ForceArray, Value, Value }, 0 }},
{ ocRow, {{ Reference }, 0 }},
{ ocRows, {{ Reference }, 1 }},
- { ocRSQ, {{ ForceArray, ForceArray }, 0 }},
+ { ocSTEYX, {{ ForceArray, ForceArray }, 0 }},
+ { ocSheet, {{ Reference }, 0 }},
+ { ocSheets, {{ Reference }, 1 }},
{ ocSkew, {{ Reference }, 1 }},
{ ocSkewp, {{ Reference }, 1 }},
{ ocSlope, {{ ForceArray, ForceArray }, 0 }},
@@ -183,7 +196,6 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
{ ocStDevPA, {{ Reference }, 1 }},
{ ocStDevP_MS, {{ Reference }, 1 }},
{ ocStDevS, {{ Reference }, 1 }},
- { ocSTEYX, {{ ForceArray, ForceArray }, 0 }},
{ ocSub, {{ Array, Array }, 0 }},
{ ocSubTotal, {{ Value, Reference }, 1 }},
{ ocSum, {{ Reference }, 1 }},
@@ -191,36 +203,24 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
{ ocSumIfs, {{ Reference, Reference, Value }, 2 }},
{ ocSumProduct, {{ ForceArray }, 1 }},
{ ocSumSQ, {{ Reference }, 1 }},
- { ocSumX2MY2, {{ ForceArray, ForceArray }, 0 }},
{ ocSumX2DY2, {{ ForceArray, ForceArray }, 0 }},
+ { ocSumX2MY2, {{ ForceArray, ForceArray }, 0 }},
{ ocSumXMY2, {{ ForceArray, ForceArray }, 0 }},
- { ocSheet, {{ Reference }, 0 }},
- { ocSheets, {{ Reference }, 1 }},
+ { ocTTest, {{ ForceArray, ForceArray, Value, Value }, 0 }},
{ ocTextJoin_MS, {{ Reference, Value, Reference }, 1 }},
{ ocTrend, {{ Reference, Reference, Reference, Value }, 0 }},
{ ocTrimMean, {{ Reference, Value }, 0 }},
- { ocTTest, {{ ForceArray, ForceArray, Value, Value }, 0 }},
+ { ocVLookup, {{ Value, ReferenceOrForceArray, Value, Value }, 0 }},
{ ocVar, {{ Reference }, 1 }},
{ ocVarA, {{ Reference }, 1 }},
{ ocVarP, {{ Reference }, 1 }},
{ ocVarPA, {{ Reference }, 1 }},
{ ocVarP_MS, {{ Reference }, 1 }},
{ ocVarS, {{ Reference }, 1 }},
- { ocVLookup, {{ Value, ReferenceOrForceArray, Value, Value }, 0 }},
+ { ocWorkday_MS, {{ Value, Value, Value, Reference }, 0 }},
{ ocXor, {{ Reference }, 1 }},
{ ocZTest, {{ Reference, Value, Value }, 0 }},
{ ocZTest_MS, {{ Reference, Value, Value }, 0 }},
- { ocNetWorkdays, {{ Value, Value, Reference, Reference }, 0 }},
- { ocNetWorkdays_MS, {{ Value, Value, Value, Reference }, 0 }},
- { ocWorkday_MS, {{ Value, Value, Value, Reference }, 0 }},
- { ocAggregate, {{ Value, Value, Reference }, 1 }},
- { ocForecast_ETS_ADD, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
- { ocForecast_ETS_MUL, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
- { ocForecast_ETS_PIA, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value, Value }, 0 }},
- { ocForecast_ETS_PIM, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value, Value }, 0 }},
- { ocForecast_ETS_SEA, {{ ForceArray, ForceArray, Value, Value }, 0 }},
- { ocForecast_ETS_STA, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
- { ocForecast_ETS_STM, {{ ForceArray, ForceArray, ForceArray, Value, Value, Value }, 0 }},
// Excel doubts:
// ocN, ocT: Excel says (and handles) Reference, error? This means no
// position dependent SingleRef if DoubleRef, and no array calculation,
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-01 16:18:02 +0000