Difference between revisions of "Insert Members"
(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…') |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{Code|[[XL3Member|XL3Member]]}} formulae can be inserted directly into the spreadsheet using the {{Menu| | + | {{Code|[[XL3Member|XL3Member]]}} formulae can be inserted directly into the spreadsheet using the {{Menu|FluenceXL|Insert Formula|Members}} ribbon or menu option. |
''To insert members:'' | ''To insert members:'' | ||
| − | # Select the {{Menu| | + | # Select the {{Menu|FluenceXL|Insert Formula|Members}} ribbon or menu option |
# Choose a location for the new formulae | # Choose a location for the new formulae | ||
# Choose the connection to use from the dropdown | # Choose the connection to use from the dropdown | ||
| Line 9: | Line 9: | ||
# Click '''OK''' and the formulae will be inserted | # Click '''OK''' and the formulae will be inserted | ||
| + | ==Additional Options== | ||
* If you want to just insert the captions of the members instead of {{Code|XL3Member}} formulae, select the '''Insert as Text''' checkbox | * If you want to just insert the captions of the members instead of {{Code|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''') | * If multiple members are selected, they can be either inserted vertically ('''Insert down''') or horizontally ('''Insert right''') | ||
Latest revision as of 09:21, 4 July 2023
XL3Member formulae can be inserted directly into the spreadsheet using the FluenceXL > Insert Formula > Members ribbon or menu option.
To insert members:
- Select the FluenceXL > 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
Additional Options
- 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)
