Difference: SpreadSheetPluginTestCases (3 vs. 4)

Revision 42015-06-07 - TWikiContributor

Line: 1 to 1
 

SpreadSheetPlugin Testing

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

Line: 474 to 474
 
<-- /actual -->
Added:
>
>

Function EQUAL

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

Expected

Line: 1797 to 1819
 
<-- /actual -->
Added:
>
>

Function NOTE

Expected

<-- expected NOTE -->
  • $NOTE(some text)=||
  • $NOTE()=||
<-- /expected -->

Actual

<-- actual -->
  • $NOTE(some text)=||
  • $NOTE()=||
<-- /actual -->
 

Function OCT2DEC

Expected

Line: 2028 to 2069
 
  • Manual test: $RAND(), $RAND(), $RAND()=|0.296468001132858, 0.0300668016920191, 0.755755654595077|
Added:
>
>

Function RANDSTRING

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()=|vVSohKI8, exceRaRc, qDhh1_6A|
  • 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)=|PJZX-F7KQ-AGZX-HUR3, 4P9D-VZBF-QUJS-29HU, DKGT-S6KS-RHZP-A7IA|
 

Function REPEAT

Expected

Line: 2616 to 2672
 
  • $SUBSTRING(abcdefgh,3,5)=|cdefg|
  • Added:
    >
    >
  • $SUBSTRING(abcdefgh,8,5)=|h|
  • $SUBSTRING(abcdefgh,9,5)=||
  •  
  • $SUBSTRING(abcdefg,-2,2)=|fg|
  • $SUBSTRING(abcdefg,-1,2)=|g|
  • Added:
    >
    >
  • $SUBSTRING(abcdefg,-7,2)=|ab|
  • $SUBSTRING(abcdefg,-8,2)=||
  •  
  • $SUBSTRING(abcdefg,0,2)=||
  • $SUBSTRING(abcdefg,1,2)=|ab|
  • Line: 2643 to 2707
     
    <-- actual -->
    • $SUBSTRING(abcdef,3,5)=|cdef|
    • $SUBSTRING(abcdefgh,3,5)=|cdefg|
    Added:
    >
    >
    • $SUBSTRING(abcdefgh,8,5)=|h|
    • $SUBSTRING(abcdefgh,9,5)=||
     
    • $SUBSTRING(abcdefg,-2,2)=|fg|
    • $SUBSTRING(abcdefg,-1,2)=|g|
    Added:
    >
    >
    • $SUBSTRING(abcdefg,-7,2)=|ab|
    • $SUBSTRING(abcdefg,-8,2)=||
     
    • $SUBSTRING(abcdefg,0,2)=||
    • $SUBSTRING(abcdefg,1,2)=|ab|
    • $SUBSTRING(abcdefg,2,2)=|bc|
    Line: 3102 to 3170
      Related Topics: SpreadSheetPlugin, VarCALC, VarCALCULATE
    Changed:
    <
    <
    -- TWiki:Main.PeterThoeny - 2013-03-20
    >
    >
    -- TWiki:Main.PeterThoeny - 2014-10-24
     
    This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 1999-2019 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.