sc/qa/unit/data/xlsx/tdf100709.xlsx |binary sc/qa/unit/subsequent_filters-test.cxx | 14 ++++++++++++++ 2 files changed, 14 insertions(+)
New commits: commit 6cf44da0395ce5d8dc9cfda838fb15c593507363 Author: Maarten Bosmans <mkbosm...@gmail.com> Date: Wed Sep 7 22:11:26 2016 +0200 Related: tdf#100709 Add unit test This tests for the two bugs fixed in d16070a3. Change-Id: I453fc603ca98895c56c6e8df6315b8d1ea96bfde Reviewed-on: https://gerrit.libreoffice.org/28734 Tested-by: Jenkins <c...@libreoffice.org> Reviewed-by: Markus Mohrhard <markus.mohrh...@googlemail.com> diff --git a/sc/qa/unit/data/xlsx/tdf100709.xlsx b/sc/qa/unit/data/xlsx/tdf100709.xlsx new file mode 100644 index 0000000..87698bb Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf100709.xlsx differ diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx index c538ec7..42aa391 100644 --- a/sc/qa/unit/subsequent_filters-test.cxx +++ b/sc/qa/unit/subsequent_filters-test.cxx @@ -216,6 +216,7 @@ public: void testBnc762542(); void testTdf100458(); + void testTdf100709XLSX(); CPPUNIT_TEST_SUITE(ScFiltersTest); CPPUNIT_TEST(testBooleanFormatXLSX); @@ -321,6 +322,7 @@ public: CPPUNIT_TEST(testHiddenSheetsXLSX); CPPUNIT_TEST(testTdf100458); + CPPUNIT_TEST(testTdf100709XLSX); CPPUNIT_TEST_SUITE_END(); @@ -3342,6 +3344,18 @@ void ScFiltersTest::testTdf100458() CPPUNIT_ASSERT(!rDoc.HasStringData(0, 0, 0)); } +void ScFiltersTest::testTdf100709XLSX() +{ + ScDocShellRef xDocSh = ScBootstrapFixture::loadDoc("tdf100709.", FORMAT_XLSX); + CPPUNIT_ASSERT_MESSAGE("Failed to load tdf100709.xlsx", xDocSh.Is()); + + ScDocument& rDoc = xDocSh->GetDocument(); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Cell B52 should not be formatted with a $", OUString("218"), rDoc.GetString(1, 51, 0)); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Cell A75 should not be formatted as a date", OUString("218"), rDoc.GetString(0, 74, 0)); + + xDocSh->DoClose(); +} + ScFiltersTest::ScFiltersTest() : ScBootstrapFixture( "sc/qa/unit/data" ) { _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits