Numbertext
Tags: Calc Extensions
Rating: ★ ★ ★ ★ ★
NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion for more than 30 languages.
Description
NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion proposed for OpenFormula standard. MONEYTEXT is functionally top-compliant with the ECMA/ISO standard BAHTTEXT function, and supports more than 30 languages: Africaans, Belgian French, Brazilian Portuguese, Catalan, Chinese, Czech, Danish, Dutch, English, Esperanto, Finnish, French, German, Greek, Hebrew, Hungarian, Indonesian, Italian, Japanese, Korean, Latvian, Lithuanian, Luxembourgish, Polish, Portuguese, Romanian, Russian, Serbian (Latin and Cyrillic), Slovenian, Spanish, Swedish, Swiss French, Thai, Turkish and Vietnamese. For Java jar and JavaScript libraries, see http://NUMBERTEXT.org. For Writer usage, see Linux Libertine G with Numbertext support and Typography toolbar.
Homepage: http://www.numbertext.org
Release List
- Release Description Compatibility Operating Systems License Release notes
-
1.0.5
New Estonian module and language fixes.
5.0
Linux, Windows, macOS
LGPL
2018-10-09: 1.0.5 release:
Download
* et.sor: new Estonian module
* Java: fix path separator for Windows by Rens Toonen
* spellout: fix DEFPATH in spellout by Rene Engelhard
* README: conversion to MarkDown by Miklós Vajna
* da.sor: fix "en million", bug report by Hsonesson1
* de.sor: add function year by c-kuehl
* eo.sor: fix ordinal-number, ie. "1-a" by Adolfo Jayme Barrientos
* fi.sor: fixed and more currencies by Tuomas Hietala
* lt.sor: fix ordinal numbers and currencies by Aurimas Fišeras
* pl.sor: fix ordinal numbers 4x, 7x, bug report by tengwar
* sq.sor: add missing 1000-9999 -
1.0 beta 3
New Bulgarian (bg), Croatian (hr), Icelandic (is), Malaysian (ms) and Swiss Standard German (de-CH, de-LI) language support and more functions.
5.1
Linux, Windows, macOS
LGPL
2018-05-28: beta 3 release:
* src: numbertext renamed to spellout
* libnumbertext: fix cppcheck warnings by Julien Nabet
* java: add -encoding utf8 to javac call by Rene Engelhard
* LO extension: default capitalization, missing capitalization
was reported by TileStonePro
* bg.sor: new Bulgarian module by Mihail Balabanov
* cs.sor: fix for ordinal numbers, bug report by Stanislav Horáček
* hu.sor: add number, letter, day and month affixation
for extended number, cross reference and date formats
* is.sor: new Icelandic module by László Németh
* it.sor: add missing groups in ordinal numbers,
the problem was reported by Valter Mura
* lt.sor: fix typo, correct ordinal-number,
problem was reported by Modestas Rimkus
* ru.sor: ordinal numbers and fixes by Mike Kaganski
* sl.sor: ordinals, also genders and adverbials,
using also information by Martin Srebotnjak
* sv.sor: fix typos
* zh.sor: real native Simplified Chinese expressions by Suokunlong
* *.xcu:
- Bulgarian translation by Mihail Balabanov
- Spanish translation by Adolfo Jayme Barrientos
- fix typo by Rene Engelhard
* web:
- fix typo by Adolfo Jayme Barrientos
- add Bulgarian and Icelandic modules
2018-04-26: László Németh (nemeth numbertext org):
* rename numbertext executable to spellout,
add default data path: /usr/share/numbertext
and support environmental variable NUMBERTEXTPATH
* fix platform incompabilities
* Greek cardinal and ordinal genders2018-04-25: László Németh (nemeth numbertext org):
* fix platform issues
* Greek cardinal and ordinal genders2018-04-19: László Németh (nemeth numbertext org):
* More ordinal numbers (prefix: ordinal) and ordinal indicator formats (prefix: ordinal-number) and other functions
* see full function list with =NUMBERTEXT("help") (Enlarge the row height to see all rows of the module help)
* Soros programming language: revised draft:
- conditional text, prefix macros, language
variant program lines
* improved interpreters
* C++11 port
* language data:
- new Malaysian and Swiss Standard German
- compressed language modules
- instead of hu_HU_2, ja_JP_2, zh_ZH_2,
"formal" prefix allows formal number names here.
For example, MONEYTEXT(1200;"money HUF";"hu")
results "egyezerkettőszáz forint" instead of
"ezerkétszáz forint",
MONEYTEXT(123;"formal";"ja") results "参百弐拾壱"
instead of "三百二十一"
- instead of en_US_2, use "money" prefix combined
with currencies, eg. MONEYTEXT(1.01;"money USD")
results "one and 1/100 U.S. dollar" in LibreOffice
instead of "one U.S. dollar and one cent".2016-05-24: Liudas Ališauskas
Download
* Fix Lithuanian module
2014-05-10: Mihovil Stanić (mihovil.stanic gmail com):
* new Croatian module
2013-03-16: Jerzy Moruś
* Polish translation of LibO extension resource data -
1.0
New languages: Albanian (sq), Galician (gl, by Adrián Chaves), Norwegian Bokmål (no), Ukrainian (uk, based on Russian).
5.0
Linux, Windows, macOS
LGPL
* gl: new Galician module by Adrian Chaves
Download
* no: new Norwegian Bokmål and Nynorsk modules (only Bokmål is available, yet)
* sq: new Albanian module
* uk: new Ukrainian module based on Russian
* ca: fix ordinal indicators
* da: remove double spaces in money amounts
* es: use plural for 0 (in currency) by Adrian Chaves
* fi: fix currency names and large cardinals by Tuomas Hietala
* hu: article, suffixation and date support
* ru: fix ordinal-neuter
* tr: add ordinal numbers -
0.9.5
<ul><li>New modules: Latvian, Lithuanian
<li>Minor bug fixes for French, Portuguese, Spanish</ul>
3.6 LGPL Download
★ ★ ★ ★ ★
Post your review
You cannot post reviews until you have logged in. Login Here.
Reviews
Raggy Nov 26, 2020, 4:59 PM (2 months ago)
★ ★ ★ ★ ★
Works perfectly. Very useful !
Sasha Scheglov Sep 3, 2020, 2:58 AM (5 months ago)
★ ★ ★ ★ ★
The best extension I ever used. Precise, correct and very versatile. I use it very often.
heri Jun 20, 2020, 4:18 PM (7 months ago)
★ ★ ★ ★ ★
Thanks
No one has commented on this page yet.
RSS feed for reviews on this page | RSS feed for all reviews