diff options
| author | Eike Rathke <erack@redhat.com> | 2015-07-21 16:09:34 +0200 |
|---|---|---|
| committer | Andras Timar <andras.timar@collabora.com> | 2015-08-31 13:52:57 +0200 |
| commit | be4ebe1713ae7c826963e979b29c1e911d0e23ee (patch) | |
| tree | 769e469ad856788c3a85ffb35971ab3862119885 /sc/source | |
| parent | 83d0bb881f7e9a9fb95332a075e577048ae6773f (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>
Diffstat (limited to 'sc/source')
| -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 }}, |