Difference: SpreadSheetPluginTestCases (4 vs. 5)

Revision 52017-10-19 - TWikiContributor

Line: 1 to 1

SpreadSheetPlugin Testing

Use this topic to verify proper operation of the SpreadSheetPlugin in your environment.

Line: 364 to 364

$DEC2BIN(9, 6)=|001001|

Deleted:

<
<

$DEC2BIN(-100)=|11111111111111111111111110011100|

$DEC2BIN()=|0|

Line: 375 to 373

<-- actual -->

$DEC2BIN(9)=|1001|
$DEC2BIN(9, 6)=|001001|

Deleted:

<
<

$DEC2BIN(-100)=|1111111111111111111111111111111111111111111111111111111110011100|

$DEC2BIN()=|0|

<-- /actual -->

Line: 389 to 386

$DEC2HEX(100, 4)=|0064|

Deleted:

<
<

$DEC2HEX(-54)=|FFFFFFCA|

$DEC2HEX()=|0|

Line: 400 to 395

<-- actual -->

$DEC2HEX(165)=|A5|
$DEC2HEX(100, 4)=|0064|

Deleted:

<
<

$DEC2HEX(-54)=|FFFFFFFFFFFFFFCA|

$DEC2HEX()=|0|

<-- /actual -->

Line: 1025 to 1019

$SETHASH()=||

Changed:

<
<

$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)=||

>
>

$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 28)=||

$HASHREVERSE(age)=||

Changed:

<
<

$HASH2LIST(age, $key: $value)=|26: Jane, 27: Tim|

>
>

$HASH2LIST(age, $key: $value)=|26: Jane, 27: Tim, 28: Sam|

$HASHREVERSE(height)=||

Line: 1043 to 1037

Actual

<-- actual -->

$SETHASH()=||

Changed:

<
<

$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)=||

>
>

$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 28)=||

$HASHREVERSE(age)=||
$HASH2LIST(age, $key: $value)=|26: Jane, 27: Tim, 28: Sam|
$HASHREVERSE(height)=||

Line: 1371 to 1365

$GETHASH(age, Tim)=|27|

Changed:

<
<

$LIST2HASH(age, Anna, 25, Jane, 27, Zoltan)=||

>
>

$LIST2HASH(age, Anna, 25, Empty, , Jane, 27, Zoltan)=||

$GETHASH(age, Jane)=|27|

Added:

>
>

$GETHASH(age, Empty)=||

$GETHASH(age, Tim)=|27|

Changed:

<
<

$GETHASH(age)=|Anna, Jane, Tim|

>
>

$GETHASH(age)=|Anna, Empty, Jane, Tim|

<-- /expected -->

Line: 1388 to 1384

$LIST2HASH(age, Jane, 26, Tim, 27)=||
$GETHASH(age, Jane)=|26|
$GETHASH(age, Tim)=|27|

Changed:

<
<

$LIST2HASH(age, Anna, 25, Jane, 27, Zoltan)=||

>
>

$LIST2HASH(age, Anna, 25, Empty, , Jane, 27, Zoltan)=||

$GETHASH(age, Jane)=|27|

Added:

>
>

$GETHASH(age, Empty)=||

$GETHASH(age, Tim)=|27|
$GETHASH(age)=|26, 27, 28, Anna, Empty, Jane, Tim|

<-- /actual -->

Line: 1467 to 1464

$LISTEACH($index: $EVAL(2 * $item), 3, 5, 7, 11)=|1: 6, 2: 10, 3: 14, 4: 22|

Added:

>
>

$LISTMAP($index: $EVAL(2 * $item), 3, 5, 7, 11)=|1: 6, 2: 10, 3: 14, 4: 22|

<-- /expected -->

Actual

<-- actual -->

$LISTEACH($index: $EVAL(2 * $item), 3, 5, 7, 11)=|1: 6, 2: 10, 3: 14, 4: 22|

Added:

>
>

$LISTMAP($index: $EVAL(2 * $item), 3, 5, 7, 11)=|1: 6, 2: 10, 3: 14, 4: 22|

<-- /actual -->

Line: 1985 to 1985

$PRODUCT()=|1|

Added:

>
>

$MULT(1,2,3,4)=|24|

<-- /expected -->

Line: 1997 to 1999

$PRODUCT(1)=|1|
$PRODUCT(0)=|0|
$PRODUCT()=|1|

Added:

>
>

$MULT(1,2,3,4)=|24|

<-- /actual -->

View topic | History: r5 < r4 < r3 < r2 | More topic actions...

Copyright © 1999-2025 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.