next up previous contents index
Next: 4.3 Entering Text Up: 4 Entering Data Previous: 4.1.2 Edit Mode

4.2 Valid Entries

   

NExS accepts several basic types of cell entries: text, constant numeric values, dates or times, formulas that calculate a value, and graphs. Calculated values may be single numbers or strings, or they can be arrays or tables of values.

Text Entries.
Text entries are useful for labeling columns and rows, for including comments about data values being calculated, and for using NExS to manage textual information, such as names, addresses or whatever your application may require.

Numeric Values.
If a cell entry begins with a digit from 0 - 9, NExS treats the entry as a numeric entry. NExS also recognizes the following symbols as indicators of numeric entries: ``+'', ``-'', and ``.''. You can format numeric values to be displayed in several ways, including fixed formats, scientific notation, currency, and hex.

Dates and Times.
NExS provides special, built-in features for displaying date entries in the format you choose. Date and time entries begin the the slash (/). Example date and time formats include:       24-Oct-91, 24-Oct, 10/24, Oct-91, 10/24/91, 24.10.1991, and 1991-10-24 (ISO 8061). Time is displayed as: 12:00:05.

Formulas.
Formulas establish and calculate mathematical relationships between elements of the spreadsheet. NExS formulas can calculate with numbers, text, logical values, cell references, and other formulas. For example, you can easily calculate the sum of a series of cells, the total of values in a column, or the absolute value of another cell entry.
Graphs.
Graphs can be inserted into cells. The anchor cell becomes the upper left corner of the embedded graph. Graph objects in cells can be manipulated with operations such as Copy Formulas.


next up previous contents index
Next: 4.3 Entering Text Up: 4 Entering Data Previous: 4.1.2 Edit Mode

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999