buildrelease

[openafs-wiki.git] / TWiki / VarCALC.mdwn

diff --git a/TWiki/VarCALC.mdwn b/TWiki/VarCALC.mdwn
new file mode 100644 (file)
index 0000000..3ba6859
--- /dev/null
+++ b/TWiki/VarCALC.mdwn
@@ -0,0 +1,11 @@
+<a name="VarCALC"></a>
+
+### <a name="CALC{&quot;formula&quot;} -- add spreadshe"></a> CALC\{"formula"\} -- add spreadsheet calculations to tables and outside tables
+
+- The `%CALC{"formula"}%` variable is handled by the [[SpreadSheetPlugin]]. There are around 80 formulae, such as `$ABS()`, `$EXACT()`, `$EXISTS()`, `$GET()/$SET()`, `$IF()`, `$LOG()`, `$LOWER()`, `$PERCENTILE()`, `$TIME()`, `$VALUE()`.
+- Syntax: `%CALC{"formula"}%`
+- Examples:
+  - `%CALC{"$SUM($ABOVE())"}%` returns the sum of all cells above the current cell
+  - `%CALC{"$EXISTS(Web.SomeTopic)"}%` returns `1` if the topic exists
+  - `%CALC{"$UPPER(Collaboration)"}%` returns `COLLABORATION`
+- Related: [[IF|Main/WebHome#VarIF]], [[SpreadSheetPlugin]]