86
Chapter 8 Pocket Sheet
Inputting Data Into a Cell
This section explains the rules and procedures for inputting text, values, and
mathematical expressions into sheet cells. It also contains detailed information
on the various cell functions that are available.
General Input Rules
The following are the general rules that you should observe whenever
inputting data.
•
Anything you enter on the keyboard is input into the sheet’s active cell.
•
You can input up to 256 characters into each cell.
•
Mixing text and numbers inside the same cell causes everything in the
cell to be treated as text.
•
Do not manually input commas as separators inside values. Doing so
interferes with correct display of calculation results. Use the procedure
under “Changing the Format Settings of a Cell” on
automatic comma separators.
Cell References
The term
cell reference
means calling the contents of one cell into another
cell. Pocket Sheet supports three types of cell references:
relative
,
absolute
,
and
mixed
. Whether a cell references is relative, absolute, or mixed does not
make affect the results it normally produces. The cell reference type matters
only when the contents of the cell are copied and then pasted into another
location. See “Copying a Relative Cell Reference” on
and “Copying
an Absolute or Mixed Cell Reference” on
about how cell references are affected by cut, copy, and paste operations.