Skip to main content

Grid

Selection

Shift+Mouse DragSelect rows
Ctrl+Shift+Mouse DragDeselect rows
Mouse Drag row headersSelect rows
Shift+drag column headersSelect columns
Ctrl+click column headersSelect columns
Ctrl+Shift+click column headersDeselect columns
(Ctrl+) Shift + ↑↓(Un)select rows
(Ctrl+) Shift + ←→(Un)select columns
(Ctrl+) Shift + mouse-drag(Un)select rows
(Ctrl+) Shift + ENTER(Un)Select rows with the current value
Ctrl + Shift + HomeSelect rows above current
Ctrl + Shift + EndSelect rows below current
Up, Down, Left, RightNavigate
Page Up, Page DownNavigate
Ctrl+HomeJump to first row
Ctrl+EndJump to last row
HomeJump to first column
EndJump to last column
Ctrl+UP / DOWNPrev / next selected row
Alt+FShow in full screen

Sorting

Double-click column headerSort
Ctrl+Shift+UPSort current column
Menu | Current Column | SortSort

Editing

Double-clickEdit cell
Ctrl+CCopy cell
Ctrl+VPaste into cell
Ctrl+clickInvert column selection
Open column filter
Enter or the "+" icon at the last rowAdd a row (requires Allow Edit set to true)
Edit | Add Rows...Add a specific number of rows at a specified position
Shift+DelDelete selected rows and/or columns

Resizing and reordering

Drag column headerReorder columns
Drag column header borderResize columns
Drag row header borderResize row height
Menu -> Column sizingBatch sizing options

Formatting

Right-click column header | FormatChange datetime format
Right-click cell | Current column | FormatChange datetime format
Column Properties (F2) | Tags | formatChange datetime format

Date and number formatting

See also:

Color coding

Grid color coding

Menu | Color coding | On/OffTurn color-coding on/off for all columns
Menu | Color coding | Color schemeSelect a palette

Color-coding

Column color coding

Color coding can be defined on the column level. Color coding types are suggested according to the column type: Categorical applies to categorical columns (string and bool); Conditional and Linear apply to numeric types (linear color coding additionally includes datetime).

Menu | Color coding | OffTurn off column color coding
Menu | Color coding | CategoricalTurn on categorical color coding
Menu | Color coding | LinearTurn on linear color coding
Menu | Color coding | ConditionalTurn on conditional color coding
Menu | Color coding | Edit...Edit column color coding
Menu | Color coding | Pick Up ColoringClone coloring settings
Menu | Color coding | Apply ColoringApply copied coloring settings

Color coding configuration can be copied from one column to another via commands Pick Up Coloring and Apply Coloring. Application can work on multiple columns. Both standard and custom color coding are copied. The Off setting can get picked up as well (when applied, it will turn off the coloring on a column in question). However, except for the Off option, copied settings cannot be applied if you try to transfer them from a numeric column to a categorical one or vice versa. This means that the column type is always taken into account. The Apply Coloring command is disabled if nothing has been picked up. Settings are remembered for a viewer instance (currently, they are not preserved through layout serialization).

Copy column color coding

By default, color coding is applied to the column background. Optionaly, you can apply it to the text:

  1. Right-click the column's header and select Color coding > Edit. A dialog opens.
  2. In the dialog, set the Apply to setting to text.

This option is available for all linear, categorical, and conditional schemas.

Visualizing grid data

Cell renderers

Molecules

Row summary columns

Summary columns is a way to visualize multiple values numerical across the row. This feature is useful for quick visual profiling of values. In the following picture, each inline viewer visualizes the values of five numerical columns, which allows for quick visual comparison between rows.

Summary columns

The following summary column types are available:

  • Sparkline
  • Bar Chart
  • Radar
  • Pie Bar Chart
  • Markup

To add a summary column: Menu | Add | Summary Columns

Forms

An HTML (or Markdown) template that renders row values can be embedded in each row.

Forms

To add a default form: Menu | Add | Forms | Default To add a custom form: Menu | Add | Forms | Custom...

Current rows

Rows in a grid can not only be selected or filtered, in addition to that, the grid keeps track of a current row and highlights it in green. This indication is a neat and lightweight way to update information related to the current value and lets users explore and compare rows with ease.

To make a row current, simply click on it, or navigate up and down the grid using the cursor up and down keys. Info panels in the context panel get synchronized with the current cell.

It is also integrated into Datagrok's visualizations and cheminformatics functionality, e.g., similarity search, so as you move from one row to another you immediately see where the row values belong on the chart or which molecules have the most similar structure to the reference. This also works the other way around: by first clicking on a visual element, you will see the row it represents in the grid.

Current rows

Pinned rows

Datagrok supports pinned rows functionality, where each row can be pinned based on its column name and cell value. Pinned rows are also saved to the layout. If you pin a non-unique row, it will be pinned but it won't be saved in the layout.

To pin a row, select the row you want to pin, right-click it and open: Pin > Pin row. To pin multiple rows, select the Pin selected rows option.

Pinned rows

Column edit permissions

You can specify who can edit a specific column. There are few ways to do it:

  • Click on the column header and go to the context panel. Select Advanced -> Permissions tab. Input a comma-separated list of usernames or group names into the "Editable By" field.
  • Open column properties and create a new "EditableBy" tag. The value is also a list of comma-separated usernames.
  • Programmatically: table.col('myColumn').tags['editableBy'] = "askalkin";

Once this is done, only users from the list are allowed to edit the column. Everyone else will get a notification when trying to edit this column.

Videos

Grid

See also: