TWiki TWikiTip025 (1 vs. 3)

Welcome | Register | Changes | Topics | Index | Search | Go

<<O>> Difference Topic TWikiTip025 (3 - 2012-09-05 - TWikiContributor)

  META TOPICPARENT 
 name="TWikiTipsOfTheDay" 

 SpreadSheetPlugin for dynamic content
- META TOPICPARENT
+ name="TWikiTipsOfTheDay"
-<
<
+Over 60 formulae are available through the SpreadSheetPlugin.
->
>
+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.
-<
<
+For Example: 
 $AVERAGE()
  $IF()
  $REPLACE()
  $TIME()
->
>
+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)
-<
<
+A formula can be placed anywhere in a topic, not just in a TWiki table.
->
>
+Here is a complete example - to space out WikiWords, write:
-<
<
+Example:

To space out WikiWords, write:
 %CALC{"$PROPERSPACE(TWikiGuest)"}% 

to get:

TWiki Guest

More Information...

See More Tips...

-- Contributors: TWiki:Main.PaulineCheung

<<O>> Difference Topic TWikiTip025 (2 - 2010-06-28 - TWikiContributor)

  META TOPICPARENT 
 name="TWikiTipsOfTheDay" 

 SpreadSheetPlugin for dynamic content 

Over 60 formulae are available through the SpreadSheetPlugin.

For Example:
- META TOPICPARENT
+ name="TWikiTipsOfTheDay"
-<
<
+ $AVERAGE()
  $IF()
  $REPLACE()
  $TIME()
->
>
+ $AVERAGE()
  $IF()
  $REPLACE()
  $TIME()
-<
<
+A formula can be placed anywhere in a topic. not just in a TWiki table.
->
>
+A formula can be placed anywhere in a topic, not just in a TWiki table.
 Example:

To space out WikiWords, write: 

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

to get:

TWiki Guest

More Information...

See More Tips...
-<
<
+-- TWiki:Main.PaulineCheung - 01 Feb 2005
->
>
+-- Contributors: TWiki:Main.PaulineCheung
-<
<

<<O>> Difference Topic TWikiTip025 (1 - 2005-02-05 - TWikiContributor)

META TOPICPARENT	name="TWikiTipsOfTheDay"

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:

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

to get:

TWiki Guest

More Information...

See More Tips...

-- TWiki:Main.PaulineCheung - 01 Feb 2005

View | History: r3 < r2 < r1 | More

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.