This is an automated email from the ASF dual-hosted git repository.
damjan pushed a commit to branch odf-1.3
in repository https://gitbox.apache.org/repos/asf/openoffice.git
The following commit(s) were added to refs/heads/odf-1.3 by this push:
new 07b7105f20 Change the parameter types of HLOOKUP, MATCH, VLOOKUP,
LINEST and LOGEST to ForceArray, or "ForceArray Reference|Array", as needed by
ODF 1.3.
07b7105f20 is described below
commit 07b7105f20776a1b6f4e27351365759551337431
Author: Damjan Jovanovic <[email protected]>
AuthorDate: Sun Jan 28 06:10:31 2024 +0200
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
---
main/sc/source/core/tool/parclass.cxx | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/main/sc/source/core/tool/parclass.cxx
b/main/sc/source/core/tool/parclass.cxx
index c833322cf3..c18734b2c8 100644
--- a/main/sc/source/core/tool/parclass.cxx
+++ b/main/sc/source/core/tool/parclass.cxx
@@ -118,7 +118,7 @@ const ScParameterClassification::RawData
ScParameterClassification::pRawData[] =
{ 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 @@ const ScParameterClassification::RawData
ScParameterClassification::pRawData[] =
{ 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 @@ const ScParameterClassification::RawData
ScParameterClassification::pRawData[] =
{ 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 @@ const ScParameterClassification::RawData
ScParameterClassification::pRawData[] =
{ 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:
