User Functions

Discuss the spreadsheet application
Post Reply
jayheiman
Posts: 2
Joined: Wed Nov 28, 2007 5:53 pm

User Functions

Post by jayheiman »

I've got a number of "user" functions implemented in excel that I'd like to transfer to calc but I don't seem to be able to get them to work quite like they do in excel and I can't find any clear explanation of how to do this.

A spreadsheet with an example of a simple user function, something like userfunction(x) which would return a constant value would be wonderful. Otherwise, a pointer to a location explaining how to do this?

Thanks
User avatar
probe1
Volunteer
Posts: 277
Joined: Mon Oct 08, 2007 1:34 am
Location: Chonburi Thailand

Re: User Functions

Post by probe1 »

You can use user defined functions: just place the code in a module in "Standard" library of OOo
Cheers
Winfried

DateTime2 extension: insert date, time or timestamp, formatted to your needs
User avatar
h1h
Posts: 40
Joined: Wed Nov 28, 2007 8:45 pm

Re: User Functions

Post by h1h »

Jay,
here a file with two functions, one very simple, the other a little less simple. I hope that gets you on your way.
Cheers
Attachments
jayheiman.ods
macros must be enabled !
(8.22 KiB) Downloaded 459 times
OOo 2.4 (from OOo-site) on Linux
Post Reply