| | 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.926206231021151, 0.525031870504868, 0.143043905953537|
|
|
>
> |
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()=|HHWQ2Okh, BI75GePS, GcCh7_uI|
- 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)=|RYC9-CSBF-CGEL-1554, KJVE-99BP-DZ2K-M6CZ, IVSA-I3FE-N9G9-IXVJ|
|
|
| |
|
| |
$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-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.