SumInWords Function for LibreOffice Calc

SUMINWORDS() Description

The SUMINWORDS() function is designed to convert a number or sum written in numbers into text.

Quite often, for accounting purposes, the value of a trade transaction needs to be spelled out in words. For example, the amount 10 568,23 display in writing how "Десять тисяч п'ятсот шістдесят вісім гривень 23 копійки" , i.e. the required sum in Ukrainian language, but there is no standard function for such purposes in LibreOffice Calc.

Main Features Functions SUMINWORDS

Syntax:

=SUMINWORDS(Amount; LangCode; CurrCode)

Parameters:

• Amount: The number to be converted to text.
• LangCode: Text language in the form of a two-letter code. Three languages are available: "UK" - Ukrainian, "RU" - Russian and "EN" - English.
• CurrCode: Currency in the form of a three-letter code. Three currencies are available: "UAH" - hryvnia, "RUB" - ruble and "USD" - dollar.

Example Usage

The SUMINWORDS() function is easy to use. You just need to enter any number in the formula, specify the language in which you want to display the number, and specify the currency of the amount of money, and LibreOffice Calc will automatically convert it to text:

=SUMINWORDS(123562,31; "UK"; "UAH")

We will have the following result:

This example uses the following values:

• Amount: A2 - Number to be converted to text (123562,31) .
• LangCode: B2 - the Ukrainian language in the form of a two-letter code ("UK") .
• CurrCode: C2 - Ukrainian hryvnia in the form of a three-letter code ("UAH") .

Extension "YouLibreCalc.oxt"

You can use the function SUMINWORDS() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.