SpreadSheetPlugin for dynamic content

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

More Information...

See More Tips...

-- Contributors: TWiki:Main.PaulineCheung

r3 - 05 Sep 2012 - 06:16:09 - TWikiContributor
 
Linux & Open Source for AT91 Microchip Microprocessors

Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.

Linux® is the registered trademark of Linus Torvalds in the U.S. and other countries.

Microchip® and others, are registered trademarks or trademarks of Microchip Technology Inc. and its subsidiaries. This site is powered by the TWiki collaboration platform

Arm® and others are registered trademarks or trademarks of Arm Limited (or its affiliates). Other terms and product names may be trademarks of others.

Ideas, requests, contributions ? Connect to LinksToCommunities page.

Syndicate this siteRSS ATOM