Welcome, Registration, and other StartingPoints; TWiki history & Wiki style; All the docs...
View   r15  >  r14  ...
SpreadSheetPlugin 15 - 24 Jan 2007 - Main.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
 

Revision 15r15 - 24 Jan 2007 - 07:34:50 - PeterThoeny?
Revision 14r14 - 19 Dec 2006 - 06:30:52 - PeterThoeny?
This site is powered by the TWiki collaboration platform.
All material on this collaboration platform is the property of the contributing authors.
All material marked as authored by Eben Moglen is available under the license terms CC-BY-SA version 4.
Syndicate this site RSSATOM