IBM Lotus Symphony
|
You can apply user-defined functions in Lotus® Symphony™ Spreadsheets in the following ways:
You can define your own functions using Macros. This method requires a basic knowledge of programming.
You can program functions as add-ins. This method requires an advanced knowledge of programming.
Enter the function code. In this example, we define a VOL(a; b; c) function that calculates the volume of a rectangular solid with side lengths a, b and c:
Function VOL(a, b, c) VOL = a*b*c End Function
Close the Basic-IDE window.
Your function is automatically saved in the default module and is now available. If you apply the function in a Lotus Symphony Spreadsheets document that is to be used on another computer, you can copy the function to the Lotus Symphony Spreadsheets document as described in the next section.
In stage 2 of "Defining A Function Using Lotus Symphony Basic", in the Macro dialog you clicked on Edit . As the default, in the Macro from field the My Macros - Standard - Module1 module is selected. The Standard library resides locally in your user directory.
If you want to copy the user-defined function to a Lotus Symphony Spreadsheets document:
In the Macro from field select My Macros - Standard - Module1 and click Edit.
In the Basic-IDE, select the source of your user-defined function and copy it to the clipboard.
Close the Basic-IDE.
Select
.In the Macro from field select (Name of the Lotus Symphony Spreadsheets document) - Standard - Module1. Click Edit.
Paste the clipboard contents in the Basic-IDE of the document.
Once you have defined the function VOL(a; b; c) in the Basic-IDE, you can apply it the same way as the built-in functions of Lotus Symphony Spreadsheets.
Open a Lotus Symphony Spreadsheets document and enter numbers for the function parameters a, b, and c in cells A1, B1, and C1.
Set the cursor in another cell and enter the following:
=VOL(A1;B1;C1)
The function is evaluated and you will see the result in the selected cell.