From: PeterThoeny Date: Tue, 9 Mar 2004 06:41:00 +0000 (+0000) Subject: none X-Git-Url: https://git.openafs.org/?p=openafs-wiki.git;a=commitdiff_plain;h=386ab6e9043a0281f18eae8c4aece8180273086e none --- diff --git a/TWiki/SpreadSheetPlugin.mdwn b/TWiki/SpreadSheetPlugin.mdwn index 2ee232a..19b6385 100644 --- a/TWiki/SpreadSheetPlugin.mdwn +++ b/TWiki/SpreadSheetPlugin.mdwn @@ -156,6 +156,10 @@ The formula next to "Total" is `**%CALC\{"\$SUM( \$ABOVE() )"\}%**`. The length in bytes of text. Example: `%CALC{"\$LENGTH(abcd)"}%` returns `4` + `"\$LIST(range)"` + Converts the content of a range of cells into a flat list, delimited by comma. Example: `%CALC{"\$LIST( \$LEFT() )"}%` returns `Apples, Lemons, Oranges, Kiwis` assuming the cells to the left contain `| Apples | Lemons, Oranges | Kiwis |` + + `"\$LOWER(text)"` The lower case string of a text. Example: `%CALC{"\$LOWER( \$T(R1:C5) )"}%` returns the lower case string of the text in cell `R1:C5` @@ -205,7 +209,7 @@ The formula next to "Total" is `**%CALC\{"\$SUM( \$ABOVE() )"\}%**`. `"\$REPEAT(text)"` - Repeat `text` a number of times. Example: `%CALC{"\$REPEAT(Hi! , 3)"}%` returns `Hi! Hi! Hi!` + Repeat `text` a number of times. Example: `%CALC{"\$REPEAT(/\, 5)"}%` returns `/\/\/\/\/\` `"\$REPLACE(text, start_num, num_chars, new_text)"` @@ -285,7 +289,7 @@ The formula next to "Total" is `**%CALC\{"\$SUM( \$ABOVE() )"\}%**`. `"\$VALUE(text)"` - Extracts a number from `text`. Returns `0` if not found. Examples:%BR% `%CALC{"\$VALUE(US\$1,200)"}%` returns `1200` %BR% `%CALC{"\$VALUE(PrjNotebook1234)"}%` returns `1234` %BR% `%CALC{"\$VALUE(Total: -12.5)"}%` returns `12.5` + Extracts a number from `text`. Returns `0` if not found. Examples:%BR% `%CALC{"\$VALUE(US\$1,200)"}%` returns `1200` %BR% `%CALC{"\$VALUE(PrjNotebook1234)"}%` returns `1234` %BR% `%CALC{"\$VALUE(Total: -12.5)"}%` returns `-12.5` @@ -395,13 +399,17 @@ Plugin settings are stored as preferences variables. To reference a plugin setti Plugin Version: - 06 Mar 2004 + 08 Mar 2004 Change History: Â  + 08 Mar 2004: + Added \$LIST() + + 06 Mar 2004: Added \$AND(), \$MOD(), \$NOT(), \$OR(), \$PRODUCT(), \$PROPER(), \$PROPERSPACE(), \$RAND(), \$REPEAT(), \$SIGN(), \$VALUE(); added digits parameter to \$ROUND(); renamed \$MULT() to \$PRODUCT(); \$MULT() is deprecated and undocumented @@ -505,4 +513,4 @@ Plugin settings are stored as preferences variables. To reference a plugin setti **_Related Topics:_** [[TWikiPreferences]], [[TWikiPlugins]] --- TWiki:Main/PeterThoeny - 06 Mar 2004 +-- TWiki:Main/PeterThoeny - 08 Mar 2004