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

[Markus Mohrhard]

 sc/qa/unit/data/xlsx/autofilter.xlsx   |binary
 sc/qa/unit/subsequent_filters-test.cxx |   17 +++++++++++++++++
 2 files changed, 17 insertions(+)

New commits:
commit 21cc5084d5fdcedec7793dbf024552592a70324d
Author: Markus Mohrhard <markus.mohrhard at googlemail.com>
Date:   Sat Mar 18 03:02:00 2017 +0100

    add test for tdf#105909
    
    Change-Id: Iba9922f40b4b72039f35371c42aa24bac52a8adc
    Reviewed-on: https://gerrit.libreoffice.org/35383
    Reviewed-by: Markus Mohrhard <markus.mohrhard at googlemail.com>
    Tested-by: Markus Mohrhard <markus.mohrhard at googlemail.com>

diff --git a/sc/qa/unit/data/xlsx/autofilter.xlsx b/sc/qa/unit/data/xlsx/autofilter.xlsx
new file mode 100644
index 000000000000..a8287c185d9e
Binary files /dev/null and b/sc/qa/unit/data/xlsx/autofilter.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 84dec1d0c83f..81bb3dc719d0 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -230,6 +230,7 @@ public:
     void testHiddenSheetsXLSX();
     void testRelFormulaValidationXLS();
     void testColumnStyle2XLSX();
+    void testAutofilterXLSX();
 
     void testBnc762542();
 
@@ -344,6 +345,7 @@ public:
     CPPUNIT_TEST(testRefStringXLSX);
     CPPUNIT_TEST(testRelFormulaValidationXLS);
     CPPUNIT_TEST(testColumnStyle2XLSX);
+    CPPUNIT_TEST(testAutofilterXLSX);
 
     CPPUNIT_TEST(testBnc762542);
 
@@ -3775,6 +3777,21 @@ void ScFiltersTest::testHiddenSheetsXLSX()
     xDocSh->DoClose();
 }
 
+void ScFiltersTest::testAutofilterXLSX()
+{
+    ScDocShellRef xDocSh = loadDoc("autofilter.", FORMAT_XLSX);
+    CPPUNIT_ASSERT_MESSAGE("Failed to open doc", xDocSh.is());
+
+    ScDocument& rDoc = xDocSh->GetDocument();
+    const ScDBData* pData = rDoc.GetDBCollection()->GetDBNearCursor(0,0,0);
+    CPPUNIT_ASSERT(pData);
+    ScRange aRange;
+    pData->GetArea(aRange);
+    CPPUNIT_ASSERT_EQUAL(ScRange(0,0,0,2,4,0), aRange);
+
+    xDocSh->DoClose();
+}
+
 namespace {
 
 void checkValidationFormula(const ScAddress& rPos, ScDocument& rDoc, const OUString& rExpectedFormula)