[Libreoffice-commits] core.git: sc/qa

[Xisco Fauli (via logerrit)]

 sc/qa/unit/data/xlsx/tdf115022.xlsx    |binary
 sc/qa/unit/subsequent_filters-test.cxx |   21 +++++++++++++++++++++
 2 files changed, 21 insertions(+)

New commits:
commit 0b6a70c3d945a9bc34f8ac4970a1b80fbbbcc08a
Author:     Xisco Fauli <xiscofauli at libreoffice.org>
AuthorDate: Fri May 7 12:00:42 2021 +0200
Commit:     Xisco Fauli <xiscofauli at libreoffice.org>
CommitDate: Fri May 7 16:46:02 2021 +0200

    tdf#115022: sc_subsequent_filters: Add unittest
    
    Change-Id: I29c633f991231af6b71a7c6e1565c9fdd1604a25
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/115233
    Tested-by: Jenkins
    Reviewed-by: Xisco Fauli <xiscofauli at libreoffice.org>

diff --git a/sc/qa/unit/data/xlsx/tdf115022.xlsx b/sc/qa/unit/data/xlsx/tdf115022.xlsx
new file mode 100644
index 000000000000..34d893b9d85e
Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf115022.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index a854f49f0774..0d8e08fd1813 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -303,6 +303,7 @@ public:
     void testTdf72470();
     void testTdf35636();
     void testTdf98481();
+    void testTdf115022();
     void testVBAMacroFunctionODS();
     void testAutoheight2Rows();
     void testXLSDefColWidth();
@@ -502,6 +503,7 @@ public:
     CPPUNIT_TEST(testTdf72470);
     CPPUNIT_TEST(testTdf35636);
     CPPUNIT_TEST(testTdf98481);
+    CPPUNIT_TEST(testTdf115022);
     CPPUNIT_TEST(testVBAMacroFunctionODS);
     CPPUNIT_TEST(testAutoheight2Rows);
     CPPUNIT_TEST(testXLSDefColWidth);
@@ -5380,6 +5382,25 @@ void ScFiltersTest::testTdf98481()
     xDocSh->DoClose();
 }
 
+void ScFiltersTest::testTdf115022()
+{
+    ScDocShellRef xDocSh = loadDoc(u"tdf115022.", FORMAT_XLSX);
+    CPPUNIT_ASSERT_MESSAGE("Failed to open doc", xDocSh.is());
+
+    ScDocument& rDoc = xDocSh->GetDocument();
+
+    CPPUNIT_ASSERT_EQUAL(6.0, rDoc.GetValue(ScAddress(1,8,0)));
+
+    xDocSh->DoHardRecalc();
+
+    // Without the fix in place, this test would have failed with
+    // - Expected: 6
+    // - Actual  : 21
+    CPPUNIT_ASSERT_EQUAL(6.0, rDoc.GetValue(ScAddress(1,8,0)));
+
+    xDocSh->DoClose();
+}
+
 void ScFiltersTest::testVBAMacroFunctionODS()
 {
     ScDocShellRef xDocSh = loadDoc(u"vba_macro_functions.", FORMAT_ODS);