sc/qa/unit/data/xls/cell-multi-line.xls   |binary
 sc/qa/unit/data/xlsx/cell-multi-line.xlsx |binary
 sc/qa/unit/subsequent_filters_test2.cxx   |   33 ++++++++++++++++++++++++++++++
 3 files changed, 33 insertions(+)

New commits:
commit 0533b51dbe13838d2bffdf59fdf6fcfe36c4a451
Author:     Henry Castro <hcas...@collabora.com>
AuthorDate: Tue Feb 28 09:57:07 2023 -0400
Commit:     Henry Castro <hcas...@collabora.com>
CommitDate: Fri Jun 23 03:22:23 2023 +0200

    sc: qa: filter: add import excel unit test
    
    single line.
    
    Change-Id: I2d76f54e0ccf943794bd817b2e80583b8dd69558
    Signed-off-by: Henry Castro <hcas...@collabora.com>
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/148005
    Tested-by: Jenkins CollaboraOffice <jenkinscollaboraoff...@gmail.com>
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/153473
    Tested-by: Jenkins

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
Binary files /dev/null and b/sc/qa/unit/data/xls/cell-multi-line.xls differ
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
Binary files /dev/null and b/sc/qa/unit/data/xlsx/cell-multi-line.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters_test2.cxx 
b/sc/qa/unit/subsequent_filters_test2.cxx
index a00558730d0b..a0a4a92d299b 100644
--- a/sc/qa/unit/subsequent_filters_test2.cxx
+++ b/sc/qa/unit/subsequent_filters_test2.cxx
@@ -1580,6 +1580,39 @@ CPPUNIT_TEST_FIXTURE(ScFiltersTest2, testNamedTableRef)
     }
 }
 
+namespace
+{
+void testCells(ScDocument* pDoc)
+{
+    {
+        const EditTextObject* pObj = pDoc->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 = pDoc->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());
+    }
+}
+}
+
+CPPUNIT_TEST_FIXTURE(ScFiltersTest2, testSingleLine)
+{
+    createScDoc("xls/cell-multi-line.xls");
+    ScDocument* pDoc = getScDoc();
+    CPPUNIT_ASSERT(pDoc);
+    testCells(pDoc);
+
+    createScDoc("xlsx/cell-multi-line.xlsx");
+    pDoc = getScDoc();
+    CPPUNIT_ASSERT(pDoc);
+    testCells(pDoc);
+}
+
 CPPUNIT_PLUGIN_IMPLEMENT();
 
 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

Reply via email to