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.
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.
Removing Rows and Columns
Select to remove all the selected columns.
Select to remove all the selected rows.
Adding New Rows and Columns
Select to add an empty column to the left of the selected column, or to add an empty column to the right of it.
Select to add an empty row above the selected row, or to add an empty row below it.
Add references...
Select to add references in columns, where objects are listed from top to bottom.
Select to add references in rows, where objects are listed from left to right.
Both these options will open a wizard with these steps:
- 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. - Optionally, change the order of the objects.
- 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.
The references you insert will have implied values for Structure, Parent and Language. You can change these with the Update Tags function.
Merging and Unmerging cells
A straddle is formed from a rectangular block of contiguous cells. Select (Merge) to merge selected cells into a single, larger cell (a "straddle"), 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 (Unmerge). 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 to remove all content from the selected cell or cells.
Editing cell content
Double-click on a cell to edit its content using the attribute editor. See 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 using the Table Wizard or with a number of empty columns and rows.
Rebuild Table
Select to discard all the columns and rows in the table and open the Table Wizard.
Convert to Manual Table
Select to change the table from one based on a table style to a manual table. Any changes to the table style originally used will no longer affect the table.
Update Tags
Select to change the Structure and/or Language values for the references ("tags") in the selected cells.
You can change the Structure value to either be "implied", where it will be based on whichever context is used to publish the table, or the the current structure of the object instance where the table is being edited.
You can change the Language value to be "implied", or to the current language version of the table attribute being edited, or to a specific language version. Note that choosing "Change to the current language" is in effect a shortcut equivalent to selecting the current language from the "Change to a selected language" list.