diff options
| author | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2015-10-15 19:27:58 +0200 |
|---|---|---|
| committer | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2015-10-15 20:10:29 +0200 |
| commit | 7b3e0aa8ad02c12706547616d7a5fd695bf0d75c (patch) | |
| tree | f7ee669849e39fcc293eb2c3b08eb3f399eb2b21 /sc/qa/unit/ucalc_formula.cxx | |
| parent | store external range names in the cache, td#88179 (diff) | |
| download | core-7b3e0aa8ad02c12706547616d7a5fd695bf0d75c.tar.gz core-7b3e0aa8ad02c12706547616d7a5fd695bf0d75c.zip | |
add test for tdf#88179
Change-Id: I8407a05e89129b533f62439d3ffedecd3248ec87
Diffstat (limited to 'sc/qa/unit/ucalc_formula.cxx')
| -rw-r--r-- | sc/qa/unit/ucalc_formula.cxx | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx index c631e1e36018..0badcac64f44 100644 --- a/sc/qa/unit/ucalc_formula.cxx +++ b/sc/qa/unit/ucalc_formula.cxx @@ -5157,6 +5157,37 @@ void Test::testExternalRef() m_pDoc->DeleteTab(0); } +void Test::testExternalRangeName() +{ + ScDocShellRef xExtDocSh = new ScDocShell; + OUString aExtDocName("file:///extdata.fake"); + OUString aExtSh1Name("Data1"); + SfxMedium* pMed = new SfxMedium(aExtDocName, STREAM_STD_READWRITE); + xExtDocSh->DoInitNew(pMed); + CPPUNIT_ASSERT_MESSAGE("external document instance not loaded.", + findLoadedDocShellByName(aExtDocName) != NULL); + + ScDocument& rExtDoc = xExtDocSh->GetDocument(); + rExtDoc.InsertTab(0, aExtSh1Name); + rExtDoc.SetValue(0, 0, 0, 123.456); + + ScRangeName* pRangeName = rExtDoc.GetRangeName(); + ScRangeData* pRangeData = new ScRangeData(&rExtDoc, "ExternalName", + "$Data1.$A$1"); + pRangeName->insert(pRangeData); + + m_pDoc->InsertTab(0, "Test Sheet"); + m_pDoc->SetString(0, 1, 0, OUString("='file:///extdata.fake'#ExternalName")); + + double nVal = m_pDoc->GetValue(0, 1, 0); + ASSERT_DOUBLES_EQUAL(123.456, nVal); + + xExtDocSh->DoClose(); + CPPUNIT_ASSERT_MESSAGE("external document instance should have been unloaded.", + findLoadedDocShellByName(aExtDocName) == NULL); + m_pDoc->DeleteTab(0); +} + void testExtRefFuncT(ScDocument* pDoc, ScDocument& rExtDoc) { Test::clearRange(pDoc, ScRange(0, 0, 0, 1, 9, 0)); |