Difference: TWikiTip025 (2 vs. 3)

Revision 305 Sep 2012 - TWikiContributor

Line: 1 to 1
 
META TOPICPARENT name="TWikiTipsOfTheDay"

SpreadSheetPlugin for dynamic content

Changed:
<
<
Over 60 formulae are available through the SpreadSheetPlugin.
>
>
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.
 
Changed:
<
<
For Example:
  • $AVERAGE()
  • $IF()
  • $REPLACE()
  • $TIME()
>
>
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)
 
Changed:
<
<
A formula can be placed anywhere in a topic, not just in a TWiki table.

Example:

To space out WikiWords, write:

>
>
Here is a complete example - to space out WikiWords, write:
  %CALC{"$PROPERSPACE(TWikiGuest)"}%
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 1999-2019 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.