Daya Bay Reactor Neutrino Experiment
TWiki > TWikiTip025 (2 vs. 3)
Daya Bay webs: Public | 中文 | Internal | Help   Log In or Register

Welcome | Register | Changes | Topics | Index | Search | Go
 <<O>>  Difference Topic TWikiTip025 (3 - 2012-09-05 - 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)"}%

View | History: r3 < r2 < r1 | More

View | History: r3 < r2 < r1 | More
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 1999-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Daya Bay? Send feedback
Note: Please contribute updates to this topic on TWiki.org at TWiki:TWiki.TWikiTip025.