Description

A Spreadsheet table is a type of Data Table where users can add and edit numeric data within the grid.

...

• Clicking a cell will:

  • select the cell.

  • deselect all other cells.

  • change the cell to an input field, allowing the user to edit it.

  • If the cell is already in focus, clicking the cell will place the insertion point on cursor location.

• Hitting the Enter key when a cell is selected or focused will:

  • save the text in the cell (if it exists).

  • remove the input field, returning the cell to the selected state.

• Hitting the Tab key or the arrow keys when a cell is selected or focused will:

  • save the text in the cell (if it exists).

  • deselect the cell.

  • move the focus to the next relevant cellcell (in a LTR layout - the cell to the right of the current one), while skipping disabled cells. If the focused cell is the last one on the row, hitting Tab will set the focus to the first cell of the next row.

• Dragging the cursor over a group of cells selects that group of cells.

• A focused cell will have a special handle in the bottom-right corner. See States above.

  • Hovering over the handle will switch the cursor to a cross.

  • Dragging the handle will copy the content of the cell to the target cells.

• The user can cut, copy, and paste cell content using Ctrl / Cmd + X, C and V respectively.

...