summaryrefslogtreecommitdiff
path: root/sc/qa/unit/ucalc.cxx
diff options
context:
space:
mode:
authorKohei Yoshida <kohei.yoshida@suse.com>2011-11-14 12:07:48 -0500
committerKohei Yoshida <kohei.yoshida@suse.com>2011-11-14 12:07:48 -0500
commit51494ab7291ad97eca5acfe2d9a4943ddfb4800d (patch)
treef2ee18579de3ad15d0b6b5e1649cc90b32f37cbf /sc/qa/unit/ucalc.cxx
parent2f61bdff4435fd25b2d7da3c2366d663bd7e5085 (diff)
Likewise, adjusted the test cases for MATCH to handle mixed comparisons.
Diffstat (limited to 'sc/qa/unit/ucalc.cxx')
-rw-r--r--sc/qa/unit/ucalc.cxx13
1 files changed, 7 insertions, 6 deletions
diff --git a/sc/qa/unit/ucalc.cxx b/sc/qa/unit/ucalc.cxx
index 3faa20809332..b18bfe020d26 100644
--- a/sc/qa/unit/ucalc.cxx
+++ b/sc/qa/unit/ucalc.cxx
@@ -589,7 +589,7 @@ void testFuncMATCH(ScDocument* pDoc)
"7",
"8",
"9",
- "A",
+ "B",
"B",
"C",
};
@@ -608,7 +608,7 @@ void testFuncMATCH(ScDocument* pDoc)
{ "9.59", "9" },
{ "10", "9" },
{ "100", "9" },
- { "Andy", "10" },
+ { "Andy", "#N/A" },
{ "Bruce", "11" },
{ "Charlie", "12" }
};
@@ -621,9 +621,9 @@ void testFuncMATCH(ScDocument* pDoc)
// data range (A1:A9)
const char* aData[] = {
+ "D",
"C",
"B",
- "A",
"9",
"8",
"7",
@@ -649,9 +649,10 @@ void testFuncMATCH(ScDocument* pDoc)
{ "0.8", "12" },
{ "0", "12" },
{ "-2", "12" },
- { "Andy", "2" },
- { "Bruce", "1" },
- { "Charlie", "#N/A" },
+ { "Andy", "3" },
+ { "Bruce", "2" },
+ { "Charlie", "1" },
+ { "David", "#N/A" }
};
runTestMATCH<SAL_N_ELEMENTS(aData),SAL_N_ELEMENTS(aChecks),-1>(pDoc, aData, aChecks);