From fc219c92befc7bdbba34f8538247c70737394353 Mon Sep 17 00:00:00 2001 From: PeterThoeny Date: Sat, 28 Feb 2004 21:51:00 +0000 Subject: [PATCH] none --- TWiki/EditTablePlugin.mdwn | 35 ++++++++++++++++++++++++++--------- TWiki/SpreadSheetPlugin.mdwn | 22 +++++++++++++++++----- 2 files changed, 43 insertions(+), 14 deletions(-) diff --git a/TWiki/EditTablePlugin.mdwn b/TWiki/EditTablePlugin.mdwn index d70c986..32ff422 100644 --- a/TWiki/EditTablePlugin.mdwn +++ b/TWiki/EditTablePlugin.mdwn @@ -46,6 +46,11 @@ Add a `%EDITTABLE{...}%` variable just before an existing table to make it edita CHANGEROWS %BR% Plugin setting + quietsave + Quiet Save button is shown if "on", hidden if "off" + QUIETSAVE %BR% Plugin setting + + include Other topic defining the EDITTABLE parameters. The first %EDITTABLE% in the topic is used. This is useful if you have many topics with the same table format and you want to update the format in one place. (none) @@ -212,8 +217,12 @@ Plugin settings are stored as preferences variables. To reference a plugin setti - Default for change rows flag: `on`, `off`, `add` - Set CHANGEROWS = on -- Default text for edit button: - - Set EDITBUTTON = Edit table +- Default flag for quiet save option: `on` to show the Quiet Save button, `off` to hide + - Set QUIETSAVE = on + +- Default edit button: Specify `button text`, or specify `alternate text, image URL` + - #Set EDITBUTTON = Edit table + - Set EDITBUTTON = Edit this table, ![edittable.gif](http://www.dementia.org/twiki//view/edittable.gif) - Date format of [Mishoo DHTML calendar](http://dynarch.com/mishoo/calendar.epl): - Set JSCALENDARDATEFORMAT = %Y/%m/%d @@ -246,10 +255,6 @@ Plugin settings are stored as preferences variables. To reference a plugin setti Description: - lib/TWiki/Plugins/%TOPIC%.pm - Plugin Perl module - - data/TWiki/%TOPIC%.txt Plugin topic @@ -258,8 +263,16 @@ Plugin settings are stored as preferences variables. To reference a plugin setti Plugin topic repository + lib/TWiki/Plugins/%TOPIC%.pm + Plugin Perl module + + + pub/TWiki/%TOPIC%/edittable.gif + Edit table button image + + pub/TWiki/%TOPIC%/*.gif - Screenshots + Screenshots and Mishoo DHTML calendar images pub/TWiki/%TOPIC%/README @@ -298,13 +311,17 @@ Plugin settings are stored as preferences variables. To reference a plugin setti Plugin Version: - 18 Feb 2004 + 27 Feb 2004 Change History:   + 27 Feb 2004: + Added QUIETSAVE setting and quietsave parameter; image for Edit button + + 18 Feb 2004: Doc fixes; allow edit button anywhere in a cell not just at the end of a cell @@ -400,4 +417,4 @@ Plugin settings are stored as preferences variables. To reference a plugin setti **_Related Topics:_** [[TWikiPreferences]], [[TWikiPlugins]] --- TWiki:Main/PeterThoeny - 18 Feb 2004 +-- TWiki:Main/PeterThoeny - 27 Feb 2004 diff --git a/TWiki/SpreadSheetPlugin.mdwn b/TWiki/SpreadSheetPlugin.mdwn index 3203e6a..be7309a 100644 --- a/TWiki/SpreadSheetPlugin.mdwn +++ b/TWiki/SpreadSheetPlugin.mdwn @@ -41,7 +41,7 @@ The formula next to "Total" is **%CALC\{"$SUM( $ABOVE() )"\}%**. **%CALC\{"formula"\}%** variable can contain built-in functions - Built-in function are of format **$FUNCNAME(parameter)%** -- Built-in functions may be nested, e.g. **%CALC\{"$SUM( R2:C$COL(0)..R$ROW(-1):C$COL(0) )"\}%** +- Built-in functions may be nested, e.g. **%CALC\{"$SUM( R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0) )"\}%** - The function parameter can be text; a mathematical formula; a cell address; or a range of cell addresses - Multiple parameters form a list; they are separated by a comma, followed by optional space, e.g. **%CALC\{"$SUM( 3, 5, 7 )"\}%** - A table cell can be addressed as **R1:C1**. Table address matrix: @@ -92,13 +92,17 @@ The formula next to "Total" is **%CALC\{"$SUM( $ABOVE() )"\}%**. - + + + + + @@ -132,7 +136,7 @@ The formula next to "Total" is **%CALC\{"$SUM( $ABOVE() )"\}%**. - + @@ -347,13 +351,17 @@ Plugin settings are stored as preferences variables. To reference a plugin setti - + + + + + @@ -426,6 +434,10 @@ Plugin settings are stored as preferences variables. To reference a plugin setti + + + + @@ -445,4 +457,4 @@ Plugin settings are stored as preferences variables. To reference a plugin setti **_Related Topics:_** [[TWikiPreferences]], [[TWikiPlugins]] --- TWiki:Main/PeterThoeny - 24 Oct 2003 +-- TWiki:Main/PeterThoeny - 27 Feb 2004 -- 1.9.4
"$COUNTITEMS(list)" The count of individual items in a list. Example: To count the items of all cells above the current cell, write %CALC{"$COUNTITEMS( $ABOVE() )"}% Counts individual items in a list. Example: %CALC{"$COUNTITEMS( $ABOVE() )"}% returns Closed: 1, Open: 2 assuming one cell above the current cell contains Closed and two cells contain Open
"$COUNTSTR(list, str)" Counts the number of cells in a list equal to a given string (if str is specified), or counts the number of non empty cells in a list. Example: To count the number of non empty cells above the current cell, write %CALC{"$COUNTSTR( $ABOVE() )"}%; to count the number of cells equal to DONE, write %CALC{"$COUNTSTR( $ABOVE(), DONE )"}%;
"$COUNTUNIQUE(list)" Counts unique items in a list, separated by comma and/or space. Example: %CALC{"$COUNTUNIQUE( $ABOVE() )"}% returns Alice: 2, Mike: 1, Tom: 2 assuming the cells above the current cell contain Alice and Tom, Mike and Alice, Tom
"$DEF(list)" Returns the first list item or cell reference that is not empty. Example: %CALC{"$DEF( R1:C1..R1:C3 )"}%
"$IF(condition, value if true, value if 0)" Returns one value if a condition is met, and another value if not. The condition can be a number (where 0 means condition not met), or two numbers with a comparison operator < (less then), <= (less then or equal), == (equal), != (not equal), >= (greater then or equal), >= (greater then). Example: %CALC{"$IF( $T(R1:C5) > 1000, Over Budget, OK )"}% returns Over Budget if value in R1:C5 is over 1000, OK if not Returns one value if a condition is met, and another value if not. The condition can be a number (where 0 means condition not met), or two numbers with a comparison operator < (less than), <= (less than or equal), == (equal), != (not equal), >= (greater than or equal), > (greater than). Example: %CALC{"$IF( $T(R1:C5) > 1000, Over Budget, OK )"}% returns Over Budget if value in R1:C5 is over 1000, OK if not
"$INT(formula)"
Plugin Version: 24 Oct 2003 27 Feb 2004
Change History:  
27 Feb 2004: Added $COUNTUNIQUE()
24 Oct 2003: Added $SET(), $GET(), $MEDIAN(); added $SUMPRODUCT(), inspired by TWiki:Main/RobertWithrow; added $SUMDAYS(), contributed by TWiki:Main/SvenDowideit
none
TWiki:Plugins/Benchmark: [[TWiki/GoodStyle]] 99%, [[TWiki/FormattedSearch]] 99%, %TOPIC% 95%
Other Dependencies: none