TWiki TWikiTip025 (2 vs. 3)

Welcome | Register | Changes | Topics | Index | Search | Go

<<O>> Difference Topic TWikiTip025 (3 - 2012-09-05 - TWikiContributor)

  META TOPICPARENT 
 name="TWikiTipsOfTheDay" 

 SpreadSheetPlugin for dynamic content
- META TOPICPARENT
+ name="TWikiTipsOfTheDay"
-<
<
+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.
-<
<
+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)
-<
<
+A formula can be placed anywhere in a topic, not just in a TWiki table.
->
>
+Here is a complete example - to space out WikiWords, write:
-<
<
+Example:

To space out WikiWords, write:
 %CALC{"$PROPERSPACE(TWikiGuest)"}% 

to get:

TWiki Guest

More Information...

See More Tips...

-- Contributors: TWiki:Main.PaulineCheung

View | History: r3 < r2 < r1 | More

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