TWikiTip025 < TWiki

---+ !SpreadSheetPlugin for dynamic content

The SpreadSheetPlugin offers 100 functions. Functions are evaluated at page view time. A formula can be placed anywhere in a topic, not just in a TWiki table.

Examples:
   * =$INT(7/3)=
   * =$AVERAGE($ABOVE())=
   * =$IF($T(R2:C1) > 100, over limit, $T(R2:C1))=
   * =$SUBSTITUTE(Good morning, morning, day)=
   * =$TIMEADD($TIME(), 2, week)=

Here is a complete example - to space out WikiWords, write: 

=%<nop>CALC{"$PROPERSPACE(<nop>TWikiGuest)"}%= 

to get:

=%CALC{"$PROPERSPACE(TWikiGuest)"}%=

[[SpreadSheetPlugin][More Information...]]

[[TWikiTipsOfTheDay][See More Tips...]]

-- __Contributors:__ TWiki:Main.PaulineCheung

This topic: TWiki > TWikiTipsOfTheDay > TWikiTip025
Topic revision: r3 - 05 Sep 2012 - TWikiContributor

Copyright © 1999-2024 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.TWikiTip025.