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

[Xisco Fauli (via logerrit)]

 sc/qa/unit/data/xlsx/tdf147955.xlsx     |binary
 sc/qa/unit/subsequent_filters_test4.cxx |   14 ++++++++++++++
 2 files changed, 14 insertions(+)

New commits:
commit 0e4429983eb73c8e0ce27feb3c5fa35bead64b88
Author:     Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Thu Aug 3 11:03:56 2023 +0200
Commit:     Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Aug 3 12:54:14 2023 +0200

    tdf#147955: sc_subsequent_filters_test4: Add unittest
    
    Change-Id: I8247d55a5d31512deeb778ad3cbe4f2569d50440
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155281
    Tested-by: Jenkins
    Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>

diff --git a/sc/qa/unit/data/xlsx/tdf147955.xlsx 
b/sc/qa/unit/data/xlsx/tdf147955.xlsx
new file mode 100644
index 000000000000..a32a724a19ba
Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf147955.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters_test4.cxx 
b/sc/qa/unit/subsequent_filters_test4.cxx
index 27d9d6f29150..ae5c7ff7e4da 100644
--- a/sc/qa/unit/subsequent_filters_test4.cxx
+++ b/sc/qa/unit/subsequent_filters_test4.cxx
@@ -1369,6 +1369,20 @@ CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testTdf151046)
     CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(0, 2, 0));
 }
 
+CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testTdf147955)
+{
+    createScDoc("xlsx/tdf147955.xlsx");
+
+    ScDocument* pDoc = getScDoc();
+
+    // Without the fix in place, this test would have failed with
+    // - Expected: 892.75
+    // - Actual  : 0
+    CPPUNIT_ASSERT_EQUAL(892.75, pDoc->GetValue(1, 6, 0));
+    CPPUNIT_ASSERT_EQUAL(130.25, pDoc->GetValue(1, 10, 0));
+    CPPUNIT_ASSERT_EQUAL(10.98, pDoc->GetValue(1, 15, 0));
+}
+
 CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testImportCrashes)
 {
     testImportCrash("ods/tdf149752.ods");