From eae5503d1b3a7f9aace2603d6ce91003ede33974 Mon Sep 17 00:00:00 2001
From: Eike Rathke <erack@redhat.com>
Date: Wed, 10 May 2017 13:59:14 +0200
Subject: Resolves: tdf#107724 INDIRECT and OFFSET return ParamClass::Reference

In which case ParamClass::ReferenceOrForceArray is not propagated to a nested
function.

Change-Id: Ibf054d7a2b7350b90ab71766fd1d501c5ae5d5e9
---
 sc/source/core/tool/parclass.cxx | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'sc/source')

diff --git a/sc/source/core/tool/parclass.cxx b/sc/source/core/tool/parclass.cxx
index fbd790ef4742..35513911adf5 100644
--- a/sc/source/core/tool/parclass.cxx
+++ b/sc/source/core/tool/parclass.cxx
@@ -128,6 +128,7 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
     { ocHarMean,         {{ Reference                                            }, 1, Value }},
     { ocIRR,             {{ Reference, Value                                     }, 0, Value }},
     { ocIndex,           {{ Reference, Value, Value, Value                       }, 0, Value }},
+    { ocIndirect,        {{ Value, Value                                         }, 0, Reference }},
     { ocIntercept,       {{ ForceArray, ForceArray                               }, 0, Value }},
     { ocIntersect,       {{ Reference, Reference                                 }, 0, Value }},
     { ocIsRef,           {{ Reference                                            }, 0, Value }},
@@ -163,7 +164,7 @@ const ScParameterClassification::RawData ScParameterClassification::pRawData[] =
     { ocNetWorkdays_MS,  {{ Value, Value, Value, Reference                       }, 0, Value }},
     { ocNot,             {{ Array                                                }, 0, Value }},
     { ocNotEqual,        {{ Array, Array                                         }, 0, Value }},
-    { ocOffset,          {{ Reference, Value, Value, Value, Value                }, 0, Value }},
+    { ocOffset,          {{ Reference, Value, Value, Value, Value                }, 0, Reference }},
     { ocOr,              {{ Reference                                            }, 1, Value }},
     { ocPearson,         {{ ForceArray, ForceArray                               }, 0, Value }},
     { ocPercentile,      {{ Reference, Value                                     }, 0, Value }},
-- 
cgit