sc/qa/unit/ucalc_range.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  */
   9
  10 #include <sal/config.h>
  11 #include "helper/qahelper.hxx"
  12 #include <unotools/configmgr.hxx>
  13 #include <document.hxx>
  14 #include <docsh.hxx>
  15 #include <global.hxx>
  16 #include <scdll.hxx>
  17
  18 #include <address.hxx>
  19 #include <rangeutl.hxx>
  20 #include <refupdatecontext.hxx>
  21
  22 class ScRangeTest : public ScUcalcTestBase
  23 {
  24 };
  25
  26 CPPUNIT_TEST_FIXTURE(ScRangeTest, testOverlap)
  27 {
  28     ScRange aRange1( ScAddress( 0, 0, 0 ), ScAddress( 1, 1, 1 ));
  29     CPPUNIT_ASSERT(aRange1.Contains( ScAddress( 0, 0, 0 )));
  30     CPPUNIT_ASSERT(aRange1.Contains( ScAddress( 1, 1, 1 )));
  31     CPPUNIT_ASSERT(!aRange1.Contains( ScAddress( 2, 1, 1 )));
  32     CPPUNIT_ASSERT(!aRange1.Contains( ScAddress( 1, 2, 1 )));
  33     CPPUNIT_ASSERT(!aRange1.Contains( ScAddress( 1, 1, 2 )));
  34
  35     ScRange aRange2( ScAddress( 0, 0, 0 ), ScAddress( 10, 10, 10 ));
  36     ScRange aRange3( ScAddress( 5, 5, 5 ), ScAddress( 15, 15, 15 ));
  37     CPPUNIT_ASSERT(!aRange2.Contains( aRange3 ));
  38     CPPUNIT_ASSERT(!aRange3.Contains( aRange2 ));
  39     CPPUNIT_ASSERT(aRange2.Intersects( aRange3 ));
  40     CPPUNIT_ASSERT(aRange3.Intersects( aRange2 ));
  41     CPPUNIT_ASSERT(!aRange3.Intersects( aRange1 ));
  42     CPPUNIT_ASSERT(!aRange1.Intersects( aRange3 ));
  43 }
  44
  45 CPPUNIT_TEST_FIXTURE(ScRangeTest, testRangeParsing)
  46 {
  47     ScRange aRange;
  48     ScRefFlags nRes = aRange.Parse(":1", *m_pDoc, formula::FormulaGrammar::CONV_OOO);
  49     CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID));
  50 }
  51
  52 CPPUNIT_TEST_FIXTURE(ScRangeTest, testAddressParsing)
  53 {
  54     ScAddress aAddr;
  55     ScRefFlags nRes = aAddr.Parse("1", *m_pDoc, formula::FormulaGrammar::CONV_OOO);
  56     CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID));
  57 }
  58
  59 CPPUNIT_TEST_FIXTURE(ScRangeTest, testTdf147451)
  60 {
  61     ScAddress aAddr;
  62     // "Sheet1" is technically a valid address like "XF1", but it should overflow.
  63     ScRefFlags nRes = aAddr.Parse("Sheet1", *m_pDoc, formula::FormulaGrammar::CONV_OOO);
  64     CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID));
  65 }
  66
  67 class ScRangeUpdaterTest : public CppUnit::TestFixture
  68 {
  69 public:
  70
  71     virtual void setUp() override
  72     {
  73         utl::ConfigManager::EnableFuzzing();
  74         ScDLL::Init();
  75         ScGlobal::Init();
  76     }
  77 };
  78
  79 CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateInsertTabBeforePos)
  80 {
  81     ScDocument aDoc;
  82     ScAddress aAddr(1, 1, 1);
  83     sc::RefUpdateInsertTabContext aContext(aDoc, 0, 1);
  84     ScRangeUpdater::UpdateInsertTab(aAddr, aContext);
  85     CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 2), aAddr);
  86 }
  87
  88 CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateInsertTabAtPos)
  89 {
  90     ScDocument aDoc;
  91     ScAddress aAddr(1, 1, 1);
  92     sc::RefUpdateInsertTabContext aContext(aDoc, 1, 1);
  93     ScRangeUpdater::UpdateInsertTab(aAddr, aContext);
  94     CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 2), aAddr);
  95 }
  96
  97 CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateInsertTabAfterPos)
  98 {
  99     ScDocument aDoc;
 100     ScAddress aAddr(1, 1, 1);
 101     sc::RefUpdateInsertTabContext aContext(aDoc, 2, 1);
 102     ScRangeUpdater::UpdateInsertTab(aAddr, aContext);
 103     CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 1), aAddr);
 104 }
 105
 106 CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateDeleteTabBeforePos)
 107 {
 108     ScDocument aDoc;
 109     ScAddress aAddr(1, 1, 1);
 110     sc::RefUpdateDeleteTabContext aContext(aDoc, 0, 1);
 111     ScRangeUpdater::UpdateDeleteTab(aAddr, aContext);
 112     CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr);
 113 }
 114
 115 CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateDeleteTabAtPos)
 116 {
 117     ScDocument aDoc;
 118
 119     // Position within deleted range is moved to the front.
 120     {
 121         ScAddress aAddr(1, 1, 1);
 122         sc::RefUpdateDeleteTabContext aContext(aDoc, 1, 1);
 123         ScRangeUpdater::UpdateDeleteTab(aAddr, aContext);
 124         CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr);
 125     }
 126     {
 127         ScAddress aAddr(1, 1, 2);
 128         sc::RefUpdateDeleteTabContext aContext(aDoc, 1, 2);
 129         ScRangeUpdater::UpdateDeleteTab(aAddr, aContext);
 130         CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr);
 131     }
 132
 133     // Would-be negative results are clamped to 0.
 134     {
 135         ScAddress aAddr(1, 1, 0);
 136         sc::RefUpdateDeleteTabContext aContext(aDoc, 0, 1);
 137         ScRangeUpdater::UpdateDeleteTab(aAddr, aContext);
 138         CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr);
 139     }
 140     {
 141         ScAddress aAddr(1, 1, 1);
 142         sc::RefUpdateDeleteTabContext aContext(aDoc, 0, 2);
 143         ScRangeUpdater::UpdateDeleteTab(aAddr, aContext);
 144         CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr);
 145     }
 146 }
 147
 148 CPPUNIT_TEST_FIXTURE(ScRangeUpdaterTest, testUpdateDeleteTabAfterPos)
 149 {
 150     ScDocument aDoc;
 151     ScAddress aAddr(1, 1, 1);
 152     sc::RefUpdateDeleteTabContext aContext(aDoc, 2, 1);
 153     ScRangeUpdater::UpdateDeleteTab(aAddr, aContext);
 154     CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 1), aAddr);
 155 }
 156
 157 CPPUNIT_PLUGIN_IMPLEMENT();
 158
 159 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */