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");