• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use

Item7848 for generic doc work for TWiki-6.1.1. Use

Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
• Does this site look broken?. Use the LitterTray web for test cases.

Item3876: Better documentation of `$FORMAT(PERCENT, ...)`

Item Form Data

AppliesTo:	Component:	Priority:	CurrentState:	WaitingFor:	TargetRelease	ReleasedIn
Extension	SpreadSheetPlugin	Normal	Closed		minor	4.2.0

Detail

Formatting a number in PERCENT returns the right formatting but the wrong value.

For example: %CALC{"$FORMAT( PERCENT, 0, 0.2 )"} returns 20, so calculating 20% of say 100, results in 2000.

-- TWiki:Main/IvanaCace - 11 Apr 2007

It may not be clearly documented, but PERCENT means to "multiply number by 100 and add a percent sign to it", e.g. 0.5 is 50%.

-- TWiki:Main.PeterThoeny - 14 Apr 2007

I updated the docs.

-- TWiki:Main.PeterThoeny - 14 Apr 2007

ItemTemplate
Summary	Better documentation of `$FORMAT(PERCENT, ...)`
ReportedBy	TWiki:Main.IvanaCace
Codebase
SVN Range	TWiki-4.1.2, Sat, 07 Apr 2007, build 13305
AppliesTo	Extension
Component	SpreadSheetPlugin
Priority	Normal
CurrentState	Closed
WaitingFor
Checkins	TWikirev:13385 TWikirev:13386
TargetRelease	minor
ReleasedIn	4.2.0