You are here: Foswiki>System Web>Category>UserDocumentationCategory>Macros>VarCALC (18 Jun 2015, ProjectContributor)Edit Attach
CALC -- add spreadsheet calculations to tables and outside tables
The%CALC{"formula"}% macro is handled by the Spread Sheet Plugin. There are around 90 formulae, such as $ABS(), $EXACT(), $EXISTS(), $GET()/$SET(), $IF(), $LOG(), $LOWER(), $PERCENTILE(), $TIME(), $VALUE(). - This macro is specifically for manipulating data in tables, and so is evaluated after the normal Macro expansion order. If you need a standard ordered evaluation see CALCULATE
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
CALCULATE, IF, Spread Sheet PluginEdit | Attach | Print version | History: r1 | Backlinks | View wiki text | Edit wiki text | More topic actions
Topic revision: r1 - 18 Jun 2015, ProjectContributor
- User Reference
- Beginners Start Here
- Editing Shorthand
- Macros
- Macros Quick Reference
- Formatted Search
- Query Search
- Document Graphics
- Skin Browser
- Installed Plugins
- Admin Maintenance
- Reference Manual
- Admin Tools Category
- Inter Wikis
- Managing Webs
- Site Tools
- Default Preferences
- Web Preferences
Events |
|
Copyright © by the contributing authors. All material on this site is the property of the contributing authors. Ideas, requests, problems regarding Foswiki? Send feedback