NUMBERASWORDS Function: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
No edit summary
Line 6: Line 6:
}}
}}
The function returns a number written out in words. Only the integer part of the number is converted; the fractional part is ignored.
The function returns a number written out in words. Only the integer part of the number is converted; the fractional part is ignored.
== format ==
== Format ==
  NUMBERASWORDS(number; OutputMode; "language")
  NUMBERASWORDS(number; OutputMode; "language")



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")