Next: 4.3 Entering Text
Up: 4 Entering Data
Previous: 4.1.2 Edit Mode
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: 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