NUMBERASWORDS Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 23: | Line 23: | ||
**en — english | **en — english | ||
**fr — french | **fr — french | ||
* | == Example == | ||
To display a number in words a document, use a function like this: | |||
<div style="display: block; padding: 1em; margin: 0 0 10px; font-size: 13px; line-height: 1.65; color: black; word-wrap: break-word; background-color: #f9f9f9; border: 1px solid #ddd; border-radius: 4px;"><nowiki>NUMBERASWORDS(SUMM({{Task.Set price}}*{{Task.Amount}}); 0; "en")</nowiki></div> | |||
Revision as of 13:26, 25 November 2025
The function returns a number written out in words. Only the integer part of the number is converted; the fractional part is ignored.
format
NUMBERASWORDS(number; OutputMode; "language")
Where:
- number — a numeric value or a formula
- OutputMode:
- 0 — standard output
- 1 — words in feminine gender
- 2 — words in masculine gender
- 3 — words in neuter gender
- 4 — words in feminine gender, starting with a capital letter
- 5 — words in masculine gender, starting with a capital letter
- 6 — words in neuter gender, starting with a capital letter
- language
- "" (empty) — uses the language of the user who is generating the document
- en — english
- fr — french
Example
To display a number in words a document, use a function like this:
NUMBERASWORDS(SUMM({{Task.Set price}}*{{Task.Amount}}); 0; "en")