On Thu, 10 Mar 2005 00:14:27 -0500 Kohei Yoshida wrote: > On Thu, 10 Mar 2005 11:41:53 +0800, > [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > Hello > > > > I'm stuck on what is probably a simple question. I have created a function > > in StarBasic to simplify the cell formulae that I'm writing in a Calc > > spreadsheet. I want to be able to call the standard sheet functions like > > LOG10, POWER, LOOKUP from my little BASIC function and I can't figure out > > if (or what) fully qualified name I need to prefix (in this example) Log10. > [snip] > > Hi there, > > To access spreadsheet's builtin functions, you need to use the > FunctionAccess service. > > You can see the code below just for an example of how to use it. [...] > It gets a bit tricky on how arguments are passed to a function of > different type, but I hope you get the idea. > > More on this below: > http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XFunctionAccess.html
Great! Thanks for the example Kohei, I'm up and running :) All the best Harry --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
