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.
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)
Here is a complete example - to space out WikiWords, write:
%CALC{"$PROPERSPACE(TWikiGuest)"}%
to get:
TWiki Guest
-- Contributors: TWiki:Main.PaulineCheung
|
|
|
Copyright © 1999-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Daya Bay? Send feedback Note: Please contribute updates to this topic on TWiki.org at TWiki:TWiki.TWikiTip025. |