/
Table Editor screen

Table Editor screen

Information valid from AMI version 8.0 initial release

Summary

This article details the functionality of the Table Editor.

Select the content of a cell to edit it.





Selecting Columns, Rows and Cells

You can select rows and columns by clicking on their header cells (leftmost column for selecting rows, topmost row for columns). You can select multiple rows and columns with Ctrl/Cmd + click and Shift + click.

To select a range of cells (as opposed to a set of rows or columns), click on a cell and hold until the cell is highlighted. Move the cursor while still holding down the mouse button to select adjacent cells.

Moving Rows and Columns

You can move selected columns left or right:

  •  Move selected columns one position to the left
  •  Move selected columns one position to the right
  •  Move selected columns as far left as possible
  •  Move selected columns as far right as possible

You can move selected rows up or down:

  •  Move selected rows one position upwards
  •  Move selected rows one position downwards
  •  Move selected rows as far up as possible
  •  Move selected rows as far down as possible

Removing Rows and Columns

Select Remove to remove all the selected rows and columns.

Adding New Rows and Columns

Select Add to add a new row or column. By default, Add will prompt you to select references to include in the new cells, but you can also choose to add empty rows or columns. If you switch to adding empty cells then that will remain the default action for Add until you re-open the Table Editor.

Add references...

If you have selected a row, you are presented with a dialog that lets you select objects, either from a browser or from the clipboard. After selecting Next, the second dialog lets you reorder those objects. 
The third dialog lets you select attributes of the objects you have chosen. The final dialog lets you reorder the attributes.
One row will be created for each object you selected, and the cells of the new rows will contain references to the attributes you chose.

If you have selected a column, the same four dialogs are presented to you, but you select attributes first and objects second.

Add empty rows/columns...

Select the number of rows or columns to add, and whether to insert them before or or after the current selection point.

If the table is empty, select both the number of rows and columns to add.

Duplicating Cells, Rows and Columns

You can copy and paste a cell, range of cells, or one or more rows or columns. Your selections do not need to be contiguous, but you cannot select both rows and columns at the same time.

Duplicating Rows

Select the rows to be duplicated then select  (Copy) to copy rows to the AMI clipboard.

To paste, select target rows then select  (Paste) to paste according to these rules:

  • If there are the same number of rows selected as there are on the clipboard, the rows on the clipboard replace the selected rows
  • If there are more rows selected than there are on the clipboard, the rows on the clipboard replace the same number of selected rows, with the remaining selected rows being unaffected
  • If there are fewer rows selected than there are on the clipboard, the selected rows are replaced by the same number of rows from the clipboard, with the remaining clipboard rows being inserted as new rows immediately after the last selected row.

Duplicating Columns

This is exactly the same as for rows, but with columns selected.

Duplicating Cells

Select a single target cell to paste cells into a table. Select  (Paste) to paste the cells on the current page of the AMI clipboard, with the selected cell corresponding to the top left one of the incoming cells.

If there is not room in the table to fit all the cells on the clipboard an error dialog is displayed: create new rows and/or columns to make room.

Creating and Destroying Straddles

A straddle is formed from a rectangular block of contiguous cells. Select  (Straddle) to merge selected cells into a single, larger cell, whose content matches the top left merged cell. you can merge an existing straddle with neighbouring cells and straddles.

If you select a single straddle, then  changes to  (Unstraddle). This reinstates the cells that were previously merged to form it. They will be empty apart from the top left cell, which will have the content of the straddle.

Editing cell content

Select the content of cells to edit it using the attribute editor. The click should be quick, because otherwise it will be interpreted as selecting the cell.

Editing an Empty Table Attribute

When you select an empty instance of a table attribute you can choose to create a new table based on a Table Style or to build the table manually, using the Table Editor.

When the Table Editor opens for an empty table attribute it shows this image:

Add is enabled, and selecting it opens the Add Rows dialog by default. From then on, the process is identical to adding rows to an existing table.

You can also choose to create a table from a file with the Import from file... option. Select a CSV file to create a table. The content of the table's cells will be unreferenced text.

Undoing Changes

The Table Editor keeps a list of all the changes you have made in it (including copying elements to the clipboard) since the last time the table was saved. Select Undo to completely reverse your last change, 

You can undo your uncommitted changes one at a time by selecting Undo repeatedly, and changes can then be reapplied by selecting Redo. In this way it is possible to completely reverse all your changes, and then reapply them all again.

Redo is disabled as soon as you make a new change and all your "undone" changes are lost.

If you save changes by selecting OK or Save then Undo is no longer an option.

Related pages