diff options
| author | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2017-08-14 23:45:17 +0200 |
|---|---|---|
| committer | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2017-08-15 00:57:56 +0200 |
| commit | 46aba1db9a8e43da03f4db580b8dc9de7b850b00 (patch) | |
| tree | d5cbc9acc44d0dc8ba4425b11641bd3723bc3758 /sc/qa | |
| parent | 3ecec2dbcff2870c385b0814203b1883887eddec (diff) | |
external data: add merge column transformation
Change-Id: I112650bbb0ed279b386389e7df6b372bde080b62
Reviewed-on: https://gerrit.libreoffice.org/41157
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Diffstat (limited to 'sc/qa')
| -rw-r--r-- | sc/qa/unit/datatransformation_test.cxx | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sc/qa/unit/datatransformation_test.cxx b/sc/qa/unit/datatransformation_test.cxx index bcd8c9a88a7a..785b7024a74b 100644 --- a/sc/qa/unit/datatransformation_test.cxx +++ b/sc/qa/unit/datatransformation_test.cxx @@ -30,10 +30,12 @@ public: void testColumnRemove(); void testColumnSplit(); + void testColumnMerge(); CPPUNIT_TEST_SUITE(ScDataTransformationTest); CPPUNIT_TEST(testColumnRemove); CPPUNIT_TEST(testColumnSplit); + CPPUNIT_TEST(testColumnMerge); CPPUNIT_TEST_SUITE_END(); private: @@ -95,6 +97,32 @@ void ScDataTransformationTest::testColumnSplit() CPPUNIT_ASSERT_EQUAL(OUString("Test2,Test3"), m_pDoc->GetString(3, 3, 0)); } +void ScDataTransformationTest::testColumnMerge() +{ + m_pDoc->SetString(2, 0, 0, "Berlin"); + m_pDoc->SetString(2, 1, 0, "Brussels"); + m_pDoc->SetString(2, 2, 0, "Paris"); + m_pDoc->SetString(2, 3, 0, "Peking"); + + m_pDoc->SetString(4, 0, 0, "Germany"); + m_pDoc->SetString(4, 1, 0, "Belgium"); + m_pDoc->SetString(4, 2, 0, "France"); + m_pDoc->SetString(4, 3, 0, "China"); + + sc::MergeColumnTransformation aTransform(2, 4, ", "); + aTransform.Transform(*m_pDoc); + + CPPUNIT_ASSERT_EQUAL(OUString("Berlin, Germany"), m_pDoc->GetString(2, 0, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("Brussels, Belgium"), m_pDoc->GetString(2, 1, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("Paris, France"), m_pDoc->GetString(2, 2, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("Peking, China"), m_pDoc->GetString(2, 3, 0)); + + for (SCROW nRow = 0; nRow <= 3; ++nRow) + { + CPPUNIT_ASSERT(m_pDoc->GetString(4, nRow, 0).isEmpty()); + } +} + ScDataTransformationTest::ScDataTransformationTest() : ScBootstrapFixture( "/sc/qa/unit/data/dataprovider" ), m_pDoc(nullptr) |