• This web contains the official documentation of the TWiki Release 4.1, code named EdinburghRelease. It is a read-only web for reference.
• This is an older release, see TWiki-6.1 for the latest release documentation.
• This is an older release, see TWiki-6.1 for the latest release documentation.
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
Edit | Attach | Topic revision: r1 - 2007-06-02 - PeterThoeny
Site map
Blog web
User registration
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.Copyright © 1999-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.