1.5 Data Tables
1.5.5 Editing the Contents of a Table
• "Editing Table Entries Directly in the Table" on page 82 • "Copying and Pasting in Tables" on page 83
• "Searching for and Replacing Text Entries in Tables" on page 85.
1.5.5.1 Editing Table Entries Directly in the Table
To edit table entries directly in the table:
1. Click the Network or Parameters explorer.
2. Right-click the data folder of which you want to display the data table. 3. Select Open Table from the context menu.
4. Edit the content of the table by entering the value directly in the field (see Figure 1.27).
5. Click elsewhere in the table when you have finished updating the table. Your changes are automatically saved.
You can only move several columns at the same time when they are adjacent.
Figure 1.26: Moving a column
If a list of options has been defined for a field, you can select a value from the list (see
1.5.5.2 Copying and Pasting in Tables
In Atoll, you can copy and paste data in tables using the Copy (Ctrl+C), Cut (Ctrl+X), and Paste (Ctrl+V) commands on the Edit menu. You can copy and paste data to create new records or you can copy and paste the same data into several cells. This section covers the following topics:
• "Copying and Pasting a Table Record" on page 83 • "Pasting the Same Data into Several Cells" on page 84.
• "Pasting Vector Point Coordinates from an External XLS File" on page 85
1.5.5.2.1
Copying and Pasting a Table Record
You can create a new record in tables by copying an existing record, pasting it into a new row and editing the details that are different.
To create a new record by copying and pasting:
1. Open the data table as explained in "Opening a Data Table" on page 76.
2. Click in the left margin of the table row containing the record to select the entire row. 3. Select Edit > Copy to copy the table row.
4. Click in the left margin of the table row marked with the New Row icon ( ) to select the entire row.
5. Select Edit > Paste to paste the copied data into the new row. Atoll, creates a new record from the copied data. The
name of the new record is the same as that of the copied record, preceded by "Copy of." You can edit this name. Figure 1.27: Editing data in the transmitters data tables
Figure 1.28: Choosing data in the transmitters data tables
1.5.5.2.2
Pasting the Same Data into Several Cells
You can paste the same data into several cells, using Fill Up or Fill Down. To paste the same data into several cells:
1. Open the data table as explained in "Opening a Data Table" on page 76.
2. Click on the cell with the data you want to copy and drag to select the cells into which you want to copy the data (see
Figure 1.29).
3. Copy into the selected cells:
• To copy the contents of the top cell of the selection into the other cells, right-click the selection and select Edit >
Fill Down from the context menu or click the Fill Down button ( ) in the Table toolbar (see Figure 1.30).
• To copy the contents of the bottom cell of the selection into the other cells, right-click the selection and select
Edit > Fill Up from the context menu or click the Fill Up button ( ) in the Table toolbar (see Figure 1.31). Figure 1.29: Selecting the cells
1.5.5.2.3
Pasting Vector Point Coordinates from an External XLS File
You can copy-paste vector point coordinates from an external XLS file directly into the vector points table of an Atoll project. When you copy, make sure that the X and Y columns are in 2nd and 3rd positions in the XLS file (insert an empty 1st column if necessary) and select entire rows (except the headers). When you paste in Atoll, click inside an editable cell before pasting.
1.5.5.3 Searching for and Replacing Text Entries in Tables
In Atoll, you can search for and replace text strings in the table entries.
1.5.5.3.1
Searching for Text Entries in Tables
In Atoll, you can search for text strings in the table entries. To search for text strings in a table:
1. Press Ctrl+Shift+F. The Find dialog box appears.
You can also click the Find button ( ) in the table toolbar.
2. In the Find button, define what you want to find: a. Enter the text you want to find in the Find what box.
b. Select whether you want to search Up or Down from your current position in the table. c. If desired, select the Match case check box.
3. Click Find Next.
1.5.5.3.2
Replacing Text Entries in Tables
In Atoll, you can search for and replace text strings in the table entries. To search for and replace text strings in a table:
1. Press Ctrl+Shift+R. The Replace dialog box appears.
You can also click the Replace button ( ) in the table toolbar.
2. In the Replace button, define the text you want to find and replace: a. Enter the text you want to find in the Find what box.
b. Enter the text you want to replace the text in the Find what box in the Replace with box. c. If desired, select the Match case check box.
3. Click Find Next. Atoll proceeds to the next entry of the text entered in the Find what box.
You can replace the text found:
• Replace: Atoll replaces the selected text with the entry in the Replace with box.
• Replace All: Atoll replaces all occurrences of the text in the Find what box with the entry in the Replace with box.