add test for fdo#84556

Change-Id: I9b3af4f66513fff437facd17c0758ee92ac5744d

3 files changed, 48 insertions, 13 deletions

diff --git a/sc/qa/unit/data/xls/shared-formula/relative-refs.xls b/sc/qa/unit/data/xls/shared-formula/relative-refs1.xls
index 88678b46e5bf..88678b46e5bf 100644
--- a/sc/qa/unit/data/xls/shared-formula/relative-refs.xls
+++ b/sc/qa/unit/data/xls/shared-formula/relative-refs1.xls
diff --git a/sc/qa/unit/data/xls/shared-formula/relative-refs2.xls b/sc/qa/unit/data/xls/shared-formula/relative-refs2.xls
new file mode 100644
index 000000000000..56ff822fc59a
--- /dev/null
+++ b/sc/qa/unit/data/xls/shared-formula/relative-refs2.xls
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 529486dce661..703f90593ba9 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -2583,23 +2583,58 @@ void ScFiltersTest::testSharedFormulaXLSB()
 
 void ScFiltersTest::testSharedFormulaXLS()
 {
-    ScDocShellRef xDocSh = loadDoc("shared-formula/relative-refs.", XLS);
-    CPPUNIT_ASSERT(xDocSh.Is());
-    ScDocument& rDoc = xDocSh->GetDocument();
-    rDoc.CalcAll();
+    {
+        // fdo#80091
+        ScDocShellRef xDocSh = loadDoc("shared-formula/relative-refs1.", XLS);
+        CPPUNIT_ASSERT(xDocSh.Is());
+        ScDocument& rDoc = xDocSh->GetDocument();
+        rDoc.CalcAll();
 
-    // A1:A30 should be all formulas, and they should belong to the same group.
-    const ScFormulaCell* pFC = rDoc.GetFormulaCell(ScAddress(0,1,0));
-    CPPUNIT_ASSERT(pFC);
-    CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(1), pFC->GetSharedTopRow());
-    CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(29), pFC->GetSharedLength());
+        // A1:A30 should be all formulas, and they should belong to the same group.
+        const ScFormulaCell* pFC = rDoc.GetFormulaCell(ScAddress(0,1,0));
+        CPPUNIT_ASSERT(pFC);
+        CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(1), pFC->GetSharedTopRow());
+        CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(29), pFC->GetSharedLength());
 
-    for(SCROW nRow = 0; nRow < 30; ++nRow)
-    {
-        ASSERT_DOUBLES_EQUAL(double(nRow+1), rDoc.GetValue(0, nRow, 0));
+        for(SCROW nRow = 0; nRow < 30; ++nRow)
+        {
+            ASSERT_DOUBLES_EQUAL(double(nRow+1), rDoc.GetValue(0, nRow, 0));
+        }
+
+        xDocSh->DoClose();
     }
 
-    xDocSh->DoClose();
+    {
+        // fdo#84556 and some related tests
+        ScDocShellRef xDocSh = loadDoc("shared-formula/relative-refs2.", XLS);
+        CPPUNIT_ASSERT(xDocSh.Is());
+        ScDocument& rDoc = xDocSh->GetDocument();
+        rDoc.CalcAll();
+
+        {
+            const ScFormulaCell* pFC = rDoc.GetFormulaCell(ScAddress(2,1,0));
+            CPPUNIT_ASSERT(pFC);
+            CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(1), pFC->GetSharedTopRow());
+            CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(10), pFC->GetSharedLength());
+
+            OUString aFormula;
+            rDoc.GetFormula(2, 1, 0, aFormula);
+            CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B9:D9)"), aFormula);
+        }
+
+        {
+            const ScFormulaCell* pFC = rDoc.GetFormulaCell(ScAddress(4,8,0));
+            CPPUNIT_ASSERT(pFC);
+            CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(8), pFC->GetSharedTopRow());
+            CPPUNIT_ASSERT_EQUAL(static_cast<SCROW>(10), pFC->GetSharedLength());
+
+            OUString aFormula;
+            rDoc.GetFormula(4, 8, 0, aFormula);
+            CPPUNIT_ASSERT_EQUAL(OUString("=SUM(G9:EY9)"), aFormula);
+        }
+
+        xDocSh->DoClose();
+    }
 }
 
 void ScFiltersTest::testExternalRefCacheXLSX()