Difference: SpreadSheetPlugin (14 vs. 15)

Revision 1524 Jan 2007 - PeterThoeny

Line: 1 to 1
 

TWiki Spreadsheet Plugin

This Plugin adds spreadsheet capabilities to TWiki topics. Formulae like %CALC{"$INT(7/3)"}% are evaluated at page view time. They can be placed in table cells and outside of tables. In other words, this Plugin provides general formula evaluation capability, not just classic spreadsheet functions.

Line: 260 to 260
 

LISTMAP( formula, list ) -- evaluate and update each element of a list

Changed:
<
<
  • In the formula you can use $item to indicate the element; $index to show the index of the list, starting at 1
>
>
  • In the formula you can use $item to indicate the element; $index to show the index of the list, starting at 1. If $item is omitted, the item is appended to the formula.
 
Line: 268 to 268
 

LISTRAND( list ) -- get one random element of a list

  • Syntax: $LISTRAND( list )
Changed:
<
<
  • Example: %CALC{"$LISTRRAND(Apple, Orange, Apple, Kiwi)"}% returns one of the four elements
>
>
  • Example: %CALC{"$LISTRAND(Apple, Orange, Apple, Kiwi)"}% returns one of the four elements
 

Line: 658 to 658
 

Plugin Info

Plugin Author: TWiki:Main/PeterThoeny
Changed:
<
<
Copyright: © 2001-2006, Peter@Thoeny.org, StructuredWikis LLC
>
>
Copyright: © 2001-2007, Peter@Thoeny.org, StructuredWikis LLC
 
License: GPL (GNU General Public License)
Changed:
<
<
Plugin Version: 18 Dec 2006 (r12315)
>
>
Plugin Version: 23 Jan 2007 (r12607)
 
Change History:
<-- specify latest version first -->
 
Added:
>
>
23 Jan 2007: Enhanced documentation
 
18 Dec 2006: Added $LISTRAND(), $LISTSHUFFLE(), $LISTTRUNCATE(); fixed spurious newline at end of topic, contributed by TWiki:Main/MichaelDaum
10 Oct 2006: Enhanced documentation
13 May 2006: Added $SETIFEMPTY(); fixes in documentation
Line: 705 to 706
  Related Topics: TWikiPreferences, TWikiPlugins
Changed:
<
<
-- TWiki:Main/PeterThoeny - 18 Dec 2006
>
>
-- TWiki:Main/PeterThoeny - 23 Jan 2007
 
 
This site is powered by the TWiki collaboration platformCopyright � 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.SpreadSheetPlugin