To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103746





------- Additional comments from [email protected] Tue Jul 28 13:56:10 +0000 
2009 -------
> 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


---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to