summaryrefslogtreecommitdiff
path: root/sc/qa
diff options
context:
space:
mode:
authorKohei Yoshida <kohei.yoshida@gmail.com>2013-07-30 00:11:06 -0400
committerKohei Yoshida <kohei.yoshida@gmail.com>2013-07-30 23:50:01 -0400
commite663dfee253fcd02d6d76c3d8934299a495a7f88 (patch)
treeba60419bc768fc613184304c2b9def8100d2d82d /sc/qa
parent1d860f9a268c02581407db539117b2d538e3d693 (diff)
Handle named range update on sheet insertion.
Change-Id: I05b43bad84333ac8aeee7928898bdd90eed53c38
Diffstat (limited to 'sc/qa')
-rw-r--r--sc/qa/unit/ucalc_formula.cxx10
1 files changed, 10 insertions, 0 deletions
diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx
index d082c19118be..1dba4538b687 100644
--- a/sc/qa/unit/ucalc_formula.cxx
+++ b/sc/qa/unit/ucalc_formula.cxx
@@ -1049,6 +1049,16 @@ void Test::testFormulaRefUpdateNamedExpression()
m_pDoc->SetValue(ScAddress(3,9,0), 20);
CPPUNIT_ASSERT_EQUAL(43.0, m_pDoc->GetValue(ScAddress(2,7,0)));
+ // Insert a new sheet before the current.
+ m_pDoc->InsertTab(0, "New");
+ m_pDoc->CalcAll();
+ OUString aName;
+ m_pDoc->GetName(1, aName);
+ CPPUNIT_ASSERT_EQUAL(OUString("Formula"), aName);
+ CPPUNIT_ASSERT_EQUAL(43.0, m_pDoc->GetValue(ScAddress(2,7,1)));
+
+ m_pDoc->DeleteTab(0);
+
m_pDoc->DeleteTab(0);
}