Tables and data

Editing data

Typing, adding rows, sums in the footer, and what a refused cell means.

  • Click any cell to edit it. Enter saves, Escape cancels.
  • + Add row under the table adds an empty row.
  • Delete a row with the button at the row's right end.
  • Number and currency columns show a running sum in the footer.
  • If a value breaks a rule (wrong format, out of range, required but empty), the cell shows the reason and nothing is saved until it's fixed.