| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Insert Members
Revision as of 15:36, 13 October 2010 by Antonio.remedios (talk | contribs) (Created page with '{{Code|XL3Member}} formulae can be inserted directly into the spreadsheet using the {{Menu|XLCubed|Insert Formula|Members}} ribbon or menu option. ''To insert memb…')
XL3Member formulae can be inserted directly into the spreadsheet using the XLCubed > Insert Formula > Members ribbon or menu option.
To insert members:
- Select the XLCubed > Insert Formula > Members ribbon or menu option
- Choose a location for the new formulae
- Choose the connection to use from the dropdown
- Select the hierarchy the desired members belong to
- Select the members to insert. An overview of how to select members can be found here
- Click OK and the formulae will be inserted
- If you want to just insert the captions of the members instead of XL3Member formulae, select the Insert as Text checkbox
- If multiple members are selected, they can be either inserted vertically (Insert down) or horizontally (Insert right)
