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

[Xisco Fauli (via logerrit)]

 sc/qa/unit/data/xlsx/tdf153767.xlsx     |binary
 sc/qa/unit/subsequent_filters_test2.cxx |   13 +++++++++++++
 2 files changed, 13 insertions(+)

New commits:
commit fce77173646392847055745c6342704eb6e500a9
Author:     Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Thu Feb 23 11:02:25 2023 +0100
Commit:     Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Feb 23 13:19:29 2023 +0000

    tdf#153767: sc_subsequent_filters_test2: Add unittest
    
    Change-Id: I66f45e54249f48440c4145ff0e877abbac073a25
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/147507
    Tested-by: Jenkins
    Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>

diff --git a/sc/qa/unit/data/xlsx/tdf153767.xlsx 
b/sc/qa/unit/data/xlsx/tdf153767.xlsx
new file mode 100644
index 000000000000..142772ca8ac4
Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf153767.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters_test2.cxx 
b/sc/qa/unit/subsequent_filters_test2.cxx
index 2b634eebc052..d63298852b6a 100644
--- a/sc/qa/unit/subsequent_filters_test2.cxx
+++ b/sc/qa/unit/subsequent_filters_test2.cxx
@@ -228,6 +228,19 @@ CPPUNIT_TEST_FIXTURE(ScFiltersTest2, testTdf118624)
                                != pDoc->GetString(ScAddress(0, 1, 0)));
 }
 
+CPPUNIT_TEST_FIXTURE(ScFiltersTest2, testTdf153767)
+{
+    createScDoc("xlsx/tdf153767.xlsx");
+
+    ScDocument* pDoc = getScDoc();
+
+    // Without the fix in place, this test would have failed with
+    // - Expected: TRUE
+    // - Actual  : 0
+    CPPUNIT_ASSERT_EQUAL(OUString("TRUE"), pDoc->GetString(ScAddress(7, 1, 
0)));
+    CPPUNIT_ASSERT_EQUAL(OUString("FALSE"), pDoc->GetString(ScAddress(7, 2, 
0)));
+}
+
 CPPUNIT_TEST_FIXTURE(ScFiltersTest2, testTdf124454)
 {
     createScDoc("ods/tdf124454.ods");