Lead:  Liav Nadler  

Description

A spreadsheet table is a type of data table where users can add and edit numeric data on a grid

...

• Clicking a cell:

  • Sets the focus to that the cell

  • Selects the cell

  • Deselects all other cells

  • If the cell contains text - selects the text, allowing the user to edit it

• Double clicking a cell is similar to clicking a cell, but if the cell has text in it, double clicking it will place the insertion point in the cursor’s location of the cursor

• Hitting the Enter key set / Tab key:

  • Saves the text in the cell (if exists)

  • Sets the focus to the cell below / to the right of the current cell

  Hitting the Tab key sets the focus to the right of the current cell

  • respectably, while skipping disabled cells

  • If the new cell contains text - selects the text

  • If the new cell does not contain text - showing the insertion point, allowing the user to enter text

• Selecting multiple cells can be done in one of two ways:

  A cell in focus or

  • Dragging the cursor over a group of cell. In this case the first selected cell gets the focus

  • Clicking cells while holding the Ctrl / Cmd key. In this case the last selected cell gets the focus

• Typing text will enter the text to the cell that is in focus, replacing any other text in the cell

• 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)

• • Shift to select group of cells

• A cell in focus or a group of cells that were selected by dragging will show a distinctive point special handle at the bottom-right corner of the cell / the selected area (see image)

  • Mouseover the handle will switch the cursor to a cross

  • Dragging the

  point to other cells

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

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

Edge Cases

...

if the text typed in a cell is longer than the cell

...

Restricting data while typing (e.g allow only digits)

...

• Edge cases may include:

  • Typing long text in a cell

  • Typing invalid data in a cell

  • Deleting mandatory cells

  • Server error when trying to save cell content

• For more information please refer to the Field Validation page

Best Practices

• Use a spreadsheet table When it supports another set of data, for example, a graph

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>>

...