Welcome to my IZL spreadsheet program.  You should have received the 
following files:

SPREDSHT.IZL - The IZL source code for the desktop version of the program
SPREDSHT.IZT - The tokenized form of the desktop version
SPREDSHT.DOC - This file

If you've used a spreadsheet before, you should recognize most of the 
stuff in SPREDSHT.  To get to a cell, you click on the button for that 
cell (in the lower half of the screen), or you can type the cell name 
(such as A1, g3, F2) in the text area next to the Go To button, and 
then click on the Go To button itself.

That text area I just mentioned -- the one next to the Go To button -- 
always indicates the current cell.  It's the only indicator you have 
of what cell you're working on.  It's your friend; be nice to it.

To edit the contents of a cell, you use the other text area, next to 
the check mark.  You can type in numbers, text, or functions from the 
GEOS parse library (like SIN(), cos(), UPPER(), and so on).  

If you want your entry to be considered text, put an apostrophe in 
front of it, as in 'my text.  (Actually, if you type in something 
non-numeric, SPREDSHT puts in an apostrophe for you if you don't.  You 
really need to put the apostrophe in only when you type in a number 
that you want to be considered text.)

If you want to type in a function, like COS(), you need to put an 
equals sign in front of it, as in =COS(1.0).  Otherwise, SPREDSHT just 
thinks it's text and won't evaluate it.  You can use names of other 
cells in your functions.  For instance, if cell A1 has the value 3.14, 
you can take the cosine of it in cell B1 by putting =COS(A1) there.  
You can also use ranges of cells by separating cell names with a 
colon.  For instance, the formula =SUM(A1:C5) will add up the values 
of all the cells in the rectangle with A1 at one corner and C5 at the 
other corner.

When you're happy with the contents of your cell, DON'T press Enter.  
That will just insert an Enter character in the cell and will make 
things look funny.  Instead, click on the checkmark () button.  If 
you don't like what you typed in, click on the X button, and your cell 
will be restored to whatever its value was before you started editing 
it.

You can save your spreadsheets using the Save button and load them 
back again later using the Load button.  They should be pretty 
self-explanatory.  You can name your spreadsheets anything you want, 
as long as they conform to the DOS 8.3 convention.  I'll try to come 
up with a separate program to import/export comma-separated files, but 
I don't have the time or energy for that right now.  If you want to 
take a stab at it, be my guest.

Now for the RECALC stuff.  Suppose you have the formula =COS(A1) in 
cell B1.  At first, A1 has the value 3.14, so B1 has the value -1.  
Then you change A1 to have the value 0.  B1 still has the value -1.  
Why?  Because B1 doesn't know yet that you've changed what's in A1 and 
hasn't recalculated its value.  You can tell B1 to recalculate by 
clicking on the cell B1 and then clicking on the checkmark button.  Or 
you can tell SPREDSHT to recalculate every cell in the spreadsheet by 
clicking on the Recalc All button (it's marked just Recalc on the 
Zoomer version).  If you want SPREDSHT to recalculate every cell every 
time you hit the checkmark button, click on the button next to Always 
recalc all.  No, not the one marked Recalc All, the other one.  If 
there's a checkmark in that button, it'll always recalculate every 
field.  Here's a worning -- the Recalc all feature is dog-slow on my 
486-66, and it's glacier-slow on a Zoomer.

IZL DEVELOPERS
--------------
If you have the developer's version of IZL 2.0, you can change the 
appearance and behavior of SPREDSHT by changing some of the variables 
in the source code.  That's mainly what I did to produce the Zoomer 
version of SPREDSHT.  The most important fields are:

NoOfRows   - the number of rows of cells in the spreadsheet
NoOfCols   - the number of columns of cells in the spreadsheet
CellLength - the length of each individual cell in characters (i.e., 
             not pixels)
CellHeight - the height of each individual cell in characters (i.e., 
             not pixels)
DecPoints  - the number of decimal points to round off to
RecalcFlag - TRUE() if default is always to recalc all, FALSE() otherwise

I hope you enjoy the program.

This program was written by Doug Taylor (doug-taylor+@osu.edu).  It has
been placed into the public domain.  Feel free to hack it, steal
routines from it, or whatever.
