Home › Browse Extensions

Numbertext

by nemeth
(8 votes)

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. Supported languages: Africaans, Belgian French, Brazilian Portuguese, Catalan, Chinese, Czech, Dutch, English, Esperanto, Finnish, French, German, Greek, Hungarian, Italian, Japanese, Korean, Luxembourgish, Polish, Portuguese, Romanian, Russian, Serbian (Latin and Cyrillic), Slovenian, Spanish, Swedish, Swiss French, Thai. See also http://NUMBERTEXT.org.

= Installation and usage =
Tools->Extension Manager->Add
After restarting OpenOffice.org, there are two new Calc functions, NUMBERTEXT() and MONEYTEXT(), i.e.:
=NUMBERTEXT(25)
=NUMBERTEXT(25;"th-TH")
=MONEYTEXT(25)
=MONEYTEXT(25;"USD")
=MONEYTEXT(25;"CNY";"zh-ZH")

Download extension
Operating System: System Independent
Compatible with: OpenOffice.org 2.4 | StarOffice 8 Update 9 or higher.
Official release: 0.6.1
Date: 2009-Sep-04
Size: 52.65 KB
View all releases
License: opensource | Read license
Source code: Browse source code
Further product information: Product details
Report abuse here | Contact extension owner
  • 5427 downloads initiated
  • 64 downloads this week

Comments

Fri, 09/04/2009 - 10:15 — bmarcelly

Splendid !

First, many thanks for this splendid and useful extension we have been waiting for years!

From a programming point of view the algorithm is extremely elegant and versatile, compared to other implementations I have seen. Maybe some day I will understand it...

Fri, 09/04/2009 - 15:54 — nemeth

Thanks

Thank you very much, also for your important bug report about English decimals. I have fixed it in version 0.6.1. I will have a presentation in the next OpenOffice.org conference about the Numbertext.org project and Soros programming, so I would be glad to your questions, too, not only for your great bug reports.

Tue, 06/30/2009 - 14:16 — nicolo74

Non funziona

Ho cercato di installare "numbertext" un'estensione di openoffice calc ma
appena immetto come formula "numbertext" attraverso "funzioni" in calc e
faccio riferimento come valore ad una cella che contiene un numero come
risultato mi da "#valore". Se qualcuno può aiutarmi, gli sarei molto grato.
P.S. usare un linguaggio abbastanza semplice perchè non sono un tecnico e ne
capisco poco.
Potete inviare risposta a: avvnicolovignanello@libero.it
Grazie in anticipo.
Cordiali saluti

Sun, 08/09/2009 - 18:23 — nemeth

Need more information

Could you send some data about the versions and distributions of your OpenOffice.org and operating system?

Regards,
László

Mon, 06/08/2009 - 06:25 — mushtaque_asghar

#MACRO? Error Occured

Dear Developer(s),

After testing this extension with XLS and ODS files in Calc, it was found that #MACRO? error occurs in excel file while ods file does support it. It is suggested to enable the same features for excel file also while accessing it through calc.

Regards,
Mushtaque Asghar

Sun, 08/09/2009 - 18:18 — nemeth

Fixed in Numbertext 0.3

Dear Mushtaque Asghar,

Thanks for the hint of Eike Rathke in OOo Issue 103746 (http://lingucomponent.openoffice.org/issues/show_bug.cgi?id=103746) and the excellent Calc Add-in example of Jan Holst Jensen (http://biochemfusion.com/doc/Calc_addin_howto.html), the new module (0.3) works well with XLS format, too.

Regards,
László