summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKohei Yoshida <kohei.yoshida@collabora.com>2014-02-24 13:53:12 -0500
committerKohei Yoshida <kohei.yoshida@collabora.com>2014-02-24 16:05:02 -0500
commit3cf0847e7514a3f1217554c08cb109902cf2a637 (patch)
treed5c16e9501b823cf0cbd51529c7305c87634b980
parenta52572057cde479ce4fc7ccd8343fe57220a70cb (diff)
fdo#75304: Add test for external reference cache import from XLSX.
Change-Id: I93c4398b5673e1edaacfe4b68015000dfd224612
-rw-r--r--sc/qa/unit/data/xlsx/external-refs.xlsxbin0 -> 9172 bytes
-rw-r--r--sc/qa/unit/subsequent_filters-test.cxx17
2 files changed, 17 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xlsx/external-refs.xlsx b/sc/qa/unit/data/xlsx/external-refs.xlsx
new file mode 100644
index 000000000000..805e36c51a61
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/external-refs.xlsx
Binary files differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index f4acfa96e088..7c332c4b25cc 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -159,6 +159,7 @@ public:
void testColumnStyleXLSX();
void testSharedFormulaHorizontalXLS();
+ void testExternalRefCacheXLSX();
CPPUNIT_TEST_SUITE(ScFiltersTest);
CPPUNIT_TEST(testBasicCellContentODS);
@@ -234,6 +235,7 @@ public:
CPPUNIT_TEST(testOutlineODS);
CPPUNIT_TEST(testColumnStyleXLSX);
CPPUNIT_TEST(testSharedFormulaHorizontalXLS);
+ CPPUNIT_TEST(testExternalRefCacheXLSX);
CPPUNIT_TEST_SUITE_END();
private:
@@ -2471,6 +2473,21 @@ void ScFiltersTest::testSharedFormulaHorizontalXLS()
xDocSh->DoClose();
}
+void ScFiltersTest::testExternalRefCacheXLSX()
+{
+ ScDocShellRef xDocSh = loadDoc("external-refs.", XLSX);
+ CPPUNIT_ASSERT(xDocSh.Is());
+ ScDocument* pDoc = xDocSh->GetDocument();
+
+ // These string values are cached external cell values.
+ CPPUNIT_ASSERT_EQUAL(OUString("Name"), pDoc->GetString(ScAddress(0,0,0)));
+ CPPUNIT_ASSERT_EQUAL(OUString("Andy"), pDoc->GetString(ScAddress(0,1,0)));
+ CPPUNIT_ASSERT_EQUAL(OUString("Bruce"), pDoc->GetString(ScAddress(0,2,0)));
+ CPPUNIT_ASSERT_EQUAL(OUString("Charlie"), pDoc->GetString(ScAddress(0,3,0)));
+
+ xDocSh->DoClose();
+}
+
ScFiltersTest::ScFiltersTest()
: ScBootstrapFixture( "/sc/qa/unit/data" )
{