Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Implement default NUMBERTEXT/MONEYTEXT spreadsheet functions in Calc for number to number name conversion | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | nemeth.lacko | ||||||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||||||
Status: | CONFIRMED --- | QA Contact: | |||||||||
Severity: | Trivial | ||||||||||
Priority: | P3 | CC: | grakic, issues, ooo | ||||||||
Version: | OOo 3.1 | ||||||||||
Target Milestone: | --- | ||||||||||
Hardware: | All | ||||||||||
OS: | All | ||||||||||
URL: | http://numbertext.org | ||||||||||
Issue Type: | FEATURE | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Attachments: |
|
Description
nemeth.lacko
2009-07-23 15:54:06 UTC
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 http://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 http://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 > 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ó Created attachment 64031 [details]
NUMBERTEXT/MONEYTEXT specification 1.1
The new release with localizable CalcAddIn.xcu and CompatibilityNames: http://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 http://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. Reset assigne to the default "issues@openoffice.apache.org". |