• No results found

Editing the Contents of a Table

In document Atoll 3.3.2 User Manual MW (Page 64-68)

1.5 Data Tables

1.5.5 Editing the Contents of a Table

You can edit the content of a table in Atoll in several different ways:

• "Editing Table Entries Directly in the Table" on page 64

• "Copying and Pasting in Tables" on page 65

• "Searching for and Replacing Text Entries in Tables" on page 67.

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.28).

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.27: Moving a column

If a list of options has been defined for a field, you can select a value from the list (see Figure 1.29) or enter a new value.

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 65

• "Pasting the Same Data into Several Cells" on page 66.

• "Pasting Vector Point Coordinates from an External XLS File" on page 67

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 58.

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.28: Editing data in the transmitters data tables

Figure 1.29: Choosing data in the transmitters data tables

Each record in a table must have a unique Name.

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 58.

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.30).

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.31).

• 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.32).

Figure 1.30: Selecting the cells

Figure 1.31: Copying the contents of the top cell

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.

Figure 1.32: Copying the contents of the bottom cell

In document Atoll 3.3.2 User Manual MW (Page 64-68)