.15 Grids
Grids
Description
Grids (tables) are used throughout the Spoon interface to enter or display information. This section describes common functions available when working with a Grid.
Usage
Click on a cell to begin editing that field. After pressing enter, you can navigate the grid by using the cursor keys. Pressing enter again allows you to edit the newly selected field.
The following table describes the functions available when you right- click on a cell in the grid:
Option |
Description |
|---|---|
Insert before this row |
Inserts an empty row before the row you clicked on. |
Insert after this row |
Inserts an empty row after the row you clicked on. |
Move the row up |
Move the row you clicked on up. The keyboard shortcut for this is CTRL-UP |
Move the row down |
Move the row you clicked on down. The keyboard shortcut for this is CTRL-DOWN. |
Optimal column size including header |
Resize all columns so that it displays all values completely, including the header. The keyboard shortcut for this function is function key F3. |
Optimal column size excluding header |
Resize all columns so that it displays all values completely. The keyboard shortcut for this function is function key F4. |
Clear all |
Clears all information in the grid. You will be asked to confirm this operation. |
Select all rows |
Selects all rows in the grid. The keyboard shortcut for this function is CTRL-A. |
Clear selections |
Clears the selection of rows in the grid. The keyboard shortcut for this function is ESC. |
Copy selected lines to clipboard |
Copies the selected lines to the clipboard in a textual representation. These lines can then be exchanged with other programs such as spreadsheets or even other Spoon & Kettle dialogs. The keyboard shortcut for this function is CTRL-C. |
Past clipboard to table |
Insert the lines that are on the clipboard to the grid, right after the line on which you clicked. The keyboard shortcut for this function is CTRL-V. |
Cut selected lines |
Copies the selected lines to the clipboard in a textual representation. After that, the lines are deleted from the grid. The keyboard shortcut for this function is CTRL-X. |
Delete selected lines |
Deletes all selected lines from the grid. The keyboard shortcut for this function is DEL. |
Keep only selected lines |
If there are more lines to delete then there are to keep, simply select the lines you want to keep and use this function. They keyboard shortcut for this function is CTRL-K. |
Copy field values to all rows |
If all rows in the grid must have the same value for a certain column, you can use this function to do this. |
Undo |
Undo the previous grid operation. The keyboard shortcut for this function is CTRL-Z. |
Redo |
Redo the next grid operation. The keyboard shortcut for this function is CTRL-Y. |