TWikiTip025 < TWiki

---+ !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: 

=%<nop>CALC{"$PROPERSPACE(<nop>TWikiGuest)"}%= 

to get:

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

[[SpreadSheetPlugin][More Information...]]

[[TWikiTipsOfTheDay][See More Tips...]]

-- TWiki:Main.PaulineCheung - 01 Feb 2005

This topic: TWiki > TWikiTipsOfTheDay > TWikiTip025
Topic revision: r1 - 2005-02-05 - TWikiContributor

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.