/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. */ #include #include "helper/qahelper.hxx" #include #include #include #include #include #include #include #include class ScRangeTest : public ScUcalcTestBase { }; CPPUNIT_TEST_FIXTURE(ScRangeTest, testOverlap) { ScRange aRange1( ScAddress( 0, 0, 0 ), ScAddress( 1, 1, 1 )); CPPUNIT_ASSERT(aRange1.Contains( ScAddress( 0, 0, 0 ))); CPPUNIT_ASSERT(aRange1.Contains( ScAddress( 1, 1, 1 ))); CPPUNIT_ASSERT(!aRange1.Contains( ScAddress( 2, 1, 1 ))); CPPUNIT_ASSERT(!aRange1.Contains( ScAddress( 1, 2, 1 ))); CPPUNIT_ASSERT(!aRange1.Contains( ScAddress( 1, 1, 2 ))); ScRange aRange2( ScAddress( 0, 0, 0 ), ScAddress( 10, 10, 10 )); ScRange aRange3( ScAddress( 5, 5, 5 ), ScAddress( 15, 15, 15 )); CPPUNIT_ASSERT(!aRange2.Contains( aRange3 )); CPPUNIT_ASSERT(!aRange3.Contains( aRange2 )); CPPUNIT_ASSERT(aRange2.Intersects( aRange3 )); CPPUNIT_ASSERT(aRange3.Intersects( aRange2 )); CPPUNIT_ASSERT(!aRange3.Intersects( aRange1 )); CPPUNIT_ASSERT(!aRange1.Intersects( aRange3 )); } CPPUNIT_TEST_FIXTURE(ScRangeTest, testRangeParsing) { ScRange aRange; ScRefFlags nRes = aRange.Parse(":1", *m_pDoc, formula::FormulaGrammar::CONV_OOO); CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID)); } CPPUNIT_TEST_FIXTURE(ScRangeTest, testAddressParsing) { ScAddress aAddr; ScRefFlags nRes = aAddr.Parse("1", *m_pDoc, formula::FormulaGrammar::CONV_OOO); CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID)); } CPPUNIT_TEST_FIXTURE(ScRangeTest, testTdf147451) { ScAddress aAddr; // "Sheet1" is technically a valid address like "XF1", but it should overflow. ScRefFlags nRes = aAddr.Parse("Sheet1", *m_pDoc, formula::FormulaGrammar::CONV_OOO); CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID)); } class ScRangeUpdaterTest : public CppUnit::TestFixture { public: virtual void setUp() override { utl::ConfigManager::EnableFuzzing(); ScDLL::Init(); ScGlobal::Init(); } }; CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateInsertTabBeforePos) { ScDocument aDoc; ScAddress aAddr(1, 1, 1); sc::RefUpdateInsertTabContext aContext(aDoc, 0, 1); ScRangeUpdater::UpdateInsertTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 2), aAddr); } CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateInsertTabAtPos) { ScDocument aDoc; ScAddress aAddr(1, 1, 1); sc::RefUpdateInsertTabContext aContext(aDoc, 1, 1); ScRangeUpdater::UpdateInsertTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 2), aAddr); } CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateInsertTabAfterPos) { ScDocument aDoc; ScAddress aAddr(1, 1, 1); sc::RefUpdateInsertTabContext aContext(aDoc, 2, 1); ScRangeUpdater::UpdateInsertTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 1), aAddr); } CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateDeleteTabBeforePos) { ScDocument aDoc; ScAddress aAddr(1, 1, 1); sc::RefUpdateDeleteTabContext aContext(aDoc, 0, 1); ScRangeUpdater::UpdateDeleteTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr); } CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateDeleteTabAtPos) { ScDocument aDoc; // Position within deleted range is moved to the front. { ScAddress aAddr(1, 1, 1); sc::RefUpdateDeleteTabContext aContext(aDoc, 1, 1); ScRangeUpdater::UpdateDeleteTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr); } { ScAddress aAddr(1, 1, 2); sc::RefUpdateDeleteTabContext aContext(aDoc, 1, 2); ScRangeUpdater::UpdateDeleteTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr); } // Would-be negative results are clamped to 0. { ScAddress aAddr(1, 1, 0); sc::RefUpdateDeleteTabContext aContext(aDoc, 0, 1); ScRangeUpdater::UpdateDeleteTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr); } { ScAddress aAddr(1, 1, 1); sc::RefUpdateDeleteTabContext aContext(aDoc, 0, 2); ScRangeUpdater::UpdateDeleteTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr); } } CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateDeleteTabAfterPos) { ScDocument aDoc; ScAddress aAddr(1, 1, 1); sc::RefUpdateDeleteTabContext aContext(aDoc, 2, 1); ScRangeUpdater::UpdateDeleteTab(aAddr, aContext); CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 1), aAddr); } CPPUNIT_PLUGIN_IMPLEMENT(); /* vim:set shiftwidth=4 softtabstop=4 expandtab: */