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 | 35 ++++++++++++++++++++++++++++++ 3 files changed, 35 insertions(+)
New commits: commit 9c5e6b87d925bb36a9d80a5f9fb611259e505d44 Author: Henry Castro <hcas...@collabora.com> AuthorDate: Tue Feb 28 09:57:07 2023 -0400 Commit: Henry Castro <hcas...@collabora.com> CommitDate: Fri May 12 21:29:35 2023 +0200 sc: qa: filter: add import excel unit test single line. Signed-off-by: Henry Castro <hcas...@collabora.com> Change-Id: I2d76f54e0ccf943794bd817b2e80583b8dd69558 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/148005 Tested-by: Jenkins CollaboraOffice <jenkinscollaboraoff...@gmail.com> 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 2e3f2a0ec88b..850026d3bc46 100644 --- a/sc/qa/unit/subsequent_filters_test2.cxx +++ b/sc/qa/unit/subsequent_filters_test2.cxx @@ -191,6 +191,7 @@ public: void testTdf83671_SmartArt_import2(); void testTdf151818_SmartArtFontColor(); void testTdf82984_zip64XLSXImport(); + void testSingleLine(); CPPUNIT_TEST_SUITE(ScFiltersTest2); @@ -312,6 +313,7 @@ public: CPPUNIT_TEST(testTdf83671_SmartArt_import2); CPPUNIT_TEST(testTdf151818_SmartArtFontColor); CPPUNIT_TEST(testTdf82984_zip64XLSXImport); + CPPUNIT_TEST(testSingleLine); CPPUNIT_TEST_SUITE_END(); }; @@ -3043,6 +3045,39 @@ void ScFiltersTest2::testTdf82984_zip64XLSXImport() createScDoc("xlsx/tdf82984_zip64XLSXImport.xlsx"); } +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()); + } +} +} + +void 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_TEST_SUITE_REGISTRATION(ScFiltersTest2); CPPUNIT_PLUGIN_IMPLEMENT();