---+ !SpreadSheetPlugin Testing Use this topic to verify proper operation of the SpreadSheetPlugin in your environment. For developers: This topic is included by TestCases.TestCaseAutoSpreadSheetPlugin for automated integration testing. This requires the TWiki:Plugins.TestFixturePlugin and a repository checkout. ---++ CALC{} and CALCULATE{} <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected CALC_and_CALCULATE --> <ul> <li>CALC{$REPLACE(1234, 2, 1, X)}=|1X34| </li> <li>CALCULATE{$REPLACE(1234, 2, 1, X)}=|1X34| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * CALC{$REPLACE(1234, 2, 1, X)}=|%CALCULATE{$REPLACE(1234, 2, 1, X)}%| * CALCULATE{$REPLACE(1234, 2, 1, X)}=|%CALCULATE{$REPLACE(1234, 2, 1, X)}%| <!-- /actual --> </td></tr></table> __NOTE:__ All functions that follow are tested via: * CALC{} if reference is done to table cells * CALCULATE{} otherwise ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncABOVE][ABOVE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ABOVE --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> A1 </td> <td> B1 </td> </tr> <tr> <td> A2 </td> <td> B2 </td> </tr> <tr> <td> $ABOVE()=R0:C1..R2:C1 </td> <td> $ABOVE()=R0:C2..R2:C2 </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> | A1 | B1 | | A2 | B2 | | $ABOVE()=%CALC{$ABOVE()}% | $ABOVE()=%CALC{$ABOVE()}% | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncABS][ABS]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ABS --> <ul> <li>$ABS(-2)=|2| </li> <li>$ABS(-0.5)=|0.5| </li> <li>$ABS(0)=|0| </li> <li>$ABS(0.5)=|0.5| </li> <li>$ABS(2)=|2| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $ABS(-2)=|%CALCULATE{$ABS(-2)}%| * $ABS(-0.5)=|%CALCULATE{$ABS(-0.5)}%| * $ABS(0)=|%CALCULATE{$ABS(0)}%| * $ABS(0.5)=|%CALCULATE{$ABS(0.5)}%| * $ABS(2)=|%CALCULATE{$ABS(2)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncADDLIST][ADDLIST]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ADDLIST --> <ul> <li>$SETLIST(test)=|| </li> <li>$ADDLIST(test, 1, 2)=|| </li> <li>$GETLIST(test)=|1, 2| </li> <li>$ADDLIST(test, 3, 4)=|| </li> <li>$GETLIST(test)=|1, 2, 3, 4| </li> <li>$ADDLIST(novalue)=|| </li> <li>$GETLIST(novalue)=|| </li> <li>$ADDLIST()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETLIST(test)=|%CALCULATE{$SETLIST(test)}%| * $ADDLIST(test, 1, 2)=|%CALCULATE{$ADDLIST(test, 1, 2)}%| * $GETLIST(test)=|%CALCULATE{$GETLIST(test)}%| * $ADDLIST(test, 3, 4)=|%CALCULATE{$ADDLIST(test, 3, 4)}%| * $GETLIST(test)=|%CALCULATE{$GETLIST(test)}%| * $ADDLIST(novalue)=|%CALCULATE{$ADDLIST(novalue)}%| * $GETLIST(novalue)=|%CALCULATE{$GETLIST(novalue)}%| * $ADDLIST()=|%CALCULATE{$ADDLIST()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncAND][AND]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected AND --> <ul> <li>$AND()=|0| </li> <li>$AND(0)=|0| </li> <li>$AND(1)=|1| </li> <li>$AND(0, 0)=|0| </li> <li>$AND(0, 1)=|0| </li> <li>$AND(1, 0)=|0| </li> <li>$AND(1, 1)=|1| </li> <li>$AND(0, 1, 2, 3)=|0| </li> <li>$AND(1, 2, 3, 4)=|1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $AND()=|%CALCULATE{$AND(0)}%| * $AND(0)=|%CALCULATE{$AND(0)}%| * $AND(1)=|%CALCULATE{$AND(1)}%| * $AND(0, 0)=|%CALCULATE{$AND(0, 0)}%| * $AND(0, 1)=|%CALCULATE{$AND(0, 1)}%| * $AND(1, 0)=|%CALCULATE{$AND(1, 0)}%| * $AND(1, 1)=|%CALCULATE{$AND(1, 1)}%| * $AND(0, 1, 2, 3)=|%CALCULATE{$AND(0, 1, 2, 3)}%| * $AND(1, 2, 3, 4)=|%CALCULATE{$AND(1, 2, 3, 4)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncAVERAGE][AVERAGE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected AVERAGE --> <ul> <li>$AVERAGE()=|0| </li> <li>$AVERAGE(x)=|0| </li> <li>$AVERAGE(0)=|0| </li> <li>$AVERAGE(0, 1)=|0.5| </li> <li>$AVERAGE(0, 1, 2)=|1| </li> <li>$AVERAGE(1.5, 2, 2.5)=|2| </li> <li>$AVERAGE(-1.5, 2, 2.5)=|1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $AVERAGE()=|%CALCULATE{$AVERAGE()}%| * $AVERAGE(x)=|%CALCULATE{$AVERAGE(x)}%| * $AVERAGE(0)=|%CALCULATE{$AVERAGE(0)}%| * $AVERAGE(0, 1)=|%CALCULATE{$AVERAGE(0, 1)}%| * $AVERAGE(0, 1, 2)=|%CALCULATE{$AVERAGE(0, 1, 2)}%| * $AVERAGE(1.5, 2, 2.5)=|%CALCULATE{$AVERAGE(1.5, 2, 2.5)}%| * $AVERAGE(-1.5, 2, 2.5)=|%CALCULATE{$AVERAGE(-1.5, 2, 2.5)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncBIN2DEC][BIN2DEC]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected BIN2DEC --> <ul> <li>$BIN2DEC(1100100)=|100| </li> <li>$BIN2DEC(1010101010101010101)=|349525| </li> <li>$BIN2DEC()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $BIN2DEC(1100100)=|%CALCULATE{$BIN2DEC(1100100)}%| * $BIN2DEC(1010101010101010101)=|%CALCULATE{$BIN2DEC(1010101010101010101)}%| * $BIN2DEC()=|%CALCULATE{$BIN2DEC()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncBITXOR][BITXOR]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected BITXOR --> <ul> <li>$BITXOR()=|| </li> <li>$BITXOR(A123)=|¾ÎÍÌ| </li> <li>$BITXOR($BITXOR(anything))=|anything| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $BITXOR()=|%CALCULATE{$BITXOR()}%| * $BITXOR(A123)=|%CALCULATE{$BITXOR(A123)}%| * $BITXOR($BITXOR(anything))=|%CALCULATE{$BITXOR($BITXOR(anything))}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncCEILING][CEILING]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected CEILING --> <ul> <li>$CEILING(5.4)=|6| </li> <li>$CEILING(-5.4)=|-5| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $CEILING(5.4)=|%CALCULATE{$CEILING(5.4)}%| * $CEILING(-5.4)=|%CALCULATE{$CEILING(-5.4)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncCHAR][CHAR]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected CHAR --> <ul> <li>$CHAR(97)=|a| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $CHAR(97)=|%CALCULATE{$CHAR(97)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncCODE][CODE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected CODE --> <ul> <li>$CODE(abc)=|97| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $CODE(abc)=|%CALCULATE{$CODE(abc)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncCOLUMN][COLUMN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected COLUMN --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> $COLUMN()=1 </td> <td> $COLUMN()=2 </td> </tr> <tr> <td> $COLUMN()=1 </td> <td> $COLUMN()=2 </td> </tr> <tr> <td> $COLUMN()=1 </td> <td> $COLUMN()=2 </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> | $COLUMN()=%CALC{$COLUMN()}% | $COLUMN()=%CALC{$COLUMN()}% | | $COLUMN()=%CALC{$COLUMN()}% | $COLUMN()=%CALC{$COLUMN()}% | | $COLUMN()=%CALC{$COLUMN()}% | $COLUMN()=%CALC{$COLUMN()}% | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncCOUNTITEMS][COUNTITEMS]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected COUNTITEMS --> <ul> <li> $COUNTITEMS(One)=|One: 1| </li> <li> $COUNTITEMS(One, Two)=|One: 1<br /> Two: 1| </li> <li> $COUNTITEMS(One, Two, One)=|One: 2<br /> Two: 1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $COUNTITEMS(One)=|%CALCULATE{$COUNTITEMS(One)}%| * $COUNTITEMS(One, Two)=|%CALCULATE{$COUNTITEMS(One, Two)}%| * $COUNTITEMS(One, Two, One)=|%CALCULATE{$COUNTITEMS(One, Two, One)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncCOUNTSTR][COUNTSTR]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected COUNTSTR --> <ul> <li>$COUNTSTR(Done, , Done, OK, )=|3| </li> <li>$COUNTSTR(Done, , Done, OK, Done)=|2| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $COUNTSTR(Done, , Done, OK, )=|%CALCULATE{$COUNTSTR(Done, , Done, OK, )}%| * $COUNTSTR(Done, , Done, OK, Done)=|%CALCULATE{$COUNTSTR(Done, , Done, OK, Done)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncDEC2BIN][DEC2BIN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected DEC2BIN --> <ul> <li>$DEC2BIN(9)=|1001| </li> <li>$DEC2BIN(9, 6)=|001001| </li> <li>$DEC2BIN(-100)=|11111111111111111111111110011100| </li> <li>$DEC2BIN()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $DEC2BIN(9)=|%CALCULATE{$DEC2BIN(9)}%| * $DEC2BIN(9, 6)=|%CALCULATE{$DEC2BIN(9, 6)}%| * $DEC2BIN(-100)=|%CALCULATE{$DEC2BIN(-100)}%| * $DEC2BIN()=|%CALCULATE{$DEC2BIN()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncDEC2HEX][DEC2HEX]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected DEC2HEX --> <ul> <li>$DEC2HEX(165)=|A5| </li> <li>$DEC2HEX(100, 4)=|0064| </li> <li>$DEC2HEX(-54)=|FFFFFFCA| </li> <li>$DEC2HEX()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $DEC2HEX(165)=|%CALCULATE{$DEC2HEX(165)}%| * $DEC2HEX(100, 4)=|%CALCULATE{$DEC2HEX(100, 4)}%| * $DEC2HEX(-54)=|%CALCULATE{$DEC2HEX(-54)}%| * $DEC2HEX()=|%CALCULATE{$DEC2HEX()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncDEC2OCT][DEC2OCT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected DEC2OCT --> <ul> <li>$DEC2OCT(58)=|72| </li> <li>$DEC2OCT(58, 3)=|072| </li> <li>$DEC2OCT()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $DEC2OCT(58)=|%CALCULATE{$DEC2OCT(58)}%| * $DEC2OCT(58, 3)=|%CALCULATE{$DEC2OCT(58, 3)}%| * $DEC2OCT()=|%CALCULATE{$DEC2OCT()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncDEF][DEF]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected DEF --> <ul> <li>$DEF(One, Two, Three)=|One| </li> <li>$DEF(, Two, Three)=|Two| </li> <li>$DEF(, , Three)=|Three| </li> <li>$DEF(, , )=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $DEF(One, Two, Three)=|%CALCULATE{$DEF(One, Two, Three)}%| * $DEF(, Two, Three)=|%CALCULATE{$DEF(, Two, Three)}%| * $DEF(, , Three)=|%CALCULATE{$DEF(, , Three)}%| * $DEF(, , )=|%CALCULATE{$DEF(, , )}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEMPTY][EMPTY]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected EMPTY --> <ul> <li>$EMPTY()=|1| </li> <li>$EMPTY( )=|0| </li> <li>$EMPTY(foo)=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $EMPTY()=|%CALCULATE{$EMPTY()}%| * $EMPTY( )=|%CALCULATE{$EMPTY( )}%| * $EMPTY(foo)=|%CALCULATE{$EMPTY(foo)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEQUAL][EQUAL]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected EQUAL --> <ul> <li>$EQUAL(foo, foo)=|1| </li> <li>$EQUAL(foo, Foo)=|1| </li> <li>$EQUAL(foo, bar)=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $EQUAL(foo, foo)=|%CALCULATE{$EQUAL(foo, foo)}%| * $EQUAL(foo, Foo)=|%CALCULATE{$EQUAL(foo, Foo)}%| * $EQUAL(foo, bar)=|%CALCULATE{$EQUAL(foo, bar)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEVAL][EVAL]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected EVAL --> <ul> <li>$EVAL( (5 * 3) / 2 + 1.1 )=|8.6| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $EVAL( (5 * 3) / 2 + 1.1 )=|%CALCULATE{$EVAL( (5 * 3) / 2 + 1.1 )}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEVEN][EVEN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected EVEN --> <ul> <li>$EVEN()=|1| </li> <li>$EVEN(-1)=|0| </li> <li>$EVEN(0)=|1| </li> <li>$EVEN(1)=|0| </li> <li>$EVEN(2)=|1| </li> <li>$EVEN(3.4)=|0| </li> <li>$EVEN(4.4)=|1| </li> <li>$EVEN(4.6)=|1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $EVEN()=|%CALCULATE{$EVEN()}%| * $EVEN(-1)=|%CALCULATE{$EVEN(-1)}%| * $EVEN(0)=|%CALCULATE{$EVEN(0)}%| * $EVEN(1)=|%CALCULATE{$EVEN(1)}%| * $EVEN(2)=|%CALCULATE{$EVEN(2)}%| * $EVEN(3.4)=|%CALCULATE{$EVEN(3.4)}%| * $EVEN(4.4)=|%CALCULATE{$EVEN(4.4)}%| * $EVEN(4.6)=|%CALCULATE{$EVEN(4.6)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEXACT][EXACT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected EXACT --> <ul> <li>$EXACT(foo, Foo)=|0| </li> <li>$EXACT(foo, $LOWER(Foo))=|1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $EXACT(foo, Foo)=|%CALCULATE{$EXACT(foo, Foo)}%| * $EXACT(foo, $LOWER(Foo))=|%CALCULATE{$EXACT(foo, $LOWER(Foo))}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEXEC][EXEC]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected EXEC --> <ul> <li>$SET(msg, $NOEXEC(Hi $GET(name)))=|| </li> <li>$EXEC($SET(name, Tom) $EXEC($GET(msg)))=| Hi Tom| </li> <li>$EXEC($SET(name, Jerry) $EXEC($GET(msg)))=| Hi Jerry| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SET(msg, $NOEXEC(Hi $GET(name)))=|%CALCULATE{$SET(msg, $NOEXEC(Hi $GET(name)))}%| * $EXEC($SET(name, Tom) $EXEC($GET(msg)))=|%CALCULATE{$EXEC($SET(name, Tom) $EXEC($GET(msg)))}%| * $EXEC($SET(name, Jerry) $EXEC($GET(msg)))=|%CALCULATE{$EXEC($SET(name, Jerry) $EXEC($GET(msg)))}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEXISTS][EXISTS]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected EXISTS --> <ul> <li>$EXISTS(WebHome)=|1| </li> <li>$EXISTS(ThisDoesNotExist)=|0| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $EXISTS(WebHome)=|%CALCULATE{$EXISTS(WebHome)}%| * $EXISTS(ThisDoesNotExist)=|%CALCULATE{$EXISTS(ThisDoesNotExist)}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncEXP][EXP]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected EXP --> <ul> <li>$EXP(1)=|2.71828182845905| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $EXP(1)=|%CALCULATE{$EXP(1)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncFILTER][FILTER]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected FILTER --> <ul> <li>$FILTER(f, fluffy)=|luy| </li> <li>$FILTER(an Franc, San Francisco)=|Sisco| </li> <li>$FILTER($sp, Cat and Mouse)=|CatandMouse| </li> <li>$FILTER([^0-9], Project-ID-1234)=|1234| </li> <li>$FILTER([^a-zA-Z0-9 ], Stupid mistake*%@^! Fixed)=|Stupid mistake Fixed| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FILTER(f, fluffy)=|%CALCULATE{$FILTER(f, fluffy)}%| * $FILTER(an Franc, San Francisco)=|%CALCULATE{$FILTER(an Franc, San Francisco)}%| * $FILTER($sp, Cat and Mouse)=|%CALCULATE{$FILTER($sp, Cat and Mouse)}%| * $FILTER([^0-9], Project-ID-1234)=|%CALCULATE{$FILTER([^0-9], Project-ID-1234)}%| * $FILTER([^a-zA-Z0-9 ], Stupid mistake*%@^! Fixed)=|%CALCULATE{$FILTER([^a-zA-Z0-9 ], Stupid mistake*%@^! Fixed)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncFIND][FIND]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected FIND --> <ul> <li>$FIND(f, fluffy)=|1| </li> <li>$FIND(f, fluffy, 2)=|4| </li> <li>$FIND(x, fluffy, 1)=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FIND(f, fluffy)=|%CALCULATE{$FIND(f, fluffy)}%| * $FIND(f, fluffy, 2)=|%CALCULATE{$FIND(f, fluffy, 2)}%| * $FIND(x, fluffy, 1)=|%CALCULATE{$FIND(x, fluffy, 1)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncFLOOR][FLOOR]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected FLOOR --> <ul> <li>$FLOOR(5.4)=|5| </li> <li>$FLOOR(-5.4)=|-6| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FLOOR(5.4)=|%CALCULATE{$FLOOR(5.4)}%| * $FLOOR(-5.4)=|%CALCULATE{$FLOOR(-5.4)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncFORMAT][FORMAT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected FORMAT --> <ul> <li>$FORMAT(COMMA, 2, 12345.6789)=|12,345.68| </li> <li>$FORMAT(DOLLAR, 2, 12345.6789)=|$12,345.68| </li> <li>$FORMAT(KB, 2, 1234567)=|1205.63 KB| </li> <li>$FORMAT(MB, 2, 1234567)=|1.18 MB| </li> <li>$FORMAT(KBMB, 2, 1234567)=|1.18 MB| </li> <li>$FORMAT(KBMB, 2, 1234567890)=|1.15 GB| </li> <li>$FORMAT(NUMBER, 1, 12345.67)=|12345.7| </li> <li>$FORMAT(PERCENT, 1, 0.1234567)=|12.3%| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FORMAT(COMMA, 2, 12345.6789)=|%CALCULATE{$FORMAT(COMMA, 2, 12345.6789)}%| * $FORMAT(DOLLAR, 2, 12345.6789)=|%CALCULATE{$FORMAT(DOLLAR, 2, 12345.6789)}%| * $FORMAT(KB, 2, 1234567)=|%CALCULATE{$FORMAT(KB, 2, 1234567)}%| * $FORMAT(MB, 2, 1234567)=|%CALCULATE{$FORMAT(MB, 2, 1234567)}%| * $FORMAT(KBMB, 2, 1234567)=|%CALCULATE{$FORMAT(KBMB, 2, 1234567)}%| * $FORMAT(KBMB, 2, 1234567890)=|%CALCULATE{$FORMAT(KBMB, 2, 1234567890)}%| * $FORMAT(NUMBER, 1, 12345.67)=|%CALCULATE{$FORMAT(NUMBER, 1, 12345.67)}%| * $FORMAT(PERCENT, 1, 0.1234567)=|%CALCULATE{$FORMAT(PERCENT, 1, 0.1234567)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncFORMATGMTIME][FORMATGMTIME]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected FORMATGMTIME --> <ul> <li>$FORMATGMTIME(1041379200, $day $mon $year)=|01 Jan 2003| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FORMATGMTIME(1041379200, $day $mon $year)=|%CALCULATE{$FORMATGMTIME(1041379200, $day $mon $year)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncFORMATTIME][FORMATTIME]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected FORMATTIME --> <ul> <li>$FORMATTIME(0, $year/$month/$day GMT)=|1970/01/01 GMT| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FORMATTIME(0, $year/$month/$day GMT)=|%CALCULATE{$FORMATTIME(0, $year/$month/$day GMT)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncFORMATTIMEDIFF][FORMATTIMEDIFF]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected FORMATTIMEDIFF --> <ul> <li>$FORMATTIMEDIFF(min, 1, 200)=|3 hours| </li> <li>$FORMATTIMEDIFF(min, 2, 200)=|3 hours and 20 minutes| </li> <li>$FORMATTIMEDIFF(min, 1, 1640)=|1 day| </li> <li>$FORMATTIMEDIFF(min, 2, 1640)=|1 day and 3 hours| </li> <li>$FORMATTIMEDIFF(min, 3, 1640)=|1 day, 3 hours and 20 minutes| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FORMATTIMEDIFF(min, 1, 200)=|%CALCULATE{$FORMATTIMEDIFF(min, 1, 200)}%| * $FORMATTIMEDIFF(min, 2, 200)=|%CALCULATE{$FORMATTIMEDIFF(min, 2, 200)}%| * $FORMATTIMEDIFF(min, 1, 1640)=|%CALCULATE{$FORMATTIMEDIFF(min, 1, 1640)}%| * $FORMATTIMEDIFF(min, 2, 1640)=|%CALCULATE{$FORMATTIMEDIFF(min, 2, 1640)}%| * $FORMATTIMEDIFF(min, 3, 1640)=|%CALCULATE{$FORMATTIMEDIFF(min, 3, 1640)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncGET][GET]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected GET --> <ul> <li>$SET(test, 1234)=|| </li> <li>$GET(test)=|1234| </li> <li>$GET()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SET(test, 1234)=|%CALCULATE{$SET(test, 1234)}%| * $GET(test)=|%CALCULATE{$GET(test)}%| * $GET()=|%CALCULATE{$GET()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncGETHASH][GETHASH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected GETHASH --> <ul> <li>$SETHASH()=|| </li> <li>$SETHASH(age, Jane, 26)=|| </li> <li>$SETHASH(age, Tim, 27)=|| </li> <li>$SETHASH(sex, Jane, F)=|| </li> <li>$SETHASH(sex, Tim, M)=|| </li> <li>$GETHASH(age, Jane)=|26| </li> <li>$SETHASH(age, Jane)=|| </li> <li>$GETHASH(age, Jane)=|| </li> <li>$GETHASH(sex)=|Jane, Tim| </li> <li>$GETHASH(foo, bar)=|| </li> <li>$GETHASH(foo)=|| </li> <li>$GETHASH()=|age, sex| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $SETHASH(age, Jane, 26)=|%CALCULATE{$SETHASH(age, Jane, 26)}%| * $SETHASH(age, Tim, 27)=|%CALCULATE{$SETHASH(age, Tim, 27)}%| * $SETHASH(sex, Jane, F)=|%CALCULATE{$SETHASH(sex, Jane, F)}%| * $SETHASH(sex, Tim, M)=|%CALCULATE{$SETHASH(sex, Tim, M)}%| * $GETHASH(age, Jane)=|%CALCULATE{$GETHASH(age, Jane)}%| * $SETHASH(age, Jane)=|%CALCULATE{$SETHASH(age, Jane)}%| * $GETHASH(age, Jane)=|%CALCULATE{$GETHASH(age, Jane)}%| * $GETHASH(sex)=|%CALCULATE{$GETHASH(sex)}%| * $GETHASH(foo, bar)=|%CALCULATE{$GETHASH(foo, bar)}%| * $GETHASH(foo)=|%CALCULATE{$GETHASH(foo)}%| * $GETHASH()=|%CALCULATE{$GETHASH()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncGETLIST][GETLIST]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected GETLIST --> <ul> <li>$SETLIST(test, 1, 2, 3, 4)=|| </li> <li>$GETLIST(test)=|1, 2, 3, 4| </li> <li>$GETLIST()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETLIST(test, 1, 2, 3, 4)=|%CALCULATE{$SETLIST(test, 1, 2, 3, 4)}%| * $GETLIST(test)=|%CALCULATE{$GETLIST(test)}%| * $GETLIST()=|%CALCULATE{$GETLIST()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHASH2LIST][HASH2LIST]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected HASH2LIST --> <ul> <li>$SETHASH()=|| </li> <li>$LIST2HASH(age, Jane, 26, Tim, 27)=|| </li> <li>$HASH2LIST(age)=|Jane, 26, Tim, 27| </li> <li>$HASH2LIST(age, $key is $value)=|Jane is 26, Tim is 27| </li> <li>$HASH2LIST(age, $key)=|Jane, Tim| </li> <li>$HASH2LIST(age, $value)=|26, 27| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $LIST2HASH(age, Jane, 26, Tim, 27)=|%CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27)}%| * $HASH2LIST(age)=|%CALCULATE{$HASH2LIST(age)}%| * $HASH2LIST(age, $key is $value)=|%CALCULATE{$HASH2LIST(age, $key is $value)}%| * $HASH2LIST(age, $key)=|%CALCULATE{$HASH2LIST(age, $key)}%| * $HASH2LIST(age, $value)=|%CALCULATE{$HASH2LIST(age, $value)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHASHCOPY][HASHCOPY]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected HASHCOPY --> <ul> <li>$SETHASH()=|| </li> <li>$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)=|| </li> <li>$HASHCOPY(age, new)=|| </li> <li>$SETHASH(age, Old, 95)=|| </li> <li>$SETHASH(new, New, 1)=|| </li> <li>$HASH2LIST(age, $key: $value)=|Jane: 26, Old: 95, Sam: 27, Tim: 27| </li> <li>$HASH2LIST(new, $key: $value)=|Jane: 26, New: 1, Sam: 27, Tim: 27| </li> <li>$HASHCOPY(age)=|| </li> <li>$HASHCOPY()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)=|%CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)}%| * $HASHCOPY(age, new)=|%CALCULATE{$HASHCOPY(age, new)}%| * $SETHASH(age, Old, 95)=|%CALCULATE{$SETHASH(age, Old, 95)}%| * $SETHASH(new, New, 1)=|%CALCULATE{$SETHASH(new, New, 1)}%| * $HASH2LIST(age, $key: $value)=|%CALCULATE{$HASH2LIST(age, $key: $value)}%| * $HASH2LIST(new, $key: $value)=|%CALCULATE{$HASH2LIST(new, $key: $value)}%| * $HASHCOPY(age)=|%CALCULATE{$HASHCOPY(age)}%| * $HASHCOPY()=|%CALCULATE{$HASHCOPY()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHASHEACH][HASHEACH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected HASHEACH --> <ul> <li>$SETHASH()=|| </li> <li>$LIST2HASH(age, Jane, 26, Tim, 27)=|| </li> <li>$HASHEACH($key is $INT($value * 2 + $index), age)=|| </li> <li>$HASH2LIST(age, $key: $value)=|Jane: Jane is 53, Tim: Tim is 56| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $LIST2HASH(age, Jane, 26, Tim, 27)=|%CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27)}%| * $HASHEACH($key is $INT($value * 2 + $index), age)=|%CALCULATE{$HASHEACH($key is $INT($value * 2 + $index), age)}%| * $HASH2LIST(age, $key: $value)=|%CALCULATE{$HASH2LIST(age, $key: $value)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHASHEXISTS][HASHEXISTS]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected HASHEXISTS --> <ul> <li>$SETHASH()=|| </li> <li>$LIST2HASH(age, Jane, 26, Tim, 27)=|| </li> <li>$HASHEXISTS(age)=|1| </li> <li>$HASHEXISTS(age, Jane)=|1| </li> <li>$HASHEXISTS(age, Blake)=|0| </li> <li>$HASHEXISTS(height)=|0| </li> <li>$HASHEXISTS()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $LIST2HASH(age, Jane, 26, Tim, 27)=|%CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27)}%| * $HASHEXISTS(age)=|%CALCULATE{$HASHEXISTS(age)}%| * $HASHEXISTS(age, Jane)=|%CALCULATE{$HASHEXISTS(age, Jane)}%| * $HASHEXISTS(age, Blake)=|%CALCULATE{$HASHEXISTS(age, Blake)}%| * $HASHEXISTS(height)=|%CALCULATE{$HASHEXISTS(height)}%| * $HASHEXISTS()=|%CALCULATE{$HASHEXISTS()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHASHREVERSE][HASHREVERSE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected HASHREVERSE --> <ul> <li>$SETHASH()=|| </li> <li>$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)=|| </li> <li>$HASHREVERSE(age)=|| </li> <li>$HASH2LIST(age, $key: $value)=|26: Jane, 27: Tim| </li> <li>$HASHREVERSE(height)=|| </li> <li>$HASH2LIST(height)=|| </li> <li>$HASHREVERSE()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)=|%CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)}%| * $HASHREVERSE(age)=|%CALCULATE{$HASHREVERSE(age)}%| * $HASH2LIST(age, $key: $value)=|%CALCULATE{$HASH2LIST(age, $key: $value)}%| * $HASHREVERSE(height)=|%CALCULATE{$HASHREVERSE(height)}%| * $HASH2LIST(height)=|%CALCULATE{$HASH2LIST(height)}%| * $HASHREVERSE()=|%CALCULATE{$HASHREVERSE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHEX2DEC][HEX2DEC]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected HEX2DEC --> <ul> <li>$HEX2DEC(A5)=|165| </li> <li>$HEX2DEC(3DA408B9)=|1034160313| </li> <li>$HEX2DEC()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $HEX2DEC(A5)=|%CALCULATE{$HEX2DEC(A5)}%| * $HEX2DEC(3DA408B9)=|%CALCULATE{$HEX2DEC(3DA408B9)}%| * $HEX2DEC()=|%CALCULATE{$HEX2DEC()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHEXDECODE][HEXDECODE]] <table class="testSideBySide"><tr><td> ---+++ Expected <literal> <!-- expected HEXDECODE --> <ul> <li>$HEXDECODE(687474703A2F2F7477696B692E6F72672F)=|http://twiki.org/| </li> </ul> <!-- /expected --> </literal> </td><td> ---+++ Actual <!-- actual --> * <literal>$HEXDECODE(687474703A2F2F7477696B692E6F72672F)=|%CALCULATE{$HEXDECODE(687474703A2F2F7477696B692E6F72672F)}%|</literal> <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncHEXENCODE][HEXENCODE]] <table class="testSideBySide"><tr><td> ---+++ Expected <literal> <!-- expected HEXENCODE --> <ul> <li>$HEXENCODE(http://twiki.org/)=|687474703A2F2F7477696B692E6F72672F| </li> </ul> <!-- /expected --> </td><td> </literal> ---+++ Actual <!-- actual --> * $<literal>HEXENCODE(http://twiki.org/)=|%CALCULATE{$HEXENCODE(http://twiki.org/)}%|</literal> <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncIF][IF]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected IF --> <ul> <li>$SET(test_number, 123)=|| </li> <li>$IF($GET(test_number)>100, greater)=|greater| </li> <li>$SET(test_string, San Francisco)=|| </li> <li>$IF($EXACT($GET(test_string), Cupertino), equal, not equal)=|not equal| </li> <li>$SET(result, $IF($GET(test_number)==0, zero, $GET(test_number)))=|| </li> <li>$GET(result)=|123| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SET(test_number, 123)=|%CALCULATE{$SET(test_number, 123)}%| * $IF($GET(test_number)>100, greater)=|%CALCULATE{$IF($GET(test_number)>100, greater)}%| * $SET(test_string, San Francisco)=|%CALCULATE{$SET(test_string, San Francisco)}%| * $IF($EXACT($GET(test_string), Cupertino), equal, not equal)=|%CALCULATE{$IF($EXACT($GET(test_string), Cupertino), equal, not equal)}%| * $SET(result, $IF($GET(test_number)==0, zero, $GET(test_number)))=|%CALCULATE{$SET(result, $IF($GET(test_number)==0, zero, $GET(test_number)))}%| * $GET(result)=|%CALCULATE{$GET(result)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncINSERTSTRING][INSERTSTRING]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected INSERTSTRING --> <ul> <li>$INSERTSTRING(abcdefg, 2, XYZ)=|abXYZcdefg| </li> <li>$INSERTSTRING(abcdefg, -2, XYZ)=|abcdeXYZfg| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $INSERTSTRING(abcdefg, 2, XYZ)=|%CALCULATE{$INSERTSTRING(abcdefg, 2, XYZ)}%| * $INSERTSTRING(abcdefg, -2, XYZ)=|%CALCULATE{$INSERTSTRING(abcdefg, -2, XYZ)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncINT][INT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected INT --> <ul> <li>$INT(10 / 4)=|2| </li> <li>$INT($VALUE(09))=|9| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $INT(10 / 4)=|%CALCULATE{$INT(10 / 4)}%| * $INT($VALUE(09))=|%CALCULATE{$INT($VALUE(09))}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncISDIGIT][ISDIGIT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ISDIGIT --> <ul> <li>$ISDIGIT(123)=|1| </li> <li>$ISDIGIT(-7)=|0| </li> <li>$ISDIGIT(abc123)=|0| </li> <li>$ISDIGIT()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $ISDIGIT(123)=|%CALCULATE{$ISDIGIT(123)}%| * $ISDIGIT(-7)=|%CALCULATE{$ISDIGIT(-7)}%| * $ISDIGIT(abc123)=|%CALCULATE{$ISDIGIT(abc123)}%| * $ISDIGIT()=|%CALCULATE{$ISDIGIT()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncISLOWER][ISLOWER]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ISLOWER --> <ul> <li>$ISLOWER(apple)=|1| </li> <li>$ISLOWER(apple tree)=|0| </li> <li>$ISLOWER(ORANGE)=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $ISLOWER(apple)=|%CALCULATE{$ISLOWER(apple)}%| * $ISLOWER(apple tree)=|%CALCULATE{$ISLOWER(apple tree)}%| * $ISLOWER(ORANGE)=|%CALCULATE{$ISLOWER(ORANGE)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncISUPPER][ISUPPER]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ISUPPER --> <ul> <li>$ISUPPER(apple)=|0| </li> <li>$ISUPPER(ORANGE)=|1| </li> <li>$ISUPPER(ORANGE GARDEN)=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $ISUPPER(apple)=|%CALCULATE{$ISUPPER(apple)}%| * $ISUPPER(ORANGE)=|%CALCULATE{$ISUPPER(ORANGE)}%| * $ISUPPER(ORANGE GARDEN)=|%CALCULATE{$ISUPPER(ORANGE GARDEN)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncISWIKIWORD][ISWIKIWORD]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected ISWIKIWORD --> <ul> <li>$ISWIKIWORD(GoldenGate)=|1| </li> <li>$ISWIKIWORD(whiteRafting)=|0| </li> <li>$ISWIKIWORD()=|0| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $ISWIKIWORD(GoldenGate)=|%CALCULATE{$ISWIKIWORD(GoldenGate)}%| * $ISWIKIWORD(whiteRafting)=|%CALCULATE{$ISWIKIWORD(whiteRafting)}%| * $ISWIKIWORD()=|%CALCULATE{$ISWIKIWORD()}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLEFT][LEFT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LEFT --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> 1 </td> <td> 2 </td> <td> $SUM($LEFT())=|3| </td> </tr> <tr> <td> 3 </td> <td> 4 </td> <td> $SUM($LEFT())=|7| </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> | 1 | 2 | $SUM($LEFT())=%VBAR%%CALC{$SUM($LEFT())}%%VBAR% | | 3 | 4 | $SUM($LEFT())=%VBAR%%CALC{$SUM($LEFT())}%%VBAR% | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLEFTSTRING][LEFTSTRING]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LEFTSTRING --> <ul> <li>$LEFTSTRING(abcdefg)=|a| </li> <li>$LEFTSTRING(abcdefg, 5)=|abcde| </li> <li>$LEFTSTRING()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LEFTSTRING(abcdefg)=|%CALCULATE{$LEFTSTRING(abcdefg)}%| * $LEFTSTRING(abcdefg, 5)=|%CALCULATE{$LEFTSTRING(abcdefg, 5)}%| * $LEFTSTRING()=|%CALCULATE{$LEFTSTRING()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLENGTH][LENGTH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LENGTH --> <ul> <li>$LENGTH(abcd)=|4| </li> <li>$LENGTH()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LENGTH(abcd)=|%CALCULATE{$LENGTH(abcd)}%| * $LENGTH()=|%CALCULATE{$LENGTH()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLIST][LIST]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LIST --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> Apple </td> <td> Banana </td> <td> Citrus </td> <td> $LIST($LEFT())=|Apple, Banana, Citrus| </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> | Apple | Banana | Citrus | $LIST($LEFT())=%VBAR%%CALC{$LIST($LEFT())}%%VBAR% | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLIST2HASH][LIST2HASH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LIST2HASH --> <ul> <li>$SETHASH()=|| </li> <li>$LIST2HASH(age, Jane, 26, Tim, 27)=|| </li> <li>$GETHASH(age, Jane)=|26| </li> <li>$GETHASH(age, Tim)=|27| </li> <li>$LIST2HASH(age, Anna, 25, Jane, 27, Zoltan)=|| </li> <li>$GETHASH(age, Jane)=|27| </li> <li>$GETHASH(age, Tim)=|27| </li> <li>$GETHASH(age)=|Anna, Jane, Tim| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $LIST2HASH(age, Jane, 26, Tim, 27)=|%CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27)}%| * $GETHASH(age, Jane)=|%CALCULATE{$GETHASH(age, Jane)}%| * $GETHASH(age, Tim)=|%CALCULATE{$GETHASH(age, Tim)}%| * $LIST2HASH(age, Anna, 25, Jane, 27, Zoltan)=|%CALCULATE{$LIST2HASH(age, Anna, 25, Jane, 27, Zoltan)}%| * $GETHASH(age, Jane)=|%CALCULATE{$GETHASH(age, Jane)}%| * $GETHASH(age, Tim)=|%CALCULATE{$GETHASH(age, Tim)}%| * $GETHASH(age)=|%CALCULATE{$GETHASH(age)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTIF][LISTIF]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTIF --> <ul> <li>$LISTIF($item > 12, 14, 7, 25)=|14, 25| </li> <li>$LISTIF($NOT($EXACT($item,)), A, B, , E)=|A, B, E| </li> <li>$LISTIF($index > 2, A, B, C, D)=|C, D| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTIF($item > 12, 14, 7, 25)=|%CALCULATE{$LISTIF($item > 12, 14, 7, 25)}%| * $LISTIF($NOT($EXACT($item,)), A, B, , E)=|%CALCULATE{$LISTIF($NOT($EXACT($item,)), A, B, , E)}%| * $LISTIF($index > 2, A, B, C, D)=|%CALCULATE{$LISTIF($index > 2, A, B, C, D)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTITEM][LISTITEM]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTITEM --> <ul> <li>$LISTITEM(2, Apple, Orange, Apple, Kiwi)=|Orange| </li> <li>$LISTITEM(-1, Apple, Orange, Apple, Kiwi)=|Kiwi| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTITEM(2, Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTITEM(2, Apple, Orange, Apple, Kiwi)}%| * $LISTITEM(-1, Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTITEM(-1, Apple, Orange, Apple, Kiwi)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTJOIN][LISTJOIN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTJOIN --> <ul> <li>$LISTJOIN(-, Apple, Orange, Apple, Kiwi)=|Apple-Orange-Apple-Kiwi| </li> <li>$LISTJOIN($empty, Apple, Orange, Apple, Kiwi)=|AppleOrangeAppleKiwi| </li> </ul> $LISTJOIN($n, Apple, Orange, Apple, Kiwi)=|Apple Orange Apple Kiwi| <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTJOIN(-, Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTJOIN(-, Apple, Orange, Apple, Kiwi)}%| * $LISTJOIN($empty, Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTJOIN($empty, Apple, Orange, Apple, Kiwi)}%| $LISTJOIN($n, Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTJOIN($n, Apple, Orange, Apple, Kiwi)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTEACH][LISTEACH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTEACH --> <ul> <li>$LISTEACH($index: $EVAL(2 * $item), 3, 5, 7, 11)=|1: 6, 2: 10, 3: 14, 4: 22| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTEACH($index: $EVAL(2 * $item), 3, 5, 7, 11)=|%CALCULATE{$LISTEACH($index: $EVAL(2 * $item), 3, 5, 7, 11)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTNONEMPTY][LISTNONEMPTY]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTNONEMPTY --> <ul> <li>$LISTNONEMPTY(, Apple, Orange, , Kiwi)=|Apple, Orange, Kiwi| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTNONEMPTY(, Apple, Orange, , Kiwi)=|%CALCULATE{$LISTNONEMPTY(, Apple, Orange, , Kiwi)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTRAND][LISTRAND]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTRAND --> <ul> <li>$LISTRAND(Apple, Apple, Apple)=|Apple| </li> </ul> <!-- /expected --> <ul> <li>Manual test: $LISTRAND(Apple, Orange, Apple, Kiwi)=|%RED%(one of the four)%ENDCOLOR%| </li> </ul> </td><td> ---+++ Actual <!-- actual --> * $LISTRAND(Apple, Apple, Apple)=|%CALCULATE{$LISTRAND(Apple, Apple, Apple)}%| <!-- /actual --> * Manual test: $LISTRAND(Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTRAND(Apple, Orange, Apple, Kiwi)}%| </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTREVERSE][LISTREVERSE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTREVERSE --> <ul> <li>$LISTREVERSE(Apple, Orange, Apple, Kiwi)=|Kiwi, Apple, Orange, Apple| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTREVERSE(Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTREVERSE(Apple, Orange, Apple, Kiwi)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTSHUFFLE][LISTSHUFFLE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTSHUFFLE --> <ul> <li>$LISTSHUFFLE(Apple, Apple, Apple)=|Apple, Apple, Apple| </li> </ul> <!-- /expected --> <ul> <li>Manual test: $LISTSHUFFLE(Apple, Orange, Apple, Kiwi)=|%RED%(4 shuffled items)%ENDCOLOR%| </li> </ul> </td><td> ---+++ Actual <!-- actual --> * $LISTSHUFFLE(Apple, Apple, Apple)=|%CALCULATE{$LISTSHUFFLE(Apple, Apple, Apple)}%| <!-- /actual --> * Manual test: $LISTSHUFFLE(Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTSHUFFLE(Apple, Orange, Apple, Kiwi)}%| </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTSIZE][LISTSIZE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTSIZE --> <ul> <li>$LISTSIZE(Apple, Orange, Apple, Kiwi)=|4| </li> <li>$LISTSIZE()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTSIZE(Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTSIZE(Apple, Orange, Apple, Kiwi)}%| * $LISTSIZE()=|%CALCULATE{$LISTSIZE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTSORT][LISTSORT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTSORT --> <ul> <li>$LISTSORT(Apple, Orange, Apple, Kiwi)=|Apple, Apple, Kiwi, Orange| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTSORT(Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTSORT(Apple, Orange, Apple, Kiwi)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTTRUNCATE][LISTTRUNCATE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTTRUNCATE --> <ul> <li>$LISTTRUNCATE(2, Apple, Orange, Apple, Kiwi)=|Apple, Orange| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTTRUNCATE(2, Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTTRUNCATE(2, Apple, Orange, Apple, Kiwi)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLISTUNIQUE][LISTUNIQUE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LISTUNIQUE --> <ul> <li>$LISTUNIQUE(Apple, Orange, Apple, Kiwi)=|Apple, Orange, Kiwi| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LISTUNIQUE(Apple, Orange, Apple, Kiwi)=|%CALCULATE{$LISTUNIQUE(Apple, Orange, Apple, Kiwi)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLN][LN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LN --> <ul> <li>$LN(10)=|2.30258509299405| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LN(10)=|%CALCULATE{$LN(10)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLOG][LOG]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LOG --> <ul> <li>$LOG(1000)=|3| </li> <li>$LOG(16, 2)=|4| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LOG(1000)=|%CALCULATE{$LOG(1000)}%| * $LOG(16, 2)=|%CALCULATE{$LOG(16, 2)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncLOWER][LOWER]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected LOWER --> <ul> <li>$LOWER(this BECOMES a lower cASE String)=|this becomes a lower case string| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $LOWER(this BECOMES a lower cASE String)=|%CALCULATE{$LOWER(this BECOMES a lower cASE String)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncMAX][MAX]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected MAX --> <ul> <li>$MAX(7, 99, 2, 5)=|99| </li> <li>$MAX(A, 99, 2, 5)=|99| </li> <li>$MAX(A, B)=|| </li> <li>$MAX()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $MAX(7, 99, 2, 5)=|%CALCULATE{$MAX(7, 99, 2, 5)}%| * $MAX(A, 99, 2, 5)=|%CALCULATE{$MAX(A, 99, 2, 5)}%| * $MAX(A, B)=|%CALCULATE{$MAX(A, B)}%| * $MAX()=|%CALCULATE{$MAX()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncMEDIAN][MEDIAN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected MEDIAN --> <ul> <li>$MEDIAN(3, 9, 4, 5)=|4.5| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $MEDIAN(3, 9, 4, 5)=|%CALCULATE{$MEDIAN(3, 9, 4, 5)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncMIN][MIN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected MIN --> <ul> <li>$MIN(7, 99, 2, 5)=|2| </li> <li>$MIN(A, 99, 2, 5)=|2| </li> <li>$MIN(A, B)=|| </li> <li>$MIN()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $MIN(7, 99, 2, 5)=|%CALCULATE{$MIN(7, 99, 2, 5)}%| * $MIN(A, 99, 2, 5)=|%CALCULATE{$MIN(A, 99, 2, 5)}%| * $MIN(A, B)=|%CALCULATE{$MIN(A, B)}%| * $MIN()=|%CALCULATE{$MIN()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncMOD][MOD]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected MOD --> <ul> <li>$MOD(7, 3)=|1| </li> <li>$MOD(7)=|0| </li> <li>$MOD()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $MOD(7, 3)=|%CALCULATE{$MOD(7, 3)}%| * $MOD(7)=|%CALCULATE{$MOD(7)}%| * $MOD()=|%CALCULATE{$MOD()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncNOEXEC][NOEXEC]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected NOEXEC --> <ul> <li>$SET(msg, $NOEXEC(Hi $GET(name)))=|| </li> <li>$SET(name, Jane)$EXEC($GET(msg))=|Hi Jane| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SET(msg, $NOEXEC(Hi $GET(name)))=|%CALCULATE{$SET(msg, $NOEXEC(Hi $GET(name)))}%| * $SET(name, Jane)$EXEC($GET(msg))=|%CALCULATE{$SET(name, Jane)$EXEC($GET(msg))}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncNOP][NOP]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected NOP --> <ul> <li>$NOP(100$percnt $quotquoted$quot)=|100% "quoted"| </li> <li>$NOP()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $NOP(100$percnt $quotquoted$quot)=|%CALCULATE{$NOP(100$percnt $quotquoted$quot)}%| * $NOP()=|%CALCULATE{$NOP()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncNOT][NOT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected NOT --> <ul> <li>$NOT(1)=|0| </li> <li>$NOT(0)=|1| </li> <li>$NOT(1234)=|0| </li> <li>$NOT()=|1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $NOT(1)=|%CALCULATE{$NOT(1)}%| * $NOT(0)=|%CALCULATE{$NOT(0)}%| * $NOT(1234)=|%CALCULATE{$NOT(1234)}%| * $NOT()=|%CALCULATE{$NOT()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncNOTE][NOTE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected NOTE --> <ul> <li>$NOTE(some text)=|| </li> <li>$NOTE()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $NOTE(some text)=|%CALCULATE{$NOTE(some text)}%| * $NOTE()=|%CALCULATE{$NOTE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncOCT2DEC][OCT2DEC]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected OCT2DEC --> <ul> <li>$OCT2DEC(54)=|44| </li> <li>$OCT2DEC(77777533)=|16777051| </li> <li>$OCT2DEC()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $OCT2DEC(54)=|%CALCULATE{$OCT2DEC(54)}%| * $OCT2DEC(77777533)=|%CALCULATE{$OCT2DEC(77777533)}%| * $OCT2DEC()=|%CALCULATE{$OCT2DEC()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncODD][ODD]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ODD --> <ul> <li>$ODD(2)=|0| </li> <li>$ODD(3)=|1| </li> <li>$ODD(3.5)=|1| </li> <li>$ODD(-4)=|0| </li> <li>$ODD()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $ODD(2)=|%CALCULATE{$ODD(2)}%| * $ODD(3)=|%CALCULATE{$ODD(3)}%| * $ODD(3.5)=|%CALCULATE{$ODD(3.5)}%| * $ODD(-4)=|%CALCULATE{$ODD(-4)}%| * $ODD()=|%CALCULATE{$ODD()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncOR][OR]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected OR --> <ul> <li>$OR()=|0| </li> <li>$OR(0)=|0| </li> <li>$OR(1)=|1| </li> <li>$OR(0, 0)=|0| </li> <li>$OR(0, 1)=|1| </li> <li>$OR(1, 0)=|1| </li> <li>$OR(1, 1)=|1| </li> <li>$OR(0, 1, 2, 3)=|1| </li> <li>$OR(1, 2, 3, 4)=|1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $OR()=|%CALCULATE{$OR()}%| * $OR(0)=|%CALCULATE{$OR(0)}%| * $OR(1)=|%CALCULATE{$OR(1)}%| * $OR(0, 0)=|%CALCULATE{$OR(0, 0)}%| * $OR(0, 1)=|%CALCULATE{$OR(0, 1)}%| * $OR(1, 0)=|%CALCULATE{$OR(1, 0)}%| * $OR(1, 1)=|%CALCULATE{$OR(1, 1)}%| * $OR(0, 1, 2, 3)=|%CALCULATE{$OR(0, 1, 2, 3)}%| * $OR(1, 2, 3, 4)=|%CALCULATE{$OR(1, 2, 3, 4)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncPERCENTILE][PERCENTILE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected PERCENTILE --> <ul> <li>$PERCENTILE(75, 400, 200, 500, 100, 300)=|450| </li> <li>$PERCENTILE(60)=|0| </li> <li>$PERCENTILE()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $PERCENTILE(75, 400, 200, 500, 100, 300)=|%CALCULATE{$PERCENTILE(75, 400, 200, 500, 100, 300)}%| * $PERCENTILE(60)=|%CALCULATE{$PERCENTILE(60)}%| * $PERCENTILE()=|%CALCULATE{$PERCENTILE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncPI][PI]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected PI --> <ul> <li>$PI()=|3.14159265358979| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $PI()=|%CALCULATE{$PI()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncPRODUCT][PRODUCT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected PRODUCT --> <ul> <li>$PRODUCT(0,4)=|0| </li> <li>$PRODUCT(1,4)=|4| </li> <li>$PRODUCT(2,4)=|8| </li> <li>$PRODUCT(1,2,3,4)=|24| </li> <li>$PRODUCT(1)=|1| </li> <li>$PRODUCT(0)=|0| </li> <li>$PRODUCT()=|1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $PRODUCT(0,4)=|%CALCULATE{$PRODUCT(0,4)}%| * $PRODUCT(1,4)=|%CALCULATE{$PRODUCT(1,4)}%| * $PRODUCT(2,4)=|%CALCULATE{$PRODUCT(2,4)}%| * $PRODUCT(1,2,3,4)=|%CALCULATE{$PRODUCT(1,2,3,4)}%| * $PRODUCT(1)=|%CALCULATE{$PRODUCT(1)}%| * $PRODUCT(0)=|%CALCULATE{$PRODUCT(0)}%| * $PRODUCT()=|%CALCULATE{$PRODUCT()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncPROPER][PROPER]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected PROPER --> <ul> <li>$PROPER(a small STEP)=|A Small Step| </li> <li>$PROPER(f1 (formula-1))=|F1 (Formula-1)| </li> <li>$PROPER()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $PROPER(a small STEP)=|%CALCULATE{$PROPER(a small STEP)}%| * $PROPER(f1 (formula-1))=|%CALCULATE{$PROPER(f1 (formula-1))}%| * $PROPER()=|%CALCULATE{$PROPER()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncPROPERSPACE][PROPERSPACE]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected PROPERSPACE --> <ul> <li>$PROPERSPACE(Old MacDonald had a ServerFarm, EeEyeEeEyeOh)=|Old MacDonald had a Server Farm, Ee Eye Ee Eye Oh| </li> <li>$PROPERSPACE()=|| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $PROPERSPACE(Old MacDonald had a ServerFarm, EeEyeEeEyeOh)=|%CALCULATE{$PROPERSPACE(Old MacDonald had a ServerFarm, EeEyeEeEyeOh)}%| * $PROPERSPACE()=|%CALCULATE{$PROPERSPACE()}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncRAND][RAND]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected RAND --> <ul> <li>$IF($RAND()<=1, OK, not OK)=|OK| </li> </ul> <!-- /expected --> <ul> <li>Manual test: $RAND(10), $RAND(10), $RAND(10)=|%RED%(three random numbers between 0 and 10)%ENDCOLOR%| </li> <li>Manual test: $RAND(), $RAND(), $RAND()=|%RED%(three random numbers between 0 and 1)%ENDCOLOR%| </li> </ul> </td><td> ---+++ Actual <!-- actual --> * $IF($RAND()<=1, OK, not OK)=|%CALCULATE{$IF($RAND()<=1, OK, not OK)}%| <!-- /actual --> * Manual test: $RAND(10), $RAND(10), $RAND(10)=|%CALCULATE{$RAND(10), $RAND(10), $RAND(10)}%| * Manual test: $RAND(), $RAND(), $RAND()=|%CALCULATE{$RAND(), $RAND(), $RAND()}%| </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncRANDSTRING][RANDSTRING]] <table class="testSideBySide"><tr><td> ---+++ Expected <ul> <li>Manual test: $RANDSTRING(), $RANDSTRING(), $RANDSTRING()=|%RED%(three random strings of 8 alphanumeric/underscore characters)%ENDCOLOR%| </li> <li>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)=|%RED%(three random strings, each of format xxxx-xxxx-xxxx-xxxx, composed of uppercase letters and numbers excluding letter O and number 0)%ENDCOLOR%| </li> </ul> </td><td> ---+++ Actual * Manual test: $RANDSTRING(), $RANDSTRING(), $RANDSTRING()=|%CALCULATE{$RANDSTRING(), $RANDSTRING(), $RANDSTRING()}%| * 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)=|%CALCULATE{$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)}%| </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncREPEAT][REPEAT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected REPEAT --> <ul> <li>$REPEAT(/\, 10)=|/\/\/\/\/\/\/\/\/\/\| </li> <li>$REPEAT(x)=|| </li> <li>$REPEAT()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $REPEAT(/\, 10)=|%CALCULATE{$REPEAT(/\, 10)}%| * $REPEAT(x)=|%CALCULATE{$REPEAT(x)}%| * $REPEAT()=|%CALCULATE{$REPEAT()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncREPLACE][REPLACE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected REPLACE --> <ul> <li>$REPLACE(abcd, 2, 1, X)=|aXcd| </li> <li>$REPLACE(1023, 2, 1, X)=|1X23| </li> <li>$REPLACE(z_1023, 4, 1, X)=|z_1X23| </li> <li>$REPLACE(abcd, 2, 1)=|acd| </li> <li>$REPLACE(abcd, 2, 0)=|abcd| </li> <li>$REPLACE(abcd, 1, 3)=|d| </li> <li>$REPLACE(abcd, 1, 4)=|| </li> <li>$REPLACE(abcd, 1, 4, YYYY)=|YYYY| </li> <li>$REPLACE(abcd, 2, 4, YYYY)=|aYYYY| </li> <li>$REPLACE(abcdefghijk,6,5,*)=|abcde*k| </li> <li>$REPLACE(abcd)=|abcd| </li> <li>$REPLACE()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $REPLACE(abcd, 2, 1, X)=|%CALCULATE{$REPLACE(abcd, 2, 1, X)}%| * $REPLACE(1023, 2, 1, X)=|%CALCULATE{$REPLACE(1023, 2, 1, X)}%| * $REPLACE(z_1023, 4, 1, X)=|%CALCULATE{$REPLACE(z_1023, 4, 1, X)}%| * $REPLACE(abcd, 2, 1)=|%CALCULATE{$REPLACE(abcd, 2, 1)}%| * $REPLACE(abcd, 2, 0)=|%CALCULATE{$REPLACE(abcd, 2, 0)}%| * $REPLACE(abcd, 1, 3)=|%CALCULATE{$REPLACE(abcd, 1, 3)}%| * $REPLACE(abcd, 1, 4)=|%CALCULATE{$REPLACE(abcd, 1, 4)}%| * $REPLACE(abcd, 1, 4, YYYY)=|%CALCULATE{$REPLACE(abcd, 1, 4, YYYY)}%| * $REPLACE(abcd, 2, 4, YYYY)=|%CALCULATE{$REPLACE(abcd, 2, 4, YYYY)}%| * $REPLACE(abcdefghijk,6,5,*)=|%CALCULATE{$REPLACE(abcdefghijk,6,5,*)}%| * $REPLACE(abcd)=|%CALCULATE{$REPLACE(abcd)}%| * $REPLACE()=|%CALCULATE{$REPLACE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncRIGHT][RIGHT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected RIGHT --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> $SUM($RIGHT())=|3| </td> <td> 1 </td> <td> 2 </td> </tr> <tr> <td> $SUM($RIGHT())=|7| </td> <td> 3 </td> <td> 4 </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> | $SUM($RIGHT())=%VBAR%%CALC{$SUM($RIGHT())}%%VBAR% | 1 | 2 | | $SUM($RIGHT())=%VBAR%%CALC{$SUM($RIGHT())}%%VBAR% | 3 | 4 | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncRIGHTSTRING][RIGHTSTRING]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected RIGHTSTRING --> <ul> <li>$RIGHTSTRING(abcdefg)=|g| </li> <li>$RIGHTSTRING(abcdefg, 0)=|g| </li> <li>$RIGHTSTRING(abcdefg, 1)=|g| </li> <li>$RIGHTSTRING(abcdefg, 2)=|fg| </li> <li>$RIGHTSTRING()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $RIGHTSTRING(abcdefg)=|%CALCULATE{$RIGHTSTRING(abcdefg)}%| * $RIGHTSTRING(abcdefg, 0)=|%CALCULATE{$RIGHTSTRING(abcdefg, 0)}%| * $RIGHTSTRING(abcdefg, 1)=|%CALCULATE{$RIGHTSTRING(abcdefg, 1)}%| * $RIGHTSTRING(abcdefg, 2)=|%CALCULATE{$RIGHTSTRING(abcdefg, 2)}%| * $RIGHTSTRING()=|%CALCULATE{$RIGHTSTRING()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncROUND][ROUND]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ROUND --> <ul> <li>$ROUND(3.15, 1)=|3.2| </li> <li>$ROUND(3.149, 1)=|3.1| </li> <li>$ROUND(-2.475, 2)=|-2.48| </li> <li>$ROUND(34.9, -1)=|30| </li> <li>$ROUND(12.34)=|12| </li> <li>$ROUND(12.51)=|13| </li> <li>$ROUND()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $ROUND(3.15, 1)=|%CALCULATE{$ROUND(3.15, 1)}%| * $ROUND(3.149, 1)=|%CALCULATE{$ROUND(3.149, 1)}%| * $ROUND(-2.475, 2)=|%CALCULATE{$ROUND(-2.475, 2)}%| * $ROUND(34.9, -1)=|%CALCULATE{$ROUND(34.9, -1)}%| * $ROUND(12.34)=|%CALCULATE{$ROUND(12.34)}%| * $ROUND(12.51)=|%CALCULATE{$ROUND(12.51)}%| * $ROUND()=|%CALCULATE{$ROUND()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncROW][ROW]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected ROW --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> $ROW()=1 </td> <td> $ROW()=1 </td> </tr> <tr> <td> $ROW()=2 </td> <td> $ROW(10)=12 </td> </tr> <tr> <td> $ROW()=3 </td> <td> $ROW(-10)=-7 </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> | $ROW()=%CALC{$ROW()}% | $ROW()=%CALC{$ROW()}% | | $ROW()=%CALC{$ROW()}% | $ROW(10)=%CALC{$ROW(10)}% | | $ROW()=%CALC{$ROW()}% | $ROW(-10)=%CALC{$ROW(-10)}% | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSEARCH][SEARCH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SEARCH --> <ul> <li>$SEARCH([uy], fluffy)=|3| </li> <li>$SEARCH([uy], fluffy, 4)=|6| </li> <li>$SEARCH([abc], fluffy,)=|0| </li> <li>$SEARCH(abc)=|0| </li> <li>$SEARCH()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SEARCH([uy], fluffy)=|%CALCULATE{$SEARCH([uy], fluffy)}%| * $SEARCH([uy], fluffy, 4)=|%CALCULATE{$SEARCH([uy], fluffy, 4)}%| * $SEARCH([abc], fluffy,)=|%CALCULATE{$SEARCH([abc], fluffy,)}%| * $SEARCH(abc)=|%CALCULATE{$SEARCH(abc)}%| * $SEARCH()=|%CALCULATE{$SEARCH()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSET][SET]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SET --> <ul> <li>$SET(test, 1234)=|| </li> <li>$GET(test)=|1234| </li> <li>$SET(sum, $SUM(1, 2, 3, 4))=|| </li> <li>$GET(sum)=|10| </li> <li>$SET(novalue)=|| </li> <li>$GET(novalue)=|| </li> <li>$SET()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SET(test, 1234)=|%CALCULATE{$SET(test, 1234)}%| * $GET(test)=|%CALCULATE{$GET(test)}%| * $SET(sum, $SUM(1, 2, 3, 4))=|%CALCULATE{$SET(sum, $SUM(1, 2, 3, 4))}%| * $GET(sum)=|%CALCULATE{$GET(sum)}%| * $SET(novalue)=|%CALCULATE{$SET(novalue)}%| * $GET(novalue)=|%CALCULATE{$GET(novalue)}%| * $SET()=|%CALCULATE{$SET()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSETHASH][SETHASH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SETHASH --> <ul> <li>$SETHASH()=|| </li> <li>$SETHASH(age, Jane, 26)=|| </li> <li>$GETHASH(age, Jane)=|26| </li> <li>$GETHASH()=|age| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH()=|%CALCULATE{$SETHASH()}%| * $SETHASH(age, Jane, 26)=|%CALCULATE{$SETHASH(age, Jane, 26)}%| * $GETHASH(age, Jane)=|%CALCULATE{$GETHASH(age, Jane)}%| * $GETHASH()=|%CALCULATE{$GETHASH()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSETIFEMPTY][SETIFEMPTY]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SETIFEMPTY --> <ul> <li>$SET(test, 1234)=|| </li> <li>$SETIFEMPTY(test, 1)=|| </li> <li>$GET(test)=|1234| </li> <li>$SET(test, 0)=|| </li> <li>$SETIFEMPTY(test, 2)=|| </li> <li>$GET(test)=|2| </li> <li>$SET(test,)=|| </li> <li>$SETIFEMPTY(test, 3)=|| </li> <li>$GET(test)=|3| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SET(test, 1234)=|%CALCULATE{$SET(test, 1234)}%| * $SETIFEMPTY(test, 1)=|%CALCULATE{$SETIFEMPTY(test, 1)}%| * $GET(test)=|%CALCULATE{$GET(test)}%| * $SET(test, 0)=|%CALCULATE{$SET(test, 0)}%| * $SETIFEMPTY(test, 2)=|%CALCULATE{$SETIFEMPTY(test, 2)}%| * $GET(test)=|%CALCULATE{$GET(test)}%| * $SET(test,)=|%CALCULATE{$SET(test,)}%| * $SETIFEMPTY(test, 3)=|%CALCULATE{$SETIFEMPTY(test, 3)}%| * $GET(test)=|%CALCULATE{$GET(test)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSETLIST][SETLIST]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SETLIST --> <ul> <li>$SETLIST(test, 1, '''2, 2.a, 2.b''', 3, 4)=|| </li> <li>$GETLIST(test)=|1, 2, 2.a, 2.b, 3, 4| </li> <li>$LISTJOIN(; , $GETLIST(test))=|1; 2, 2.a, 2.b; 3; 4| </li> <li>$SETLIST(novalue)=|| </li> <li>$GETLIST(novalue)=|| </li> <li>$SETLIST()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETLIST(test, 1, '''2, 2.a, 2.b''', 3, 4)=|%CALCULATE{$SETLIST(test, 1, '''2, 2.a, 2.b''', 3, 4)}%| * $GETLIST(test)=|%CALCULATE{$GETLIST(test)}%| * $LISTJOIN(; , $GETLIST(test))=|%CALCULATE{$LISTJOIN(; , $GETLIST(test))}%| * $SETLIST(novalue)=|%CALCULATE{$SETLIST(novalue)}%| * $GETLIST(novalue)=|%CALCULATE{$GETLIST(novalue)}%| * $SETLIST()=|%CALCULATE{$SETLIST()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSETM][SETM]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SETM --> <ul> <li>$SET(total, 10)=|| </li> <li>$SETM(total, +5)=|| </li> <li>$SETM(total)=|| </li> <li>$GET(total)=|15| </li> <li>$SETM()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SET(total, 10)=|%CALCULATE{$SET(total, 10)}%| * $SETM(total, +5)=|%CALCULATE{$SETM(total, +5)}%| * $SETM(total)=|%CALCULATE{$SETM(total)}%| * $GET(total)=|%CALCULATE{$GET(total)}%| * $SETM()=|%CALCULATE{$SETM()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSETMHASH][SETMHASH]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SETMHASH --> <ul> <li>$SETHASH(count)=|| </li> <li>$LISTJOIN(, $LISTEACH($SETMHASH(count, $item, +1), Anna, Jane, Berta, Charlie, Jane, Tom, Anna, Jane))=|| </li> <li>$HASH2LIST(count, $key: $value)=|Anna: 2, Berta: 1, Charlie: 1, Jane: 3, Tom: 1| </li> <li>$SETMHASH(count, Jane, +1)=|| </li> <li>$SETMHASH(count, Jane)=|| </li> <li>$HASH2LIST(count, $key: $value)=|Anna: 2, Berta: 1, Charlie: 1, Jane: 4, Tom: 1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SETHASH(count)=|%CALCULATE{$SETHASH(count)}%| * $LISTJOIN(, $LISTEACH($SETMHASH(count, $item, +1), Anna, Jane, Berta, Charlie, Jane, Tom, Anna, Jane))=|%CALCULATE{$LISTJOIN(, $LISTEACH($SETMHASH(count, $item, +1), Anna, Jane, Berta, Charlie, Jane, Tom, Anna, Jane))}%| * $HASH2LIST(count, $key: $value)=|%CALCULATE{$HASH2LIST(count, $key: $value)}%| * $SETMHASH(count, Jane, +1)=|%CALCULATE{$SETMHASH(count, Jane, +1)}%| * $SETMHASH(count, Jane)=|%CALCULATE{$SETMHASH(count, Jane)}%| * $HASH2LIST(count, $key: $value)=|%CALCULATE{$HASH2LIST(count, $key: $value)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSIGN][SIGN]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SIGN --> <ul> <li>$SIGN(12.34)=|1| </li> <li>$SIGN(2)=|1| </li> <li>$SIGN(0)=|0| </li> <li>$SIGN()=|0| </li> <li>$SIGN(-2)=|-1| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SIGN(12.34)=|%CALCULATE{$SIGN(12.34)}%| * $SIGN(2)=|%CALCULATE{$SIGN(2)}%| * $SIGN(0)=|%CALCULATE{$SIGN(0)}%| * $SIGN()=|%CALCULATE{$SIGN()}%| * $SIGN(-2)=|%CALCULATE{$SIGN(-2)}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSPLIT][SPLIT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SPLIT --> <ul> <li>$SPLIT(, Apple Orange Kiwi)=|Apple, Orange, Kiwi| </li> <li>$SPLIT(-, Apple-Orange-Kiwi)=|Apple, Orange, Kiwi| </li> <li>$SPLIT([-:]$sp*, Apple-Orange: Kiwi)=|Apple, Orange, Kiwi| </li> <li>$SPLIT($empty, Apple)=|A, p, p, l, e| </li> <li>$SPLIT(x)=|| </li> <li>$SPLIT()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SPLIT(, Apple Orange Kiwi)=|%CALCULATE{$SPLIT(, Apple Orange Kiwi)}%| * $SPLIT(-, Apple-Orange-Kiwi)=|%CALCULATE{$SPLIT(-, Apple-Orange-Kiwi)}%| * $SPLIT([-:]$sp*, Apple-Orange: Kiwi)=|%CALCULATE{$SPLIT([-:]$sp*, Apple-Orange: Kiwi)}%| * $SPLIT($empty, Apple)=|%CALCULATE{$SPLIT($empty, Apple)}%| * $SPLIT(x)=|%CALCULATE{$SPLIT()}%| * $SPLIT()=|%CALCULATE{$SPLIT()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSQRT][SQRT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SQRT --> <ul> <li>$SQRT(16)=|4| </li> <li>$SQRT(1)=|1| </li> <li>$SQRT()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SQRT(16)=|%CALCULATE{$SQRT(16)}%| * $SQRT(1)=|%CALCULATE{$SQRT(1)}%| * $SQRT()=|%CALCULATE{$SQRT()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSTDEV][STDEV]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected STDEV --> <ul> <li>$STDEV(2, 4, 4, 4, 5, 5, 7, 9)=|2.1380899352994| </li> <li>$STDEV(2, 5, 3, 12)=|4.50924975282289| </li> <li>$STDEV(2, 5, 3, xyz, 12)=|4.50924975282289| </li> <li>$STDEV(3.50, 5.00, 7.23, 2.99)=|1.90205152401295| </li> <li>$STDEV()=|0| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $STDEV(2, 4, 4, 4, 5, 5, 7, 9)=|%CALC{$STDEV(2, 4, 4, 4, 5, 5, 7, 9)}%| * $STDEV(2, 5, 3, 12)=|%CALC{$STDEV(2, 5, 3, 12)}%| * $STDEV(2, 5, 3, xyz, 12)=|%CALC{$STDEV(2, 5, 3, xyz, 12)}%| * $STDEV(3.50, 5.00, 7.23, 2.99)=|%CALC{$STDEV(3.50, 5.00, 7.23, 2.99)}%| * $STDEV()=|%CALC{$STDEV()}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSTDEVP][STDEVP]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected STDEVP --> <ul> <li>$STDEVP(2, 5, 3, 12)=|3.90512483795333| </li> <li>$STDEVP(2, 5, 3, xyz, 12)=|3.90512483795333| </li> <li>$STDEVP(3.50, 5.00, 7.23, 2.99)=|1.64722493910213| </li> <li>$STDEVP()=|0| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $STDEVP(2, 5, 3, 12)=|%CALC{$STDEVP(2, 5, 3, 12)}%| * $STDEVP(2, 5, 3, xyz, 12)=|%CALC{$STDEVP(2, 5, 3, xyz, 12)}%| * $STDEVP(3.50, 5.00, 7.23, 2.99)=|%CALC{$STDEVP(3.50, 5.00, 7.23, 2.99)}%| * $STDEVP()=|%CALC{$STDEVP()}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSUBSTITUTE][SUBSTITUTE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SUBSTITUTE --> <ul> <li>$SUBSTITUTE(Good morning, morning, day)=|Good day| </li> <li>$SUBSTITUTE('''Good, early morning''', morning, '''day''')=|Good, early day| </li> <li>$SUBSTITUTE(Q2-2012, 2, 3)=|Q3-3013| </li> <li>$SUBSTITUTE(Q2-2012,2, 3, 3)=|Q2-2013| </li> <li>$SUBSTITUTE(abc123def, [0-9], 9, , r)=|abc999def| </li> <li>$SUBSTITUTE(abcd)=|abcd| </li> <li>$SUBSTITUTE()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SUBSTITUTE(Good morning, morning, day)=|%CALCULATE{$SUBSTITUTE(Good morning, morning, day)}%| * $SUBSTITUTE('''Good, early morning''', morning, '''day''')=|%CALCULATE{$SUBSTITUTE('''Good, early morning''', morning, '''day''')}%| * $SUBSTITUTE(Q2-2012, 2, 3)=|%CALCULATE{$SUBSTITUTE(Q2-2012, 2, 3)}%| * $SUBSTITUTE(Q2-2012,2, 3, 3)=|%CALCULATE{$SUBSTITUTE(Q2-2012,2, 3, 3)}%| * $SUBSTITUTE(abc123def, [0-9], 9, , r)=|%CALCULATE{$SUBSTITUTE(abc123def, [0-9], 9, , r)}%| * $SUBSTITUTE(abcd)=|%CALCULATE{$SUBSTITUTE(abcd)}%| * $SUBSTITUTE()=|%CALCULATE{$SUBSTITUTE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSUBSTRING][SUBSTRING]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SUBSTRING --> <ul> <li>$SUBSTRING(abcdef,3,5)=|cdef| </li> <li>$SUBSTRING(abcdefgh,3,5)=|cdefg| </li> <li>$SUBSTRING(abcdefgh,8,5)=|h| </li> <li>$SUBSTRING(abcdefgh,9,5)=|| </li> <li>$SUBSTRING(abcdefg,-2,2)=|fg| </li> <li>$SUBSTRING(abcdefg,-1,2)=|g| </li> <li>$SUBSTRING(abcdefg,-7,2)=|ab| </li> <li>$SUBSTRING(abcdefg,-8,2)=|| </li> <li>$SUBSTRING(abcdefg,0,2)=|| </li> <li>$SUBSTRING(abcdefg,1,2)=|ab| </li> <li>$SUBSTRING(abcdefg,2,2)=|bc| </li> <li>$SUBSTRING(abcdefg,2,-1)=|bcdef| </li> <li>$SUBSTRING(abcdefg,-2,-1)=|f| </li> <li>$SUBSTRING(abc,def,3,3)=|c,d| </li> <li>$SUBSTRING(abcdefg)=|| </li> <li>$SUBSTRING()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SUBSTRING(abcdef,3,5)=|%CALCULATE{$SUBSTRING(abcdef,3,5)}%| * $SUBSTRING(abcdefgh,3,5)=|%CALCULATE{$SUBSTRING(abcdefgh,3,5)}%| * $SUBSTRING(abcdefgh,8,5)=|%CALCULATE{$SUBSTRING(abcdefgh,8,5)}%| * $SUBSTRING(abcdefgh,9,5)=|%CALCULATE{$SUBSTRING(abcdefgh,9,5)}%| * $SUBSTRING(abcdefg,-2,2)=|%CALCULATE{$SUBSTRING(abcdefg,-2,2)}%| * $SUBSTRING(abcdefg,-1,2)=|%CALCULATE{$SUBSTRING(abcdefg,-1,2)}%| * $SUBSTRING(abcdefg,-7,2)=|%CALCULATE{$SUBSTRING(abcdefg,-7,2)}%| * $SUBSTRING(abcdefg,-8,2)=|%CALCULATE{$SUBSTRING(abcdefg,-8,2)}%| * $SUBSTRING(abcdefg,0,2)=|%CALCULATE{$SUBSTRING(abcdefg,0,2)}%| * $SUBSTRING(abcdefg,1,2)=|%CALCULATE{$SUBSTRING(abcdefg,1,2)}%| * $SUBSTRING(abcdefg,2,2)=|%CALCULATE{$SUBSTRING(abcdefg,2,2)}%| * $SUBSTRING(abcdefg,2,-1)=|%CALCULATE{$SUBSTRING(abcdefg,2,-1)}%| * $SUBSTRING(abcdefg,-2,-1)=|%CALCULATE{$SUBSTRING(abcdefg,-2,-1)}%| * $SUBSTRING(abc,def,3,3)=|%CALCULATE{$SUBSTRING(abc,def,3,3)}%| * $SUBSTRING(abcdefg)=|%CALCULATE{$SUBSTRING(abcdefg)}%| * $SUBSTRING()=|%CALCULATE{$SUBSTRING()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSUM][SUM]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SUM --> <ul> <li>$SUM(1, 2, 3, 4, 5)=|15| </li> <li>$SUM(1, x, 3, , 5)=|9| </li> <li>$SUM(1)=|1| </li> <li>$SUM()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SUM(1, 2, 3, 4, 5)=|%CALCULATE{$SUM(1, 2, 3, 4, 5)}%| * $SUM(1, x, 3, , 5)=|%CALCULATE{$SUM(1, x, 3, , 5)}%| * $SUM(1)=|%CALCULATE{$SUM(1)}%| * $SUM()=|%CALCULATE{$SUM()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSUMDAYS][SUMDAYS]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SUMDAYS --> <ul> <li>$SUMDAYS(2w, 1, 2d, 4h)=|13.5| </li> <li>$SUMDAYS(1w, x)=|5| </li> <li>$SUMDAYS()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $SUMDAYS(2w, 1, 2d, 4h)=|%CALCULATE{$SUMDAYS(2w, 1, 2d, 4h)}%| * $SUMDAYS(1w, x)=|%CALCULATE{$SUMDAYS(1w, x)}%| * $SUMDAYS()=|%CALCULATE{$SUMDAYS()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncSUMPRODUCT][SUMPRODUCT]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected SUMPRODUCT --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> 1 </td> <td> 2 </td> </tr> <tr> <td> 3 </td> <td> 4 </td> </tr> <tr> <td> $SUMPRODUCT(R1:C1..R2:C1, R1:C2..R2:C2)=|14| </td> <td> $SUMPRODUCT(R1:C1..R2:C1, $ABOVE())=|14| </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> | 1 | 2 | | 3 | 4 | | $SUMPRODUCT(R1:C1..R2:C1, R1:C2..R2:C2)=%VBAR%%CALC{$SUMPRODUCT(R1:C1..R2:C1, R1:C2..R2:C2)}%%VBAR% | $SUMPRODUCT(R1:C1..R2:C1, $ABOVE())=%VBAR%%CALC{$SUMPRODUCT(R1:C1..R2:C1, $ABOVE())}%%VBAR% | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncT][T]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected T --> <table cellspacing="0" cellpadding="0" class="twikiTable" border="1"><tbody> <tr> <td> 1 </td> <td> 2 </td> </tr> <tr> <td> 3 </td> <td> 4 </td> </tr> <tr> <td> $T(R2:C1)=|3| </td> <td> $T(R1:C2)=|2| </td> </tr></tbody></table> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> |1|2| |3|4| | $T(R2:C1)=%VBAR%%CALC{$T(R2:C1)}%%VBAR% | $T(R1:C2)=%VBAR%%CALC{$T(R1:C2)}%%VBAR% | <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncTIME][TIME]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected TIME --> <ul> <li>$TIME(2012-12-31 GMT)=|1356912000| </li> </ul> <!-- /expected --> <ul> <li>Manual test: $TIME($FORMATTIME($TIME(), $year-$mo-$day))=|%RED%(today)%ENDCOLOR%| </li> </ul> </td><td> ---+++ Actual <!-- actual --> * $TIME(2012-12-31 GMT)=|%CALCULATE{$TIME(2012-12-31 GMT)}%| <!-- /actual --> * Manual test: $TIME($FORMATTIME($TIME(), $year-$mo-$day))=|%CALCULATE{$FORMATTIME($TIME(), $year-$mo-$day)}%| </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncTIMEADD][TIMEADD]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected TIMEADD --> <ul> <li>$FORMATTIME($TIMEADD($TIME(2012-12-31), 2, day), $year-$mo-$day)=|2013-01-02| </li> <li>$FORMATTIME($TIMEADD($TIME(2012-12-31), 2, year), $year-$mo-$day)=|2014-12-31| </li> <li>$TIMEADD($TIME(2012-12-31 GMT), 10)=|1356912010| </li> <li>$TIMEADD($TIME(2012-12-31 GMT), 10, sec)=|1356912010| </li> <li>$TIMEADD($TIME(2012-12-31 GMT), 2, min)=|1356912120| </li> <li>$TIMEADD()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $FORMATTIME($TIMEADD($TIME(2012-12-31), 2, day), $year-$mo-$day)=|%CALCULATE{$FORMATTIME($TIMEADD($TIME(2012-12-31), 2, day), $year-$mo-$day)}%| * $FORMATTIME($TIMEADD($TIME(2012-12-31), 2, year), $year-$mo-$day)=|%CALCULATE{$FORMATTIME($TIMEADD($TIME(2012-12-31), 2, year), $year-$mo-$day)}%| * $TIMEADD($TIME(2012-12-31 GMT), 10)=|%CALCULATE{$TIMEADD($TIME(2012-12-31 GMT), 10)}%| * $TIMEADD($TIME(2012-12-31 GMT), 10, sec)=|%CALCULATE{$TIMEADD($TIME(2012-12-31 GMT), 10, sec)}%| * $TIMEADD($TIME(2012-12-31 GMT), 2, min)=|%CALCULATE{$TIMEADD($TIME(2012-12-31 GMT), 2, min)}%| * $TIMEADD()=|%CALCULATE{$TIMEADD()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncTIMEDIFF][TIMEDIFF]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected TIMEDIFF --> <ul> <li>$TIMEDIFF($TIME(), $EVAL($TIME()+90), minute)=|1.5| </li> <li>$TIMEDIFF($ROUND($TIMEDIFF($TIME(2012-12-06),$TIME(2012-12-13), day)))=|7| </li> <li>$TIMEDIFF()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $TIMEDIFF($TIME(), $EVAL($TIME()+90), minute)=|%CALCULATE{$TIMEDIFF($TIME(), $EVAL($TIME()+90), minute)}%| * $TIMEDIFF($ROUND($TIMEDIFF($TIME(2012-12-06),$TIME(2012-12-13), day)))=|%CALCULATE{$ROUND($TIMEDIFF($TIME(2012-12-06),$TIME(2012-12-13), day))}%| * $TIMEDIFF()=|%CALCULATE{$TIMEDIFF()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncTODAY][TODAY]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected TODAY --> <ul> <li>(can't be tested automatically) </li> </ul> <!-- /expected --> <ul> <li>Manual test: $TIME($FORMATTIME($TODAY(), $year-$mo-$day $hour:$min:$sec GMT))=|%RED%(this morning midnight GMT)%ENDCOLOR%| </li> </ul> </td><td> ---+++ Actual <!-- actual --> * (can't be tested automatically) <!-- /actual --> * Manual test: $TIME($FORMATTIME($TODAY(), $year-$mo-$day $hour:$min:$sec GMT))=|%CALCULATE{$FORMATTIME($TODAY(), $year-$mo-$day $hour:$min:$sec GMT)}%| </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncTRANSLATE][TRANSLATE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected TRANSLATE --> <ul> <li>$TRANSLATE(boom,bm,cl)=|cool| </li> <li>$TRANSLATE(one, two,$comma,;)=|one; two| </li> <li>$TRANSLATE()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $TRANSLATE(boom,bm,cl)=|%CALCULATE{$TRANSLATE(boom,bm,cl)}%| * $TRANSLATE(one, two,$comma,;)=|%CALCULATE{$TRANSLATE(one, two,$comma,;)}%| * $TRANSLATE()=|%CALCULATE{$TRANSLATE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncTRIM][TRIM]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected TRIM --> <ul> <li>$TRIM( eat spaces )=|eat spaces| </li> <li>$TRIM()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $TRIM( eat spaces )=|%CALCULATE{$TRIM( eat spaces )}%| * $TRIM()=|%CALCULATE{$TRIM()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncUPPER][UPPER]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected UPPER --> <ul> <li>$UPPER(this beCOMES an UPPER cASE String)=|THIS BECOMES AN UPPER CASE STRING| </li> <li>$UPPER()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $UPPER(this beCOMES an UPPER cASE String)=|%CALCULATE{$UPPER(this beCOMES an UPPER cASE String)}%| * $UPPER()=|%CALCULATE{$UPPER()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncVALUE][VALUE]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected VALUE --> <ul> <li>$VALUE(US$1,200)=|1200| </li> <li>$VALUE(PrjNotebook1234)=|1234| </li> <li>$VALUE(Total: -12.5)=|-12.5| </li> <li>$VALUE()=|0| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $VALUE(US$1,200)=|%CALCULATE{$VALUE(US$1,200)}%| * $VALUE(PrjNotebook1234)=|%CALCULATE{$VALUE(PrjNotebook1234)}%| * $VALUE(Total: -12.5)=|%CALCULATE{$VALUE(Total: -12.5)}%| * $VALUE()=|%CALCULATE{$VALUE()}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncVAR][VAR]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected VAR --> <ul> <li>$VAR(1, 2, 3, 4, 5, 6)=|3.5| </li> <li>$VAR(2, 5, 3, 12)=|20.3333333333333| </li> <li>$VAR(2, 5, 3, xyz, 12)=|20.3333333333333| </li> <li>$VAR(3.50, 5.00, 7.23, 2.99)=|3.6178| </li> <li>$VAR()=|0| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $VAR(1, 2, 3, 4, 5, 6)=|%CALCULATE{$VAR(1, 2, 3, 4, 5, 6)}%| * $VAR(2, 5, 3, 12)=|%CALCULATE{$VAR(2, 5, 3, 12)}%| * $VAR(2, 5, 3, xyz, 12)=|%CALCULATE{$VAR(2, 5, 3, xyz, 12)}%| * $VAR(3.50, 5.00, 7.23, 2.99)=|%CALCULATE{$VAR(3.50, 5.00, 7.23, 2.99)}%| * $VAR()=|%CALCULATE{$VAR()}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncVARP][VARP]] <table class="testSideBySide"><tr><td> ---+++ Expected <noautolink> <!-- expected VARP --> <ul> <li>$VARP(1, 2, 3, 4, 5, 6)=|2.91666666666667| </li> <li>$VARP(2, 5, 3, 12)=|15.25| </li> <li>$VARP(2, 5, 3, xyz, 12)=|15.25| </li> <li>$VARP(3.50, 5.00, 7.23, 2.99)=|2.71335| </li> <li>$VARP()=|0| </li> </ul> <!-- /expected --> </noautolink> </td><td> ---+++ Actual <noautolink> <!-- actual --> * $VARP(1, 2, 3, 4, 5, 6)=|%CALCULATE{$VARP(1, 2, 3, 4, 5, 6)}%| * $VARP(2, 5, 3, 12)=|%CALCULATE{$VARP(2, 5, 3, 12)}%| * $VARP(2, 5, 3, xyz, 12)=|%CALCULATE{$VARP(2, 5, 3, xyz, 12)}%| * $VARP(3.50, 5.00, 7.23, 2.99)=|%CALCULATE{$VARP(3.50, 5.00, 7.23, 2.99)}%| * $VARP()=|%CALCULATE{$VARP()}%| <!-- /actual --> </noautolink> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncWHILE][WHILE]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected WHILE --> <ul> <li>$WHILE($counter<=10, $counter )=|1 2 3 4 5 6 7 8 9 10 | </li> <li>$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, | </li> <li>$WHILE()=|| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $WHILE($counter<=10, $counter )=|%CALCULATE{$WHILE($counter<=10, $counter )}%| * $SET(i, 0)$WHILE($GET(i)<10, $SETM(i, +1) $EVAL($GET(i) * $GET(i)), )=|%CALCULATE{$SET(i, 0)$WHILE($GET(i)<10, $SETM(i, +1) $EVAL($GET(i) * $GET(i)), )}%| * $WHILE()=|%CALCULATE{$WHILE()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncWORKINGDAYS][WORKINGDAYS]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected WORKINGDAYS --> <ul> <li>$WORKINGDAYS($TIME(2012-07-15 GMT), $TIME(2012-08-03 GMT))=|14| </li> <li>$WORKINGDAYS()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $WORKINGDAYS($TIME(2012-07-15 GMT), $TIME(2012-08-03 GMT))=|%CALCULATE{$WORKINGDAYS($TIME(2012-07-15 GMT), $TIME(2012-08-03 GMT))}%| * $WORKINGDAYS()=|%CALCULATE{$WORKINGDAYS()}%| <!-- /actual --> </td></tr></table> ---++ Function [[%SYSTEMWEB%.SpreadSheetPlugin#FuncXOR][XOR]] <table class="testSideBySide"><tr><td> ---+++ Expected <!-- expected XOR --> <ul> <li>$XOR(0)=|0| </li> <li>$XOR(1)=|0| </li> <li>$XOR(0, 0)=|0| </li> <li>$XOR(0, 1)=|1| </li> <li>$XOR(1, 0)=|1| </li> <li>$XOR(1, 1)=|0| </li> <li>$XOR(0, 1, 2, 3)=|1| </li> <li>$XOR(1, 2, 3, 4)=|0| </li> <li>$XOR()=|0| </li> </ul> <!-- /expected --> </td><td> ---+++ Actual <!-- actual --> * $XOR(0)=|%CALCULATE{$XOR(0)}%| * $XOR(1)=|%CALCULATE{$XOR(1)}%| * $XOR(0, 0)=|%CALCULATE{$XOR(0, 0)}%| * $XOR(0, 1)=|%CALCULATE{$XOR(0, 1)}%| * $XOR(1, 0)=|%CALCULATE{$XOR(1, 0)}%| * $XOR(1, 1)=|%CALCULATE{$XOR(1, 1)}%| * $XOR(0, 1, 2, 3)=|%CALCULATE{$XOR(0, 1, 2, 3)}%| * $XOR(1, 2, 3, 4)=|%CALCULATE{$XOR(1, 2, 3, 4)}%| * $XOR()=|%CALCULATE{$XOR()}%| <!-- /actual --> </td></tr></table> <style> .testSideBySide { margin-left: -10px; } .testSideBySide td { padding: 0 10px; } .testSideBySide tr td h3 { margin-top: 0; } </style> * Set EDITMETHOD = raw __Related Topics:__ SpreadSheetPlugin, VarCALC, VarCALCULATE -- TWiki:Main.PeterThoeny - 2014-10-24
This topic: TWiki
>
SpreadSheetPluginTestCases
Topic revision: r4 - 2015-06-07 - TWikiContributor
Copyright © 1999-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback
Note:
Please contribute updates to this topic on TWiki.org at
TWiki:TWiki.SpreadSheetPluginTestCases
.