To edit a table
About editing tables
To open the Edit Table window, click the Edit Table button in either:
- The Object window
- The Attribute panel of the diagram
In the Attribute panel, select Definition from the Attribute dropdown menu.
The Edit Table window: The Edit Table window looks much like the Result window table view. The difference is that you can add indexes and edit the values in cells.
Edit a cell: Click the cell, and start typing to replace what’s in it. To add to what’s there, click three times to get a cursor in the cell, and type. You can use left-arrow and right-arrow keys to move the cursor. Press Enter to accept the value and to select the next cell, or click in another cell.
Select a cell: Click the cell once.
Select a range of cells: Drag the cursor from a cell at one corner of a rectangular region to the cell at the opposite corner.
Copy and paste a cell or region: You can copy a cell or a range (two-dimensional rectangular region) of cells from a table or paste a cell into a region, just as with a spreadsheet:
- Select the source cell or region as above, and choose Copy from the Edit menu or press Control+c.
- Select the destination cell (or top-left cell of the destination region), and choose Paste from the Edit menu or press Control+v.
If you select a destination region that is n times larger (width, height, or both) than the source cell or region, it repeats the source n times in the destination.
Accept: Click to accept all the changes you have made to the table. If you close a table, it also accepts the changes, unless you click .
Cancel: Click to cancel all the changes you have made to the table since you opened it or last clicked .
Copy and paste to or from a spreadsheet: Copy and paste of a cell or region works much the same from a spreadsheet to an Analytica table or vice versa. If necessary, you can easily pivot the Analytica table so its rows and columns correspond with those in the spreadsheet. It copies numbers in exponential format with full precision, no matter what number format is used in the table, so that other applications can receive them with no problems.
Copy an entire table: To copy a table, including its row and column headers, click the top-left cell to select the whole table. You can also copy a table with more than two dimensions: Select Copy table from the Edit menu. When you paste into a spreadsheet, it includes the name of the table, and all indexes, including the slicer index(es) for the third and higher dimensions.
Entering multi-line text: When entering multi-line text or multiple line expressions into single cells of an edit table, press Ctrl+Enter while editing the cell contents to insert a new line within the cell. Pressing just Enter when editing the contents of a cells accepts the changes for that cell and leaves the cell edit; hence, you need to hold Alt when inserting the new line. You can also select Add new line within cell from the right-mouse context menu while editing.
Editing or extending indexes in an edit table
One convenient aspect of Intelligent Arrays is that you can edit and extend the indexes of an array right in the edit table, to change index values, insert or remove rows or columns, or, more generally, subarrays.
This works for an index defined as a list of numbers or list of labels. If an index is defined in another way — for example as m .. n or Sequence(x1, x2, dx) — you must edit the original index. Either way, all edit tables that use the changed index are automatically modified accordingly.
To edit or extend an index, either you must be in edit mode or the index variable you want to modify must have an input node.
Edit a cell in a row or column index: Click the cell once to select its row or column. Then double-click the cell to select its contents. Start typing to replace the text or number. Remember, the same change happens to all tables that use that index.
Append a row: Click the bottom element of the row index to select the bottom row, and press the down-arrow key or select Append Row from the Edit menu.
Append a column: Click the rightmost element of the column index to select the right column, and press the right- arrow key or select Append Column from the Edit menu.
Insert a row or column:
- Click the row or column header to select the row or column before which you wish to insert a new one.
- Select Insert Rows (or Insert Columns) from the Edit menu, or press or Control+i.
Normally, the new row or column contains zeros. You can change this default with the system variable Sys_tableCellDefault
. You can also set table-specific default values, using the TableCellDefault
attribute.
Reordering items :Items in a list view can be reordered by selecting one or more items and dragging the selected region to a new position. There is also a Reorder command on the right-mouse context menu. After selecting Reorder, move the mouse or use the arrow keys to move the selected cells to a newposition in the list.
Delete a row or column:
- Click the row or column header to select the row or column you wish to delete.
- Choose Delete Rows or Delete Columns from the Edit menu, or press Control+k.
Add an index: To add an index, use one of these two methods:
- Draw an arrow from the index to the node containing the table. When it asks if you want to add the index as a new dimension of the table, answer Yes.
- Click in the edit table to open the Indexes dialog. Double-click the index you want to add, and click OK.
When adding a new dimension to an edit table, it copies the values of the table to each new sub-array over the new index. Thus, the expanded table has the same values for every element of the new index. This has no effect on other edit tables.
Remove an index: To remove an index, use one of these two methods:
- Draw an arrow from the index to the node containing the table. When it asks if you want to remove the index as a dimension of the table, answer Yes.
- Or, click in the edit table to open the Indexes dialog. Double-click the index you want to remove, and click OK.
See Also
- Tutorial: Arrays
- To make an edit table
- Shortcuts to navigate and edit a table
- Table
- Table view of a result
- Inserting Choice Controls in Edit Table Cells
- Choice menus and Checkboxes in an edit table
- Dropdown menus in an Edit table
- MakeChangesInTable
Enable comment auto-refresher