assay
test suite

text-longtail

104 tests · 86 with documented divergences

Test Subject Formula Category DVs
40ec6d ARABIC =ARABIC("XIV") value 1
ff6cd0 ARABIC =ARABIC("MCMXCIV") value 1
263f63 ARABIC =ARABIC("") value 1
ff939a ARABIC =ARABIC("xiv") value 1
c4c36b ARABIC =ARABIC("hello") value
128e5c ASC =ASC("ABC") value 1
f47574 ASC =ASC("123") value 1
f29a28 ASC =ASC("hello") value 1
6046c0 ASC =ASC("") value
92ae07 CHAR =CHAR(65) value 1
c2316b CHAR =CHAR(97) value 1
068a35 CHAR =CHAR(48) value 1
e1bac5 CHAR =CHAR(32) value 1
64adc4 CHAR =CHAR(0) value
642c37 CLEAN =CLEAN("hello" & CHAR(9) & "world") value 1
0c7a32 CLEAN =CLEAN("line1" & CHAR(10) & "line2") value 1
cfe703 CLEAN =CLEAN("hello world") value 1
ebc46f CLEAN =CLEAN("") value 2
d2a5b5 CODE =CODE("A") value 1
3d3776 CODE =CODE("a") value 1
b67498 CODE =CODE("Alphabet") value 1
1d5c13 CODE =CODE("") value 2
970b06 DOLLAR =DOLLAR(1234.567) value 1
ae2cef DOLLAR =DOLLAR(1234.567, 2) value 1
6e0318 DOLLAR =DOLLAR(1234.567, 0) value 1
a003ee DOLLAR =DOLLAR(-1234.5, 2) value
0dfc09 FINDB =FINDB("world", "hello world") value 1
166848 FINDB =FINDB("h", "hello") value 1
4d26db FINDB =FINDB("z", "hello") value 1
d71831 FINDB =FINDB("い", "あいう") value
a8f34b FIXED =FIXED(1234.567, 1) value 1
aa8b85 FIXED =FIXED(1234.567, 1, TRUE) value 1
148445 FIXED =FIXED(1234.567) value 1
d8ab0d FIXED =FIXED(1234.567, -1) value
8632a3 JOIN =JOIN("-", {"a","b","c"}) value 2
498f7c JOIN =JOIN(",", {1,2,3}) value 2
ab8f6f JOIN =JOIN("", {"a","b","c"}) value 2
e5def8 JOIN =JOIN("-", {"solo"}) value 2
ee2b6c LEFTB =LEFTB("Sale Price", 4) value 1
dc5148 LEFTB =LEFTB("hello") value 1
95e173 LEFTB =LEFTB("hello", 0) value 2
5832a1 LEFTB =LEFTB("あいう", 2) value
514abe LENB =LENB("hello") value 1
b51361 LENB =LENB("") value 1
0fa999 LENB =LENB(" ") value 1
7bce6f LENB =LENB("あ") value
ca5d6b MIDB =MIDB("Romain", 3, 4) value 1
42207a MIDB =MIDB("Romain", 1, 2) value 1
a36817 MIDB =MIDB("Romain", 3, 100) value 1
ed37f6 MIDB =MIDB("あいう", 3, 2) value
c884ea PROPER =PROPER("hello world") value 1
7ce6cd PROPER =PROPER("THIS IS A TITLE") value 1
a5d880 PROPER =PROPER("76BudGet") value 1
219a88 PROPER =PROPER("o'brien") value 1
0b43a2 REPLACEB =REPLACEB("abcdefghijk", 6, 5, "*") value 1
cfb47c REPLACEB =REPLACEB("2009", 3, 2, "10") value 1
129436 REPLACEB =REPLACEB("hello", 2, 3, "") value 1
1d040f REPLACEB =REPLACEB("あいう", 3, 2, "X") value
eb6088 RIGHTB =RIGHTB("Sale Price", 5) value 1
74422a RIGHTB =RIGHTB("hello") value 1
faad2c RIGHTB =RIGHTB("hello", 0) value 2
4072cf RIGHTB =RIGHTB("あいう", 2) value
6faa52 ROMAN =ROMAN(14) value 1
252fcc ROMAN =ROMAN(1994) value 1
eccb3b ROMAN =ROMAN(1) value 1
f47fb6 ROMAN =ROMAN(0) value
aa8d16 ROMAN =ROMAN(499, 0) value 1
f87de8 SEARCH =SEARCH("m", "Miriam McGovern") value 1
03dd2f SEARCH =SEARCH("m", "Miriam McGovern", 3) value 2
031624 SEARCH =SEARCH("m?r", "Miriam McGovern") value 3
b8b6d1 SEARCH =SEARCH("M*n", "Miriam McGovern") value 2
3dabc9 SEARCH =SEARCH("z", "Miriam McGovern") value 1
76a2c0 SEARCHB =SEARCHB("m", "Miriam McGovern") value 1
0c611f SEARCHB =SEARCHB("M", "Miriam McGovern", 3) value 2
1e5af4 SEARCHB =SEARCHB("z", "Miriam") value 1
6a7a3f SEARCHB =SEARCHB("い", "あいう") value
9006fb SPLIT =SPLIT("a,b,c", ",") value 3
4d1bcd SPLIT =SPLIT("a-b_c", "-_") value 3
0a0a13 SPLIT =SPLIT("hello", ",") value 3
669bc2 SPLIT =SPLIT("a,,b", ",", TRUE, FALSE) value 2
9dcb5e T =T("hello") value 1
b07219 T =T("42") value 1
772f7c T =T(42) value 2
f985ab T =T(TRUE) value 2
d3fea8 T =T("") value 2
88f3f7 TEXT =TEXT(1234.5, "#,##0.00") value 1
d9295e TEXT =TEXT(1234, "0000000") value 1
9f5959 TEXT =TEXT(0.25, "0.0%") value 1
05454c TEXT =TEXT(DATE(2024,1,15), "yyyy-mm-dd") value 1
40512c TEXT =TEXT(1234.5, "$#,##0.00") value 1
6a80d6 UNICHAR =UNICHAR(65) value 1
a8b784 UNICHAR =UNICHAR(9731) value 1
fea5d2 UNICHAR =UNICHAR(9829) value 1
63eb01 UNICHAR =UNICHAR(0) value 2
5f0592 UNICODE =UNICODE("A") value 1
43aebb UNICODE =UNICODE("☃") value 1
379dba UNICODE =UNICODE("♥") value 1
19ec47 UNICODE =UNICODE("Alphabet") value 1
69c69c UNICODE =UNICODE("") value
a18e10 VALUE =VALUE("42") value
94b04b VALUE =VALUE("3.14") value
138f38 VALUE =VALUE("-100") value
9e6e1a VALUE =VALUE("") value 1
414c0d VALUE =VALUE("hello") value