NUMBERTEXT/MONEYTEXT spreadsheet functions are the generalization of the
ECMA/ISO standard BAHTTEXT function and a huge number language-dependent
third-party extensions of Microsoft Office Excel and OpenOffice.org.

See the attached specifications, numbertext.org (dedicated site for
NUMBERTEXT resource development) and
extensions.services.openoffice.org/project/numbertext (Numbertext extension).

Created attachment 63714 [details]
NUMBERTEXT/MONEYTEXT specification

Note: (it will be in the next version of the NUMBERTEXT/MONEYTEXT specification):

Used standards:

ISO 4217 for currency codes

Language codes: xx-XX, xxx-XX, xx-XX-variant, xxx-XX-variant

xx, xxx: ISO 639-1 and if necessary, ISO 639-2 language codes
XX: ISO 3166-1 alpha-2 country codes
variant: name of variant

Created attachment 63716 [details]
Soros language specification

Nice work :-)
But why did you create this OOo issue?

Btw, out of curiosity, what are the functions' names stored as in an ODF document?

er: Thanks. (By the way, there is a lot of interesting usage of NUMBERTEXT, for
example, usage for text to speech in telebanking and I just began to write a
variant of Hungarian NUMBERTEXT/MONEYTEXT rules for special rounding of
Hungarian Forint: the lowest valued coin of HUF is HUF 5.)

The aim of the NUMBERTEXT project is to standardize these functions, so I will
also write to the OASIS Formula subcommittee to propose these functions and
their technical background for standardization. I have also modified the summary
of this issue (Implement default NUMBERTEXT/MONEYTEXT spreadsheet functions in
Calc for number to number name conversion). 

About the stored function names: I have used some Calc Add-on example for the
NUMBERTEXT extension, the result from a saved example:

table:formula="of:=ORG.OPENOFFICE.ADDIN.SAMPLE.PYTHON.NUMBERTEXT.NUMBERTEXT.MONEYTEXT(454545)

er: Is there any way to store add-on function references in Excel files for
OpenOffice.org 3? (Question of Mushtaque Asghar in
extensions.services.openoffice.org/project/numbertext).

> The aim of the NUMBERTEXT project is to standardize these functions, so I will
> also write to the OASIS Formula subcommittee to propose these functions and
> their technical background for standardization.

Thank you for taking the initiative.

> I have also modified the summary of this issue (Implement default
> NUMBERTEXT/MONEYTEXT spreadsheet functions in Calc for number to number
> name conversion).

As you already provide the extension, we later should think about
including it with the installation set. For this it would have to be
fully localizable though (UI function names, parameters and
description).

> About the stored function names: I have used some Calc Add-on example for the
> NUMBERTEXT extension, the result from a saved example:
> 
> table:formula="of:=ORG.OPENOFFICE.ADDIN.SAMPLE.PYTHON.NUMBERTEXT.NUMBERTEXT.MONEYTEXT(454545)

Umm.. quite long ;-)  Why the duplicated NUMBERTEXT.NUMBERTEXT? Anyway,
as you already registered a domain for this purpose I'd suggest to use
that in the function names, for example ORG.NUMBERTEXT.NUMBERTEXT(12345) or
ORG.NUMBERTEXT.MONEYTEXT(12345)

> Is there any way to store add-on function references in Excel files for
> OpenOffice.org 3?

Yes, with compatibility names. Be sure you pick a name that is not used
by other Excel Add-Ins. As there are many, the safest bet might be to
use ORG.NUMBERTEXT.* as well. See
api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCompatibilityNames.html
and the DevGuide section it links to.

  Eike

er: Thank you for your help.

> As you already provide the extension, we later should think about
> including it with the installation set. For this it would have to be
> fully localizable though (UI function names, parameters and
> description).

I tried to search and use an XML resource file for this task without success.

> > About the stored function names: I have used some Calc Add-on example for the
> > NUMBERTEXT extension, the result from a saved example:
> > 
> >
table:formula="of:=ORG.OPENOFFICE.ADDIN.SAMPLE.PYTHON.NUMBERTEXT.NUMBERTEXT.MONEYTEXT(454545)

> Umm.. quite long ;-)  Why the duplicated NUMBERTEXT.NUMBERTEXT? Anyway,
> as you already registered a domain for this purpose I'd suggest to use
> that in the function names, for example ORG.NUMBERTEXT.NUMBERTEXT(12345) or
ORG.NUMBERTEXT.MONEYTEXT(12345)

It was a temporary solution. Thanks for the hint, I have shortened the name for
your suggestion. (I just seen that the OpenFormula standard supports the
function names in the same way, with name spaces.)

> > Is there any way to store add-on function references in Excel files for
> > OpenOffice.org 3?

> Yes, with compatibility names. Be sure you pick a name that is not used
> by other Excel Add-Ins. As there are many, the safest bet might be to
> use ORG.NUMBERTEXT.* as well. See
>
api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCompatibilityNames.html
> and the DevGuide section it links to.

Thanks. I will use it.

Regards,
László

Created attachment 64031 [details]
NUMBERTEXT/MONEYTEXT specification 1.1

The new release with localizable CalcAddIn.xcu and CompatibilityNames:

extensions.services.openoffice.org/project/numbertext

*** Issue 3702 has been marked as a duplicate of this issue. ***

Numbertext 0.8 has support for English, German and Hungarian ordinal numbers,
and it will be extended for other languages. See Issue 92730 for new numbering
types based on the spelling out of numbers.

It seems, this would be a competitive feature, because MS Word (maybe also
Excel) supports (only English) number and money amount to text conversion by its
field format switches \*CardText, \*OrdText, \*Ordinal and \*DollarText, see
office.microsoft.com/en-us/help/HP051862221033.aspx

There is a RFE from 2005 in issue 43043 with 6 votes and few duplicates for 
having the special spellout number format.

As stated in the issue description advantage of using number formats is that the 
users will be able choose the new spellout number formats from the list in Format
Cell->Numbers->Format and see the sample.