r1 - 02 Jun 2007 - 23:15:03 - PeterThoenyYou are here: TWiki > 
TWiki04x01 Web > TWikiVariables > VarCALC
TWiki04x01 Web > TWikiVariables > VarCALCTags:
| NOTE: This web contains the official documentation of the TWiki Release 4.1, code named EdinburghRelease. It is a read-only web for reference. Please update documentation at TWiki.VarCALC. -- PeterThoeny - 30 Mar 2007 |
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)"}%returns1if the topic exists -
%CALC{"$UPPER(Collaboration)"}%returnsCOLLABORATION
-
- Related: IF, SpreadSheetPlugin
TWiki04x01 Web
Users
Groups
Index
Search
Changes
Notifications
Statistics
Preferences
Blog |
|
Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding TWiki? Send feedback
Note: Please contribute updates to this topic on TWiki.org at TWiki:TWiki.VarCALC