Lead: Liav Nadler
| Status | ||||
|---|---|---|---|---|
|
| Table of Contents |
|---|
Description
An A spreadsheet table is a type of data table where users can add and edit numeric data on a spreadsheet-like grid
...
Usage & Behaviour
Structure
The table contains a grid of rows and columns
Rows and column may have headersThe table may contain:
Header row
Header column (on the left)
Total row (at the bottom)
If the table is higher than its container, a scroll bar will appear. The scroll bar will not affect the header and title rows, if exists
States
A cell can be in one of these states:
State | Example | Comments |
|---|---|---|
Normal ( |
...
Enables) |
...
Disabled | ||
In Focus |
...
Only one cell can be in focus at any time. By default, the top-left cell is in focus | ||
Selected | User can select one or more cells (see below) | |
Selected + In Focus |
...
No Data |
...
Missing Information
Error | See Field Validation |
Interaction
Clicking a cell:
Sets the focus to that cell
Selects the cell
Deselects all other cells
Double clicking a cell 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 cursor
Hitting the Enter key set the focus to the cell below the current cell
Hitting the Tab key sets the focus to the right of the current cell
Selecting multiple cells can be done in one of two ways:
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)
A cell in focus or 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
...