diff options
| author | Eike Rathke <erack@redhat.com> | 2016-04-29 21:55:51 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2016-04-30 00:30:34 +0200 |
| commit | 8162cf2a005be68262525c2a11947fa0e10d15ed (patch) | |
| tree | 3409876d661c87f04765d45d9f998bbe0250a098 /sc/qa | |
| parent | 043df58d1acf247f6ea85985b0531de41906bd4f (diff) | |
unit test for copying names not used in formulas during sheet-copy
... but global or local name references copied sheet, or all local names.
Change-Id: I84b22f444b72b032a339d5826989ad934cc10981
Diffstat (limited to 'sc/qa')
| -rw-r--r-- | sc/qa/unit/ucalc_formula.cxx | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx index a58ec4d34d99..d47ea6aa54e2 100644 --- a/sc/qa/unit/ucalc_formula.cxx +++ b/sc/qa/unit/ucalc_formula.cxx @@ -3045,10 +3045,18 @@ void Test::testFormulaRefUpdateNameCopySheet() CPPUNIT_ASSERT(bInserted); bInserted = m_pDoc->InsertNewRangeName( "global_local", aPos, "local*1000"); CPPUNIT_ASSERT(bInserted); + bInserted = m_pDoc->InsertNewRangeName( "global_unused", aPos, "$Test2.$A$1"); + CPPUNIT_ASSERT(bInserted); + bInserted = m_pDoc->InsertNewRangeName( "global_unused_noref", aPos, "42"); + CPPUNIT_ASSERT(bInserted); bInserted = m_pDoc->InsertNewRangeName( aPos.Tab(), "local_global", aPos, "global*10000"); CPPUNIT_ASSERT(bInserted); bInserted = m_pDoc->InsertNewRangeName( aPos.Tab(), "local_local", aPos, "local*100000"); CPPUNIT_ASSERT(bInserted); + bInserted = m_pDoc->InsertNewRangeName( aPos.Tab(), "local_unused", aPos, "$Test2.$A$2"); + CPPUNIT_ASSERT(bInserted); + bInserted = m_pDoc->InsertNewRangeName( aPos.Tab(), "local_unused_noref", aPos, "23"); + CPPUNIT_ASSERT(bInserted); m_pDoc->SetString(aPos, "=SHEET()"); aPos.IncRow(); @@ -3093,10 +3101,18 @@ void Test::testFormulaRefUpdateNameCopySheetCheckTab( SCTAB nTab, bool bCheckNam CPPUNIT_ASSERT_MESSAGE("Sheet-local name GLOBAL_GLOBAL should exist", pName); pName = m_pDoc->GetRangeName(nTab)->findByUpperName("GLOBAL_LOCAL"); CPPUNIT_ASSERT_MESSAGE("Sheet-local name GLOBAL_LOCAL should exist", pName); + pName = m_pDoc->GetRangeName(nTab)->findByUpperName("GLOBAL_UNUSED"); + CPPUNIT_ASSERT_MESSAGE("Sheet-local name GLOBAL_UNUSED should exist", pName); + pName = m_pDoc->GetRangeName(nTab)->findByUpperName("GLOBAL_UNUSED_NOREF"); + CPPUNIT_ASSERT_MESSAGE("Sheet-local name GLOBAL_UNUSED_NOREF should not exist", !pName); pName = m_pDoc->GetRangeName(nTab)->findByUpperName("LOCAL_GLOBAL"); CPPUNIT_ASSERT_MESSAGE("Sheet-local name LOCAL_GLOBAL should exist", pName); pName = m_pDoc->GetRangeName(nTab)->findByUpperName("LOCAL_LOCAL"); CPPUNIT_ASSERT_MESSAGE("Sheet-local name LOCAL_LOCAL should exist", pName); + pName = m_pDoc->GetRangeName(nTab)->findByUpperName("LOCAL_UNUSED"); + CPPUNIT_ASSERT_MESSAGE("Sheet-local name LOCAL_UNUSED should exist", pName); + pName = m_pDoc->GetRangeName(nTab)->findByUpperName("LOCAL_UNUSED_NOREF"); + CPPUNIT_ASSERT_MESSAGE("Sheet-local name LOCAL_UNUSED_NOREF should exist", pName); } ScAddress aPos(0,0,0); |