add test for tdf#105909

Change-Id: Iba9922f40b4b72039f35371c42aa24bac52a8adc
Reviewed-on: https://gerrit.libreoffice.org/35383
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>

2 files changed, 17 insertions, 0 deletions

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
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/autofilter.xlsx
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)