PyCharm 2019.1 Help

Cells

Basic operations with cells

You can modify values in the table cells and, if appropriate, upload files.

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.

Edit Maximized

Shift+Enter

Expands a cell for editing. To confirm your changes, press Ctrl+Enter.

Add a new line

Ctrl+Enter

Adds a new line in the regular editing mode (F2).

Revert selected

Ctrl+Alt+Z

Restores the previous cell value.

Maximize

Ctrl+Shift+Alt+M

Expands the selected cell.

Add a new line in a maximized cell

Enter

Adds a new line in the maximized editing mode (Shift+Enter). To confirm your changes, press Ctrl+Enter.

Set the default value

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 the default value

Set the NULL value

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.

Set the NULL value

Load file

Uploads a file into the field. Right-click a cell and select Load File.

Edit as

F2 or Shift+Enter

Edit a value in the cell as a fragment of SQL, HTML, XML, or any other supported language.

Edit a value in the cell as a fragment of a supported 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.

Adding 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 Shift+Alt+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.

Compare cells

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).

  1. In the Database tool window (View | Tool Windows | Database), expand a data source tree.

  2. Right-click the table and select Modify Table (Ctrl+F6).

  3. On the Columns tab, double-click the column that you want to edit.

  4. In the Default field, specify the default value of the cell in the column. To allow NULL values, clear the Not null checkbox.

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.

Quick documentation view for long texts

Image

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

Quick documentation view for images

Records

The quick documentation view for records displays records that are referenced in the current record and records that reference the current one.

Quick documentation view for an image

You can switch to the 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.

§
Transposed view for records

Edit multiple cell values simultaneously

  1. Select a range of cells that you want to edit.

  2. Start typing a new value. The changes are applied to all the selected cells.

  3. To confirm the value, press Enter. To cancel editing, press Escape.

Saving a LOB in a file

You can save a binary large object (BLOB or LOB) from a cell into a file.

  1. Right-click the cell that contains the LOB and select Save LOB.

  2. In the save dialog, specify the name and location of the file and click OK.

Last modified: 17 July 2019