globemopa.blogg.se

I had a problem when I wanted to use a spreadsheet function that required two range addresses for arguments but I played around with it until I figured out that only one Array function was required. Above, RngAdd is a string naming a range (by the form B1:D15). The Array function can take numbers, text, variables, or, as above, range or cell addresses.

Once open, Select a category of functions to shorten the list, then scroll down through the named functions and select the required one. The name is easy - justĪrguments are transferred to the spreadsheet function by an array using an array function. To open the Function Wizard can be opened through, the menu choose Insert Function or using the shortcut key press Ctrl+F2. Name of the spreadsheet function being calledĪnd the arguments being transferred to the The callFunction function has two parts, the The Apache OpenOffice User Forum is an user to user help and discussion forum for exchanging information and tips with other users of Apache OpenOffice, the open source office suite.