Selecting and editing data in lists

To a large extent, you can select the common functions and hotkeys in spreadsheet programs and subsequently edit, copy, delete or paste the data. Some attributes cannot be changed; these cells are displayed in gray in the lists.

Note: In lists, you can use the  Attribute selection icon to show and hide attribute values (Selecting attributes and subattributes for columns of a list).

List sections in which you can select data

You can select the following areas in lists:

  • all cells
  • an individual cell
  • adjacent cells in multiple rows
  • adjacent cells in multiple columns
  • adjacent cells in multiple rows and columns
  • non-adjacent cells
  • row by row
  • column by column
  • non-adjacent rows or columns

You edit data in lists depending on their data type. The following types of cells exist:

  • Cells, in which you enter text or values
  • Cells, in which you select one or more options or for which the selection can be canceled
  • Cells, in which you select one or multiple entries from list box .

Entering text or values in a cell

To change the text or value of cell that can be edited, you have to mark the cell.

1.  Click or double-click into the desired cell.

An entry is marked.

When you click or double-click a selected cell, the cell content is marked and an insertion marker is displayed at the end of the cell.

2.  In the cell, click the position to which you want to move the insertion marker.

3.  Enter the desired data.

4.  To complete your entry, press Enter.

The entry is completed.

5.  If desired, click another cell.

Entering text or values in multiple cells

If you highlight multiple cells that contain similar data, changing the data in one cell will automatically change the data in all highlighted cells.

1.  Mark the desired cells in the list.

2.  Enter the desired data.

3.  To complete your entry, press Enter.

4.  If desired, click another cell.

Selection options in cells

Using the mouse, you can only select options for individual data sets or you can cancel the selection.

  • ►  Click in the list of the desired option:

The option is selected.

The option is not selected.

Using the keyboard, you can also activate or deactivate options for multiple cells at the same time.

1.  Mark the desired cells in the list.

2.  Press the space bar.

 All options are selected.

 Not all options are selected.

Selecting data in cells via list boxes

In cells with list boxes, you can click a value in the list box (which contains various values), e.g. a reference to other objects. Cells with list boxes are marked with the button .

1.  Point the cursor at the right border of the cell.

2.  Click on the symbol.

A list box opens.

You have the following options to highlight the entry:

  • Click the desired entry.

The entry is selected.

  • Enter the first or the first few characters of the entry.

The first entry that begins with the characters entered is selected.

Defining data in cells with list boxes

In some cells that contain list boxes, you can create a new entry. The first entry of the list boxes is Add.

1.  If the desired cell is not selected, double-click the cell. If the desired cell is selected, click the cell.

A list box opens.

2.  In the cell, in the list box, click the first entry Add.

If there is a window for editing the attributes of this object type, and it should be shown according to your user preferences, this window opens. You can enter attributes for the new object. Otherwise, the new object is created with the default values.

3.  If the window for editing has opened, enter the data of your choice.

4.   Confirm with OK.

Opening the Edit <network object name> window from a list

If for a network object, there is an Edit <network object name> window, in the Edit <network object name> window, you have the following options to open an attribute list:

  • Row header: Double-click the row header of the desired entry.
  • Non-editable cell: Double-click a non-editable cell of the desired row.
  • Cell with option: In the row of your choice, double-click a non-editable cell next to a selected option  or a deselected option .