summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTakeshi Abe <tabe@fixedpoint.jp>2011-06-12 12:04:30 +0900
committerKohei Yoshida <kyoshida@novell.com>2011-06-14 10:02:22 -0400
commit4fc6f57f47a3e43a90eeafa8f8057ead3fda29dc (patch)
tree0568cff32cf2b2c77a84fd9c9c7baad95c5fda8f
parent2d33162c409ed520b0befc063db3102c4f552f11 (diff)
fdo#37776
VLOOKUP/HLOOKUP now allow a single reference as the second parameter. Signed-off-by: Kohei Yoshida <kyoshida@novell.com>
-rw-r--r--sc/source/core/tool/interpr1.cxx6
1 files changed, 6 insertions, 0 deletions
diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index 90eeeb613..812134407 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -5805,6 +5805,12 @@ void ScInterpreter::CalculateLookup(sal_Bool HLookup)
return;
}
}
+ else if (eType == svSingleRef)
+ {
+ PopSingleRef(nCol1, nRow1, nTab1);
+ nCol2 = nCol1;
+ nRow2 = nRow1;
+ }
else if (eType == svMatrix || eType == svExternalDoubleRef || eType == svExternalSingleRef)
{
pMat = GetMatrix();