Ask Your Question
2

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

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

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
3

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

Regina gravatar image

Yes. Example:


function MYFKT (byVal x as double) as double
dim oFunction as variant
oFunction = createUnoService("com.sun.star.sheet.FunctionAccess")
dim aArgument(2) as variant
dim result as double
aArgument(0)=x
aArgument(1)=2
aArgument(2)=3
result = oFunction.callFunction( "FDIST", aArgument() )
MYFKT = result
end function
edit flag offensive delete link more

Comments

This is more of a currying than a function.

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

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

sargdavid gravatar image

I think this this should answer your question:

http://www.oooforum.org/forum/viewtopic.phtml?t=24943

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 259 times

Last updated: Jan 07 '14