Editing Tables

Every Table in the Lab opens in a spreadsheet grid built for large data: rows and columns load lazily as you scroll, and editing works the way you expect from a desktop spreadsheet. The same grid also powers the attributes, events, links, and selection views.

Double-click a cell — or press Enter or F2 on the focused cell — to edit it. Simply typing replaces the current value, and Alt+Enter inserts a line break inside a cell. Enter commits and moves down (Shift+Enter moves up), Tab commits and moves right, and Escape cancels the edit.

Entered values are validated against the column's value type — text, boolean, integer, number, or decimal. An invalid entry keeps the editor open and explains what is expected; clearing a cell is always allowed.

Click selects a cell, Shift+click extends the selection, and Ctrl+click adds further, disjoint ranges. Clicking a row or column header selects the whole row or column, and the corner cell — or Ctrl+A — selects everything. The arrow keys move the focus (Shift extends), Home/End jump within the row, Ctrl+Home/End jump to the grid corners, and PageUp/PageDown move a screen at a time.

Ctrl+C, Ctrl+X, and Ctrl+V exchange tab-separated values with the system clipboard, so ranges paste cleanly to and from Excel and Google Sheets. Pasting a block larger than the current table automatically appends the missing rows and columns. Cut cells stay marked until the next paste moves their content in a single undoable step.

Ctrl+Z undoes and Ctrl+Y (or Ctrl+Shift+Z) redoes. Multi-cell operations — a paste, a cleared selection — undo as one step. The history is local to your current editing session and is reset when the table's structure changes.

Right-click opens a context menu. On any grid you can Clear the targeted cell, selection, row, or column. On an editable Table the menu additionally offers renaming rows and columns, setting a column's alignment and value type, inserting rows and columns on either side, and removing or deleting them. Row heights and column widths adjust by dragging the header borders, and column widths are saved with the Table.

Changes save automatically a few seconds after you stop editing. Cells with unsaved changes carry a small marker, and the status bar below the grid shows the number of pending changes, a Saving indicator while a save is in flight, and the table's dimensions.