Table Editor v2 screen

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:

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  (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

Convert to Manual Table

Update Tags