Numbertext

4.5
Average: 4.5 (18 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, 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, 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 OpenOffice.org Writer usage, see Linux Libertine G with Numbertext support and OpenOffice.org Typography toolbar.

= 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.
Version: 0.9.4
Date: 2010-Nov-03
Size: 70.64 KB
License: Opensource | Not specified

Source code: Browse source code
Downloads: Today: 26 | Week: 155 | Month: 709 | Year: 68,787

Comments

I was really excited to see

I was really excited to see this extension. I have a desperate need for it. But I need it in a Base Report. I confirmed that it's available in calc, but it does not appear in the Sun Report Builder. live vysledky .

Blizzard

Codies has released the launch trailer for Bodycount ahead of the game's UK release this Friday.Featuring new gameplay footage, the movie shows off the shooter's overpowered weaponry in action, tearing up bodies and 'shredding' destructible environments. Watch in HD リネージュ RMTNo comments yet, be the first! Last week Codemasters launched a developer diary focusing on the game's competitive multiplayer andco-op modes.A Bodycount demo is available for those of you who want to try out the game pre-release. Tom Ivan

This is is very usefull

This is is very usefull function but it converts number 100000 to one hundred thousand, instead of that is it possible to convert it to one lakh or 200000 as two lakh or 1,25,000 as one lakh twenty five thousand & so on?bet365,sázkové kanceláře . Thanks and wish all the best.

-

-

Thank you very much, also

Thank you very much, also for your important bug report about English decimals. I have sázkové kanceláře fixed it in version 0.6.1. I will have a presentation in the next OpenOffice.org conference about the sázkové tipy Numbertext.org project and Soros programming, so I would be glad to your questions, too, not only for your great bug reports.sázky .Thanks and wish all the best to all.

Error in pt-BR numbers

There is no *ciento* nor *cientos* in pt-br numbers. So, numbers having 101 to 199, 400 to 499 and 600 to 999 in any group are spelled wrong. Please, change it to *cento* and *centos* ( file numbertext_pt_BR.py ? ).

Thank you for this great extension.

Error in Portuguese numbers

I'll try posting again, the first try was deleted as spam. The Portuguese spelling of 100 in the numbers 101 to 199 is "cento", not "ciento".

ru_RU subunits

In russian subunits of USD, GBP & EUR are «male», so digit «2» (that has male/female distinction) must be also «male»: “два цента” not “две цента” (USD, EUR), “два пенса” not “две пенса” (GBP).
Could you fix it?

Also would you be so kind to add in ru_RU -- Ukrainian currency (that is very needful for Russian-speaking Ukrainians) . Just one line:
UAH:(\D+) $(\1: гривна, гривны, гривен, копейка, копейки, копеек)

Thanks in advance!

Fixed in 0.9.4

Thanks for your bug report and patch. (By the way, there is a new module for the Vietnamese language, too.)

MoneyText availablity in Sun Report Builder?

I was really excited to see this extension. I have a desperate need for it. But I need it in a Base Report. I confirmed that it's available in calc, but it does not appear in the Sun Report Builder.

Any ideas on how I could access it from the report?

Maybe not yet, but

I've posted your question to the Sun Report Builder site:
http://extensions.services.openoffice.org/en/project/reportdesign#commen...

There are several methods to use Numbertext in the source code of Sun Report Builder: service FunctionAccess of OpenOffice.org UNO and Numbertext Java jar, so I hope, the developers of the Report Builder will be interested in it.

Traditional Chinese Numbers

Excellent little tool.
Would it be possible to add in traditional chinese numbers used for writing cheques as follows:
零 壹 貳 叁 肆 伍 陸 柒 捌 玖 拾 佰 仟 萬
0 1 2 3 4 5 6 7 8 9 10 100 1000 10000

It would be a very useful option to have.
many thanks
Muddler

Solution: [NatNum5] number formatting

OpenOffice.org supports native number formats of Chinese, Japanese, Korean etc. languages by special formatting codes. Set the cell language to traditional Chinese, and use the following custom number formatting code:

[NatNum5]#

The cell with 1230 will show "壹仟貳佰參拾".

Try the language id "zh-ZH-2" for formal Chinese numerals

Eg. MONEYTEXT(1230;"CNY";"zh-ZH-2") returns with "壹仟贰佰叁拾". The result is in simplified Chinese characters, so I will add the zh-TW module for the traditional ones in the next release. Thanks for your comment, László

Can't install!!![URGENT]

Hey.

I can't install this plugin on my computer which is running Pardus 2009.2 with all the latest software.

I get the following error message:

loading component library failed: file:///opt/OpenOffice.org/lib/000-3.2/program/../basis-link/program/pyt...

Install openoffice-python package

OpenOffice.org contains Python and PyUNO, the requierements of the Numbertext extension, but some Linux distributions remove them to separated packages. On Pardus Linux you have to install the openoffice-python package.

Conversion error

Works great! Thanks a lot!
But there is a small error converting number "3783,48" to russian.
In Calc (3.2) it gives "Conversion error".
On site it responds "три тысячи рубля сорок восемь копеек"
but should "три тысячи семьсот восемьдесят три рубля сорок восемь копеек".
Maybe you check what is the problem?
Thank you again for your great job!

Fixed in 0.9.2

I had made a bad back reference in one the rules of the Russian module. Fixed in the newest release. Many thanks for your report.

Is it possible to format the text

Hello,
This is is very usefull function but it converts number 100000 to one hundred thousand, instead of that is it possible to convert it to one lakh or 200000 as two lakh or 1,25,000 as one lakh twenty five thousand & so on?
Regards,
Dhanil

new module "en-IN" with lakh and crore

Hello Dhanil, I have added the en-IN module to the Numbertext 0.9.1. A question: what about the ordinal numbers? Now are lakhth and croreth. Regards, László

"features" in russian moneytext, numbertext 0.8.1

Hello!
Thank you for this cool and very useful extention!
Found some bugs:
Moneytext:
- in many financial documents i must write number of thousands when thousands=1:
1000=одна тысяча, like in english module
- It is not necessary to write lead "ноль рублей" when roubles=0
0,01=одна копейка, for example
- 90=девяносто (not "девятьдесят"), also in Numbertext
- and what rogerclc (02/26/2010 - 08:54) told about, but not only (1, 21, 31, 41). Also for 51, 61, 71, 91
51,51=пятьдесят один рубль пятьдесят одна копейка
61,61=шестьдесят один рубль шестьдесят одна копейка
71,71=семьдесят один рубль семьдесят одна копейка
81,81=восемьдесят один рубль восемьдесят одна копейка
91,91=девяносто один рубль девяносто одна копейка
Numbertext correct is:
- 1,001=одна целая и одна тысячная and so on x,xx1
- 1,01=одна целая и одна сотая and so on [x,21...x,91] step 0,1
- 1,1=одна целая и одна десятая
- x,11= "x" и одиннадцать сотых
- x,011= "x" и одиннадцать тысячных and so on [x,011...x,911] step 0,1
- [0,2...0,9]=["ноль целых две"... "ноль целых девять"] десятых
- may be it's better to limit fractional part to 3 digits after comma before conversion to text. (guess theese values never be used)
I understand that is very difficult task to write in many languages, so i have to thank you again for working on it!

Fixed in Numbertext 0.8.2

Many thanks for your detailed bug report! Fixed in the last release.

Moneytext

the polish version contains an error in writting 20, 30 and 40 after the coma, it should read "jeden zloty dwadziescia groszy" and instead, it reads "jeden coma dwa zlote". The same error exist in 1,30 / 1,40 and so on...

Fixed in Numbertext 0.8.1

Thanks for your bug report.

Compatibility with OOo 3.2: Language not recognized

Hello,
first of all: Thanks for this great extension.

In OOo 3.2 (DE; Win XP and Win 7) obviously the language of the document is not recognized by both numbertext and moneytext, so you always have to insert the parameters for language and currency. Do you plan to release an update for OOo 3.2? Would be really great!

Fixed in Numbertext 0.8

Hello, Numbertext 0.8 restores the original function for the Western languages. Many thanks, László

Been looking for this for ages...

Dear Developer(s),

A superb program that I could never write myself - thank you!

If I could be so bold - some grammatical corrections for the Russian "Moneytext" for your consideration:

- for numbers ending in 1 that are not 'teens' (1, 21, 31, 41, 101, 121, etc.): roubles = рубль; kopeks = копейка
- for all numbers ending in 1 in the kopeks column (.01, .21, etc): one = одна

eg:

21.00 = двадцать один рубль
21.01 = двадцать один рубль одна копейка
21.21 = двадцать один рубль двадцать одна копейка

Fixed in Numbertext 0.8

I have fixed the Russian module according to your bug report. Many thanks, László

MONEYTEXT

Dear Developer(s),

After testing MONEYTEXT I find the bug in 1 eurocent it's write 10. Follow that link http://img264.yfrog.com/i/appunti02.jpg/

Regards,
Nicolas Pagni

Fixed in Numbertext 0.7.1

Thanks for your report. I have found and fixed similar mistakes in the Afrikaans and Dutch modules, too. László

spelling

The swedish for 7 is "sju" not "sjo".

Fixed in Numbertext 0.7.1

Thanks for your report. László

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...

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.

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

Need more information

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

Regards,
László

#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

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ó