{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

ToWords

Converts a numeric value or currency to words so it can be used as in texts. The number of decimals places can be set. This function only converts the integer part of a number into words. The fraction is displayed with digits.

The conversion depends on the language on the client, if the value of the property "Use Client Locale" is true. You can find it in the configuration manager category "General Options".

Supported Languages:

The following languages are currently supported:

  • Chinese (Simplified)
  • Chinese (Traditional)
  • English
  • English (India)
  • French
  • German
  • Hungarian
  • Indonesian
  • Polish
  • Portuguese (Brazil)
  • Russian
  • Serbian
  • Serbian (Latn)
  • Spanish
  • Thai
  • Turkish

We can add more languages in the short term, if we can get the necessary information for the required language, e.g. from a native speaker.

Usage:

ToWords(value)
ToWords(value, places)
ToWords(value, places, locale)

Parameters:

value A number or currency that should be convertet to string
places An optional value indicating the number of decimal places to be converted, default is 2
locale A an optional value with the ISO 639-1 language code to set the conversion language. A language code is a lower-case, two-letter code as defined by ISO-639. You can find a full list of these codes at a number of sites, such as:http://www.loc.gov/standards/iso639-2/php/English_list.php (the last column)
Default is the current resource locale.

Returns:

String

Examples:

ToWords(7) // Returns "seven and xx/100".
ToWords(7,3)// Returns "seven and xx/1000".
ToWords(732.573,2) // Returns "seven hundred thirty-two and 57 / 100".
ToWords(732.573,0,"en-US") // Returns "seven hundred thirty-two" in any environment
ToWords(value,0)+" euro "+ToWords((value-Truncate(value))*100,0)+" cent" // Returns "twelve euro thirty-four cent" for 12.34

See also:

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - toWords