diff options
author | Eike Rathke <erack@redhat.com> | 2015-07-21 16:09:34 +0200 |
---|---|---|
committer | Caolán McNamara <caolanm@redhat.com> | 2015-08-25 15:15:16 +0000 |
commit | be28207b668d9f8752ea82ef669aa45876b9ed69 (patch) | |
tree | 41a1f583d3253c07a2afbdb3ac9a161bde05d534 | |
parent | 5aecce00ee5e9c60cdd8a5af47600a06eddf911d (diff) |
MATCH, HLOOKUP and VLOOKUP have a ReferenceOrForceArray parameter
tdf#91278 related
Change-Id: Iab4728b07649bcbb1beb372e68369f3762b13a5c
(cherry picked from commit 01eea7fe40c939311bf1920b6e8b4391a93c2e82)
Reviewed-on: https://gerrit.libreoffice.org/17265
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
-rw-r--r-- | sc/source/core/tool/parclass.cxx | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sc/source/core/tool/parclass.cxx b/sc/source/core/tool/parclass.cxx index a397e795e11f..8fff96357421 100644 --- a/sc/source/core/tool/parclass.cxx +++ b/sc/source/core/tool/parclass.cxx @@ -114,7 +114,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 }}, @@ -126,7 +126,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, Value }, 0 }}, { ocMatDet, {{ ForceArray }, 0 }}, { ocMatInv, {{ ForceArray }, 0 }}, { ocMatMult, {{ ForceArray, ForceArray }, 0 }}, @@ -204,7 +204,7 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] = { ocVarPA, {{ Reference }, 1 }}, { ocVarP_MS, {{ Reference }, 1 }}, { ocVarS, {{ Reference }, 1 }}, - { ocVLookup, {{ Value, Reference, Value, Value }, 0 }}, + { ocVLookup, {{ Value, ReferenceOrForceArray, Value, Value }, 0 }}, { ocXor, {{ Reference }, 1 }}, { ocZTest, {{ Reference, Value, Value }, 0 }}, { ocZTest_MS, {{ Reference, Value, Value }, 0 }}, |