Using Paste Elements

image_pdfimage_print

In a new spreadsheet, make sure that the cursor is placed in the cell in which you want to paste elements. Then select Paste Elements to open the following dialog:

You can choose a connection at the top left corner and a dimension below. Note that you can only handle elements of one dimension at a time.

If you have selected one single element, you can click the Paste button. The element will be inserted with the function PALO.ESELECT in the spreadsheet cell.

Double-click on that cell to open a new dialog window, which allows you to select another element from the same dimension. Use “+” and “-” to open and close one level. “Expand all” and “Collapse all” refers to the entire element tree.

With more than one selected element, you can build column titles (Paste vertically) or row titles (Paste horizontally). Open the whole dimension with the “++” button:

With the option “More” on the bottom right, you can show more selection tools. In the screenshot above, the “South” is selected and its sub-elements are selected  by clicking the “Select branch” icon. When pasted vertically, the following list appears in the spreadsheet:

As you can see in the formula bar of the screenshot above, such row titles are displayed as text, not as a function.

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...