13-4-8

Editing Cell Contents

(4)Tap the cell you want to reference (which will input its name into the edit box automatically) or use the editing toolbar and keypad to input its name.

Important!

The above step always inputs a relative cell reference. If you want to input an absolute cell reference, use the stylus or cursor keys to move the editing cursor to the appropriate location, and then use the editing toolbar to input a dollar ($) symbol. See “Inputting a Cell Reference” on page 13-4-6 for more information about relative and absolute cell references.

(5)Repeat step (4) as many times as necessary to input all of the cell references you want. For example, you could input “=A1 + A2”. You can also input a range of cells into the edit box by dragging across a group of cells.

(6)After your input is the way you want, tap the sbutton next to the edit box or press the Ekey to save it.

Inputting a Constant

A constant is data whose value is defined when it is input. When you input something into a cell for which text is specified as the data type without an equal sign (=) at the beginning, a numeric value is treated as a constant and non-numeric values are treated as text.

Note the following examples for cells of utype:

This input:Is interpreted as:And is treated as:

 

 

 

sin(1)

A numeric expression

A constant value

 

 

 

1+1/2

A numeric expression

A constant value

 

 

 

1.02389

A numeric expression

A constant value

 

 

 

sin(x)

A symbolic expression

Text

 

 

 

x+y

A symbolic expression

Text

 

 

 

Result

A string expression

Text

 

 

 

sin(

Invalid expression context

Text

 

 

 

When text is too long to fit in a cell, it spills over into the next cell to the right if the neighboring cell is empty. If the cell to the right is not empty, the text is cut off and “...” is displayed to indicate that non-displayed text is contained in the cell.

20060301