This section describes the basic operations that can be used for editing data in grid windows for the following database items:
There are some additional operations that are specific to network objects which are described in the topic, Editing Data in the Network Object Grid View.
To move between the cells in the grid
To select a single cell, click on it to make it the current cell.
To select a group of cells
To select a whole column or columns
To select a whole row or rows
To select the entire grid, click the top left cell.
Click
or choose Copy from the Edit menu or from the context menu to copy the contents of the current selected cells to the clipboard.
Click
or choose Paste from the Edit menu or the context menu to paste data back into the grid.
Use the DELETE key to delete the contents of the current selected cells.
To enter a new value or replace the existing value for a single cell, click the cell and type the new value.
All edits are applied to the current cell. The current cell has two states; active and inactive.
|
If you move to the cell using the arrow keys, or click with the mouse inside the cell but not on the cell data, the cell becomes current but inactive. An inactive current cell is shown with a thick border. Typing or pasting data into an inactive current cell will replace the current cell contents. |
|
If you double click within the cell data, or begin to edit an inactive current cell, it becomes active. The active current cell is shown with a flashing cursor at the point where text will be inserted. Typing or pasting into an active current cell will insert text at the insertion point. |
For network objects grids only.
To enter a new value or replace the existing values for several cells simultaneously
Row based grids allow you to add or delete data a row at a time, assuming these operations are available for the particular data in the grid.
Add a row |
To add a new row to the grid, begin typing in the append row. The append row is marked with the
![]() This shows that it is the current row, and it is being edited. |
Edit a row |
The current row is marked with the
Tip: This means the data has been saved internally by the grid. You may also have to save again to save the data into the database. There will be a Save button or menu item. If there is unsaved data when you try to close the grid, you will be given the option to save changes. Some grids, such as the network object grids, work directly with the database, and save data to the database whenever you change rows.
|
Delete a row |
To delete a row or rows, the row(s) needs to be selected. See Selecting Cells above. Once rows are selected they are highlighted in blue: ![]() To delete selected rows, press the DELETE key. |
You can print the data in a grid window. See the topic Printing from Grid Windows for further information.
Data in a single column or multiple columns on can be sorted. Sorting can also be limited to selected rows.
To sort the rows in the grid according to the contents of a particular column
When carrying out subsequent sorting on single columns, the order of the previous sort is preserved where possible.
A selection of columns can be sorted by using the Sort on Selected Columns options from the grid popup menu. All columns must be sorted either by ascending or by descending order:
To sort the data in a selection of rows only
Network objects can also be sorted using the Sort Grid dialog. See Sorting Network Objects for further information.
A number of options change the layout and appearance of the grid:
Change Font Size |
Available in Network Object grid windows only. To adjust font size, select options from the Font size submenu of the Grid menu:
|
Adjust column width |
To adjust the width of a column, drag the divider line on the right of the column header. ![]() The cursor will change as shown when correctly positioned over the column divider. |
Change column order |
To change the column order, select a column and drag it to a new position. If the position is valid, the dividing line between columns where the dragged column will be inserted turns red. The picture shows a valid drop position for the selected DS Node ID column. If the position where you want to drop is invalid the
|
Freeze columns |
Columns can be frozen at the left hand side of the grid so that they are visible at all times. Select one or more columns and choose Freeze columns from the context menu. The columns are moved to the left hand side of the grid. The boundary between frozen and scrollable columns is marked with an extra thick line. When you scroll the grid sideways, the frozen columns do not move. To unfreeze all frozen columns, choose Unfreeze columns from the Grid menu. |
Data can be autofiltered in network grid window columns, allowing the display of rows of data based on the content of cells and conditions applied to them.
See Filtering Grid Data for details.