Edit Cell Data

Data in a cell can be edited directly in a list by double-clicking on the value so that it is selected and typing in a new value, or by selecting a different value from a list of values.

Successfully edited cells, unsuccessfully edited cells and read-only cells are indicated by their background color. See Cells for further information.

A failed attempt at editing the data in a cell may also be indicated by a red background color. For example:

Hover the mouse cursor over the cell to view the text of the message in the Tool Tip. The message will also be displayed in the status bar and recorded in the Message Log. See Messages and the Message Log for further information.

Edit Long Text

To aid in the editing of long text, the following facility is provided. Click within a cell, then click the bottom-right hand corner of the cell and drag it down and/or to the right to open a larger area in which to edit the text:

A new line of text can be added to a cell by pressing Alt+Enter.

Copy, Cut and Paste Commands

• To copy the content of a cell in a list, select the cell and click Copy in the Clipboard group of the Home Tab, or right-click and select Copy from the menu that is then displayed, or press Ctrl+C.

• To cut the content of a cell in a list, select the list and click Cut in the Clipboard group of the Home Tab, or right-click and select Cut from the menu that is then displayed, or press Ctrl+X.

• To paste into a cell in a list, select the cell and click Paste in the Clipboard group of the Home Tab, or right-click and select Paste from the menu that is then displayed, or press Ctrl+V.

Clear Cells

To quickly delete the contents of a cell or of multiple cells, select the cells and then right-click and select the Clear option from the menu that is then displayed.

Lists of Values

Lists of values are available for some fields, accessed from the arrow button which is displayed when the mouse cursor is hovered over them. For example:

Reference Browser

Some fields are provided with the facility to select values from a reference browser.

To access the browser for a field, click the ellipsis button which is displayed when the mouse cursor is hovered over it. The Reference Browser window is then displayed with the current value selected. For example:

Use the Explorer tab to browse the database structure for the required value.

Click OK. The window is then closed and the selected value populates the field in the list.

Alternately, search for the required value using the Search tab.

• Searches carried out using this facility search at and below the level in the database structure currently selected on the Explorer tab, as indicated at the top of the tab (for example, "Search In: /PROCESS_SYSTEMS").

• The Item Type field displays the type of element currently being searched for.

• To further restrict the search results, in the Name/Description field, enter a string. The search results will include only elements with that string in their name or description.

• Click Search to carry out the search. The results of the search are displayed beneath the fields.

• Select the required value from the search results and click OK. The window is then closed and the selected value populates the field in the list.

• Click Clear to exit the window and delete the current value from the field in the list.

Arrays of References

Some fields may be populated with arrays of references. For example:

To create or edit an array of references for a field, click on the ellipsis button which is displayed when the mouse cursor is hovered over it. The Reference Picker window is then displayed with the current values in the array displayed. For example:

• To add a new reference to the array, click Add. The Reference Browser window (see above) is then displayed. Select the required value from this window and click OK. The selected value is then added to the list of values in the Reference Picker window.

• The Up and Down buttons are used to set the order in which values are listed in the grid fields. The first value listed in the Reference Picker window will be the first value in the array displayed in the field and so on. To move a value up or down the list, select it and click Up or Down as appropriate.

• To delete a value from array, select it and click Remove.

• Click OK to exit the window and save the changes made to the array.