Ask Your Question

Can we use regular spreadsheet functions in Basic functions? [closed]

asked 2014-01-07 20:33:16 +0100

Bill-LibreOffice Newby gravatar image

For example, can Vlookup be included in a Basic function/ And if so, what is the format to use?
Would it be =vlookup(w,x,y,z) or =vlookup(w;x;y;z) ?

And is there something that needs to precede the function name? Thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 11:13:51.759740

2 Answers

Sort by » oldest newest most voted

answered 2014-01-07 21:01:34 +0100

Regina gravatar image

Yes. Example:

function MYFKT (byVal x as double) as double
dim oFunction as variant
oFunction = createUnoService("")
dim aArgument(2) as variant
dim result as double
result = oFunction.callFunction( "FDIST", aArgument() )
MYFKT = result
end function
edit flag offensive delete link more


This is more of a currying than a function.

Adobe gravatar imageAdobe ( 2016-07-19 23:06:48 +0100 )edit

answered 2014-01-07 21:04:33 +0100

sargdavid gravatar image

I think this this should answer your question:

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-01-07 20:33:16 +0100

Seen: 421 times

Last updated: Jan 07 '14