Difference: TWikiTip025 (1 vs. 2)

Revision 22021-06-04 - TWikiAdminUser

 
META TOPICPARENT name="TWikiTipsOfTheDay"

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

Deleted:
<
<

Revision 12021-06-04 - TWikiAdminUser

 
META TOPICPARENT name="TWikiTipsOfTheDay"

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

View topic | History: r2 < r1 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 1999-2021 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.