Versions Compared

Version Old Version 1 New Version 2
Changes made by

xJon Finn

xJon Finn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info

Information valid from AMI version 8.0 SP 8 and 7.2 SP 4


Summary

This article details the functionality of the Table Editor.

Select the content of a cell to edit it. Use Control-click to select one or more cells.


Table of Contents
maxLevel2


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:

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

You can move selected rows up or down:

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

Removing Rows and Columns

Select (error) Image Added to remove all the selected columns.

Select (error)Image Added to remove all the selected rows.

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.

Select (error) to add a

Select Image Added to add an empty column to the left of the selected column, or (error)Image Added to add a an empty column to the right of it.

Select (error)Image Added to add a an empty row above the selected row, or (error)Image Added to add a an empty row below it.

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 Image Removed (Copy) to copy rows to the AMI clipboard.

To paste, select target rows then select Image Removed (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 Image Removed (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

Select Image Added to add references in columns, where objects are listed from top to bottom.

Select Image Added to add references in rows, where objects are listed from left to right.

Both these options will open a wizard with these steps:

  1. Select the objects.
    You may not select more objects than there are selected columns or rows, as applicable.
    If you choose to Include Attribute Name as Heading then that will take the place of an object. 
  2. Optionally, change the order of the objects.
  3. Select the references you wish to insert.
    You may not select more references than there are selected rows or columns, as applicable.
    These can be Attribute, Asset Relation, Price or Smart Attribute references.
    You can specify text to insert before the reference (Prefix), after the reference (Suffix) or to replace any unresolved references (Text If Missing).
    For Price references you must also specify which Price Style to use.

Merging and Unmerging cells

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

If you select a single straddle, then Image RemovedImage Added changes to Image Removed Image Added (UnstraddleUnmerge). 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.

Blanking cell content

Select (error)Image Added to remove all content from the selected cell or cells.

Editing cell content

Select the content of cells Double-click on a cell to edit it its content using the attribute editor. The click should be quick, because otherwise it will be interpreted as selecting the cellSee Attribute Editor screen for more information.

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:

Image Removed

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.

Info

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.

Wizard or with a number of empty columns and rows.

Rebuild Table

Convert to Manual Table

Update Tags