======================================================================= 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.EXE which is provided on the disk. 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.001. 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. BLOCK NAMES 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. SPREADSHEET LINKING 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 TEXT FUNCTIONS 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. TITLE LOCKING 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: /M?prompt[RET] 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.