sc/qa/unit/data/xlsx/tdf139934.xlsx |binary
sc/qa/unit/subsequent_filters_test.cxx | 15 +++++++++++++++
2 files changed, 15 insertions(+)
New commits:
commit d367cefb0281767762b1671c03b3852cf3d1b7ab
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Fri Feb 10 16:11:25 2023 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Fri Feb 10 19:50:43 2023 +0000
tdf#139934: sc_subsequent_filters_test: Add unittest
Change-Id: Ib1540bb7058606c7629ce0459fd18bd463e99998
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/146786
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/unit/data/xlsx/tdf139934.xlsx
b/sc/qa/unit/data/xlsx/tdf139934.xlsx
new file mode 100644
index 000000000000..c4fcf6905df4
Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf139934.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters_test.cxx
b/sc/qa/unit/subsequent_filters_test.cxx
index fd0aa159467b..7749106a3883 100644
--- a/sc/qa/unit/subsequent_filters_test.cxx
+++ b/sc/qa/unit/subsequent_filters_test.cxx
@@ -88,6 +88,7 @@ public:
void testContentXLS_XML();
void testContentGnumeric();
void testCondFormatOperatorsSameRangeXLSX();
+ void testTdf139934();
void testTdf150452();
void testTdf119292();
void testTdf48731();
@@ -219,6 +220,7 @@ public:
CPPUNIT_TEST(testContentXLS_XML);
CPPUNIT_TEST(testContentGnumeric);
CPPUNIT_TEST(testCondFormatOperatorsSameRangeXLSX);
+ CPPUNIT_TEST(testTdf139934);
CPPUNIT_TEST(testTdf150452);
CPPUNIT_TEST(testTdf119292);
CPPUNIT_TEST(testTdf48731);
@@ -563,6 +565,19 @@ void ScFiltersTest::testTdf119292()
CPPUNIT_ASSERT_EQUAL(Point(114, 54), aPoly270Pos3);
}
+void ScFiltersTest::testTdf139934()
+{
+ createScDoc("xlsx/tdf139934.xlsx");
+
+ ScDocument* pDoc = getScDoc();
+
+ // Without the fix in place, this test would have failed with
+ // - Expected: 1/20/2021
+ // - Actual : 44216
+ CPPUNIT_ASSERT_EQUAL(OUString("1/20/2021"), pDoc->GetString(0, 2, 0));
+ CPPUNIT_ASSERT_EQUAL(OUString("11/25/2020"), pDoc->GetString(0, 61, 0));
+}
+
void ScFiltersTest::testTdf150452()
{
// Without the fix in place, this test would have crashed
