data/TWiki/TWikiTip025.txt
author Colas Nahaboo <colas@nahaboo.net>
Sat, 26 Jan 2008 15:50:53 +0100
changeset 0 414e01d06fd5
permissions -rw-r--r--
RELEASE 4.2.0 freetown
     1 %META:TOPICINFO{author="TWikiContributor" date="1107572937" format="1.0" version="1"}%
     2 %META:TOPICPARENT{name="TWikiTipsOfTheDay"}%
     3 ---+ !SpreadSheetPlugin for dynamic content
     4 
     5 Over 60 formulae are available through the SpreadSheetPlugin.
     6 
     7 For Example:
     8 	* =$AVERAGE()=
     9 	* =$IF()=
    10 	* =$REPLACE()=
    11 	* =$TIME()=
    12 
    13 A formula can be placed anywhere in a topic. not just in a TWiki table.
    14 
    15 Example:
    16 
    17 To space out WikiWords, write: 
    18 
    19 =%<nop>CALC{"$PROPERSPACE(<nop>TWikiGuest)"}%= 
    20 
    21 to get:
    22 
    23 =%CALC{"$PROPERSPACE(TWikiGuest)"}%=
    24 
    25 [[SpreadSheetPlugin][More Information...]]
    26 
    27 [[TWikiTipsOfTheDay][See More Tips...]]
    28 
    29 -- TWiki:Main.PaulineCheung - 01 Feb 2005
    30