data/TWiki/TWikiTip025.txt,v
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
colas@0
     1
head	1.1;
colas@0
     2
access;
colas@0
     3
symbols;
colas@0
     4
locks; strict;
colas@0
     5
comment	@# @;
colas@0
     6
colas@0
     7
colas@0
     8
1.1
colas@0
     9
date	2006.02.01.12.01.24;	author TWikiContributor;	state Exp;
colas@0
    10
branches;
colas@0
    11
next	;
colas@0
    12
colas@0
    13
colas@0
    14
desc
colas@0
    15
@new-topic
colas@0
    16
@
colas@0
    17
colas@0
    18
colas@0
    19
1.1
colas@0
    20
log
colas@0
    21
@buildrelease
colas@0
    22
@
colas@0
    23
text
colas@0
    24
@%META:TOPICINFO{author="TWikiContributor" date="1107572937" format="1.0" version="1"}%
colas@0
    25
%META:TOPICPARENT{name="TWikiTipsOfTheDay"}%
colas@0
    26
---+ !SpreadSheetPlugin for dynamic content
colas@0
    27
colas@0
    28
Over 60 formulae are available through the SpreadSheetPlugin.
colas@0
    29
colas@0
    30
For Example:
colas@0
    31
	* =$AVERAGE()=
colas@0
    32
	* =$IF()=
colas@0
    33
	* =$REPLACE()=
colas@0
    34
	* =$TIME()=
colas@0
    35
colas@0
    36
A formula can be placed anywhere in a topic. not just in a TWiki table.
colas@0
    37
colas@0
    38
Example:
colas@0
    39
colas@0
    40
To space out WikiWords, write: 
colas@0
    41
colas@0
    42
=%<nop>CALC{"$PROPERSPACE(<nop>TWikiGuest)"}%= 
colas@0
    43
colas@0
    44
to get:
colas@0
    45
colas@0
    46
=%CALC{"$PROPERSPACE(TWikiGuest)"}%=
colas@0
    47
colas@0
    48
[[SpreadSheetPlugin][More Information...]]
colas@0
    49
colas@0
    50
[[TWikiTipsOfTheDay][See More Tips...]]
colas@0
    51
colas@0
    52
-- TWiki:Main.PaulineCheung - 01 Feb 2005
colas@0
    53
colas@0
    54
@