| | SpreadSheetPlugin Testing
Use this topic to verify proper operation of the SpreadSheetPlugin in your environment. |
| | |
|
>
> |
Expected
<-- expected EQUAL -->
- $EQUAL(foo, foo)=|1|
- $EQUAL(foo, Foo)=|1|
- $EQUAL(foo, bar)=|0|
<-- /expected -->
|
Actual
<-- actual -->
- $EQUAL(foo, foo)=|1|
- $EQUAL(foo, Foo)=|1|
- $EQUAL(foo, bar)=|0|
<-- /actual -->
|
|
| | Function EVAL
|
| | |
|
>
> | Function NOTE
Expected
<-- expected NOTE -->
- $NOTE(some text)=||
- $NOTE()=||
<-- /expected -->
|
Actual
<-- actual -->
- $NOTE(some text)=||
- $NOTE()=||
<-- /actual -->
|
|
| |
|
| |
- Manual test: $RAND(), $RAND(), $RAND()=|0.596611187930048, 0.463384090498117, 0.576453286912884|
|
|
>
> |
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()=|jVEmAQdl, 8ilHvpld, wiThIUnO|
- 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)=|3VW1-JFYI-P97J-H4WW, 26Y3-3H6N-TAX6-R1TS, 3PPK-U1KJ-UX5X-F4LR|
|
|
| |
|
| |
$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| |
| | <-- 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|
|
| |
Related Topics: SpreadSheetPlugin, VarCALC, VarCALCULATE |
|
<
< | -- TWiki:Main.PeterThoeny - 2013-03-20 |
>
> | -- TWiki:Main.PeterThoeny - 2014-10-24 |
Copyright &© 1999-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.