From c8fb4f13309ffecbaa72e0108315bb917ea33064 Mon Sep 17 00:00:00 2001
From: Kohei Yoshida <kohei.yoshida@gmail.com>
Date: Sat, 27 Jul 2013 16:33:00 -0400
Subject: fdo#61201: Don't forget to calculate row offset for external single
 ref.

Change-Id: Ie3dbf2eeba98a60aa2426b1db35ac885102d3821
(cherry picked from commit 8b96cfd6caedbad7b3b79e57421a834f18c5c511)
Reviewed-on: https://gerrit.libreoffice.org/5143
Reviewed-by: Fridrich Strba <fridrich@documentfoundation.org>
Tested-by: Fridrich Strba <fridrich@documentfoundation.org>
---
 sc/source/core/tool/interpr1.cxx | 1 +
 1 file changed, 1 insertion(+)

diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index 5ee90faf3c24..c4d83899533f 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -7958,6 +7958,7 @@ void ScInterpreter::ScOffset()
                 nCol1 = (SCCOL)((long)nCol1+nColPlus);
                 nRow1 = (SCROW)((long)nRow1+nRowPlus);
                 nCol2 = (SCCOL)((long)nCol1+nColNew-1);
+                nRow2 = (SCROW)((long)nRow1+nRowNew-1);
                 nTab2 = nTab1;
                 if (!ValidCol(nCol1) || !ValidRow(nRow1) ||
                     !ValidCol(nCol2) || !ValidRow(nRow2))
-- 
cgit v1.2.3