From: <de...@de...> - 2007-01-24 07:42:15
|
Author: PeterThoeny Date: 2007-01-24 01:42:09 -0600 (Wed, 24 Jan 2007) New Revision: 12607 Modified: twiki/branches/MAIN/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt twiki/branches/Patch04x01/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt Log: Item3496: Doc work Modified: twiki/branches/MAIN/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt =================================================================== --- twiki/branches/MAIN/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt 2007-01-23 20:19:08 UTC (rev 12606) +++ twiki/branches/MAIN/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt 2007-01-24 07:42:09 UTC (rev 12607) @@ -1,4 +1,4 @@ -%META:TOPICINFO{author="PeterThoeny" date="1166509852" format="1.0" version="1.48"}% +%META:TOPICINFO{author="PeterThoeny" date="1169624090" format="1.0" version="1.49"}% ---+!! TWiki Spreadsheet Plugin This Plugin adds spreadsheet capabilities to %WIKITOOLNAME% topics. Formulae like ==%<nop>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. @@ -260,7 +260,7 @@ #FuncLISTMAP ---+++ LISTMAP( formula, list ) -- evaluate and update each element of a list - * 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. * Syntax: ==$LISTMAP( formula, list )== * Example: ==%<nop>CALC{"$LISTMAP($index: $EVAL(2 * $item), 3, 5, 7, 11)"}%== returns ==1: 6, 2: 10, 3: 14, 4: 22== * Related: =[[#FuncCOUNTITEMS][$COUNTITEMS()]]=, =[[#FuncCOUNTSTR][$COUNTSTR()]]=, =[[#FuncLIST][$LIST()]]=, =[[#FuncLISTIF][$LISTIF()]]=, =[[#FuncLISTITEM][$LISTITEM()]]=, =[[#FuncLISTREVERSE][$LISTREVERSE()]]=, =[[#FuncLISTSIZE][$LISTSIZE()]]=, =[[#FuncLISTSORT][$LISTSORT()]]=, =[[#FuncLISTUNIQUE][$LISTUNIQUE()]]=, =[[#FuncSUM][$SUM()]]= @@ -268,7 +268,7 @@ #FuncLISTRAND ---+++ LISTRAND( list ) -- get one random element of a list * Syntax: ==$LISTRAND( list )== - * Example: ==%<nop>CALC{"$LISTRRAND(Apple, Orange, Apple, Kiwi)"}%== returns one of the four elements + * Example: ==%<nop>CALC{"$LISTRAND(Apple, Orange, Apple, Kiwi)"}%== returns one of the four elements * Related: =[[#FuncCOUNTITEMS][$COUNTITEMS()]]=, =[[#FuncCOUNTSTR][$COUNTSTR()]]=, =[[#FuncLIST][$LIST()]]=, =[[#FuncLISTIF][$LISTIF()]]=, =[[#FuncLISTITEM][$LISTITEM()]]=, =[[#FuncLISTMAP][$LISTMAP()]]=, =[[#FuncLISTSHUFFLE][$LISTSHUFFLE()]]=, =[[#FuncLISTSIZE][$LISTSIZE()]]=, =[[#FuncLISTSORT][$LISTSORT()]]=, =[[#FuncLISTUNIQUE][$LISTUNIQUE()]]=, =[[#FuncRAND][$RAND()]]=, =[[#FuncSUM][$SUM()]]= #FuncLISTREVERSE @@ -658,10 +658,11 @@ ---++ Plugin Info | Plugin Author: | TWiki:Main/PeterThoeny | -| Copyright: | © 2001-2006, Peter@Thoeny.org, [[http://www.structuredwikis.com/][StructuredWikis LLC]] | +| Copyright: | © 2001-2007, Peter@Thoeny.org, [[http://www.structuredwikis.com/][StructuredWikis LLC]] | | License: | GPL ([[http://www.gnu.org/copyleft/gpl.html][GNU General Public License]]) | -| Plugin Version: | 18 Dec 2006 (r12315) | +| Plugin Version: | 23 Jan 2007 (r12607) | | Change History: | <!-- specify latest version first --> | +| 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 | @@ -705,5 +706,5 @@ __Related Topics:__ %TWIKIWEB%.TWikiPreferences, %TWIKIWEB%.TWikiPlugins --- TWiki:Main/PeterThoeny - 18 Dec 2006 +-- TWiki:Main/PeterThoeny - 23 Jan 2007 Modified: twiki/branches/Patch04x01/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt =================================================================== --- twiki/branches/Patch04x01/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt 2007-01-23 20:19:08 UTC (rev 12606) +++ twiki/branches/Patch04x01/twikiplugins/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt 2007-01-24 07:42:09 UTC (rev 12607) @@ -1,4 +1,4 @@ -%META:TOPICINFO{author="PeterThoeny" date="1166509852" format="1.0" version="1.48"}% +%META:TOPICINFO{author="PeterThoeny" date="1169624090" format="1.0" version="1.49"}% ---+!! TWiki Spreadsheet Plugin This Plugin adds spreadsheet capabilities to %WIKITOOLNAME% topics. Formulae like ==%<nop>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. @@ -260,7 +260,7 @@ #FuncLISTMAP ---+++ LISTMAP( formula, list ) -- evaluate and update each element of a list - * 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. * Syntax: ==$LISTMAP( formula, list )== * Example: ==%<nop>CALC{"$LISTMAP($index: $EVAL(2 * $item), 3, 5, 7, 11)"}%== returns ==1: 6, 2: 10, 3: 14, 4: 22== * Related: =[[#FuncCOUNTITEMS][$COUNTITEMS()]]=, =[[#FuncCOUNTSTR][$COUNTSTR()]]=, =[[#FuncLIST][$LIST()]]=, =[[#FuncLISTIF][$LISTIF()]]=, =[[#FuncLISTITEM][$LISTITEM()]]=, =[[#FuncLISTREVERSE][$LISTREVERSE()]]=, =[[#FuncLISTSIZE][$LISTSIZE()]]=, =[[#FuncLISTSORT][$LISTSORT()]]=, =[[#FuncLISTUNIQUE][$LISTUNIQUE()]]=, =[[#FuncSUM][$SUM()]]= @@ -268,7 +268,7 @@ #FuncLISTRAND ---+++ LISTRAND( list ) -- get one random element of a list * Syntax: ==$LISTRAND( list )== - * Example: ==%<nop>CALC{"$LISTRRAND(Apple, Orange, Apple, Kiwi)"}%== returns one of the four elements + * Example: ==%<nop>CALC{"$LISTRAND(Apple, Orange, Apple, Kiwi)"}%== returns one of the four elements * Related: =[[#FuncCOUNTITEMS][$COUNTITEMS()]]=, =[[#FuncCOUNTSTR][$COUNTSTR()]]=, =[[#FuncLIST][$LIST()]]=, =[[#FuncLISTIF][$LISTIF()]]=, =[[#FuncLISTITEM][$LISTITEM()]]=, =[[#FuncLISTMAP][$LISTMAP()]]=, =[[#FuncLISTSHUFFLE][$LISTSHUFFLE()]]=, =[[#FuncLISTSIZE][$LISTSIZE()]]=, =[[#FuncLISTSORT][$LISTSORT()]]=, =[[#FuncLISTUNIQUE][$LISTUNIQUE()]]=, =[[#FuncRAND][$RAND()]]=, =[[#FuncSUM][$SUM()]]= #FuncLISTREVERSE @@ -658,10 +658,11 @@ ---++ Plugin Info | Plugin Author: | TWiki:Main/PeterThoeny | -| Copyright: | © 2001-2006, Peter@Thoeny.org, [[http://www.structuredwikis.com/][StructuredWikis LLC]] | +| Copyright: | © 2001-2007, Peter@Thoeny.org, [[http://www.structuredwikis.com/][StructuredWikis LLC]] | | License: | GPL ([[http://www.gnu.org/copyleft/gpl.html][GNU General Public License]]) | -| Plugin Version: | 18 Dec 2006 (r12315) | +| Plugin Version: | 23 Jan 2007 (r12607) | | Change History: | <!-- specify latest version first --> | +| 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 | @@ -705,5 +706,5 @@ __Related Topics:__ %TWIKIWEB%.TWikiPreferences, %TWIKIWEB%.TWikiPlugins --- TWiki:Main/PeterThoeny - 18 Dec 2006 +-- TWiki:Main/PeterThoeny - 23 Jan 2007 |