|
Expected
<-- expected PROPER -->
- $PROPER(a small STEP)=|A Small Step|
- $PROPER(f1 (formula-1))=|F1 (Formula-1)|
- $PROPER()=||
<-- /expected -->
|
Actual
<-- actual -->
- $PROPER(a small STEP)=|A Small Step|
- $PROPER(f1 (formula-1))=|F1 (Formula-1)|
- $PROPER()=||
<-- /actual -->
|
Expected
<-- expected PROPERSPACE -->
- $PROPERSPACE(Old MacDonald had a ServerFarm, EeEyeEeEyeOh)=|Old MacDonald had a Server Farm, Ee Eye Ee Eye Oh|
- $PROPERSPACE()=||
<-- /expected -->
|
Actual
<-- actual -->
- $PROPERSPACE(Old MacDonald had a ServerFarm, EeEyeEeEyeOh)=|Old MacDonald had a Server Farm, Ee Eye Ee Eye Oh|
- $PROPERSPACE()=||
<-- /actual -->
|
Function RAND
Expected
<-- expected RAND -->
- $IF($RAND()<=1, OK, not OK)=|OK|
<-- /expected -->
- Manual test: $RAND(10), $RAND(10), $RAND(10)=|(three random numbers between 0 and 10)|
- Manual test: $RAND(), $RAND(), $RAND()=|(three random numbers between 0 and 1)|
|
Actual
<-- actual -->
- $IF($RAND()<=1, OK, not OK)=|OK|
<-- /actual -->
- Manual test: $RAND(10), $RAND(10), $RAND(10)=|9.8715777254419, 6.21497471108775, 6.66241197876833|
- Manual test: $RAND(), $RAND(), $RAND()=|0.0113173558727482, 0.925841048665912, 0.525500309973829|
|
Expected
- Manual test: $RANDSTRING(), $RANDSTRING(), $RANDSTRING()=|(three random strings of 8 alphanumeric/underscore characters)|
- Manual test: $RANDSTRING(A..NP..Z1..9, xxxx-xxxx-xxxx-xxxx), $RANDSTRING(A..NP..Z1..9, xxxx-xxxx-xxxx-xxxx), $RANDSTRING(A..NP..Z1..9, xxxx-xxxx-xxxx-xxxx)=|(three random strings, each of format xxxx-xxxx-xxxx-xxxx, composed of uppercase letters and numbers excluding letter O and number 0)|
|
Actual
- Manual test: $RANDSTRING(), $RANDSTRING(), $RANDSTRING()=|v_2DijTP, trKjKgBU, UrgrmIE6|
- Manual test: $RANDSTRING(A..NP..Z1..9, xxxx-xxxx-xxxx-xxxx), $RANDSTRING(A..NP..Z1..9, xxxx-xxxx-xxxx-xxxx), $RANDSTRING(A..NP..Z1..9, xxxx-xxxx-xxxx-xxxx)=|8VN4-MER5-U4T7-BQ53, YRBQ-LK6S-CWYL-KHKI, 82BD-8L8G-Y15T-5JZ3|
|
Expected
<-- expected REPEAT -->
- $REPEAT(/\, 10)=|/\/\/\/\/\/\/\/\/\/\|
- $REPEAT(x)=||
- $REPEAT()=||
<-- /expected -->
|
Actual
<-- actual -->
- $REPEAT(/\, 10)=|/\/\/\/\/\/\/\/\/\/\|
- $REPEAT(x)=||
- $REPEAT()=||
<-- /actual -->
|
Expected
<-- expected REPLACE -->
- $REPLACE(abcd, 2, 1, X)=|aXcd|
- $REPLACE(1023, 2, 1, X)=|1X23|
- $REPLACE(z_1023, 4, 1, X)=|z_1X23|
- $REPLACE(abcd, 2, 1)=|acd|
- $REPLACE(abcd, 2, 0)=|abcd|
- $REPLACE(abcd, 1, 3)=|d|
- $REPLACE(abcd, 1, 4)=||
- $REPLACE(abcd, 1, 4, YYYY)=|YYYY|
- $REPLACE(abcd, 2, 4, YYYY)=|aYYYY|
- $REPLACE(abcdefghijk,6,5,*)=|abcde*k|
- $REPLACE(abcd)=|abcd|
- $REPLACE()=||
<-- /expected -->
|
Actual
<-- actual -->
- $REPLACE(abcd, 2, 1, X)=|aXcd|
- $REPLACE(1023, 2, 1, X)=|1X23|
- $REPLACE(z_1023, 4, 1, X)=|z_1X23|
- $REPLACE(abcd, 2, 1)=|acd|
- $REPLACE(abcd, 2, 0)=|abcd|
- $REPLACE(abcd, 1, 3)=|d|
- $REPLACE(abcd, 1, 4)=||
- $REPLACE(abcd, 1, 4, YYYY)=|YYYY|
- $REPLACE(abcd, 2, 4, YYYY)=|aYYYY|
- $REPLACE(abcdefghijk,6,5,*)=|abcde*k|
- $REPLACE(abcd)=|abcd|
- $REPLACE()=||
<-- /actual -->
|
Expected
<-- expected RIGHT -->
$SUM($RIGHT())=|3| |
1 |
2 |
$SUM($RIGHT())=|7| |
3 |
4 |
<-- /expected -->
|
Actual
<-- actual -->
$SUM($RIGHT())=|3| |
1 |
2 |
$SUM($RIGHT())=|7| |
3 |
4 |
<-- /actual -->
|
Expected
<-- expected RIGHTSTRING -->
- $RIGHTSTRING(abcdefg)=|g|
- $RIGHTSTRING(abcdefg, 0)=|g|
- $RIGHTSTRING(abcdefg, 1)=|g|
- $RIGHTSTRING(abcdefg, 2)=|fg|
- $RIGHTSTRING()=||
<-- /expected -->
|
Actual
<-- actual -->
- $RIGHTSTRING(abcdefg)=|g|
- $RIGHTSTRING(abcdefg, 0)=|g|
- $RIGHTSTRING(abcdefg, 1)=|g|
- $RIGHTSTRING(abcdefg, 2)=|fg|
- $RIGHTSTRING()=||
<-- /actual -->
|
Expected
<-- expected ROUND -->
- $ROUND(3.15, 1)=|3.2|
- $ROUND(3.149, 1)=|3.1|
- $ROUND(-2.475, 2)=|-2.48|
- $ROUND(34.9, -1)=|30|
- $ROUND(12.34)=|12|
- $ROUND(12.51)=|13|
- $ROUND()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $ROUND(3.15, 1)=|3.2|
- $ROUND(3.149, 1)=|3.1|
- $ROUND(-2.475, 2)=|-2.48|
- $ROUND(34.9, -1)=|30|
- $ROUND(12.34)=|12|
- $ROUND(12.51)=|13|
- $ROUND()=|0|
<-- /actual -->
|
Function ROW
Expected
<-- expected ROW -->
$ROW()=1 |
$ROW()=1 |
$ROW()=2 |
$ROW(10)=12 |
$ROW()=3 |
$ROW(-10)=-7 |
<-- /expected -->
|
Actual
<-- actual -->
$ROW()=1 |
$ROW()=1 |
$ROW()=2 |
$ROW(10)=12 |
$ROW()=3 |
$ROW(-10)=-7 |
<-- /actual -->
|
Expected
<-- expected SEARCH -->
- $SEARCH([uy], fluffy)=|3|
- $SEARCH([uy], fluffy, 4)=|6|
- $SEARCH([abc], fluffy,)=|0|
- $SEARCH(abc)=|0|
- $SEARCH()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $SEARCH([uy], fluffy)=|3|
- $SEARCH([uy], fluffy, 4)=|6|
- $SEARCH([abc], fluffy,)=|0|
- $SEARCH(abc)=|0|
- $SEARCH()=|0|
<-- /actual -->
|
Function SET
Expected
<-- expected SET -->
- $SET(test, 1234)=||
- $GET(test)=|1234|
- $SET(sum, $SUM(1, 2, 3, 4))=||
- $GET(sum)=|10|
- $SET(novalue)=||
- $GET(novalue)=||
- $SET()=||
<-- /expected -->
|
Actual
<-- actual -->
- $SET(test, 1234)=||
- $GET(test)=|1234|
- $SET(sum, $SUM(1, 2, 3, 4))=||
- $GET(sum)=|10|
- $SET(novalue)=||
- $GET(novalue)=||
- $SET()=||
<-- /actual -->
|
Expected
<-- expected SETHASH -->
- $SETHASH()=||
- $SETHASH(age, Jane, 26)=||
- $GETHASH(age, Jane)=|26|
- $GETHASH()=|age|
<-- /expected -->
|
Actual
<-- actual -->
- $SETHASH()=||
- $SETHASH(age, Jane, 26)=||
- $GETHASH(age, Jane)=|26|
- $GETHASH()=|age|
<-- /actual -->
|
Expected
<-- expected SETIFEMPTY -->
- $SET(test, 1234)=||
- $SETIFEMPTY(test, 1)=||
- $GET(test)=|1234|
- $SET(test, 0)=||
- $SETIFEMPTY(test, 2)=||
- $GET(test)=|2|
- $SET(test,)=||
- $SETIFEMPTY(test, 3)=||
- $GET(test)=|3|
<-- /expected -->
|
Actual
<-- actual -->
- $SET(test, 1234)=||
- $SETIFEMPTY(test, 1)=||
- $GET(test)=|1234|
- $SET(test, 0)=||
- $SETIFEMPTY(test, 2)=||
- $GET(test)=|2|
- $SET(test,)=||
- $SETIFEMPTY(test, 3)=||
- $GET(test)=|3|
<-- /actual -->
|
Expected
<-- expected SETLIST -->
- $SETLIST(test, 1, '''2, 2.a, 2.b''', 3, 4)=||
- $GETLIST(test)=|1, 2, 2.a, 2.b, 3, 4|
- $LISTJOIN(; , $GETLIST(test))=|1; 2, 2.a, 2.b; 3; 4|
- $SETLIST(novalue)=||
- $GETLIST(novalue)=||
- $SETLIST()=||
<-- /expected -->
|
Actual
<-- actual -->
- $SETLIST(test, 1, '''2, 2.a, 2.b''', 3, 4)=||
- $GETLIST(test)=|1, 2, 2.a, 2.b, 3, 4|
- $LISTJOIN(; , $GETLIST(test))=|1; 2, 2.a, 2.b; 3; 4|
- $SETLIST(novalue)=||
- $GETLIST(novalue)=||
- $SETLIST()=||
<-- /actual -->
|
Function SETM
Expected
<-- expected SETM -->
- $SET(total, 10)=||
- $SETM(total, +5)=||
- $SETM(total)=||
- $GET(total)=|15|
- $SETM()=||
<-- /expected -->
|
Actual
<-- actual -->
- $SET(total, 10)=||
- $SETM(total, +5)=||
- $SETM(total)=||
- $GET(total)=|15|
- $SETM()=||
<-- /actual -->
|
Expected
<-- expected SETMHASH -->
- $SETHASH(count)=||
- $LISTJOIN(, $LISTEACH($SETMHASH(count, $item, +1), Anna, Jane, Berta, Charlie, Jane, Tom, Anna, Jane))=||
- $HASH2LIST(count, $key: $value)=|Anna: 2, Berta: 1, Charlie: 1, Jane: 3, Tom: 1|
- $SETMHASH(count, Jane, +1)=||
- $SETMHASH(count, Jane)=||
- $HASH2LIST(count, $key: $value)=|Anna: 2, Berta: 1, Charlie: 1, Jane: 4, Tom: 1|
<-- /expected -->
|
Actual
<-- actual -->
- $SETHASH(count)=||
- $LISTJOIN(, $LISTEACH($SETMHASH(count, $item, +1), Anna, Jane, Berta, Charlie, Jane, Tom, Anna, Jane))=||
- $HASH2LIST(count, $key: $value)=|Anna: 2, Berta: 1, Charlie: 1, Jane: 3, Tom: 1|
- $SETMHASH(count, Jane, +1)=||
- $SETMHASH(count, Jane)=||
- $HASH2LIST(count, $key: $value)=|Anna: 2, Berta: 1, Charlie: 1, Jane: 4, Tom: 1|
<-- /actual -->
|
Function SIGN
Expected
<-- expected SIGN -->
- $SIGN(12.34)=|1|
- $SIGN(2)=|1|
- $SIGN(0)=|0|
- $SIGN()=|0|
- $SIGN(-2)=|-1|
<-- /expected -->
|
Actual
<-- actual -->
- $SIGN(12.34)=|1|
- $SIGN(2)=|1|
- $SIGN(0)=|0|
- $SIGN()=|0|
- $SIGN(-2)=|-1|
<-- /actual -->
|
Expected
<-- expected SPLIT -->
- $SPLIT(, Apple Orange Kiwi)=|Apple, Orange, Kiwi|
- $SPLIT(-, Apple-Orange-Kiwi)=|Apple, Orange, Kiwi|
- $SPLIT([-:]$sp*, Apple-Orange: Kiwi)=|Apple, Orange, Kiwi|
- $SPLIT($empty, Apple)=|A, p, p, l, e|
- $SPLIT(x)=||
- $SPLIT()=||
<-- /expected -->
|
Actual
<-- actual -->
- $SPLIT(, Apple Orange Kiwi)=|Apple, Orange, Kiwi|
- $SPLIT(-, Apple-Orange-Kiwi)=|Apple, Orange, Kiwi|
- $SPLIT([-:]$sp*, Apple-Orange: Kiwi)=|Apple, Orange, Kiwi|
- $SPLIT($empty, Apple)=|A, p, p, l, e|
- $SPLIT(x)=||
- $SPLIT()=||
<-- /actual -->
|
Function SQRT
Expected
<-- expected SQRT -->
- $SQRT(16)=|4|
- $SQRT(1)=|1|
- $SQRT()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $SQRT(16)=|4|
- $SQRT(1)=|1|
- $SQRT()=|0|
<-- /actual -->
|
Expected
<-- expected STDEV -->
- $STDEV(2, 4, 4, 4, 5, 5, 7, 9)=|2.1380899352994|
- $STDEV(2, 5, 3, 12)=|4.50924975282289|
- $STDEV(2, 5, 3, xyz, 12)=|4.50924975282289|
- $STDEV(3.50, 5.00, 7.23, 2.99)=|1.90205152401295|
- $STDEV()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $STDEV(2, 4, 4, 4, 5, 5, 7, 9)=|2.1380899352994|
- $STDEV(2, 5, 3, 12)=|4.50924975282289|
- $STDEV(2, 5, 3, xyz, 12)=|4.50924975282289|
- $STDEV(3.50, 5.00, 7.23, 2.99)=|1.90205152401295|
- $STDEV()=|0|
<-- /actual -->
|
Expected
<-- expected STDEVP -->
- $STDEVP(2, 5, 3, 12)=|3.90512483795333|
- $STDEVP(2, 5, 3, xyz, 12)=|3.90512483795333|
- $STDEVP(3.50, 5.00, 7.23, 2.99)=|1.64722493910213|
- $STDEVP()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $STDEVP(2, 5, 3, 12)=|3.90512483795333|
- $STDEVP(2, 5, 3, xyz, 12)=|3.90512483795333|
- $STDEVP(3.50, 5.00, 7.23, 2.99)=|1.64722493910213|
- $STDEVP()=|0|
<-- /actual -->
|
Expected
<-- expected SUBSTITUTE -->
- $SUBSTITUTE(Good morning, morning, day)=|Good day|
- $SUBSTITUTE('''Good, early morning''', morning, '''day''')=|Good, early day|
- $SUBSTITUTE(Q2-2012, 2, 3)=|Q3-3013|
- $SUBSTITUTE(Q2-2012,2, 3, 3)=|Q2-2013|
- $SUBSTITUTE(abc123def, [0-9], 9, , r)=|abc999def|
- $SUBSTITUTE(abcd)=|abcd|
- $SUBSTITUTE()=||
<-- /expected -->
|
Actual
<-- actual -->
- $SUBSTITUTE(Good morning, morning, day)=|Good day|
- $SUBSTITUTE('''Good, early morning''', morning, '''day''')=|Good, early day|
- $SUBSTITUTE(Q2-2012, 2, 3)=|Q3-3013|
- $SUBSTITUTE(Q2-2012,2, 3, 3)=|Q2-2013|
- $SUBSTITUTE(abc123def, [0-9], 9, , r)=|abc999def|
- $SUBSTITUTE(abcd)=|abcd|
- $SUBSTITUTE()=||
<-- /actual -->
|
Expected
<-- expected SUBSTRING -->
- $SUBSTRING(abcdef,3,5)=|cdef|
- $SUBSTRING(abcdefgh,3,5)=|cdefg|
- $SUBSTRING(abcdefgh,8,5)=|h|
- $SUBSTRING(abcdefgh,9,5)=||
- $SUBSTRING(abcdefg,-2,2)=|fg|
- $SUBSTRING(abcdefg,-1,2)=|g|
- $SUBSTRING(abcdefg,-7,2)=|ab|
- $SUBSTRING(abcdefg,-8,2)=||
- $SUBSTRING(abcdefg,0,2)=||
- $SUBSTRING(abcdefg,1,2)=|ab|
- $SUBSTRING(abcdefg,2,2)=|bc|
- $SUBSTRING(abcdefg,2,-1)=|bcdef|
- $SUBSTRING(abcdefg,-2,-1)=|f|
- $SUBSTRING(abc,def,3,3)=|c,d|
- $SUBSTRING(abcdefg)=||
- $SUBSTRING()=||
<-- /expected -->
|
Actual
<-- actual -->
- $SUBSTRING(abcdef,3,5)=|cdef|
- $SUBSTRING(abcdefgh,3,5)=|cdefg|
- $SUBSTRING(abcdefgh,8,5)=|h|
- $SUBSTRING(abcdefgh,9,5)=||
- $SUBSTRING(abcdefg,-2,2)=|fg|
- $SUBSTRING(abcdefg,-1,2)=|g|
- $SUBSTRING(abcdefg,-7,2)=|ab|
- $SUBSTRING(abcdefg,-8,2)=||
- $SUBSTRING(abcdefg,0,2)=||
- $SUBSTRING(abcdefg,1,2)=|ab|
- $SUBSTRING(abcdefg,2,2)=|bc|
- $SUBSTRING(abcdefg,2,-1)=|bcdef|
- $SUBSTRING(abcdefg,-2,-1)=|f|
- $SUBSTRING(abc,def,3,3)=|c,d|
- $SUBSTRING(abcdefg)=||
- $SUBSTRING()=||
<-- /actual -->
|
Function SUM
Expected
<-- expected SUM -->
- $SUM(1, 2, 3, 4, 5)=|15|
- $SUM(1, x, 3, , 5)=|9|
- $SUM(1)=|1|
- $SUM()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $SUM(1, 2, 3, 4, 5)=|15|
- $SUM(1, x, 3, , 5)=|9|
- $SUM(1)=|1|
- $SUM()=|0|
<-- /actual -->
|
Expected
<-- expected SUMDAYS -->
- $SUMDAYS(2w, 1, 2d, 4h)=|13.5|
- $SUMDAYS(1w, x)=|5|
- $SUMDAYS()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $SUMDAYS(2w, 1, 2d, 4h)=|13.5|
- $SUMDAYS(1w, x)=|5|
- $SUMDAYS()=|0|
<-- /actual -->
|
Expected
<-- expected SUMPRODUCT -->
1 |
2 |
3 |
4 |
$SUMPRODUCT(R1:C1..R2:C1, R1:C2..R2:C2)=|14| |
$SUMPRODUCT(R1:C1..R2:C1, $ABOVE())=|14| |
<-- /expected -->
|
Actual
<-- actual -->
1 |
2 |
3 |
4 |
$SUMPRODUCT(R1:C1..R2:C1, R1:C2..R2:C2)=|14| |
$SUMPRODUCT(R1:C1..R2:C1, $ABOVE())=|14| |
<-- /actual -->
|
Function T
Expected
<-- expected T -->
1 |
2 |
3 |
4 |
$T(R2:C1)=|3| |
$T(R1:C2)=|2| |
<-- /expected -->
|
Actual
<-- actual -->
1 |
2 |
3 |
4 |
$T(R2:C1)=|3| |
$T(R1:C2)=|2| |
<-- /actual -->
|
Function TIME
Expected
<-- expected TIME -->
- $TIME(2012-12-31 GMT)=|1356912000|
<-- /expected -->
- Manual test: $TIME($FORMATTIME($TIME(), $year-$mo-$day))=|(today)|
|
Actual
<-- actual -->
- $TIME(2012-12-31 GMT)=|1356912000|
<-- /actual -->
- Manual test: $TIME($FORMATTIME($TIME(), $year-$mo-$day))=|2025-03-14|
|
Expected
<-- expected TIMEADD -->
- $FORMATTIME($TIMEADD($TIME(2012-12-31), 2, day), $year-$mo-$day)=|2013-01-02|
- $FORMATTIME($TIMEADD($TIME(2012-12-31), 2, year), $year-$mo-$day)=|2014-12-31|
- $TIMEADD($TIME(2012-12-31 GMT), 10)=|1356912010|
- $TIMEADD($TIME(2012-12-31 GMT), 10, sec)=|1356912010|
- $TIMEADD($TIME(2012-12-31 GMT), 2, min)=|1356912120|
- $TIMEADD()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $FORMATTIME($TIMEADD($TIME(2012-12-31), 2, day), $year-$mo-$day)=|2013-01-02|
- $FORMATTIME($TIMEADD($TIME(2012-12-31), 2, year), $year-$mo-$day)=|2014-12-31|
- $TIMEADD($TIME(2012-12-31 GMT), 10)=|1356912010|
- $TIMEADD($TIME(2012-12-31 GMT), 10, sec)=|1356912010|
- $TIMEADD($TIME(2012-12-31 GMT), 2, min)=|1356912120|
- $TIMEADD()=|0|
<-- /actual -->
|
Expected
<-- expected TIMEDIFF -->
- $TIMEDIFF($TIME(), $EVAL($TIME()+90), minute)=|1.5|
- $TIMEDIFF($ROUND($TIMEDIFF($TIME(2012-12-06),$TIME(2012-12-13), day)))=|7|
- $TIMEDIFF()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $TIMEDIFF($TIME(), $EVAL($TIME()+90), minute)=|1.5|
- $TIMEDIFF($ROUND($TIMEDIFF($TIME(2012-12-06),$TIME(2012-12-13), day)))=|7|
- $TIMEDIFF()=|0|
<-- /actual -->
|
Expected
<-- expected TODAY -->
- (can't be tested automatically)
<-- /expected -->
- Manual test: $TIME($FORMATTIME($TODAY(), $year-$mo-$day $hour:$min:$sec GMT))=|(this morning midnight GMT)|
|
Actual
<-- actual -->
- (can't be tested automatically)
<-- /actual -->
- Manual test: $TIME($FORMATTIME($TODAY(), $year-$mo-$day $hour:$min:$sec GMT))=|2025-03-14 00:00:00 GMT|
|
Expected
<-- expected TRANSLATE -->
- $TRANSLATE(boom,bm,cl)=|cool|
- $TRANSLATE(one, two,$comma,;)=|one; two|
- $TRANSLATE()=||
<-- /expected -->
|
Actual
<-- actual -->
- $TRANSLATE(boom,bm,cl)=|cool|
- $TRANSLATE(one, two,$comma,;)=|one; two|
- $TRANSLATE()=||
<-- /actual -->
|
Function TRIM
Expected
<-- expected TRIM -->
- $TRIM( eat spaces )=|eat spaces|
- $TRIM()=||
<-- /expected -->
|
Actual
<-- actual -->
- $TRIM( eat spaces )=|eat spaces|
- $TRIM()=||
<-- /actual -->
|
Expected
<-- expected UPPER -->
- $UPPER(this beCOMES an UPPER cASE String)=|THIS BECOMES AN UPPER CASE STRING|
- $UPPER()=||
<-- /expected -->
|
Actual
<-- actual -->
- $UPPER(this beCOMES an UPPER cASE String)=|THIS BECOMES AN UPPER CASE STRING|
- $UPPER()=||
<-- /actual -->
|
Expected
<-- expected VALUE -->
- $VALUE(US$1,200)=|1200|
- $VALUE(PrjNotebook1234)=|1234|
- $VALUE(Total: -12.5)=|-12.5|
- $VALUE()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $VALUE(US$1,200)=|1200|
- $VALUE(PrjNotebook1234)=|1234|
- $VALUE(Total: -12.5)=|-12.5|
- $VALUE()=|0|
<-- /actual -->
|
Function VAR
Expected
<-- expected VAR -->
- $VAR(1, 2, 3, 4, 5, 6)=|3.5|
- $VAR(2, 5, 3, 12)=|20.3333333333333|
- $VAR(2, 5, 3, xyz, 12)=|20.3333333333333|
- $VAR(3.50, 5.00, 7.23, 2.99)=|3.6178|
- $VAR()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $VAR(1, 2, 3, 4, 5, 6)=|3.5|
- $VAR(2, 5, 3, 12)=|20.3333333333333|
- $VAR(2, 5, 3, xyz, 12)=|20.3333333333333|
- $VAR(3.50, 5.00, 7.23, 2.99)=|3.6178|
- $VAR()=|0|
<-- /actual -->
|
Function VARP
Expected
<-- expected VARP -->
- $VARP(1, 2, 3, 4, 5, 6)=|2.91666666666667|
- $VARP(2, 5, 3, 12)=|15.25|
- $VARP(2, 5, 3, xyz, 12)=|15.25|
- $VARP(3.50, 5.00, 7.23, 2.99)=|2.71335|
- $VARP()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $VARP(1, 2, 3, 4, 5, 6)=|2.91666666666667|
- $VARP(2, 5, 3, 12)=|15.25|
- $VARP(2, 5, 3, xyz, 12)=|15.25|
- $VARP(3.50, 5.00, 7.23, 2.99)=|2.71335|
- $VARP()=|0|
<-- /actual -->
|
Expected
<-- expected WHILE -->
- $WHILE($counter<=10, $counter )=|1 2 3 4 5 6 7 8 9 10 |
- $SET(i, 0)$WHILE($GET(i)<10, $SETM(i, +1) $EVAL($GET(i) * $GET(i)), )=| 1, 4, 9, 16, 25, 36, 49, 64, 81, 100, |
- $WHILE()=||
<-- /expected -->
|
Actual
<-- actual -->
- $WHILE($counter<=10, $counter )=|1 2 3 4 5 6 7 8 9 10 |
- $SET(i, 0)$WHILE($GET(i)<10, $SETM(i, +1) $EVAL($GET(i) * $GET(i)), )=| 1, 4, 9, 16, 25, 36, 49, 64, 81, 100, |
- $WHILE()=||
<-- /actual -->
|
Expected
<-- expected WORKINGDAYS -->
- $WORKINGDAYS($TIME(2012-07-15 GMT), $TIME(2012-08-03 GMT))=|14|
- $WORKINGDAYS()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $WORKINGDAYS($TIME(2012-07-15 GMT), $TIME(2012-08-03 GMT))=|14|
- $WORKINGDAYS()=|0|
<-- /actual -->
|
Function XOR
Expected
<-- expected XOR -->
- $XOR(0)=|0|
- $XOR(1)=|0|
- $XOR(0, 0)=|0|
- $XOR(0, 1)=|1|
- $XOR(1, 0)=|1|
- $XOR(1, 1)=|0|
- $XOR(0, 1, 2, 3)=|1|
- $XOR(1, 2, 3, 4)=|0|
- $XOR()=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $XOR(0)=|0|
- $XOR(1)=|0|
- $XOR(0, 0)=|0|
- $XOR(0, 1)=|1|
- $XOR(1, 0)=|1|
- $XOR(1, 1)=|0|
- $XOR(0, 1, 2, 3)=|1|
- $XOR(1, 2, 3, 4)=|0|
- $XOR()=|0|
<-- /actual -->
|
Related Topics: SpreadSheetPlugin, VarCALC, VarCALCULATE
-- TWiki:Main.PeterThoeny - 2014-10-24 |