diff options
author | Kohei Yoshida <kohei.yoshida@suse.com> | 2012-01-04 12:59:32 -0500 |
---|---|---|
committer | Kohei Yoshida <kohei.yoshida@suse.com> | 2012-01-04 13:02:16 -0500 |
commit | bc4699ba6e05af115ffed17e2938e3176f3f930a (patch) | |
tree | ebf5eaef05465ed443ba4c29863a05ea60dbced2 /sc/qa | |
parent | fpicker: fix makefile typo (diff) | |
download | core-bc4699ba6e05af115ffed17e2938e3176f3f930a.tar.gz core-bc4699ba6e05af115ffed17e2938e3176f3f930a.zip |
New unit test to test jumping to precedent / dependent cells.
The test doesn't do the actual jumping, but it only tests the validity
of the destination range(s).
Diffstat (limited to 'sc/qa')
-rw-r--r-- | sc/qa/unit/ucalc.cxx | 92 |
1 files changed, 92 insertions, 0 deletions
diff --git a/sc/qa/unit/ucalc.cxx b/sc/qa/unit/ucalc.cxx index f98195da9378..5471c47bfb16 100644 --- a/sc/qa/unit/ucalc.cxx +++ b/sc/qa/unit/ucalc.cxx @@ -47,6 +47,7 @@ #include "postit.hxx" #include "attrib.hxx" #include "dbdata.hxx" +#include "reftokenhelper.hxx" #include "docsh.hxx" #include "docfunc.hxx" @@ -160,6 +161,12 @@ public: */ void testToggleRefFlag(); + /** + * Test to make sure correct precedent / dependent cells are obtained when + * preparing to jump to them. + */ + void testJumpToPrecedentsDependents(); + CPPUNIT_TEST_SUITE(Test); CPPUNIT_TEST(testCollator); CPPUNIT_TEST(testInput); @@ -187,6 +194,7 @@ public: CPPUNIT_TEST(testCopyPaste); CPPUNIT_TEST(testMergedCells); CPPUNIT_TEST(testUpdateReference); + CPPUNIT_TEST(testJumpToPrecedentsDependents); CPPUNIT_TEST_SUITE_END(); private: @@ -2875,6 +2883,90 @@ void Test::testUpdateReference() m_pDoc->DeleteTab(0); } +namespace { + +bool hasRange(const std::vector<ScTokenRef>& rRefTokens, const ScRange& rRange) +{ + std::vector<ScTokenRef>::const_iterator it = rRefTokens.begin(), itEnd = rRefTokens.end(); + for (; it != itEnd; ++it) + { + const ScTokenRef& p = *it; + if (!ScRefTokenHelper::isRef(p) || ScRefTokenHelper::isExternalRef(p)) + continue; + + switch (p->GetType()) + { + case formula::svSingleRef: + { + ScSingleRefData aData = p->GetSingleRef(); + if (rRange.aStart != rRange.aEnd) + break; + + ScAddress aThis(aData.nCol, aData.nRow, aData.nTab); + if (aThis == rRange.aStart) + return true; + } + break; + case formula::svDoubleRef: + { + ScComplexRefData aData = p->GetDoubleRef(); + ScRange aThis(aData.Ref1.nCol, aData.Ref1.nRow, aData.Ref1.nTab, aData.Ref2.nCol, aData.Ref2.nRow, aData.Ref2.nTab); + if (aThis == rRange) + return true; + } + break; + default: + ; + } + } + return false; +} + +} + +void Test::testJumpToPrecedentsDependents() +{ + // Precedent is another cell that the cell references, while dependent is + // another cell that references it. + m_pDoc->InsertTab(0, rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Test"))); + + m_pDoc->SetString(2, 0, 0, rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("=A1+A2+B3"))); // C1 + m_pDoc->SetString(2, 1, 0, rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("=A1"))); // C2 + m_pDoc->CalcAll(); + + std::vector<ScTokenRef> aRefTokens; + ScDocFunc& rDocFunc = m_xDocShRef->GetDocFunc(); + + { + // C1's precedent should be A1:A2,B3. + ScRangeList aRange(ScRange(2, 0, 0)); + rDocFunc.DetectiveCollectAllPreds(aRange, aRefTokens); + CPPUNIT_ASSERT_MESSAGE("A1:A2 should be a precedent of C1.", + hasRange(aRefTokens, ScRange(0, 0, 0, 0, 1, 0))); + CPPUNIT_ASSERT_MESSAGE("B3 should be a precedent of C1.", + hasRange(aRefTokens, ScRange(1, 2, 0))); + } + + { + // C2's precedent should be A1 only. + ScRangeList aRange(ScRange(2, 1, 0)); + rDocFunc.DetectiveCollectAllPreds(aRange, aRefTokens); + CPPUNIT_ASSERT_MESSAGE("there should only be one reference token.", + aRefTokens.size() == 1); + CPPUNIT_ASSERT_MESSAGE("A1 should be a precedent of C1.", + hasRange(aRefTokens, ScRange(0, 0, 0))); + } + + { + // A1's dependent should be C1:C2. + ScRangeList aRange(ScRange(0, 0, 0)); + rDocFunc.DetectiveCollectAllSuccs(aRange, aRefTokens); + CPPUNIT_ASSERT_MESSAGE("C1:C2 should be the only dependent of A1.", + aRefTokens.size() == 1 && hasRange(aRefTokens, ScRange(2, 0, 0, 2, 1, 0))); + } + + m_pDoc->DeleteTab(0); +} CPPUNIT_TEST_SUITE_REGISTRATION(Test); |