Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 226 insertions, 0 deletions

diff --git a/sc/qa/unit/range.cxx b/sc/qa/unit/range.cxx
new file mode 100644
index 000000000..843ecddcb
--- /dev/null
+++ b/sc/qa/unit/range.cxx
@@ -0,0 +1,226 @@
+/* -*- 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 <test/bootstrapfixture.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 ScAddressTest : public test::BootstrapFixture
+{
+public:
+
+    virtual void setUp() override;
+    virtual void tearDown() override;
+
+    CPPUNIT_TEST_SUITE(ScAddressTest);
+    CPPUNIT_TEST(testAddressParsing);
+    CPPUNIT_TEST(testTdf147451);
+    CPPUNIT_TEST_SUITE_END();
+
+    void testAddressParsing();
+    void testTdf147451();
+
+private:
+    ScDocShellRef m_xDocShRef;
+};
+
+void ScAddressTest::testAddressParsing()
+{
+    ScAddress aAddr;
+    ScDocument& rDoc = m_xDocShRef->GetDocument();
+    ScRefFlags nRes = aAddr.Parse("1", rDoc, formula::FormulaGrammar::CONV_OOO);
+    CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID));
+}
+
+void ScAddressTest::testTdf147451()
+{
+    ScAddress aAddr;
+    ScDocument& rDoc = m_xDocShRef->GetDocument();
+    // "Sheet1" is technically a valid address like "XF1", but it should overflow.
+    ScRefFlags nRes = aAddr.Parse("Sheet1", rDoc, formula::FormulaGrammar::CONV_OOO);
+    CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID));
+}
+
+void ScAddressTest::setUp()
+{
+    BootstrapFixture::setUp();
+
+    ScDLL::Init();
+    m_xDocShRef = new ScDocShell(
+        SfxModelFlags::EMBEDDED_OBJECT |
+        SfxModelFlags::DISABLE_EMBEDDED_SCRIPTS |
+        SfxModelFlags::DISABLE_DOCUMENT_RECOVERY);
+}
+
+void ScAddressTest::tearDown()
+{
+    m_xDocShRef->DoClose();
+    m_xDocShRef.clear();
+    BootstrapFixture::tearDown();
+}
+
+class ScRangeTest : public test::BootstrapFixture
+{
+public:
+    virtual void setUp() override;
+    virtual void tearDown() override;
+
+    CPPUNIT_TEST_SUITE(ScRangeTest);
+    CPPUNIT_TEST(testOverlap);
+    CPPUNIT_TEST(testRangeParsing);
+    CPPUNIT_TEST_SUITE_END();
+
+    void testOverlap();
+    void testRangeParsing();
+
+private:
+    ScDocShellRef m_xDocShRef;
+};
+
+void 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 ));
+}
+
+void ScRangeTest::testRangeParsing()
+{
+    ScRange aRange;
+    ScDocument& rDoc = m_xDocShRef->GetDocument();
+    ScRefFlags nRes = aRange.Parse(":1", rDoc, formula::FormulaGrammar::CONV_OOO);
+    CPPUNIT_ASSERT_MESSAGE("Should fail to parse.", !(nRes & ScRefFlags::VALID));
+}
+
+void ScRangeTest::setUp()
+{
+    BootstrapFixture::setUp();
+
+    ScDLL::Init();
+    m_xDocShRef = new ScDocShell(
+        SfxModelFlags::EMBEDDED_OBJECT |
+        SfxModelFlags::DISABLE_EMBEDDED_SCRIPTS |
+        SfxModelFlags::DISABLE_DOCUMENT_RECOVERY);
+}
+
+void ScRangeTest::tearDown()
+{
+    m_xDocShRef->DoClose();
+    m_xDocShRef.clear();
+    BootstrapFixture::tearDown();
+}
+
+class ScRangeUpdaterTest : public CppUnit::TestFixture
+{
+public:
+
+    virtual void setUp() override
+    {
+        utl::ConfigManager::EnableFuzzing();
+        ScDLL::Init();
+        ScGlobal::Init();
+    }
+    void testUpdateInsertTabBeforePos();
+    void testUpdateInsertTabAtPos();
+    void testUpdateInsertTabAfterPos();
+    void testUpdateDeleteTabBeforePos();
+    void testUpdateDeleteTabAtPos();
+    void testUpdateDeleteTabAfterPos();
+
+    CPPUNIT_TEST_SUITE(ScRangeUpdaterTest);
+    CPPUNIT_TEST(testUpdateInsertTabBeforePos);
+    CPPUNIT_TEST(testUpdateInsertTabAtPos);
+    CPPUNIT_TEST(testUpdateInsertTabAfterPos);
+    CPPUNIT_TEST(testUpdateDeleteTabBeforePos);
+    CPPUNIT_TEST(testUpdateDeleteTabAtPos);
+    CPPUNIT_TEST(testUpdateDeleteTabAfterPos);
+    CPPUNIT_TEST_SUITE_END();
+};
+
+void 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);
+}
+
+void 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);
+}
+
+void 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);
+}
+
+void 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);
+}
+
+void ScRangeUpdaterTest::testUpdateDeleteTabAtPos()
+{
+    ScDocument aDoc;
+    ScAddress aAddr(1, 1, 1);
+    sc::RefUpdateDeleteTabContext aContext(aDoc, 1, 1);
+    ScRangeUpdater::UpdateDeleteTab(aAddr, aContext);
+    CPPUNIT_ASSERT_EQUAL(ScAddress(1, 1, 0), aAddr);
+}
+
+void 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_TEST_SUITE_REGISTRATION(ScAddressTest);
+CPPUNIT_TEST_SUITE_REGISTRATION(ScRangeTest);
+CPPUNIT_TEST_SUITE_REGISTRATION(ScRangeUpdaterTest);
+
+CPPUNIT_PLUGIN_IMPLEMENT();
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */