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 Functions
Re: User Functions
You can use user defined functions: just place the code in a module in "Standard" library of OOo
Re: User Functions
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
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