Contents of the README file
First, a BIG thank you to all of our registered users for their comments
(and registrations) which have helped us make QubeCalc PC Magazine's
Editor's Choice among low cost spreadsheets (February 16, 1988). We
appreciate your support and confidence in our products.
If you have questions, you can now ask them via EPLEX on CompuServe. Just
leave a message to ID 73250,3163.
The on-disk documentation has been compressed to fit on the disk. To print
out this documentation use the program named PRINTDOC.COM
QubeCalc V3 uses a different file structure than versions 1 and 2.
Your old version 1 and 2 files must be converted over to the new format
using the program CONVERT.COM.
QubeCalc uses an overlay structure. This means that the QubeCalc program
actually consists of 3 different files; QUBECALC.COM, QUBECALC.000, and
QUBECALC.COM is the main part of the program. QUBECALC.000 and QUBECALC.001
are overlay files which contain various features and functions of QubeCalc.
When QubeCalc needs to access one of these features or functions, it reads
the code for that feature in from QUBECALC.000 or QUBECALC.001.
The advantage of using an overlay structure is that the program uses up
less memory, thereby freeing up more RAM to put your spreadsheets in.
If you place the overlay files (QUBECALC.000 and QUBECALC.001) on a hard disk
or in a RAM disk in extended memory, you should not notice any significant
delay when these features are accessed. If the overlay files are on a floppy
disk, you may notice a small delay when accessing these features. If you have
a floppy based system and cannot tolerate the short delays, you may place the
overlay files in a RAM disk in regular memory (the first 640K of memory).
QubeCalc needs to know where you place the overlay files. By default,
QubeCalc assumes that the overlay files are in the directory where you
start up QubeCalc. If you place the overlay files in a RAM disk or in a
directory other than where you start the program, then you must run the
setup program to create a configuration file which tells QubeCalc where
you put the overlays.
The setup program can also be used to tell QubeCalc where you placed the
help file and which directory you want to use as the startup data directory.
It will also let you customize the screen colors which QubeCalc uses.
You can now give a name to a cell or block of cells. This name can
then be used anywhere that a cell or block reference can be used.
You can now link multiple 3D spreadsheets together.
LOTUS RELEASE 2 IMPORTING
You can now import both versions of Lotus 1-2-3 files (WKS and WK1).
IMPORTING AND EXPORTING FILES FROM OTHER SOFTWARE PACKAGES
(INCLUDING EXPORTING 1-2-3 FILES)
You can now import from:
- DIF files
- dBase II files
- dBase III files
You can now export to:
- Lotus 1-2-3 files (R1 and R2)
- DIF files
- dBase II files
- dBase III files
You can now use text strings in formulas (at least the ones that are
capable of providing useful information from text). Several existing
@functions now support text arguments, and several new text functions
have been added.
OTHER NEW FUNCTIONS
@ISNUM(x) returns TRUE if x is a number.
@ISTEXT(x) returns TRUE if x is text.
@ERROR returns error as its value.
@INDEX("block name",ColOffset,RowOffset,PageOffset) returns the value
of the cell in "block name" which is RowOffset rows, ColOffset columns,
and PageOffset pages from the first cell in "block name". The top row
of the block has a RowOffset of 0, the left column of the block has a
ColOffset of 0, and the first page of the block has a PageOffset of 0.
You can lock (hold) title rows and columns on the screen.
NEW CELL FORMATS (AND COMMA OPTION)
There are 2 new ways to display numerical values on the screen:
Hidden and General
NOTE: The General format is now the default format.
The currency, fixed, and percent formats now allow you to specify
commas to be used to make large numbers more readable.
SORTING A BLOCK
You can now sort a block of cells by row or column.
MOVING A SCREEN AT A TIME
QubeCalc now allows you to move the cell pointer up, down, left, and right
a full screen at a time.
ENHANCED DIRECTORY LISTING CAPABILITY
The directory listing command /File Files now asks for a file mask.
The /File Files command now also lists any subdirectories which match the
mask you provide. Directories will be highlighted on the display.
COPYING TO MULTIPLE PAGES
QubeCalc now allows you to copy a page (or other 2D range) to multiple
pages. If the block you define to copy with the /Block Copy command is
a two dimensional range (not multiple pages), then QubeCalc will ask
you how many pages you want to copy it to.
SUPPLYING A FILE NAME ON THE COMMAND LINE
If you want to start up with a particular file, you may now supply the
file name on the command line and that file will be loaded when the
program comes up.
FULL PATH SUPPORT WHEN LOADING/SAVING FILES
You may now Load or Save files from another directory without having
to change directories with the /File Directory command. Simply type
in the full path name when you are asked for a file name.
INSERT/OVERWRITE MODE REMAINS CONSTANT
When you select insert mode, it will now remain in effect until you change
it (it doesn't go back to overwrite mode as soon as you finish editing).
/M? MACRO COMMAND NOW ALLOWS YOU TO SUPPLY A PROMPT
The format for the /M? command is now:
Now when this macro command is encountered, it will prompt you with
the text you supply between the ? and the [RET].
AUTOCALC ITERATION COUNT
You can set a recalculation interation count so that QubeCalc
will make more than one pass through the spreadsheet on each recalculation.