test suite

text-longtail

104 tests · 86 with documented divergences

Test	Subject	Formula	Category	DVs
`arabic-xiv`	ARABIC	`=ARABIC("XIV")`	value	1
`arabic-mcmxciv`	ARABIC	`=ARABIC("MCMXCIV")`	value	1
`arabic-empty`	ARABIC	`=ARABIC("")`	value	1
`arabic-lowercase`	ARABIC	`=ARABIC("xiv")`	value	1
`arabic-invalid`	ARABIC	`=ARABIC("hello")`	value
`asc-fullwidth-alpha`	ASC	`=ASC("ABC")`	value	1
`asc-fullwidth-digits`	ASC	`=ASC("123")`	value	1
`asc-ascii-passthrough`	ASC	`=ASC("hello")`	value	1
`asc-empty`	ASC	`=ASC("")`	value
`char-uppercase-a`	CHAR	`=CHAR(65)`	value	1
`char-lowercase-a`	CHAR	`=CHAR(97)`	value	1
`char-digit-0`	CHAR	`=CHAR(48)`	value	1
`char-space`	CHAR	`=CHAR(32)`	value	1
`char-out-of-range`	CHAR	`=CHAR(0)`	value
`clean-strips-tab`	CLEAN	`=CLEAN("hello" & CHAR(9) & "world")`	value	1
`clean-strips-newline`	CLEAN	`=CLEAN("line1" & CHAR(10) & "line2")`	value	1
`clean-plain-passthrough`	CLEAN	`=CLEAN("hello world")`	value	1
`clean-empty`	CLEAN	`=CLEAN("")`	value	2
`code-uppercase-a`	CODE	`=CODE("A")`	value	1
`code-lowercase-a`	CODE	`=CODE("a")`	value	1
`code-first-char`	CODE	`=CODE("Alphabet")`	value	1
`code-empty`	CODE	`=CODE("")`	value	2
`dollar-basic`	DOLLAR	`=DOLLAR(1234.567)`	value	1
`dollar-2-decimals`	DOLLAR	`=DOLLAR(1234.567, 2)`	value	1
`dollar-zero-decimals`	DOLLAR	`=DOLLAR(1234.567, 0)`	value	1
`dollar-negative`	DOLLAR	`=DOLLAR(-1234.5, 2)`	value
`findb-ascii`	FINDB	`=FINDB("world", "hello world")`	value	1
`findb-at-start`	FINDB	`=FINDB("h", "hello")`	value	1
`findb-not-found`	FINDB	`=FINDB("z", "hello")`	value	1
`findb-dbcs`	FINDB	`=FINDB("い", "あいう")`	value
`fixed-basic`	FIXED	`=FIXED(1234.567, 1)`	value	1
`fixed-no-commas`	FIXED	`=FIXED(1234.567, 1, TRUE)`	value	1
`fixed-default`	FIXED	`=FIXED(1234.567)`	value	1
`fixed-negative-decimals`	FIXED	`=FIXED(1234.567, -1)`	value
`join-basic`	JOIN	`=JOIN("-", {"a","b","c"})`	value	2
`join-with-numbers`	JOIN	`=JOIN(",", {1,2,3})`	value	2
`join-empty-delim`	JOIN	`=JOIN("", {"a","b","c"})`	value	2
`join-single-element`	JOIN	`=JOIN("-", {"solo"})`	value	2
`leftb-ascii`	LEFTB	`=LEFTB("Sale Price", 4)`	value	1
`leftb-default`	LEFTB	`=LEFTB("hello")`	value	1
`leftb-zero`	LEFTB	`=LEFTB("hello", 0)`	value	2
`leftb-dbcs`	LEFTB	`=LEFTB("あいう", 2)`	value
`lenb-ascii`	LENB	`=LENB("hello")`	value	1
`lenb-empty`	LENB	`=LENB("")`	value	1
`lenb-spaces`	LENB	`=LENB(" ")`	value	1
`lenb-dbcs`	LENB	`=LENB("あ")`	value
`midb-ascii`	MIDB	`=MIDB("Romain", 3, 4)`	value	1
`midb-from-start`	MIDB	`=MIDB("Romain", 1, 2)`	value	1
`midb-beyond-end`	MIDB	`=MIDB("Romain", 3, 100)`	value	1
`midb-dbcs`	MIDB	`=MIDB("あいう", 3, 2)`	value
`proper-hello-world`	PROPER	`=PROPER("hello world")`	value	1
`proper-all-caps`	PROPER	`=PROPER("THIS IS A TITLE")`	value	1
`proper-mixed`	PROPER	`=PROPER("76BudGet")`	value	1
`proper-apostrophe`	PROPER	`=PROPER("o'brien")`	value	1
`replaceb-ascii`	REPLACEB	`=REPLACEB("abcdefghijk", 6, 5, "*")`	value	1
`replaceb-year`	REPLACEB	`=REPLACEB("2009", 3, 2, "10")`	value	1
`replaceb-empty-insert`	REPLACEB	`=REPLACEB("hello", 2, 3, "")`	value	1
`replaceb-dbcs`	REPLACEB	`=REPLACEB("あいう", 3, 2, "X")`	value
`rightb-ascii`	RIGHTB	`=RIGHTB("Sale Price", 5)`	value	1
`rightb-default`	RIGHTB	`=RIGHTB("hello")`	value	1
`rightb-zero`	RIGHTB	`=RIGHTB("hello", 0)`	value	2
`rightb-dbcs`	RIGHTB	`=RIGHTB("あいう", 2)`	value
`roman-14-xiv`	ROMAN	`=ROMAN(14)`	value	1
`roman-1994`	ROMAN	`=ROMAN(1994)`	value	1
`roman-1`	ROMAN	`=ROMAN(1)`	value	1
`roman-zero`	ROMAN	`=ROMAN(0)`	value
`roman-499-form0`	ROMAN	`=ROMAN(499, 0)`	value	1
`search-case-insensitive`	SEARCH	`=SEARCH("m", "Miriam McGovern")`	value	1
`search-with-start`	SEARCH	`=SEARCH("m", "Miriam McGovern", 3)`	value	2
`search-wildcard-question`	SEARCH	`=SEARCH("m?r", "Miriam McGovern")`	value	3
`search-wildcard-star`	SEARCH	`=SEARCH("M*n", "Miriam McGovern")`	value	2
`search-not-found`	SEARCH	`=SEARCH("z", "Miriam McGovern")`	value	1
`searchb-ascii`	SEARCHB	`=SEARCHB("m", "Miriam McGovern")`	value	1
`searchb-with-start`	SEARCHB	`=SEARCHB("M", "Miriam McGovern", 3)`	value	2
`searchb-not-found`	SEARCHB	`=SEARCHB("z", "Miriam")`	value	1
`searchb-dbcs`	SEARCHB	`=SEARCHB("い", "あいう")`	value
`split-comma`	SPLIT	`=SPLIT("a,b,c", ",")`	value	3
`split-multi-delim`	SPLIT	`=SPLIT("a-b_c", "-_")`	value	3
`split-single-token`	SPLIT	`=SPLIT("hello", ",")`	value	3
`split-empty-tokens`	SPLIT	`=SPLIT("a,,b", ",", TRUE, FALSE)`	value	2
`t-text-passthrough`	T	`=T("hello")`	value	1
`t-numeric-string-literal`	T	`=T("42")`	value	1
`t-number`	T	`=T(42)`	value	2
`t-boolean`	T	`=T(TRUE)`	value	2
`t-empty`	T	`=T("")`	value	2
`text-thousands`	TEXT	`=TEXT(1234.5, "#,##0.00")`	value	1
`text-integer`	TEXT	`=TEXT(1234, "0000000")`	value	1
`text-percent`	TEXT	`=TEXT(0.25, "0.0%")`	value	1
`text-date`	TEXT	`=TEXT(DATE(2024,1,15), "yyyy-mm-dd")`	value	1
`text-currency`	TEXT	`=TEXT(1234.5, "$#,##0.00")`	value	1
`unichar-uppercase-a`	UNICHAR	`=UNICHAR(65)`	value	1
`unichar-snowman`	UNICHAR	`=UNICHAR(9731)`	value	1
`unichar-emoji-bmp`	UNICHAR	`=UNICHAR(9829)`	value	1
`unichar-zero`	UNICHAR	`=UNICHAR(0)`	value	2
`unicode-uppercase-a`	UNICODE	`=UNICODE("A")`	value	1
`unicode-snowman`	UNICODE	`=UNICODE("☃")`	value	1
`unicode-heart`	UNICODE	`=UNICODE("♥")`	value	1
`unicode-first-char`	UNICODE	`=UNICODE("Alphabet")`	value	1
`unicode-empty`	UNICODE	`=UNICODE("")`	value
`value-integer-string`	VALUE	`=VALUE("42")`	value
`value-decimal-string`	VALUE	`=VALUE("3.14")`	value
`value-negative`	VALUE	`=VALUE("-100")`	value
`value-empty`	VALUE	`=VALUE("")`	value	1
`value-non-numeric`	VALUE	`=VALUE("hello")`	value