Working with cells
Basic operations with cells
You can modify values in the table cells and, if appropriate, upload files.
Edit a cell value. Alternatively, select a cell and start typing a new value. To confirm your changes, press Enter.
Expands a cell for editing. To confirm your changes, press Ctrl+Enter.
Add a new line
Adds a new line in the regular editing mode (F2).
Restores the previous cell value.
Expands the selected cell.
Add a new line in a maximized cell
Adds a new line in the maximized editing mode (Shift+Enter). To confirm your changes, press Ctrl+Enter.
Set the default value
Sets the current cell value to the default value.
Set the NULL value
Sets the current cell value to the NULL value.
Uploads a file into the field. Right-click a cell and select Load File.
F2 or Shift+Enter
Edit a value in the cell as a fragment of SQL, HTML, XML, or any other supported language.
Opens the suggestion list. To invoke value completion, start editing the cell and press Ctrl+Space. The list contains values from the current column that match your input.
Adding cells with the same contents to the selection
Adds the nearest cell with the same contents to the selection. To remove a cell from the selection, press Shift+Alt+J.
Expand a selection from a cell to a table
Expands a selection from a cell to a table.
Compares the contents of two or three cells within one table. Select up to three cells and press Ctrl+Shift+D. Alternatively, right-click the selection and select Compare Cells.
Using the quick documentation view
The quick documentation view provides details about values in the selected cell or cells. For example, if a cell contains long text, you will see the whole text. If a cell contains an image, you will see a preview of the image. Also, you can see records that are referenced in the current record as well as the records that reference the current one.
If a cell contains long text, you will see the whole text.
If a cell contains an image, you will see a preview of the image.
The quick documentation view for records displays records that are referenced in the current record and records that reference the current one.
You can switch to the transposed view. In the transposed view, rows and columns are interchanged.
Edit multiple cell values simultaneously
Select a range of cells that you want to edit.
Start typing a new value. The changes are applied to all the selected cells.
To confirm the value, pressEnter. To cancel editing, pressEscape.
Saving a LOB in a file
You can save a binary large object (BLOB or LOB) from a cell into a file.
Right-click the cell that contains the LOB and select Save LOB.
In the save dialog, specify the name and location of the file and click OK.