summaryrefslogtreecommitdiff
path: root/sc
diff options
context:
space:
mode:
authorHenry Castro <hcastro@collabora.com>2023-02-28 09:57:07 -0400
committerHenry Castro <hcastro@collabora.com>2023-06-23 03:22:23 +0200
commit0533b51dbe13838d2bffdf59fdf6fcfe36c4a451 (patch)
treee5e0ca1df180eaf768750d646faa1167531181ea /sc
parent7626e37b7c77980ba41bdc7e9131b9c373dea038 (diff)
sc: qa: filter: add import excel unit test
single line. Change-Id: I2d76f54e0ccf943794bd817b2e80583b8dd69558 Signed-off-by: Henry Castro <hcastro@collabora.com> Reviewed-on: https://gerrit.libreoffice.org/c/core/+/148005 Tested-by: Jenkins CollaboraOffice <jenkinscollaboraoffice@gmail.com> Reviewed-on: https://gerrit.libreoffice.org/c/core/+/153473 Tested-by: Jenkins
Diffstat (limited to 'sc')
-rw-r--r--sc/qa/unit/data/xls/cell-multi-line.xlsbin0 -> 33792 bytes
-rw-r--r--sc/qa/unit/data/xlsx/cell-multi-line.xlsxbin0 -> 9144 bytes
-rw-r--r--sc/qa/unit/subsequent_filters_test2.cxx33
3 files changed, 33 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
Binary files 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
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/cell-multi-line.xlsx
Binary files 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: */