WELCOME TO QUATTRO PRO FOR WINDOWS UTILITIES This file contains information pertaining to the utilities on this disk. It will provide a description of the functionality of each utility along with specific instructions for using the utility. Please read it in its entirety. N O T I C E These files are provided free of charge by Novell International, Inc. as a service to our users, and are provided "AS IS." These files are miscellaneous utilities and examples that may assist in your understanding and use of Quattro Pro. Novell disclaims all warranties, expressed or implied, including but not limited to any warranties of merchantability or fitness for a particular purpose. By using these files, you acknowledge the above disclaimer and agree that Novell shall not be liable for any damages from your use of the file, including but not limited to damages for lost data, lost profits and special, incidental and consequential damages. Copyright (c) 1994 Novell, Inc. All rights reserved. 1-2-3 is a registered trademark of the Lotus Development Corp. ================================================================ Table of Contents ----------------- 1. SQZ2WQ1 2. WS_LIB 3. DELMAKER 4. TAB&ENT 5. POINTD 6. BIO 7. AMORT 8. AUTOSAVE 9. DJMULT 10. STATS 11. Z 12. ICONNAME 13. FORMAT 14. ODBC/ODBCINST 15. INSTQPW 16. POLY 17. QDDE 18. STATMAC 19. WPMERGE 20. 123TOQPW 21. DEMO 22. MOVEDLG 23. MPLNDLD 24. POKER 25. BLKJACK 26. CONVERT 27. DATEPICK 28. CSV 1. SQZ2WQ1 (SQZ2WQ1.WQ1) ========================== Quattro Pro for Windows cannot translate files compressed with SQZ! or SQZ! Plus. It is necessary to uncompress any files before they can be loaded into Quattro Pro for Windows. SQZ2WQ1 is a Quattro Pro for DOS utility that converts .WQ!, .WKZ, .WK!, and .WK$ compressed files to the Quattro Pro for DOS native WQ1 file format. SQZ2WQ1 allows you to uncompress multiple compressed files at one time. Open the file SQZ2WQ1 in Quattro Pro for DOS. Press [ALT+G] to activate SQZ2WQ1. A menu will appear that displays the type of squeeze files to convert. You can choose a specific format or choose "All" from the menu. "All" will convert all .WQ!, .WKZ, .WK!, and .WK$ files in the specified directory to .WQ1 files. The macro will also prompt you to enter the source directory (the directory that contains the compressed files) and the destination directory (the directory where you would like to place the resulting .WQ1 files). It is recommended that these two directories be different. Note: If a Postscript printer is the default printer, no files will be translated. Set your default printer to a non-Postscript printer before running SQZ2WQ1. SQZ2WQ1 is a Quattro Pro for DOS utility that must be run from Quattro Pro for DOS. It will not function in Quattro Por for Windows. This utility will not work in Quattro Pro 1.0 for DOS. ============================== END ============================= 2. WS_LIB (WS_LIB.WB1) ========================== WS_LIB is a utility that lets you convert a Quattro Pro for DOS workspace (.WSP) into a Quattro Pro for Windows notebook (.WB1). When the workspace is converted, each Quattro Pro for DOS spreadsheet in the workspace will be placed on a separate page in the notebook. The pages of the notebook will be arranged in the same order as the spreadsheets appear in the workspace. The notebook file will be named with the workspace's orginal name with a .WB1 file extension (Quattro Pro for Windows' native file format). Spreadsheet links that exist between files in the workspace will be converted to notebook links in the new notebook. Any link from files in the workspace to a file outside the workspace will remain linked to the original file. Upon opening WS_LIB, you will be presented with a description of the file and a SpeedButton entitled "Convert Workspace". To execute the macro, choose the SpeedButton or press [CTRL+W]. The WS_LIB file will be minimized and a file control dialog box will appear. Enter the name of the workspace file that you want to convert. When the approriate workspace file has been selected, choose OK and the macro will start the conversion process. Although WS_LIB provides an efficient method for converting workspaces, it does have limitations: 1. .WK3 (1-2-3 v3.x) and .WK4 (1-2-3 v4.x) files cannot be converted. 2. Compressed files (e.g., WQ!, WK!, and WKZ) cannot be converted. 3. Formulas that include multiple links to different files in a single formula may not be converted. TIP: WS_LIB makes it easy to convert a group of linked spreadsheets into a single notebook. To convert a group of linked files, create a workspace in Quattro Pro for DOS and use WS_LIB in Quattro Pro for Windows to convert the workspace into a notebook. It is not difficult to create a workspace from a set of linked files in Quattro Pro for DOS: 1. Open one of the linked spreadsheets. If possible, choose the spreadsheet that is the master spreadsheet with links to all the other supporting spreadsheets. A menu will appear prompting for Hot Link options. 2. Choose Load Supporting. 3. Open any other files that you want included in the resulting notebook. 4. Choose /File | Workspace | Save. Give the workspace a name. The workspace can now be converted into a Quattro Pro for Windows notebook using WS_LIB. Note, this utility will only work with Quattro Pro 1.0 for Windows. ============================== END ============================= 3. DELMAKER (DELMAKER.WB1) ========================== DELMAKER is a macro driven application that lets you create an ASCII delimited text file from a block of cells within your notebook. The delimited formats can be Comma & "" Delimited, Commas Only, or User Defined (where you specify any symbol/character to use as the delimiter). How to use DELMAKER: 1. Open the macro library DELMAKER.WB1. 2. Open the file from which you wish to extract data. Make sure it is the current active window. 3. Press: [CTRL+D] 4. At this point, the DELMAKER dialog box will appear. Set your options (see the descriptions below). 5. When DELMAKER has completed exporting your block to the delimited ASCII file, it will display a completion message. Choose OK to clear the message. Press [CTRL+D] to create another delimited file. The DELMAKER dialog box provides the following choices: - Output File Name Specify a file name for the delimited ASCII file that will be created. By default, the file name will be given a .PRN extension. If you wish the extension to be something other than .PRN, specify it along with the file name. - Delimited File Format Comma & "" Delimited uses commas between each cell (field) in a row (record), and quotes surrounding the contents of each field (e.g., "one","two"). Only Commas uses commas between each cell (field) in a row (record) (e.g., one,two). User Defined uses a symbol/character that you provide as the delimiter. This is similar to Only Commas except you provide the delimiter (e.g., one;two). - Blank Cells As Blank Cells As lets you specify how DELMAKER will treat blank cells in your notebook. Blanks (the default) will write out blank cells as blank labels. Zeros will write out your empty cells as zero values. - Value Cells As Value Cells As lets you specify the way your values will be saved. Numbers (the default) will convert values to a General display format before saving them into the extracted file. Labels will retain the cells formatting (Currency, Scientific, Etc.) but will store all values as labels to insure the data translates properly into your own program regardless of the cells' display format. NOTE: If you have dates in your notebook, use Labels. Otherwise, the dates will be saved as date serial numbers. These numbers may be meaningless to some applications. - Source Block The source block is the block of cells in your notebook that you wish to export to the delimited ASCII file. This must be a contiguous block of cells. You cannot specify multiple blocks or multiple pages. =============================== END ============================= 4. TAB&ENT (TAB&ENT.WB1) ======================== TAB&ENT.WB1 is a macro library which contains two useful macros. The first macro (Tab Label) allows you to use a block of labels to name notebook page tabs. For example, you could use a block containing the names of the 12 months of the year to name 12 page tabs with the month names. This feature can be especially useful when used in conjunction with SpeedFill. The second macro (Enter) allows you to enter data into a selected block of a notebook without using arrow keys to move the cell selector. When TAB&ENT is loaded, a startup macro (named \0) will add Tab Label, Enter, and Remove to the Tools menu. Then, the startup macro will hide the macro library notebook. To use the macros, use the menu selections on the Tools menu or use the CTRL+key shortcuts to execute each macro. To remove the additonal selections from the Tools menu and close the macro library, choose Tools | Remove. The first item added to the bottom of the Tools menu is Tab Label. Tab Label allows you to use a block of labels to name the pages in a notebook. This macro can also be executed by pressing [CTRL+T]. When you execute the macro, a dialog box appears requesting a block of labels. This block should contain the names to assign to the notebook pages (in one column). The dialog box also requests a page to start labeling. The page can be specified as a page letter or as any block on the page where you want to start labeling. After choosing a block of labels and a page to start labeling, choose OK. The page names are taken from the specified block. For example, to name pages B through M of a notebook with the 12 months of the year: 1. File | Open | TAB&ENT.WB1 2. Choose OK 3. Open or activate the notebook where you want to name pages 4. In cell A:A1 of the notebook, enter January 5. Select A:A1..A:A12 6. Choose the SpeedFill button on the Speedbar 7. Choose Tools | Tab Label or press [CTRL+T] 8. In the "Page to start labeling" edit field, enter B: 9. Choose OK The Tab Label dialog box also has a Reset All button that deletes all the page tab names in the entire notebook. Be patient; it may take some time to delete all the page names. Even if there are only a few page names, the macro must go through each of the 256 pages to make sure that it has deleted all the page names. Be careful when selecting this button; this command can not be undone with the Undo feature. The second item added to the Tools menu is Enter. The Enter macro allows you to select a block of cells and enter data into that block without pressing the arrow keys to advance the cell selector. Because the ENTER key advances the cell selector, this command is especially convenient if you use the numeric keypad for data entry. You can enter data by row or by column. For example, to enter the numbers 1,7,13, and 25 in the block A1..B2 of a notebook: 1. File | Open | TAB&ENT.WB1 2. Choose OK 3. Open or activate the notebook where you want to enter data 4. Select the block A1..B2 5. Choose Tools | Enter 6. Choose OK 7. To enter in the order A1, A2, B1, B2, select Enter by Column 8. Type 1 and press [ENTER] 9. Type 7 and press [ENTER] 10. Type 13 and press [ENTER] 11. Type 25 and press [ENTER] To end this data entry mode, move the pointer to a different cell or select a menu command and press [ENTER]. The indicator on the status line (bottom right of the screen) indicates the cell the macro expects the pointer to be in when [ENTER] is pressed. As long as you return to the cell shown by the indicator before you press [ENTER], you can move the cell pointer around using the arrow keys or the mouse and make changes to other cells. If you move to a different page before ending the macro, end the macro by pressing [ENTER] when the cell selector is in a DIFFERENT cell from the one shown by the indicator. The indicator will change to READY when you have ended data entry mode. The Enter macro can also be activated by pressing [CTRL+E] after selecting the block into which you want to enter data. If you use [CTRL+E] to execute the macro, it will not ask which direction to move the pointer. The pointer will move in the direction you selected the last time you executed the macro from the menu. The final item added to the Tools menu is Remove. Choose Remove to remove Tab Label, Enter, and Remove from the Tools menu. Tools | Remove also closes the macro library. ============================== END ============================= 5. POINTD (POINTD.WB1) ========================== POINTD contains the game Point Duty. The object of Point Duty is to clear a mine field without blowing yourself up. To play Point Duty, retrieve the notebook POINTD.WB1. The rules of play can be found by choosing Help from the main menu. Point Duty is started by the startup macro named \0. If the macro does not execute to start the game, verify that Property | Application | Startup | Startup Macro is set to \0. POINTD writes your high scores to the disk when you quit the game. You should not run the game from a write protected disk. Copy the file POINTD.WB1 to a directory on the hard drive before loading POINTD.WB1 into Quattro Pro. While Quattro Pro was not specifically designed as an environment for creating entertainment software, Point Duty demonstrates the power of the Quattro Pro for Windows application building environment. ============================== END ============================= 6. BIO (BIO.WB1) ========================== This application (BIO.WB1) generates a simple biorhythm chart based upon your date of birth. The macro will chart your biorhythm over a 19 day cycle including four days prior to the current date and 14 days into the future. This notebook was designed in the standard VGA resolution (640x480). BIO is started by a startup macro called \0. If the macro does not execute to start the application, verify that Property | Application | Startup | Startup Macro is set to \0. To use BIORHYTHM: 1. Choose File | Open | BIO.WB1 2. For instructions, choose About Bio on the main menu or choose the About Bio SpeedButton This notebook is not intended for serious use nor for the promotion of astrology. ============================== END ============================= 7. AMORT (AMORT.WB1) ========================== AMORT.WB1 is a notebook that helps you create an amortization table for a loan. An amortization table breaks out the interest and principal for each period of a loan and shows the balance remaining on the loan each period. To create an amortization table for a loan, enter the principal, annual interest rate, term of the loan (in months), and balloon payment (if any) on the page Loan_Terms. Your scheduled monthly payment will be calculated in this table. Below the table are two SpeedButtons. The first button is labeled "Help" and provides help on using the notebook. The second button is labeled "View a Year". Use this SpeedButton to examine or change the values for any year of the loan. The amortization table is calculated on the next 31 pages in the notebook. On the loan pages that show the amortization schedule, you will see how much principal remains before each monthly payment, the portion of each monthly payment that is applied to interest, and the portion of each monthly payment that reduces the principal. You can also enter additional principal payments. The table can handle up to a 31 year loan. If your loan has a shorter term, the extra entries in the table will appear as 0 or blank. ============================== END ============================= 8. AUTOSAVE (AUTOSAVE.BAR) ========================== AUTOSAVE enables Quattro Pro for Windows to save notebooks at timed intervals. To load the SpeedBar, follow the steps corresponding to your version of Quattro Pro. Version 5.0 & 6.0 1. Right-click the SpeedBar any place outside a button or field. 2. Choose Append 3. Choose Browse 4. Select AUTOSAVE.BAR from the directory your copied it into and choose OK. Version 1.0 1. Choose Property | Application 2. Choose SpeedBar 3. Choose Browse 4. Select AUTOSAVE.BAR from the directory you copied it into and choose OK. Now the SpeedBar is loaded and ready to use. This SpeedBar will provide timed saves and\or backups for the current notebook. The spin control allows you to change how often the current notebook is saved. THE DIFFERENCES BETWEEN REPLACE, BACKUP AND CONFIRM Replace overwrites the existing file with the new information. Backup copies the file that exists on disk, giving it a .BAK file extension, and creates a new file with the original file name. To load the backup file later, include the .BAK extension with that file name when choosing File | Open. The .BAK file contains your data as you previously saved it. Confirm prompts you to either Replace, Backup or Cancel the save process. ============================== END ============================= 9. DJMULT (DJMULT.WB1) ======================== DJMULT is a macro driven application that allows Quattro Pro for Windows to print multiple copies on a HP DeskJet. To run DJMULT: 1. Copy DJMULT.WB1 into the QPW directory. 2. Choose Property | Application | Startup | Autoload File. 3. Enter DJMULT.WB1 and choose OK. 4. Exit Quattro Pro and start it again. As long as DJMULT.WB1 is defined as the Autoload File, DJMULT is loaded each time you start Quattro Pro. When DJMULT is loaded, it runs a macro that modifies the Print menu and hides DJMULT.WB1. If you close DJMULT.WB1 after it has been loaded, you will not be able to print until you restart Quattro Pro. To remove DJMULT: 1. Choose Property | Application | Startup | Autoload File. 2. Enter QUATTRO.WB1 or anything other than DJMULT.WB1. 3. Exit Quattro Pro and start it again. ============================== END ============================= 10. STATS (STATS.BAR) ======================== STATS.BAR is a custom SpeedBar that allows Quattro Pro for Windows to automatically apply many statistical @functions to a list of numbers. The functions included are @AVG, @MAX, @MIN, @STD and @VAR. The SpeedBar provides two buttons for each of these functions: one for calculating a result based on a list of numbers in a column, and one for a list of numbers in a row. For example, the columnar @AVG button appears as CAvg, while the row-based @AVG button shows RAvg. To load STATS.BAR, follow the steps corresponding to your version of Quattro Pro. Version 5.0 & 6.0 1. Right-click the SpeedBar any place outside a button or field. 2. Choose Append 3. Choose Browse 4. Select STATS.BAR from the directory your copied it into and choose OK. Version 1.0 1. Choose Property | Application 2. Choose SpeedBar 3. Choose Browse 4. Select STATS.BAR from the directory you copied it into and choose OK Each of the functions can be applied to a single column or row or multiple columns or rows, even if there are blank cells in the selected block. However, the functions will only work when applied to a contiguous block. To use one of the buttons, first select the appropriate block of cells. If you select the exact block of cells that contain data, the result will be placed one cell below (for the column functions) or one cell to the right (for the row functions). If you select the block of cells along with one blank cell at the bottom or to the right, the result will be placed in the blank cell. After selecting the block, choose one of the buttons from the SpeedBar. Note, be careful when selecting one of the buttons on the SpeedBar. For example, if you accidentally choose CAvg when a row is highlighted, the results may be placed in a cell containing other information. ============================== END ============================= 11. Z (Z.BAR) ========================== Z.BAR is a custom SpeedBar that makes it convenient to use the Novell SEND utility. Novell SEND is a DOS utility that allows you to send one line messages to other users on your Novell network. There are two files needed to run Z.BAR; Z.BAR, the SpeedBar you see in Quattro Pro for Windows, and Z.PIF, a PIF file that Z.BAR uses to execute the Novell SEND. Z.PIF should be copied into your Windows directory but Z.BAR may be located anywhere. You must also have a Novell search mapping to the directory that contains SEND.EXE. This is usually your \PUBLIC directory. If you do not have a search map for that directory, you may either add the search map or edit the Z.PIF file to point directly to the directory containing SEND.EXE. Ask your network administrator if you do not know where SEND.EXE is located. To use Z.BAR, first copy Z.PIF into your Windows directory. If Windows is installed on a network, copy it into your local Windows directory. Copy Z.BAR into any directory you would like (your Quattro Pro data directory would be a good choice). Start Quattro Pro. To load the SpeedBar, follow the steps corresponding to your version of Quattro Pro. Version 5.0 & 6.0 1. Right-click the SpeedBar any place outside a button or field. 2. Choose Append 3. Choose Browse 4. Select Z.BAR from the directory you copied it into and choose OK. Version 1.0 1. Choose Property | Application 2. Choose Speedbar 3. Choose Browse 4. Select Z.BAR from the directory you copied it into and choose OK. The SpeedBar is now loaded and ready to use. The first pick list field is for the recipient of the SEND. The second pick list field is for the message, which may be up to 100 characters. The Send button is used to execute the send. If you would like to see the results of your send, check the Show Send box. This will pop up a very brief window with the results of the send. If you wish to have the results displayed for a longer period of time, modify Z.PIF so that the DOS window does not close on exit. To modify Z.PIF: 1. From the Windows Program Manager open the PIF editor (usually it is in the Main group). 2. Choose File | Open and select Z.PIF. Choose OK. 3. Uncheck the box labeled "Close Window on Exit". 4. Choose File | Save 5. Choose File | Exit This will allow you to read the result of the send. However, you will have to manually close the window. You may create a pick list of Novell Login names in the first field for the send recipients by following these steps. 1. In a notebook page, enter a list of the Novell login names for the people you wish to have in your list. 2. Select your list and choose Edit | Copy. 3. Choose Tools | UI Builder 4. Choose Dialog | Open Speedbar... 5. Choose Z.BAR. Choose OK. 6. Choose the first Combo Box, which holds the send recipients. 7. Choose Edit | Paste 8. Choose Dialog | Save Speedbar 9. Choose Dialog | Close Speedbar 10. Close the blank dialog box on your screen. Now, when you load the SpeedBar, the first box will contain the list of names that you specified. You can choose those names by clicking on the down arrow to the right of the pick list field or by pressing the down arrow on the keyboard when that box is selected. ============================== END ============================= 12. ICONNAME (ICONNAME.WB1) =========================== ICONNAME will provide a list of Graphs page icon (object) names in your notebook. ICONNAME will prompt for a block in which to place the names. If you specify a single cell for the block, ICONNAME will use as many cells as necessary to write the icon names. If you specify multiple cells for the block, ICONNAME will only write to those cells. You will be informed if more cells are needed to complete the list of icon names. You will also be informed before ICONNAME overwrites existing data. You will have a choice of ending the macro or overwriting the data. To execute ICONNAME: 1. Choose File | Open. Select the file ICONNAME.WB1. 2. Choose OK. 3. Choose File | Open and select the file containing the icon names. Do NOT choose File | Retrieve to open this file. 4. Choose OK. 5. Press [ALT+G]. 6. Enter the cell or block of cells in which ICONNAME should place the icon names. 7. Choose OK. ============================== END ============================= 13. FORMAT (FORMAT.BAR) ======================== FORMAT.BAR is a custom SpeedBar that displays some of the properties assigned to the active cell. These properties include Column Width, Row Height, Numeric Format, Protection and Font Size. To load FORMAT.BAR, follow the steps corresponding to your version of Quattro Pro. Version 5.0 1. Right-click the SpeedBar any place outside a button or field. 2. Choose Append 3. Choose Browse 4. Select FORMAT.BAR from the directory your copied it into and choose OK. Version 1.0 1. Choose Property | Application 2. Choose SpeedBar 3. Choose Browse 4. Select FORMAT.BAR from the directory you copied it into and choose OK ============================== END ============================= 14. ODBC (ODBC.DLL and ODBCINST.DLL) ==================================== These two files allow applications that are compliant with older versions of ODBC to run with the version of IDAPI that ships with Quattro Pro 6.0 for Windows. Be sure to make a back up copy of these two files in the ODBC directory before you copy these files to that directory. Once these files are copied, you should be able to configure the drivers using the IDAPI Configuration Utility. ============================== END ============================= 15. INSTQPW (INSTQPW.WCM) ========================= This WordPerfect for Windows 5.2 macro creates a QPW.WCM to allow WordPerfect for Windows to switch to Quattro Pro for Windows. This macro also has options for adding QPW.WCM to various WordPerfect for Windows menus to allow convenient switching to Quattro Pro for Windows. The areas that QPW.WCM can be added are the Button Bar, the Tools menu, the Macro menu, or the Keyboard. To run INSTQPW.WCM, choose | Run | INSTQPW.WCM. A menu will be displayed. 1. Switch to Quattro Pro for Windows This option switches immediately to Quattro Pro. Quattro Pro will display in full screen mode if it needs to be loaded from disk. Otherwise it will display in the mode it was last left in. For example, if Quattro Pro was minimized before switching to WordPerfect, choosing this option will display the Quattro Pro icon. 2. Create Switch To QProWin Macro This option creates the macro QPW.WCM and saves it in the WordPerfect macros directory. This menu option must be created before the other options will work. Quattro Pro will display in full screen mode if it needs to be loaded from disk. Otherwise it will display in the mode it was last left in. 3. Add QProWin to Button Bar This option adds a button named QPro Win that executes the QPW.WCM macro to the current Button Bar. QPW.WCM can only be added once per Button Bar. If an attempt is made to load it again, the WordPerfect Macro Facility will display an error QPW.WCM has already been attached. 4. Add QProWin to Tools Menu This option adds a selection to the WordPerfect Tools menu that executes the QPW.WCM macro to switch to Quattro Pro. 5. Add QProWin to Macro Menu This option adds a selection to the WordPerfect Macro menu that executes the QPW.WCM macro to switch to Quattro Pro. 6. Assign QProWin to Keyboard Key This option brings up the Keyboard dialog box that allows QPW.WCM to be executed by defining or editing a keyboard. See below for additional instructions on assigning QPW.WCM to a keyboard key. Path to QPW This is the drive and directory where QPW.EXE has been installed followed by a \. This must be filled in correctly if the QPW directory is not included as part of the DOS Path. Use the WordPerfect File Manager or Windows File Manager to find the drive and directory where QPW.EXE resides. QPW Command Line This is where you set the command line options to included everytime Quattro Pro is loaded from disk. This information is not used when Quattro Pro is already in memory and the macro is just making it the active application. It contains the same information as included in Windows Program Manager QPW icon. The QPW Command Line can generally be left blank. Done This option exits INSTQPW.WCM and returns to WordPerfect. AUTOMATICALLY ADDING QPW.WCM TO TOOLS MENU To automatically add QPW.WCM to Tools Menu when WordPerfect starts: 1. Start WordPerfect for Windows. 2. Open INSTQPW.WCM. 3. Change the line //AutoAdd:="YES" to AutoAdd:="YES". 4. Save INSTQPW.WCM to the WordPerfect Macros directory and Exit WordPerfect. 5. In Windows Program Manager: Select the WordPerfect for Windows Icon. Choose File | Properties and in the Command Line: field, after wpwin.exe add: /m-d:\path\INSTQPW.WCM where d:\path is the drive and path name where INSTQPW.WCM was saved earlier. Choose OK. REMOVING QPW.WCM To remove QPW.WCM from menus, follow the instructions for the particular menu: Tools Menu Exit and restart WordPerfect. Button Bar Right click on Button Bar, choose Edit, click on the QPro Win button and drag it off of the menu bar. Macro Menu Choose Macro | Assign to Menu | QPro Win | Delete. ASSIGING TO KEYBOARD To assign QPW.WCM to keyboard key: 1. From the INSTQPW.WCM menu, choose option 6. 2. Choose Create. 3. Set Item Types to Macros. 4. Add QPW.WCM. 5. Press keystroke to be defined, such as {Ctrl+Alt+Q} Assign | OK. 6. Save the keyboard file with a .WWK file extension. TROUBLESHOOTING If QPW.WCM does not run: Verify you are using WordPerfect for Windows 5.2 and it is the 4/23/93 release or later. Verify the file MXWIN.EXE is located in the WPC directory. Verify the Quattro Pro (QPW) directory is in the DOS path or use WordPerfect to modify QPW.WCM. Change the line Path:="" to Path:="d:\pathname", where d:\pathname is the location of Quattro Pro. If QPW.WCM does not start Quattro Pro but displays the Quattro Pro icon, Quattro Pro was minimized before switching to WordPerfect. QPW.WCM will start Quattro Pro in full screen mode if it has not been loaded into Windows. To determine the applications that are currently loaded, press {Ctrl+Esc} to bring up the Task List. If Quattro Pro is loaded, then it will be reactivated by QPW.WCM in the same mode it was in before switching to WordPerfect. For example, if Quattro Pro was minimized before switching to WordPerfect, choosing this option will bring up the Quattro Pro icon. If the block F:A5..G30 was selected before switching to WordPerfect, when QPW.WCM reactivates Quattro Pro, the block will still be selected. ============================== END ============================= 16. POLY (POLY.WB1) =================== POLY displays a graph of a polynomial function when you enter the coefficients for the following formula: y = a + bx + cx^2 + dx^3 + ex^4 + fx^5 You enter the coefficients a, b, c, d, e, and f. If all terms of degree greater than 1 (c, d, e, f) are zero, the function is linear and the graph will display a line. If all terms of degree greater than 2 (d, e, f) are zero, the function is quadratic and will display the form of a quadratic. The range of x values for which the equation is plotted can also be defined. By setting the range of x you can display a particular range of interest for the polynomial that you are plotting. To plot your polynomial, choose the Change Graph button and enter the coefficients into the appropriate box. You may enter zero for any terms you want omitted from the equation. Enter the high and low graph value and choose OK. ============================== END ============================= 17. QDDE (QDDE.WB1) =================== OVERVIEW Quicken for Windows allows the transfer of three different types of data to other programs that have Dynamic Data Exchange (DDE) capability. This macro transfers the three Quicken data types into tables in the Quattro Pro notebook. After the data has been transferred into the spreadsheet, it may be used for further calculations or to create custom reports or graphs. NOTE: If changes are made to the Quicken data from within Quicken, you must run this macro again to update the Quattro Pro notebook. TRANSACTION SUM TABLE The Sum table is used to obtain totals of transactions in the Quicken for Windows data file. You can specify the transactions to be searched by date range, account, payee, category, and class. Each column may be defined for a different set of conditions for the transactions to be totaled. SECURITY PRICE TABLE The Security Price table lists the price of a security as of a specified date. SHARE COUNT TABLE The Share Count table lists the total number of shares of a security that you own in all your accounts as of a specified date. USING THE QUATTRO PRO SPREADSHEET 1. Start Quicken for Windows and open the Quicken file you want to use. 2. Start Quattro Pro for Windows and open the QDDE.WB1 notebook. 3. Enter conditions into the three tables for the data you wish to transfer. See "MODIFYING THE SPREADSHEET" for more information. 4. Choose UPDATE or press [Ctrl+U] to display the Quicken DDE dialog box. 5. Verify and update the Quicken date format and file name displayed. You may search for the Quicken file by choosing the Browse button. 6. Select the tables you wish to update by clicking on the check box. QUICKEN SUM updates the Quicken Transaction Summary table. SECURITY PRICE updates the Quicken Share Prices table. SHARE COUNT updates the Quicken Share Count table. 7. Choose the OK button to make the setup changes and update the tables (choosing Cancel will reset to the original settings). 8. You may now graph, copy, and/or paste-link the values to another page or file where they can be further manipulated. Changes to the data are not sent back to Quicken for Windows. SETTING UP QUICKEN DDE SELECTING THE QUICKEN DATE FORMAT Quicken for Windows offers a choice of two date formats, Standard date (m/d/yy) and Canadian (d/m/yy). Select the date format that Quicken is currently set for. It is not required that Quattro Pro for Windows use the same date format. The Quicken date format may be selected from the Quicken DDE dialog box by clicking on the appropriate choice or entered directly into the first section of the macro page. ENTERING THE QUICKEN PATH AND FILE NAME Before data can be retrieved from Quicken for Windows through Dynamic Data Exchange (DDE), the QDDE macro must know Quicken's location and executable file. This file is usually called QW.EXE and by default is located in the \QUICKENW directory on the hard drive. However, this may vary on each system. Verify the file name and location of the Quicken program installed on your hard drive. The Quicken path and program file name may be entered in the Quicken DDE dialog box by typing it into the Quicken Path and File Name input field or clicking Browse and selecting it off the directory tree. The Quicken path and file name may also be typed directly into the first section of the macro page. MODIFYING THE SPREADSHEET The tables in the sample spreadsheet page come with predefined block names used by the macro. Do not remove or change the order of these cells. The location of the cells are critical for the data transfer to work properly. Additional columns of data may be added as needed up to a maximum of 256 columns. Do not skip any columns. The macro stops updating when a blank column is found. Using keyword matches: Two periods may be used in most cells as wild cards to indicate a keyword match. The periods may be added to a keyword or entered as the only text. An apostrophe is needed before the two periods, if entered alone in the cell, or the cells must be set for Labels Only as the Data Entry Input property (refer to the Quattro Pro for Windows User's Guide for more information on this option). The two periods are not allowed in the Date and Security name cells. Entering multiple items in a single cell: Multiple items may be entered into a single cell by separating them with forward slashes, such as: Utilities/Rent or Checking/Savings. Multiple items are not allowed in the date and payee cells. CELLS IN THE TABLES DATES - Enter the starting and ending dates for the transactions, or the single date for the price and number of shares, you want to transfer to the Quattro Pro notebook. You may use any Quattro Pro date format (must be entered as a date value). The macro automatically converts the date to the Quicken format when communicating with Quicken. ACCOUNT, PAYEE, CATEGORY, CLASS, SECURITY NAME - Enter the name of the Quicken account, payee, category, class, and/or security name to which you want to restrict the data transfer. HOW THE MACRO WORKS This macro was based on the Excel and 1-2-3 macros that ship with Quicken for Windows, and follows a similiar process for retrieving data. Those basic macros have been translated for use with Quattro Pro for Windows, and additional features have been added. The macro opens a conversation with Quicken using Dynamic Data Exchange, then requests specific data for which you have entered restrictions in the three tables. Quicken receives the request from Quattro Pro and sends back the filtered data as you requested. This process is repeated for each column of data, and ends once a blank column is encountered. This macro uses the following DDE macro commands to transfer data: {EXEC AppName,WindowMode,} {INITIATE AppName,Topic,ChannelLoc} {EXECUTE DDEChannel,Macro,} {REQUEST DDEChannel,DataToSend,DestBlock} NOTE: Please refer to the Quattro Pro for Windows Building Spreadsheet Applications manual or on-line help for additional information on these and other macro commands. This macro was designed for general use and is only an example of what can be done using a customized macro for your specific need. All of the available types of data that Quicken for Windows will export have been shown in this macro. You may wish to refer to the Quicken for Windows User's Guide for additional information on using Quicken data in spreadsheets. Disclaimer: The QDDE.WK3, QDDE.XLS and QDDE.XLM macro and spreadsheet files are copyrighted by Intuit Corportion c1991. Portions of those macros have been used in this translation by permission of Intuit Corporation. All rights reserved. Quicken is a registered trademark of Intuit Corporation. ============================== END ============================= 18. STATMAC (STATMAC.WB1) ========================= STATMAC is a macro library that allows you to count or average non-zero number in a specified block. It also allows you to find the maximum or minimum value that is not equal to zero. To use STATMAC: 1. Open the STATMAC.WB1 file. It will open as a hidden file. 2. Press [CTRL+M] and select a block of cells. Choose the appropriate operation and choose OK. ============================== END ============================= 19. WPMERGE (WPMERGE.WCM) ========================= WPMERGE is a WordPerfect for Windows 5.2 macro that converts a Quattro Pro .WB1, .WQ1 or .WKQ spreadsheet into WordPerfect secondary merge file. This file can then be used with a WordPerfect primary merge file for making labels, addressing envelopes or other merge operations. The Quattro Pro Users Guide gives valuable information on setting up a block for use as a database. The WordPerfect Users Guide contains the necessary information for creating a primary merge file and for performing the merge operation. Before Running WPMERGE.WCM, copy WPMERGE.WCM to the WordPerfect macro directory. The location of this directory can be found by starting WordPerfect, choosing File | Preferences | Location of Files. Running "WPMERGE.WCM": 1. Start WordPerfect with a new blank document. 2. Press {Alt+F10} (Macro Run), type WPMERGE, and press enter. 3. Choose the Quattro Pro file that contains the merge data. 4. Select the spreadsheet block or range to be converted into the merge format. 5. Verify that Spreadsheet Import | Type is set to Text. If this option is set incorrectly the macro will fail to convert the file properly. 6. Choose OK. When prompted, choose how the first row of the data block is to be treated. The first row of the block can be treated either as WordPerfect merge field names or as data like the rest o the block. 7. When the conversion is complete, save the file {Shift+F3} with an appropriate file name. It can now be used with a WordPerfect primary merge file to create labels or form letters. ============================== END ============================= 20. 123TOQPW (123TOQPW.WB2) =========================== The 1-2-3 macro translator is a Quattro Pro 6.0 for Windows notebook that converts keystroke macros from 1-2-3 (Release 2.01 through Release 2.4) to Quattro Pro's macro syntax. Using The 1-2-3 Macro Translator 1. Open 123TOQPW.WB2 in Quattro Pro. It is a hidden macro notebook which will add an extra option under the Tools | Macro submenu. This option is called Translate which can also be activated via a keyboard shortcut [ALT+F1]. 2. Open the 1-2-3 file containing the macro(s) that you want to convert. 3. Choose Tools | Macro | Translate to begin the translation process. 4. In the Convert dialog box, specify the block (i.e., ranges) of macros you want to convert. 5. Check the Highlight unsupported macros checkbox (it is checked by default) if you want to highlight problem macros and choose OK. If you checked Highlight unsupported macros, macros that could not be converted are highlighted with the following colors: Blue = contains macros not supported in Quattro Pro Red = contains unrecognized macros Purple = contains both unsupported and unrecognized macros Specifications of the 1-2-3 Macro Translator 1. The 1-2-3 macro translator will only translate 1-2-3 keystroke commands that start with a "/". 2. It will only translate full menu commands. For example, /G alone will not be translated as it only opens the graph menu but does not do any action in the graph menu. 3. Commands that are broken into more than one line will not be translated. For example: A1: /F A2: R This is equivalent to /File | Retrieve in 1-2-3, but the macro translator will not translate it. The 1-2-3 command will be translated, if it were: A1: /FR 4. If you choose to highlight unsupported commands, it will highlight any "/" that it could not translate. If you select a block that has text that contains a slash (/), the macro translator will highlight that cell. 5. If you have text labels in the selected block that contain an identical character string found in a 1-2-3 menu command, it will be treated as a macro and be translated. 6. /X commands are not translated because they are supported by Quattro Pro. 7. Self-modifying macros which concatenate menu commands will not be translated. 8. Macros that require the user to input menu keystrokes will not be translated. These may work in some situations but most 1-2-3 macros that use this method activate a certain menu (i.e., /G to the graph menu) and then allow the user to make a selection. These commands will not translate because only full menu commands are translated. 9. Macros which use other macro commands to navigate the menus will not be translated. For example /{RIGHT 2}~ which takes the user to the 1-2-3 Copy menu option will not be translated. Tips 1. If you have an autoload macro (i.e., \0) in your 1-2-3 file, it might activate Quattro Pro menus. Press [CTRL+BREAK] while your file is being loaded to stop this macro from executing. 2. It is highly recommended you save your 1-2-3 file as a Quattro Pro .WB2 notebook prior to starting the translation process. It is also recommended that you make a backup of your 1-2-3 file. ============================== END ============================= 21. DEMO (DEMO.WK1, DEMO.FMT, DATA.TXT) ======================================= DEMO.WK1 1-2-3 spreadsheet application file DEMO.FMT 1-2-3 spreadsheet formatting file DATA.TXT Text file used by the DEMO.WK1 macro This demonstration shows how a macro (DEMO.WK1) created in 1-2-3 can be translated to run under Quattro Pro 6.0 for Windows using the 123TOQPW.WB2 1-2-3 macro translator. This application will not run properly in Quattro Pro unless it is converted by using the macro translator. 1. Choose File | Open 123TOQPW.WB2. It loads as a hidden system file. 2. Open the file DEMO.WK1. 3. Choose File | Save As DEMO.WB2 as the file name, choose QPW v6 (*.WB2) as the file type, and choose OK. The 1-2-3 file is now saved as a Quattro Pro .WB2 notebook. 4. Choose Tools | Macro | Translate. Enter J1..J20 as the block to convert in this demo. Make sure the Highlight unsupported macros checkbox is checked and choose OK. The macro translator will now go through the block that you specified and convert all the 1-2-3 keystroke macros into Quattro Pro macro commands. Depending on the type of PC you have, it might take anywhere from 30 seconds to several minutes. A few modifications need to be made so the application will fully converted for use with Quattro Pro. 5. Cell J2 needs to include the path to the file DATA.TXT (i.e., C:\FILES\DATA.TXT). 6. Notice cell J14 is blue which indicates the commands in this cell could not be translated. It should be replaced with the command: {Navigate.SelectTable}{GraphNew Sales,1} 7. Cell J18 also did not translate. This command should be converted into a comment because it is no longer needed. This is done by placing a semicolon in front of the command and surrounding the entire cell contents with French braces. For example: {;/golrA2..A5~{ESC 3}} 8. Choose File | Save to save the notebook. The macro has been successfully converted to run under Quattro Pro 6.0 for Windows. ============================== END ============================= 22. MOVEDLG (MOVEDLG.WB1) ========================= MOVEDLG is an example of a Quattro Pro for Windows dialog box that displays two lists and allows the user to move list items from one list box to the other list box. While this dialog box is not overly complex, it does rely on a combination of macros and dialog links to accomplish its task. HOW MOVEDLG WORKS List items can be moved from the primary list (list 1) to the secondary list (list 2), either by double clicking on the list item or selecting the list item and then clicking on the Add >> button. When a dialog link is activated (either by clicking or double clicking on the appropriate control) a macro associated with that control is executed. Since the result of double clicking on a list item should be the same as clicking on the Add button, either action sends a trigger to the list box. The list box executes the move macro when it receives the trigger. This reduces the amount of information the dialog must contain and ensures the controls operate in a consistent manner. INSERTING MOVEDLG INTO A MACRO LIBRARY By using Block | Insert | File | Filename: MOVEDLG.WB1 (Notebook | Insert in Quattro Pro 6.0 for Windows), it will not be necessary to manually recreate the MOVEDLG macros, links, and dialog box in each macro library. When including MOVEDLG in another macro library it is important to remember that it changes its copy of the lists. This means that choosing Cancel will not restore the lists to the original form. To avoid this, keep the working copy of the lists in a different location in the notebook. When a macro calls MOVEDLG, the working lists are copied to List1 and List2. Then _List1Size and _List2Size are set to the number of elements in each list and _UpdateLists is called. Finally, {DODIALOG} is used to call the dialog box. If OK is selected, the contents of List1 and List 2 can then be copied back to the working location. Otherwise, if Cancel is selected, the macro can continue with the original working lists unmodified. Another advantage to this approach is the same move dialog box can be used by different sections of the macro with very little effort. WORKING WITH DATABASE RECORDS MOVEDLG was designed to work with single item lists. However, it can be modified to operate on database records. The major modification is to change the {Block.Copy} macro commands to copy the entire row rather than a single notebook cell similar to the example below. Note, the command listed below is one command and should be entered into one cell in its entirety. {BlockCopy @cellindex("FullAddress",List2:A,0,_Selected,0)&".."& @cellindex("Address",List2:A,255,_Selected,0), @cellindex("FullAddress",List1:A,0,_List1Size,0)} Another modification required for sorted lists would be to make sure the Sort Block contained the entire record. This can be best accomplished by creating additional named blocks (see example below) and using this block name in the _SortList macro. Again, the command listed below is one command and should be entered into one cell in its entirety. {BlockName.Create _List1AllData,+"List1:A1..IV"& @STRING(@IF(_List1Size>2,_List1Size,2),0)} ============================== END ============================= 23. MPLNDLD (MPLNDLD.WB2) ========================= Map Land 1.7 is third party mapping software that works with spreadsheet programs. MPLNDLD contains a macro that allows Map Land version 1.7 and earlier to work with Quattro Pro 6.0 for Windows. Any version of Map Land greater than 1.7 will work with Quattro Pro without the MPLNDLD macro. To use Map Land with Quattro Pro: 1. Map Land must be installed according to the manufacturer's instructions. However, Map Land should not be loaded. 2. Run Quattro Pro and open the file MPLNDLD.WB2. It will open as a hidden system file and will load Map Land for you. ============================== END ============================= 24. POKER (POKER.WB2) ===================== Poker Pro is a computerized version of five card draw. To play the game, close all other files, choose Start Game then choose Go. Choose the cards you want to keep by clicking on the card. If you change your mind, click on the card again. When you are finished making your selection, choose Done. Poker Pro will keep track of your gains and losses based on the level of bet you choose. The points per hand will also change depending on the bet level. In case you are playing Poker Pro when you should be planning next year's budget, we have added a "The Boss in Coming!!" button to display a graph. ============================== END ============================= 25. BLKJACK (BLKJACK.WB2) ========================= BlackJack Pro is a computerized version of the game BlackJack. To play the game, close all other files and choose Play. The object of the game is to have your cards total more than the dealer without going over 21. All face cards are worth ten. If you would like more cards, choose More. When you are satisfied with your cards, choose Stay. You can choose whether you want your aces to be counted as one or eleven by choosing the appropriate button. You win if your cards are more than the dealer but not over 21, you have five cards and the total of the cards is 21 or less, or you get a BlackJack which is a card equaling ten and an ace as your first two cards. If you are playing BlackJack Pro when you really should be working on your company's income statement, we have added a "The Boss is Coming!!" button to display a graph. ============================== END ============================= 26. CONVERT (CONVERT.WB1) ========================= Choose the type of conversion you would like by choosing the appropriate button. When the conversion dialog box appears, select the unit of measure you are converting from, enter the value in the From box, and double-click the unit of measure you are converting to. The To box will display the converted value. Choose Tables to see a list of measures and their corresponding abbreviations. ============================== END ============================= 27. DATEPICK (DATEPICK.WB1) =========================== DATEPICK is a sample dialog box demonstrating the use of a picklist in Quattro Pro to create a date serial number. There are two features about the example that make it interesting: 1. The dialog keeps track of the number of days in the month. For example, only 28 days are shown in the Days pick list when February is selected. When a leap year is selected, then 29 days are shown. 2. The dialog does not rely on macros contained in a notebook. All of the logic is contained in the dialog itself. This makes it easy to copy the example to a different notebook. The user is presented with three pick lists, one for month, day, and year. However, there are actually four pick lists for days, one each for 28, 29, 30, and 31 days. When the the month or year is changed, the links in the dialog determine the number of days in the selected year. Then, the four day pick lists are hidden and the appropriate day pick list is unhidden. Finally, there is a check to verify that the selected day is not greater than the number of days in the selected month an the four day pick lists are synchronized. Notes: 1. The four Day pick lists have been separated for easy viewing. Before using, stack the four pick lists under Day so that only the top one is visible (select the four pick lists, then choose Tools | Align | Top). 2. When copying or renaming the dialog, change the dialog name ("Dialog1") in all the control links that contain DOMACRO. 3. When creating pick lists from this documentation, replace baseYear with a value calculated by subtracting 1900 from the first year you want to have on the pick list. In this example, baseYear = 1975 - 1900 = 75. 4. The pick lists are initialized with the current system date, this can be changed by replacing @TODAY references with the reference of a cell containing a date. 5. The dialog saves the date serial number (when the OK button is selected) to the cell named Picklist_Example_Destination. This can be changed to the current notebook cell by replacing Picklist_Example_Destination with: @PROPERTY("Active_Block.Selection") ============================== END ============================= 28. CSV (CSV.DLL) ================= CSV.DLL is an addin for Quattro Pro 5.0 for Windows and later that allows you to write Comma Separated Value (.CSV) files. A CSV file is a comma and quote delimited ASCII file (labels are surrounded by quotes, values are not, and all values and labels are separated by commas). To load the addin program, copy the file CSV.DLL into the Quattro Pro directory where the QPW.EXE file is located (i.e., C:\QPW). Once the file has been copied, there are two ways to access the DLL: 1. Add the following line to your QPW.INI file [Quattro Pro 5.0 (or 6.0) for Windows] InitMacro={DLL.LOAD CSV} - OR - 2. Run the macro command {DLL.LOAD CSV} To write a block of cells to a CSV file, use the following macro command: {WRITECSV ,""} For example: {WRITECSV A:A1..C400,"C:\DATAFILE.CSV"} If the file already exists, you will be asked if you want to overwrite the existing file. ============================== END =============================