Amiga Elysian Archive/AmigaElysianArchive.iso/bus_pers/analycal.lha/AnalyBig.Doc

Text File | 1989-09-21 | 2KB | 33 lines

This version of AnalytiCalc requires at least 1 megabyte of memory to run.
It is similar to the "regular" edition, but is made with the included
AParms.Inc file and has greater sheet capacity. In  particular, the
"prime area" of the spreadsheet is 70 columns by 400 rows instead of
60 by 300, and the in-memory storage can hold 6000 values instead of
800, and 24000-odd formula chunks instead of 2000. The "standard"
edition can use all cells by going out to disk, but this is a slow
operation. This version will need to use the disk paging only very
seldom and should be adequate in capacity to handle all but the most
egregiously oversized spreadsheet problems.
  Please remember: spreadsheets are INTERPRETERS and as such are far
slower than compiled languages. If you find your application needing
multi-10000 cell spreadsheets, perhaps you should think, HARD, about
using a compiled language for it. 'Nuff said.
  You are free to edit aparms.inc and recompile if the sizes do not
suit you. The current (9/22/89) sources support only up to 32767
cells reliably however. A small change to permit 32 bit (well,
31 plus sign) cell numbers requires mainly using a 4 byte cell hash
in XVBLGT/XVBLST and in WSHEET subroutines, where the actual storage
management takes place.
  To adapt to other screen types (e.g., the European 256 by 640 PAL
screens), look for variable iDdpTp and change window specs as
desired. It's a good idea also to reset default numbers of rows and
columns accordingly at those points. No need to parametrize this;
if you have the compiler, there are only a couple of places in the
code to alter. Searching for variable IDSPTP (for i-DiSPlay-TyPe)
will position you correctly in a jiffy.
  Glenn Everhart
  9/22/1989
25 Sleigh Ride Rd.
Glen Mills, PA 19342
USA