commit 1d1e89988d45564d17acc286ecfb8d59cddf94ce
author Xisco Fauli <xiscofauli@libreoffice.org> Tue Mar 22 12:42:41 2022 +0100
committer Xisco Fauli <xiscofauli@libreoffice.org> Tue Mar 22 15:58:48 2022 +0100
tree 746e95c872dd4124b08335446bf9629e1e1841fb
parent 931ce5db280ab7c4ccd005cc43f08a693dc34e9f

tdf#118983: sc_uicalc: Add unittest

Change-Id: I7d0e473136b4d57fbebf6c6477044a61e2fa39f3
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/131933
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>

sc/qa/unit/uicalc/data/tdf118983.ods

diff --git a/sc/qa/unit/uicalc/data/tdf118983.ods b/sc/qa/unit/uicalc/data/tdf118983.ods
new file mode 100644
index 0000000..3c10a7f
--- /dev/null
+++ b/sc/qa/unit/uicalc/data/tdf118983.ods
Binary files differ

sc/qa/unit/uicalc/uicalc.cxx

diff --git a/sc/qa/unit/uicalc/uicalc.cxx b/sc/qa/unit/uicalc/uicalc.cxx
index aff4574..a3a782a 100644
--- a/sc/qa/unit/uicalc/uicalc.cxx
+++ b/sc/qa/unit/uicalc/uicalc.cxx
@@ -2467,6 +2467,35 @@ CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf126540_GridToggleModifiesTheDocument)
    CPPUNIT_ASSERT(pDocSh->IsModified());
}

CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf118983)
{
    ScModelObj* pModelObj = createDoc("tdf118983.ods");
    ScDocument* pDoc = pModelObj->GetDocument();
    CPPUNIT_ASSERT(pDoc);

    css::uno::Reference<css::sheet::XGlobalSheetSettings> xGlobalSheetSettings
        = css::sheet::GlobalSheetSettings::create(::comphelper::getProcessComponentContext());
    bool bOldValue = xGlobalSheetSettings->getExpandReferences();

    xGlobalSheetSettings->setExpandReferences(true);

    const ScRangeData* pRD = pDoc->GetRangeName()->findByUpperName("TEST");
    CPPUNIT_ASSERT(pRD);
    CPPUNIT_ASSERT_EQUAL(OUString("$Test.$A$3:$D$7"), pRD->GetSymbol());

    //Select columns E to G
    goToCell("E:G");

    dispatchCommand(mxComponent, ".uno:InsertColumnsBefore", {});

    // Without the fix in place, this test would have failed with
    // - Expected: $Test.$A$3:$D$7
    // - Actual  : $Test.$A$3:$G$7
    CPPUNIT_ASSERT_EQUAL(OUString("$Test.$A$3:$D$7"), pRD->GetSymbol());

    xGlobalSheetSettings->setExpandReferences(bOldValue);
}

CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf144022)
{
    ScModelObj* pModelObj = createDoc("tdf144022.ods");