Manage table columns.
To define column size
Set columns to either a specific or an automatic width.
- You can set the column width to
Manual and specify the number of characters allowed in a string. Strings over the specified amount are truncated unless word wrapping is selected.
- You can set the column width to
Automatic, which adjusts the width to accommodate the longest string in the column.
- In the
Table Style dialog box, click the
Data Properties tab.
- Under
Structure, click a
Column Width icon
to display the selections.
- Click either
Automatic or
Manual.
- If you select
Manual, enter the number of characters.
- Click
OK.
To rearrange columns
Rearrange and move columns in the table by dragging them.
- In the
Table Style dialog box, click the
Data Properties tab.
- Under
Structure, click the column to be moved in its title cell and drag it to the new position.
Note: You cannot move the first table column.
To add columns
Add or delete columns in a table.
- In the
Table Style dialog box, click the
Data Properties tab.
- Under Structure, click
to add a column.
- Double-click the blank column heading to open the Text Component Editor window.
- Enter a title, and then click
OK.
- Double-click the blank
Column Value cell and select a property on the Properties tab of the Text Component Editor.
To delete columns
- In the
Table Style dialog box, click the
Data Properties tab.
- Under Structure, click the column and then click
.
- Click
OK.
To sort a column
Sort columns in ascending or descending order.
- In the
Table Style dialog box, click the
Data Properties tab.
- Select the
Sort Data check box.
- Select the column whose rows you want to sort and specify whether the sort should be in
Ascending or
Descending order.
- Click
OK.
Important: Column sorting uses either a numerical method or a string method depending on the content of the first (top) cell in the column. This may not provide the expected order when sorting columns of data.
- If the first cell contains only numbers, then the sorting logic is numerical and accounts for non-numeric characters in their ASCII order.
- If the first cell contains a non-numeric character, then the sorting logic is based on ASCII string order and accounts for numeric characters in their ASCII order.
Refer to the following examples of how this sorting logic can affect the order.
- 16, 22, 365, 1, 14 would sort as 1, 14, 16, 22, 365 because the first data entry (16) is a number and is sorted numerically.
- EE, DCE, AD, ABC, BCD would sort as ABC, AD, BCD, DCE, EE because the first data entry (EE) contains a non-numeric character and is sorted by the ASCII string method.
- 100, 10, 1, 1A, 11A would sort as 1, 10, 100, 11A, 1A because the first data entry (100) is a number and is sorted numerically.
- 1, 1A, 1B, 2, 10 would sort as 1, 1A, 1B, 2, 10 because the first data entry (1) is a number and is sorted numerically.
- 1+, 1A, 1B, 2, 10 would sort as 1+, 10, 1A, 1B, 2 because the first data entry (1+) contains a non-numeric character and is sorted by the ASCII string method.
To define column titles
Column titles are displayed in the second row of a table.
The first column must be the tag column.
- In the
Table Style dialog box, click the
Data Properties tab.
- Under Structure, double-click a column heading to open the
Text Component Editor.
- Enter the column title.
- Format the text using the editing options.
- Click
OK.