summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKohei Yoshida <kohei.yoshida@collabora.com>2014-02-07 14:23:24 -0500
committerKohei Yoshida <kohei.yoshida@collabora.com>2014-02-07 14:46:21 -0500
commit36e7fca5fa87fc72cdc9315438d9437fae9aa3da (patch)
treea3ceb160d6ccc77c4960ce3d63ddc1d714bc5e58
parent38d0047da7f964c862360b48d88cc869ad376b6b (diff)
fdo#74535: Write unit test for importing hyperlinks from xlsx.
Change-Id: I64e053106cee396a09f2a4915c19fcb1d69e5e82
-rw-r--r--sc/qa/unit/data/xlsx/hyperlinks.xlsxbin0 -> 9068 bytes
-rw-r--r--sc/qa/unit/subsequent_filters-test.cxx14
2 files changed, 14 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xlsx/hyperlinks.xlsx b/sc/qa/unit/data/xlsx/hyperlinks.xlsx
new file mode 100644
index 000000000000..5faea7dba137
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/hyperlinks.xlsx
Binary files differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 448a9fab1271..83841b3e3505 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -89,6 +89,7 @@ public:
void testBasicCellContentODS();
void testRangeNameXLS();
void testRangeNameXLSX();
+ void testHyperlinksXLSX();
void testHardRecalcODS();
void testFunctionsODS();
void testFunctionsExcel2010();
@@ -164,6 +165,7 @@ public:
CPPUNIT_TEST(testBasicCellContentODS);
CPPUNIT_TEST(testRangeNameXLS);
CPPUNIT_TEST(testRangeNameXLSX);
+ CPPUNIT_TEST(testHyperlinksXLSX);
CPPUNIT_TEST(testHardRecalcODS);
CPPUNIT_TEST(testFunctionsODS);
CPPUNIT_TEST(testFunctionsExcel2010);
@@ -342,6 +344,18 @@ void ScFiltersTest::testRangeNameXLSX()
xDocSh->DoClose();
}
+void ScFiltersTest::testHyperlinksXLSX()
+{
+ ScDocShellRef xDocSh = loadDoc("hyperlinks.", XLSX);
+ ScDocument* pDoc = xDocSh->GetDocument();
+
+ CPPUNIT_ASSERT_EQUAL(OUString("10:ABC10"), pDoc->GetString(ScAddress(0,1,0)));
+ CPPUNIT_ASSERT_EQUAL(OUString("10:ABC11"), pDoc->GetString(ScAddress(0,2,0)));
+ CPPUNIT_ASSERT_EQUAL(OUString("10:ABC12"), pDoc->GetString(ScAddress(0,3,0)));
+
+ xDocSh->DoClose();
+}
+
void ScFiltersTest::testHardRecalcODS()
{
ScDocShellRef xDocSh = loadDoc("hard-recalc.", ODS);