Difference: TWikiTip025 (1 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)"}%

Revision 228 Jun 2010 - TWikiContributor

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

SpreadSheetPlugin for dynamic content

Line: 10 to 10
 
  • $REPLACE()
  • $TIME()
Changed:
<
<
A formula can be placed anywhere in a topic. not just in a TWiki table.
>
>
A formula can be placed anywhere in a topic, not just in a TWiki table.
  Example:
Line: 26 to 26
  See More Tips...
Changed:
<
<
-- TWiki:Main.PaulineCheung - 01 Feb 2005
>
>
-- Contributors: TWiki:Main.PaulineCheung

Revision 105 Feb 2005 - TWikiContributor

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

SpreadSheetPlugin for dynamic content

Over 60 formulae are available through the SpreadSheetPlugin.

For Example:

  • $AVERAGE()
  • $IF()
  • $REPLACE()
  • $TIME()

A formula can be placed anywhere in a topic. not just in a TWiki table.

Example:

To space out WikiWords, write:

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

to get:

TWiki Guest

More Information...

See More Tips...

-- TWiki:Main.PaulineCheung - 01 Feb 2005

 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 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.