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

[Maarten Bosmans]

 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 <mkbosmans at 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 <ci at libreoffice.org>
    Reviewed-by: Markus Mohrhard <markus.mohrhard at 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" )
 {