summaryrefslogtreecommitdiff
path: root/sc/qa
diff options
context:
space:
mode:
authorNoel Power <noel.power@suse.com>2012-09-24 18:10:32 +0100
committerNoel Power <noel.power@suse.com>2012-09-25 11:30:13 +0100
commitfde638b3ac35997aa3e38a37fed56d6eb661806b (patch)
tree63c922bfac06e7ebb8a183040d0f7f50694b1321 /sc/qa
parent3610d36782ca30aa6478921bcf331dcd7a554efb (diff)
unit test for bnc#780296 fix
Change-Id: Ib75437bb52c8094821fc9d18429f4ce01bb7ec2f
Diffstat (limited to 'sc/qa')
-rw-r--r--sc/qa/unit/data/xlsx/named-ranges-global.xlsxbin5665 -> 5664 bytes
-rw-r--r--sc/qa/unit/subsequent_filters-test.cxx5
2 files changed, 3 insertions, 2 deletions
diff --git a/sc/qa/unit/data/xlsx/named-ranges-global.xlsx b/sc/qa/unit/data/xlsx/named-ranges-global.xlsx
index 3bb0cbcd7506..fe90d6d088dc 100644
--- a/sc/qa/unit/data/xlsx/named-ranges-global.xlsx
+++ b/sc/qa/unit/data/xlsx/named-ranges-global.xlsx
Binary files differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index e9f6b66af326..678d1ecfcb50 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -321,6 +321,9 @@ void testRangeNameImpl(ScDocument* pDoc)
CPPUNIT_ASSERT_EQUAL_MESSAGE("=SUM(global3) should be 10", 10.0, aValue);
pDoc->GetValue(1,0,1,aValue);
CPPUNIT_ASSERT_EQUAL_MESSAGE("range name Sheet2.local1 should reference Sheet1.A5", 5.0, aValue);
+ // Test if Global5 ( which depends on Global6 ) is evaluated
+ pDoc->GetValue(0,5,1, aValue);
+ CPPUNIT_ASSERT_EQUAL_MESSAGE("formula Global5 should reference Global6 ( which is evaluated as local1 )", 5.0, aValue);
}
}
@@ -351,8 +354,6 @@ void ScFiltersTest::testRangeNameXLSX()
ScDocument* pDoc = xDocSh->GetDocument();
testRangeNameImpl(pDoc);
-
- xDocSh->DoClose();
}
void ScFiltersTest::testHardRecalcODS()