~kosova/+junk/tuxfamily-twiki

« back to all changes in this revision

Viewing changes to foswiki/data/System/TipTopic025.txt

  • Committer: James Michael DuPont
  • Date: 2009-07-18 19:58:49 UTC
  • Revision ID: jamesmikedupont@gmail.com-20090718195849-vgbmaht2ys791uo2
added foswiki

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
%META:TOPICINFO{author="ProjectContributor" date="1107572937" format="1.1" version="$Rev$"}%
 
2
%META:TOPICPARENT{name="TipsOfTheDay"}%
 
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 Foswiki table.
 
14
 
 
15
Example:
 
16
 
 
17
To space out WikiWords, write: 
 
18
 
 
19
=%<nop>CALC{"$PROPERSPACE(<nop>WikiGuest)"}%= 
 
20
 
 
21
to get:
 
22
 
 
23
=%CALC{"$PROPERSPACE(WikiGuest)"}%=
 
24
 
 
25
[[SpreadSheetPlugin][More Information...]]
 
26
 
 
27
[[TipsOfTheDay][See More Tips...]]