The user can enter values in table cells from the keyboard. To do this the cell to be entered should be selected first. It can be done either by clicking this cell or moving to the necessary cell using the keyboard. For vertical movements in a table the keys ↓ and ↑ are used, for horizontal – Tab and <Shift+Tab>.
If selected cell was linked with some array of values, this link is broken as soon as the user starts to enter a value.
Processing the value being entered depends on the type of data this value belongs to. The user can select the type of data in the drop-down list located in data toolbar before performing the input.
By default the input mode Auto is set, that is, the system tries to automatically determine to which type of data these values belong by the format of values being entered. For example, the value “12:59” will be identified as time value, but “12:60” will be referred to string type since it is not admissible representation of some other type.
The system successively tests data types in the following order: number, date, time, timestamp, Boolean, string. Testing is stopped as soon as the type to which entered values correspond is found. Only the values which cannot be referred to other types will be referred to string type.
The user can select from the list a particular type of data being entered. If the value he entered in a cell after this does not correspond to the specified type, the system ignores the input and assigns an empty value to a cell.
Selected type of entered data continues to be in force when input to other cells is performed until the user selects another type.
The user can enter into the cell the text which consists of several lines. To switch to the new line it is required to enter the sign of a back slash character ”\”. If it is necessary to include into the text the sign ”\” itself, it should be entered twice: ”\\”.
The text consisting of several lines is always recognized by the system as the value of string type.
After the user finished input of the value into the cell, the system formats this value in accordance with the type and formatting string set for this cell (see “Selecting type and format of data”). It may happen so that the type of entered value does not correspond to the appropriate data type admissible for the cell. In this case the system displays a message about an error in the cell “{Error of value conversion}”.
To remove the values in some table cells the user can select these cells and press the key Delete. Empty values are entered into the cells, however the types and formats of data specified for the cells are retained and will be used for further input of data.
Another way to clean selected cells is performing the menu command Edit+Clean (the button 
of the standard toolbar). In this case resetting of cell format occurs besides deleting the values. A mixed type of data and default formatting are set for all cleaned cells as when creating a table.
 |  |
