TWiki > TWikiTipsOfTheDay > TWikiTip025	Daya Bay webs: Public | 中文 | Internal | Help
			Log In or Register

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:

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

to get:

TWiki Guest

More Information...

See More Tips...

-- Contributors: TWiki:Main.PaulineCheung