1 files changed, 159 insertions, 0 deletions
diff --git a/sc/qa/unit/ucalc_range.cxx b/sc/qa/unit/ucalc_range.cxx
new file mode 100644
index 0000000000..8a48665035
--- /dev/null
+++ b/sc/qa/unit/ucalc_range.cxx
@@ -0,0 +1,159 @@
+/* -*- 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 <sal/config.h>
+#include "helper/qahelper.hxx"
+#include <unotools/configmgr.hxx>
+#include <document.hxx>
+#include <docsh.hxx>
+#include <global.hxx>
+#include <scdll.hxx>
+
+#include <address.hxx>
+#include <rangeutl.hxx>
+#include <refupdatecontext.hxx>
+
+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: */