Using a real programming language you can package your function as a
Calc function add-in, which can be seen as a special type of add-on.
You've got to implement
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XAddIn.html
which is impossible in StarBasic. Add-in functions allow for localized
function names, function descriptions and argument descriptions to be
used in help files, the function navigator and the function wizard.
Basic functions to be used as cell functions need to be stored in the
special Basic library "Standard" in container "My Macros" or in the
document's container (may be the OOo container works as well).
"Standard" is always loaded, so the sheet can find the called Basic
function.
Contrary to method get/setDataArray() sheet functions operate on
2-dimensional arrays. Any result that needs to be returned in array
context has to be a 2D array rather than a nested list of columns within
rows. See also
http://api.openoffice.org/docs/common/ref/com/sun/star/script/ArrayWrapper.html
with example at
http://www.oooforum.org/forum/viewtopic.phtml?t=59534&highlight=arraywrapper
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
