Lead:  Liav Nadler  

Description

An spreadsheet table is a type of data table where users can add and edit data on a spreadsheet-like grid

Usage & Behaviour

Structure

• The table contains a grid of rows and columns
• Rows and column may have headers
• If the table is higher than its container, a scroll bar will appear

States

• A cell can be in one of these states:
  • Normal (enabled)
  • Selected. The user can select a single cell or multiple cells (see below)
  • In Focus. Only one cell can be in focus at any time. By default, the top-left cell is in focus
  • Disabled

...

Interaction

• Clicking a cell selects that cell, deselecting all other cells
• Double clicking a cell selects that cell, placing the insertion point in the selected position
• Hitting the Enter key selects the cell below the cell that is in focus
• Hitting the Tab key selects the cell to the right of the cell that is in focus
• The user can select multiple cells in one of two ways:
  • Clicking cells while holding the Ctrl / Cmd key. In this case the first selected cell gets the focus
  • Dragging the cursor over a group of cell. In this case the last selected cell gets the focus
• Typing text will enter that text to the cell that is in focus, replacing any other text in the cell
• Hitting the Enter / Tab key when a cell is in focus will save the text in the cell and set the focus to the cell below it / next cell
• Adding / deleting rows and columns

...