Defining the Table Format

Atoll lets you format the data tables so that the data presented is more legible or better presented. You can change the format of the data table by:

• "Formatting the Column Headers" on page 51

Figure 1.15: Editing data in the transmitters data tables

Figure 1.16: Choosing data in the transmitters data tables

You can also open the Record Properties dialogue by double-clicking the record. To avoid editing the record when you double-click, double-click the left margin of the record instead of the record itself. You can also select the record and click the Record Properties button ( ) in the Table toolbar.

• "Formatting Table Cells" on page 51

• "Changing Column Width or Row Height" on page 51 • "Displaying or Hiding a Column" on page 52 • "Freezing or Unfreezing a Column" on page 53 • "Moving Columns" on page 53

Formatting the Column Headers

To define the format of the column headers:

1. Open the data table as explained in "Opening a Data Table" on page 47. 2. Right-click the table. The context menu appears.

3. Select Format > Header Format from the context menu. The Format dialogue appears. 4. The Format dialogue has the following tabs:

- Font: You can select the Font, Outline (the font style), font Size, Effects, and Text colour.

- Colour: You can select the colour of the column headers by selecting a Foreground colour, a Background colour, and a pattern from the list box. You can also select a 3D Effect for the header.

- Borders: You can select the Border, the Type, and the Colour for each column header.

- Alignment: You can select both the Horizontal and Vertical alignment of the column header text. The Alignment tab has additional options as well, allowing you to enable Wrap text, Auto-size, and Allow enter.

5. Click OK.

Formatting Table Cells

To define the format of the table cells:

1. Open the data table as explained in "Opening a Data Table" on page 47. 2. Right-click the table. The context menu appears.

3. Select Format > Cell Format from the context menu. The Format dialogue appears. 4. The Format dialogue has the following tabs:

- Font: You can select the Font, Outline (the font style), font Size, Effects, and Text Colour.

- Colour: You can select the background colour (Interior) of the column headers, by selecting a Foreground colour, a Background colour, and a pattern from the list box. You can also select a 3D Effect for the header.

- Borders: You can select the Border, the Type, and the Colour for each column header.

- Alignment: You can select both the Horizontal and Vertical alignment of the column header text. The Alignment tab has additional options as well, allowing you to enable Wrap text, Auto-size, and Allow enter.

5. Click OK.

Changing Column Width or Row Height

You can change the column width and row height in a data table. When you change the column width, you change the width only for the selected column. When you change the row height, however, you change the row height for every row in the table.

To change the column width:

1. Open the data table as explained in "Opening a Data Table" on page 47.

2. Click the border separating two column headers and drag to change the column width (see Figure 1.17). To change the row height:

1. Open the data table as explained in "Opening a Data Table" on page 47.

2. Click the border separating two rows and drag to change the row height (see Figure 1.18). The width or height of the columns or rows change once you release the mouse.

Displaying or Hiding a Column

You can choose which columns in data tables to display or hide. To display or hide a column:

1. Open the data table as explained in "Opening a Data Table" on page 47. 2. Right-click the table. The context menu appears.

3. Select Display Columns from the context menu or click the Display Columns button ( ) in the Table toolbar. The Columns to Be Displayed dialogue appears (see Figure 1.19).

4. To display a column, select its check box. 5. To hide a column, clear its check box.

6. Click Close.

Figure 1.17: Changing column width

Figure 1.18: Changing row height

You can also hide a column by right-clicking on its header and selecting Hide Columns from the context menu or by clicking the Hide Columns button ( ) in the Table toolbar. You can hide more than one column by pressing CTRL while selecting the columns and then clicking the Hide Columns button ( ).

Freezing or Unfreezing a Column

In Atoll, you can freeze one or more columns of a data table so that they always remain visible as you scroll horizontally through the table. For example, while scrolling through the Sites table, you might want to have the Name column always visi- ble. You can keep this column, or any other column visible, by freezing it.

To freeze a column:

1. Open the data table as explained in "Opening a Data Table" on page 47.

2. Select the header of the column you want to freeze. Click and drag over several headers to select more than one column to freeze.

3. Right-click the selected header or headers and select Freeze Columns from the context menu or click the Freeze Col- umns button ( ) in the Table toolbar.

To unfreeze columns:

• Right-click the table and select Unfreeze All Columns from the context menu or click the Unfreeze All Columns button ( ) in the Table toolbar.

Moving Columns

In Atoll, you can change the column order so that you can group similar columns or present data in a determined order. To move a column:

1. Open the data table as explained in "Opening a Data Table" on page 47.

2. Select the header of the column you want to move. Click and drag over several headers to select more than one column to move.

3. Click again on the selected column and drag to the desired area. As you drag the column, the position the column will occupy is indicated by a red line (see Figure 1.20).

Figure 1.19: The Columns to Be Displayed dialogue

You can only freeze adjacent columns.

You can not freeze a column in a report table.

4. Release the mouse column to place the column.