You are here: WAPAWiki>System Web>Plugins>SpreadSheetPlugin>VarCALC (02 Jun 2007, ProjectContributor) Edit this topic text (e) Attach an image or document to this topic; manage existing attachments (a) View sequential topic history View without formatting (v) Create new topic Printable version of this topic (p) More: delete or rename this topic; set parent topic; view and compare revisions (m)

CALC{"formula"} -- add spreadsheet calculations to tables and outside tables

  • The %CALC{"formula"}% macro is handled by the SpreadSheetPlugin. There are around 90 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, SpreadSheetPlugin
Edit | Attach | Print version | History: r0 | Backlinks | View wiki text | Edit wiki text | More topic actions
Topic revision: r1 - 02 Jun 2007 - 18:57:49 - ProjectContributor
 
Worcester Area Pilots Association
Pilots have to have good eyes to see through the clouds, and they can't be afraid of thunder or lightning because they are much closer to them than we are. --5th grade student

This site is powered by FoswikiCopyright © by the contributing authors. All material on this site is the property of the contributing authors.
Ideas, requests, problems regarding WAPAWiki? Send feedback