Does Lotus have User-Defined Functions?

[RosewoodCrocket]

Hi guys,

I have three questions relating to user-defined functions using Lotus:

(1) Does Lotus provide the ability to use LotusScript to produce a User Defined Function (UDF) as can be done in Excel? That is, can you produce a function that returns a value based on inputs to the function and then utilize that function within the spreadsheet environment as you would an @Function()?

(2) If this can be done, could someone show a simple example of how to, say, make an @SumIt() function, which in Excel VBA, might look like this:

Sub SumIt(Arg1 As Variant, Arg2 As Variant)
    SumIt = Arg1 + Arg2
End Sub

(3) Are such UDFs prevented from manipulating the spreadsheet environment as they are in Excel? For example, in Excel, UDFs are prevented from deleting rows, or affecting cell formatting or the like. Are Lotus UDFs also similarly prevented?

Thanks in advance! I really appreciate any and all help on this...

-- Mike

 

[RosewoodCrocket]

Sorry, my bad, in the above, the UDF code for Excel VBA should have been a Function, not a Sub:

Function SumIt(Arg1 As Variant, Arg2 As Variant)
    SumIt = Arg1 + Arg2
End Sub

I don't know how to edit after it has been submitted, or I would have simply edited the above. Sorry for any confusion, and I appreciate any and all help... Thanks in advance.

-- Mike