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.434474616119665, 0.832820250644009, 0.12053303193602|
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()=|f9pxa2Zj, oyZgF8Of, IGLjsfor|
  • 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)=|MH4U-X53D-6WJD-FCFZ, QXVN-7FCF-WYM3-JTIA, 8821-PYZW-QYKX-PU27|
 

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
    View topic | History: r4 < r3 < r2 < r1 | More topic actions...
     
    This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 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.