Add an attachment
(proposed patch, testcase, etc.)
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, numbertext.org (dedicated site for
NUMBERTEXT resource development) and
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
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
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
>
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:
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
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.
Format For Printing
- XML
- Clone This Bug
- Top of page
FirstLastPrevNextThis bug is not in your last
search results.
Created attachment 63714 [details] NUMBERTEXT/MONEYTEXT specification
Created attachment 63716 [details] Soros language specification
Created attachment 64031 [details] NUMBERTEXT/MONEYTEXT specification 1.1