Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Lead:  Liav Nadler  

Status
colourYellow
titleongoing

Table of Contents

Description

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

...

  • 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
    • Selected + In Focus
    • Disabled
    • Missing Information
    • Alert

Interaction

  • Clicking a cell selects :
    • Sets the focus to that cell
    , deselecting
    • Selects the cell
    • Deselects all other cells
  • Double clicking a cell selects that cell, placing is similar to clicking a cell, but if the cell has text in it, double clicking will place the insertion point in the location of the selected positioncursor
  • Hitting the Enter key selects set the focus to the cell below the current cell that is in focus
  • Hitting the Tab key selects sets the cell focus to the right of the current cell that is in focusThe user can select
  • Selecting multiple cells can be done in one of two ways:
    • Clicking cells while holding the Ctrl / Cmd keyDragging the cursor over a group of cell. In this case the first selected cell gets the focus
    • Dragging the cursor over a group of cellClicking cells while holding the Ctrl / Cmd key. In this case the last selected cell gets the focus
  • Typing text will enter that the text to the cell that is in focus, replacing any other text in the cellHitting
  • A newly added text in a cell will be updated in the cell after losing focus (either by clicking another cell or using the Enter / Tab key when a )
  • A cell is in focus will save the text in the cell and set the focus to the cell below it / next cellor a group of cells that were selected by dragging will show a distinctive point at the bottom-right corner of the cell / the selected area
  • Dragging the point to other cells will copy the content of the cell to the target cells
  • Adding / deleting rows and columns?
  • Resizing rows and columns?

Edge Cases

  • if the text typed in a cell is longer than the cell
  • Restricting data while typing (e.g allow only digits)
  • Missing information / errors

Accessibility compliance

<<In general each component should be A11y complied,  please follow the 3 guidelines linked below. At the very least we should document that each component is in compliance with each of the 3>>

...