Issue 103746 - Implement default NUMBERTEXT/MONEYTEXT spreadsheet functions in Calc for number to number name conversion
Implement default NUMBERTEXT/MONEYTEXT spreadsheet functions in Calc for numb...
Status: CONFIRMED
Product: Calc
Classification: Application
Component: code
OOo 3.1
All All
: P3 trivial (vote)
: ---
Assigned To: nemeth.lacko
http://numbertext.org
:
: 3702 (view as issue list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-07-23 15:54 UTC by nemeth.lacko
Modified: 2013-08-07 15:13 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation on: ---
Developer Difficulty: ---


Attachments
NUMBERTEXT/MONEYTEXT specification (19.48 KB, application/vnd.oasis.opendocument.text)
2009-07-24 11:18 UTC, nemeth.lacko
no flags Details
Soros language specification (16.22 KB, application/vnd.oasis.opendocument.text)
2009-07-24 11:47 UTC, nemeth.lacko
no flags Details
NUMBERTEXT/MONEYTEXT specification 1.1 (20.14 KB, application/vnd.oasis.opendocument.text)
2009-08-10 01:12 UTC, nemeth.lacko
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description nemeth.lacko 2009-07-23 15:54:06 UTC
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, http://numbertext.org (dedicated site for
NUMBERTEXT resource development) and
http://extensions.services.openoffice.org/project/numbertext (Numbertext extension).
Comment 1 nemeth.lacko 2009-07-24 11:18:28 UTC
Created attachment 63714 [details]
NUMBERTEXT/MONEYTEXT specification
Comment 2 nemeth.lacko 2009-07-24 11:43:44 UTC
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
Comment 3 nemeth.lacko 2009-07-24 11:47:42 UTC
Created attachment 63716 [details]
Soros language specification
Comment 4 ooo 2009-07-24 13:08:10 UTC
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?
Comment 5 nemeth.lacko 2009-07-24 17:45:27 UTC
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)
Comment 6 nemeth.lacko 2009-07-26 11:07:57 UTC
er: Is there any way to store add-on function references in Excel files for
OpenOffice.org 3? (Question of Mushtaque Asghar in
http://extensions.services.openoffice.org/project/numbertext).
Comment 7 ooo 2009-07-28 14:56:10 UTC
> 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
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCompatibilityNames.html
and the DevGuide section it links to.

  Eike
Comment 8 nemeth.lacko 2009-07-30 19:29:57 UTC
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
>
http://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ó

Comment 9 nemeth.lacko 2009-08-10 01:12:39 UTC
Created attachment 64031 [details]
NUMBERTEXT/MONEYTEXT specification 1.1
Comment 10 nemeth.lacko 2009-08-10 01:35:57 UTC
The new release with localizable CalcAddIn.xcu and CompatibilityNames:

http://extensions.services.openoffice.org/project/numbertext
Comment 11 ooo 2009-08-27 13:20:18 UTC
*** Issue 3702 has been marked as a duplicate of this issue. ***
Comment 12 nemeth.lacko 2010-04-20 15:24:22 UTC
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.

Comment 13 nemeth.lacko 2010-04-21 14:02:43 UTC
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
http://office.microsoft.com/en-us/help/HP051862221033.aspx
Comment 14 grakic 2010-06-07 15:14:06 UTC
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.