Cells

You can find all basic actions for working with cells under the context menu. To call the context menu, right-click the cell that you want to modify. The following table lists all the actions.

Action	Shortcut	Description
Edit	`F2`	Edit a cell value. Alternatively, select a cell and start typing a new value. To confirm your changes, press `Enter`.
Maximize	`Shift+Enter`	Opens a separate value editor where you can edit data that is stored in the cell. Also, you can enable soft wrap in the editor by clicking the Toggle Soft-Wrap button . If you store one-line JSON in a cell, you can click the Toggle Formatting icon. This action formats one-line XML and JSON strings. Also, you can preview images in the value editor. Note that to leverage the performance issues, the default LOB size is limited to 1024 bytes. It means that only 1024 bytes are loaded to the table editor. To increase this size and view larger images, open settings by pressing `Ctrl+Alt+S`, navigate to Tools \| \| Data Views, and change the value of the Maximum number of bytes loaded per value option.
Add a new line	`Ctrl+Enter`	Adds a new line in the editing mode when you press `F2`.
Revert Selected	`Ctrl+Alt+Z`	Restores the previous cell value.
Add a new line in a maximized cell	`Enter`	Adds a new line in the maximized editing mode ( when you press `Shift+Enter`). To confirm your changes, press `Ctrl+Enter`.
Set DEFAULT	`Ctrl+Alt+D`	Sets the current cell value to the default value. For more information about how to set a default value, see Set default values for a cell.
Set NULL	`Ctrl+Alt+N`	Sets the current cell value to the NULL value. For more information about how to set a default value, see Set default values for a cell.
Load File		Uploads a file into the field. Right-click a cell and select Load File.
Edit	`F2`	Edit a value in the cell as a fragment of SQL, HTML, XML, or any other supported language. To set the language, right-click the cell and select Set language.
Value completion	`Ctrl+Space`	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.
Add cells with the same contents to the selection	`Alt+J`	Adds the nearest cell with the same contents to the selection. To remove a cell from the selection, press `Alt+Shift+J`.
Expand a selection from a cell to a table	`Ctrl+W`	Expands a selection from a cell to a table. Press one time: the selection expands to a column. Press two times: the selection switches from the column to a row. Press three times: the selection expands to the whole table.
Compare Cells	`Ctrl+Shift+D`	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.

Object	Documentation view
Long text	If a cell contains long text, you will see the whole text.
Image	If a cell contains an image, you will see a preview of the image. Also, you can
Records	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 a transposed view. In the transposed view, rows and columns are interchanged. To switch to the transposed view, click Transposed View. For more information about the transposed view in tables, see Transpose a table.

Object

Documentation view

Long text

If a cell contains long text, you will see the whole text.

Image

If a cell contains an image, you will see a preview of the image.

Also, you can

Records

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 a transposed view. In the transposed view, rows and columns are interchanged.

To switch to the transposed view, click Transposed View. For more information about the transposed view in tables, see Transpose a table.

Productivity tips

Set default values for a cell

When a new row is created and no values are specified for some of the cells, those cells are filled with their respective default Ctrl+Alt+D or NULL (Ctrl+Alt+N) values.

When you set default values for a cell, you can use corresponding actions from the context menu (Set DEFAULT and Set NULL).

In the Database tool window (View | Tool Windows | Database), expand a data source tree.
Right-click the table and select Modify Table Ctrl+F6.
On the Columns tab, double-click the column that you want to edit.
In the Default field, specify the default value of the cell in the column. To allow NULL values, clear the Not null checkbox.

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, press Enter. To cancel editing, press Escape.

Saving a LOB into 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.

Copy and paste cells between tables

You can copy Ctrl+C and paste Ctrl+V selected cells and ranges of cells - within the same table or from one table to another one. When pasting, JetBrains Rider converts data types automatically if and as necessary.

Last modified: 29 September 2021