reading your data

Reading a row down

Row Details shows the row of the cursor as a list, a name and its value on each line, to read a wide table without scrolling sideways, and to edit any of its values.

The Row Details panel for row 3 of 36 of a file of support tickets: each column’s number and name in its colour, id, created, customer, subject, description, priority and status, with its value beside it; the description, several lines long, shown whole, and the cursor’s field, id, highlighted

A table with many columns is read across: to see the end of a row you scroll sideways, and lose its beginning. Row Details shows the row of the cursor down a panel at the right of the window instead: each column’s number and name, in its colour, and its value beside it, all of the row at once. Long values and values with line breaks are shown whole.

Open it with View › Row Details. It takes the place of the column profile and the Quality Check panel: one of the three at a time. Drag its left edge to make it wider.

It follows the cursor

Move the cursor to another row and the panel shows that row. The field of the cursor’s column is highlighted, and kept in sight.

The arrows at the top go to the previous and the next row, with the cursor in the same column. A row that a filter hides is skipped.

On the header row, the panel lists the columns’ names, which you can edit there too.

The values of hidden columns are in the list as well, marked hidden: here a row is read whole. A click on one of them leaves the table’s cursor where it is (a hidden column has no cell to go to).

Click a name to go to that cell in the table. If the cell is out of sight, the table scrolls sideways until it starts at the left edge (or as far as it can, near the last columns).

Editing a value

Click a value and type. The editor’s cursor goes to that cell, so you can see it in the table too.

  • Enter writes the value in the file and goes to the next one, as in a spreadsheet.
  • Tab, or a click anywhere else, writes it too.
  • Shift+Enter or Alt+Enter starts a new line inside the value.
  • Esc leaves the value as it was.

Each value you change is one step to undo with Ctrl+Z⌘Z. A value keeps its quotes if it had them, and gets them if it needs them: type a comma into a value of a comma-separated file and it is written between quotes.

A row shorter than the others has no value in its last columns; the panel shows them as (no value). Type in one, and the delimiters it needs are added before it.