Change the parameter types of HLOOKUP, MATCH, VLOOKUP, LINEST and LOGEST
to ForceArray, or "ForceArray Reference|Array", as needed by ODF 1.3.
Patch by: me
diff --git a/main/sc/source/core/tool/parclass.cxx b/main/sc/source/core/tool/parclass.cxx
index c833322..c18734b 100644
--- a/main/sc/source/core/tool/parclass.cxx
+++ b/main/sc/source/core/tool/parclass.cxx
@@ -118,7 +118,7 @@
{ ocGreaterEqual, {{ Array, Array }, 0 }},
{ ocGrowth, {{ Reference, Reference, Reference, Value }, 0 }},
{ ocHarMean, {{ Reference }, 1 }},
- { ocHLookup, {{ Value, Reference, Value, Value }, 0 }},
+ { ocHLookup, {{ Value, ReferenceOrForceArray, Value, Value }, 0 }},
{ ocIRR, {{ Reference, Value }, 0 }},
{ ocIndex, {{ Reference, Value, Value, Value }, 0 }},
{ ocIntercept, {{ ForceArray, ForceArray }, 0 }},
@@ -130,7 +130,7 @@
{ ocLess, {{ Array, Array }, 0 }},
{ ocLessEqual, {{ Array, Array }, 0 }},
{ ocLookup, {{ Value, ReferenceOrForceArray, ReferenceOrForceArray }, 0 }},
- { ocMatch, {{ Value, Reference, Reference }, 0 }},
+ { ocMatch, {{ Value, ReferenceOrForceArray, Reference }, 0 }},
{ ocMatDet, {{ ForceArray }, 0 }},
{ ocMatInv, {{ ForceArray }, 0 }},
{ ocMatMult, {{ ForceArray, ForceArray }, 0 }},
@@ -162,8 +162,8 @@
{ ocProduct, {{ Reference }, 1 }},
{ ocQuartile, {{ Reference, Value }, 0 }},
{ ocRank, {{ Value, Reference, Value }, 0 }},
- { ocRGP, {{ Reference, Reference, Value, Value }, 0 }},
- { ocRKP, {{ Reference, Reference, Value, Value }, 0 }},
+ { ocRGP, {{ ForceArray, ForceArray, Value, Value }, 0 }},
+ { ocRKP, {{ ForceArray, ForceArray, Value, Value }, 0 }},
{ ocRow, {{ Reference }, 0 }},
{ ocRows, {{ Reference }, 1 }},
{ ocRSQ, {{ ForceArray, ForceArray }, 0 }},
@@ -194,7 +194,7 @@
{ ocVarA, {{ Reference }, 1 }},
{ ocVarP, {{ Reference }, 1 }},
{ ocVarPA, {{ Reference }, 1 }},
- { ocVLookup, {{ Value, Reference, Value, Value }, 0 }},
+ { ocVLookup, {{ Value, ReferenceOrForceArray, Value, Value }, 0 }},
{ ocXor, {{ Reference }, 1 }},
{ ocZTest, {{ Reference, Value, Value }, 0 }},
// Excel doubts:
