commit d951f9cafbc4674e4bf6fc174f5fd28e451c59ae
author Xisco Fauli <xiscofauli@libreoffice.org> Mon Mar 06 11:14:14 2023 +0100
committer Xisco Fauli <xiscofauli@libreoffice.org> Mon Mar 06 15:10:02 2023 +0000
tree 2aeba58c0b5b0228676e474bd485878ae7659af7
parent a78d1b359966a2ab829fe13eaac7821894a96d91

tdf#153924: sc_subsequent_filters_test4: Add unittest

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

sc/qa/unit/data/ods/tdf153924.ods

diff --git a/sc/qa/unit/data/ods/tdf153924.ods b/sc/qa/unit/data/ods/tdf153924.ods
new file mode 100644
index 0000000..1373ded
--- /dev/null
+++ b/sc/qa/unit/data/ods/tdf153924.ods
Binary files differ

sc/qa/unit/subsequent_filters_test4.cxx

diff --git a/sc/qa/unit/subsequent_filters_test4.cxx b/sc/qa/unit/subsequent_filters_test4.cxx
index c1a0f9c..ec22e99 100644
--- a/sc/qa/unit/subsequent_filters_test4.cxx
+++ b/sc/qa/unit/subsequent_filters_test4.cxx
@@ -1487,6 +1487,23 @@ CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testSharedFormulaRefUpdateXLSX)
    }
}

CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testTdf153924)
{
    createScDoc("ods/tdf153924.ods");
    ScDocument* pDoc = getScDoc();

    double aCheck[6][2] = { { 148.0, 195.0 }, { 144.0, 200.0 }, { 151.0, 192.0 },
                            { 154.0, 189.0 }, { 165.0, 183.0 }, { 0.0, 0.0 } };
    for (size_t i = 0; i < 6; ++i)
    {
        for (size_t j = 0; j < 2; ++j)
        {
            // Without the fix in place, the output from LARGE()/SMALL() would have been 0
            CPPUNIT_ASSERT_EQUAL(aCheck[i][j], pDoc->GetValue(ScAddress(j, i + 8, 0)));
        }
    }
}

CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testSheetNamesXLSX)
{
    createScDoc("xlsx/sheet-names.xlsx");