sc: qa: filter: add import excel unit test

single line.

Signed-off-by: Henry Castro <hcastro@collabora.com>
Change-Id: I2d76f54e0ccf943794bd817b2e80583b8dd69558
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/151431
Tested-by: Jenkins CollaboraOffice <jenkinscollaboraoffice@gmail.com>

3 files changed, 36 insertions, 0 deletions

diff --git a/sc/qa/unit/data/xls/cell-multi-line.xls b/sc/qa/unit/data/xls/cell-multi-line.xls
new file mode 100644
index 000000000000..8ed0aded3243
--- /dev/null
+++ b/sc/qa/unit/data/xls/cell-multi-line.xls
diff --git a/sc/qa/unit/data/xlsx/cell-multi-line.xlsx b/sc/qa/unit/data/xlsx/cell-multi-line.xlsx
new file mode 100644
index 000000000000..ecaf8124c86b
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/cell-multi-line.xlsx
diff --git a/sc/qa/unit/subsequent_filters_test2.cxx b/sc/qa/unit/subsequent_filters_test2.cxx
index ead6c8da4070..ce84c891649f 100644
--- a/sc/qa/unit/subsequent_filters_test2.cxx
+++ b/sc/qa/unit/subsequent_filters_test2.cxx
@@ -209,6 +209,7 @@ public:
     void testAutofilterNamedRangesXLSX();
     void testInvalidBareBiff5();
     void testTooManyColsRows();
+    void testSingleLine();
 
     CPPUNIT_TEST_SUITE(ScFiltersTest2);
 
@@ -318,6 +319,7 @@ public:
     CPPUNIT_TEST(testAutofilterNamedRangesXLSX);
     CPPUNIT_TEST(testInvalidBareBiff5);
     CPPUNIT_TEST(testTooManyColsRows);
+    CPPUNIT_TEST(testSingleLine);
 
     CPPUNIT_TEST_SUITE_END();
 
@@ -3069,6 +3071,40 @@ void ScFiltersTest2::testTooManyColsRows()
     xDocSh->DoClose();
 }
 
+namespace
+{
+void testCells(ScDocShellRef xDocSh)
+{
+    ScDocument& rDoc = xDocSh->GetDocument();
+    {
+        const EditTextObject* pObj = rDoc.GetEditText(ScAddress(0, 0, 0));
+        CPPUNIT_ASSERT(pObj);
+        CPPUNIT_ASSERT_EQUAL(sal_Int32(1), pObj->GetParagraphCount());
+        CPPUNIT_ASSERT_EQUAL(size_t(1), pObj->GetSharedStrings().size());
+    }
+
+    {
+        const EditTextObject* pObj = rDoc.GetEditText(ScAddress(0, 1, 0));
+        CPPUNIT_ASSERT(pObj);
+        CPPUNIT_ASSERT_EQUAL(sal_Int32(3), pObj->GetParagraphCount());
+        CPPUNIT_ASSERT_EQUAL(size_t(3), pObj->GetSharedStrings().size());
+    }
+}
+}
+
+void ScFiltersTest2::testSingleLine()
+{
+    ScDocShellRef xDocSh = loadDoc(u"cell-multi-line.", FORMAT_XLS);
+    CPPUNIT_ASSERT(xDocSh.is());
+    testCells(xDocSh);
+    xDocSh->DoClose();
+
+    xDocSh = loadDoc(u"cell-multi-line.", FORMAT_XLSX);
+    CPPUNIT_ASSERT(xDocSh.is());
+    testCells(xDocSh);
+    xDocSh->DoClose();
+}
+
 CPPUNIT_TEST_SUITE_REGISTRATION(ScFiltersTest2);
 
 CPPUNIT_PLUGIN_IMPLEMENT();