LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

Numbertext

NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion for more than 30 languages.

★ ★ ★ ★ ☆
Calc Extensions
Download latest

latest release: 2024-03-20 04:12:08

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 Description Compatibility Operating Systems License Release notes Updated  
1.0.11 Fixes for several languages and for the Soros interpreter. New modules: Persian (Farsi), mul.sor 3.3 Linux, Windows, macOS BSD 2022-11-13: 1.0.11 release:
* Soros.cxx/java/js/py: fix boundary inheritance of
optional function (conditional text), reported by Juanma Sanchez
and Antonio Bueno
* test/*, configure.ac, Makefile.am: add C++ unit testing
* Soros.cxx: fix an assert seen with in libreoffice crashtesting on
an empty string, by Caolán McNamara

New modules:

* fa.sor: new Persian (Farsi) module by Amir Hossein Maher
* mul.sor: new module with note symbols for multiple languages

Module fixes and extensions:

* ca.sor: revert removing conditional text
* cs.sor: fix ordinals, cardinals, currencies by Stanislav Horáček,
with help of Zdeněk Crhonek
* da.sor: revert removing conditional text
* en.sor: add extra currencies (BZF, DKK, ILS, LKR, ZMW, ZWD) for
LibreOffice locales of Number Format dialog windows
* es.sor: add extra currencies (PAB, SVC, VED/VES) for LibreOffice,
revert removing conditional text
* ga.sor: add currency support
* hu_Hung.sor: fix regression of transliteration of parenthesized words
in LibreOffice, reported by Zoltán Óvári
* ro.sor: strip first space and remove double space in currency
* ru.sor: fix grammar of cents by Alex Ivanov
* sl.sor: fix cardinal-masculine and cardinal-neuter,
reported by Martin Srebotnjak
* uk.sor: fix grammar of cents by Alex Ivanov

LibreOffice Calc add-on:

* CalcAddIn.xcu: new Russian translation by Evgeniy Kukhtinov
2022-12-01 18:57:06 Download
1.0.9 New languages: Irish (ga), Luganda (lg, by Phillip Samuel), Maltase (mt), Marathi (mr, by Ankur Heramb Joshi). Fixes in several languages. 3.3 Linux, Windows, macOS LGPL Fixes in Bulgarian, Chinese, Estonian, Finnish, French, Galician, Greek, Hungarian, Italian, Korean, Japanese, Latvian, Polish, Spanish, Thai, Russian and Ukrainian.

 

2022-04-01: 1.0.9 release:
* hu_Hung.sor: fix regression of transliteration of punctuation marks

2021-12-31: 1.0.8 release:
* src/Soros.py: fix FutureWarning: Possible nested set at position, reported by Rene Engelhard
* fr.sor:
- use hyphens instead of spaces, e.g. cent-deux, reported by "4560041" at GitHub
- new prefix "informal" for 1100–1900 (onze-cents - dix-neuf-cents)
- add prefix "feminine" and "masculine" (1 -> une/un), bug reports by arena94 at GitGub
* hu_Hung.sor:
- fix transliteration of old Hungarian family names, bug report by Zoltán Óvári
- fix 100–199, 1000–1999, 1000000–1999999 and 1000000000–1999999999 (bad ordering)
– fix conversion of single letters "í", "Í" and "NY";
- fix unnecessary conversion of words ending with "q", e.g. "IQ";
- fix unnecessary conversion of words not ending with unknown letters
* mr.sor: Marathi spelling corrections by Shantanu Oak
* pl.sor: fix ordinal 20-29, reported by Gabryha at GitHub
* uk.sor, CalcAddIn.xcu, description.xml.in: fix spell by Olexandr Nesterenko
- replace apostrophe symbol to U+02BC, reported by Volodymyr Lisivka
- up number to 10^42
- add cardinal, update help
- add uk locale
* zh.sor: add ordinal numbers, use always 二 for 2, reported by Ming-Hua

2021-01-31: 1.0.7 release:
* ga.sor: new module Irish by László Németh
* lg.sor: new module Luganda by Phillip Samuel
* mr.sor: new module Marathi by Ankur Heramb Joshi
* mt.sor: new module Maltase by László Németh

* fi.sor: fix ordinal 0, bug report by Tuomas Hietala
* hu_Hung.sor:
- fix transliteration of Vörösmarty, bug report by Zoltán Óvári
- replace ü and ű by Viktor Kovács
- fix transliteration of dates with affixation
* th.sor: fix big (>999,999) numbers by Vladislav Kiper
* ua.sor: fix euro cent, bug report by Kty0mka

2020-06-01: 1.0.6 release:
* Numbertext.cxx: don't depend on en_US.UTF-8 locale by Stephan Bergmann
* Java:
- clean-up by Balázs Meskó with Maven support
- port special logic for Norwegian language from C++ by Ilya Idamkin
* Makefile.am: prefix for datadir by Li-Wen Hsu
* bg.sor: avoid using \d and \D by Mihail Balabanov
* ee.sor: update Estonian language spellings by Alvar Laigna
* el.sor: fix "and" before currency fractions and "zero" in case of 0 whole euro by Spiros Evangelatos
* es.sor: fixes by Juanma Sanchez, and based on him report
* gl.sor, es.sor: fix ISO codename of Honduran lempira by Ilya Idamkin
* fr.sor: fix EUR 200, 300 etc., bug report by armik71
* hu.sor: fix date function for 1
* hu_Hung.sor:
- Old Hungarian transliteration support for words
- remove obsolete function left-to-right
- add sch -> s, ä -> é transliteration by Viktor Kovács
* it.sor: fix ordinal numbers, bug report by dario-gallucci
* ja.sor: fix word "negative" (负 -> 負), bug report by cmplstofB
* ko.sor, en.sor: fix Korean module and add Korean Won unit by DaeHyun Sun
* lv.sor: fix 40, 50 ... 90, bug report by andritis
* my.sor, en.sor: add Malay currency MYR by Bee Ing
* ru.sor, uk.sor: fix cardinal and feminine RUB, UAH usage by Alex Ivanov
* th.sor: fix usage of 1 by Ilya Idamkin and tyindeepit
2022-04-01 09:28:13 Download
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
* 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
2020-03-05 23:06:48 Download
1.0.5 New Estonian module and language fixes. 5.0 Linux, Windows, macOS LGPL 2018-10-09: 1.0.5 release:
    * 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
2020-03-05 23:06:47 Download
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 genders

 

2018-04-25: László Németh (nemeth numbertext org):
        * fix platform issues
        * Greek cardinal and ordinal genders

2018-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
        * 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
2020-03-05 23:06:47 Download
0.9.5 <ul><li>New modules: Latvian, Lithuanian
<li>Minor bug fixes for French, Portuguese, Spanish</ul>
3.6 LGPL 2020-03-05 23:06:45 Download
Show more

Related Extensions

VBA Expressions

Logo for VBA Expressions

VBA Expressions is a powerful string expression evaluator for LO Basic, providing the user with more than 100 mathematical, statistical, financial, date-time, logical and text manipulation functions, with support for variables and arrays.

10-2024

5738

★ ★ ★ ★ ★

Unlock The Matrix

Logo for Unlock The Matrix

Unprotects the array formula and returns it to the formula in the upper left cell.

04-2024

122

Not rated yet

MACROS EXTENSION FOR LIBREOFFICE

Logo for MACROS EXTENSION FOR LIBREOFFICE

Extension for scripting

04-2024

5832

★ ★ ★ ☆ ☆

Heimdall (goConfig) - The Configurator

Logo for Heimdall (goConfig) - The Configurator

Heimdall is an easy-to-use extension configurator. The configurator is multilingual.

04-2024

344

★ ☆ ☆ ☆ ☆

TexTra

Logo for TexTra

This extension performs translation on Writer, Calc. Impress.

04-2024

 

Not rated yet

Lox365: Modern functions for LibreOffice

Screenshot for Lox365: Modern functions for LibreOffice

Lox365 is a LibreOffice extension that adds modern spreadsheet functions like IMAGE to LibreOffice. https://github.com/goosepirate/lox365

10-2024

3747

★ ★ ★ ★ ☆

Feedback

★ ★ ★ ★ ☆

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

  • نوار حسام Aug 15, 2022, 11:35 AM (2 years ago)

    ☆ ☆ ☆ ☆ ☆

    Great extension
    How can i add new language to the package ??

  • hector czelada Oct 1, 2021, 8:51 PM (3 years ago)

    ★ ★ ★ ★ ★

    hi, on the website numbertext.org, says:

    numbertext-1.0.7.oxt (description)

    but the download option it is 1.0.5

    besides that, good work, it help me a lot

  • Vladyslav Orlov Jun 15, 2021, 5:10 PM (3 years ago)

    ★ ★ ★ ★ ★

    Good work! Just annoying typo for the number 15 in the Ukrainian language - the correct spelling is "П'ятнадцять", "дцять" instead of "дцать"

  • Raggy Nov 26, 2020, 4:59 PM (4 years ago)

    ★ ★ ★ ★ ★

    Works perfectly. Very useful !

  • Sasha Scheglov Sep 3, 2020, 2:58 AM (4 years ago)

    ★ ★ ★ ★ ★

    The best extension I ever used. Precise, correct and very versatile. I use it very often.

  • heri Jun 20, 2020, 4:18 PM (4 years ago)

    ★ ★ ★ ★ ★

    Thanks

RSS feed for reviews on this page | RSS feed for all reviews