Grid
Selection
Shift+Mouse Drag | Select rows |
Ctrl+Shift+Mouse Drag | Deselect rows |
Mouse Drag row headers | Select rows |
Shift+drag column headers | Select columns |
Ctrl+click column headers | Select columns |
Ctrl+Shift+click column headers | Deselect 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 + Home | Select rows above current |
Ctrl + Shift + End | Select rows below current |
Navigation
Up, Down, Left, Right | Navigate |
Page Up, Page Down | Navigate |
Ctrl+Home | Jump to first row |
Ctrl+End | Jump to last row |
Home | Jump to first column |
End | Jump to last column |
Ctrl+UP / DOWN | Prev / next selected row |
Alt+F | Show in full screen |
Sorting
Double-click column header | Sort |
Ctrl+Shift+UP | Sort current column |
Menu | Current Column | Sort | Sort |
Editing
Double-click | Edit cell |
Ctrl+C | Copy cell |
Ctrl+V | Paste into cell |
Ctrl+click | Invert column selection |
≡ | Open column filter |
Enter or the "+" icon at the last row | Add a row (requires Allow Edit set to true) |
Edit | Add Rows... | Add a specific number of rows at a specified position |
Shift+Del | Delete selected rows and/or columns |
Resizing and reordering
Drag column header | Reorder columns |
Drag column header border | Resize columns |
Drag row header border | Resize row height |
Menu -> Column sizing | Batch sizing options |
Formatting
Right-click column header | Format | Change datetime format |
Right-click cell | Current column | Format | Change datetime format |
Column Properties (F2) | Tags | format | Change datetime format |
See also:
- Formatting notation for dates and numbers
- Formatting via JS API
Color coding
Grid color coding
Menu | Color coding | On/Off | Turn color-coding on/off for all columns |
Menu | Color coding | Color scheme | Select a palette |
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 | Off | Turn off column color coding |
Menu | Color coding | Categorical | Turn on categorical color coding |
Menu | Color coding | Linear | Turn on linear color coding |
Menu | Color coding | Conditional | Turn on conditional color coding |
Menu | Color coding | Edit... | Edit column color coding |
Menu | Color coding | Pick Up Coloring | Clone coloring settings |
Menu | Color coding | Apply Coloring | Apply 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).
By default, color coding is applied to the column background. Optionaly, you can apply it to the text:
- Right-click the column's header and select Color coding > Edit. A dialog opens.
- 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
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.
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.
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.
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.
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
See also: