Skip to content

Latest commit

 

History

History
106 lines (78 loc) · 3.5 KB

File metadata and controls

106 lines (78 loc) · 3.5 KB

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

Sorting

Double-click column header Sort
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

Resizing and reordering

Drag column header Reorder columns
Drag column header border Resize columns
Drag row header border Copy cell
Menu -> Column sizing Batch sizing options

Color-coding

Menu | Color coding | On/Off Turn color-coding on/off for all columns
Menu | Color coding | Color scheme Select a palette

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

Custom cell renderers

Molecules

See also: