Maxiplan Plus ~~~~~~~~~~~~~~~ The following topics are discussed in this directory: * Work arounds to Known Bugs * Using System Clipboard * Freeze Titles * 32,760 Rows in MaxiPlan Plus * Installation of MaxiPlan on new Workbench Disk * Installation of MaxiPlan on a Hard Disk * Mail Merge * Printer Control Menu * Setting Column Widths with the Mouse * Dithering of Charts * Pattern option for Display of Charts 1. Workarounds for Known Bugs, please do not report. They are being worked on as of this writing. a. 48 Row limitation on Recalculation in Natural Calculation Order If a formula is filled down more than 48 rows, in Natural Calculation Order only the first 48 rows will recalculate. Workaround: This can be avoided by switching to Row by Row or Col by Col calculation order. b. Extract, Delete and Find Database Criteria pick out records that both match the criteria AND have a BLANK CELL in the fields columns) used by the criteria. The result is that extra records will be found, deleted, or extracted. If the criteria is used in a database function such as DSUM, the results will be erroneous too large. Workaround: These errors can be avoided by putting in a dummy character instead of a blank in the field used by the criteria for each record in the database. c. Cell protection violated by Macro. Workaround: No known workaround. Avoid using macros on cells of a worksheet that are Protected. d. ROUND function gives erroneous results for larger numbers. Workaround: No known workaround. e. SELECT function in an Automatic Macro may select cell on macrosheet instead of worksheet, even if cell adress properly denoted. Workaround: No known workaround. Macro must be executed manually to select cells on worksheet properly. f. Execution of ESC key while in a database Find Mode in a Macro aborts the execution of the Macro. Workaround: No known workaround. g. Colors confused when printing worksheets in color. Workaround: No known workaround. h. Most Amiga 2000 numeric keypad operator keys inoperable. Workaround: No known workaround. 2. Using System Clipboard On the Edit Menu are two new menu items for Importing and Exporting Data to and from other programs via the System Clipboard. To export data, select the range of data to be exported and select the Ext.Copy menu item on the Edit Menu. This saves the data to the System Clipboard where it can be copied into another product which utilizes the System Clipboard. To import data from the System Clipboard, move the active cell to an area to the worksheet that will accomodate the data and select the Ext.Paste menu item on the Edit Menu. Note in the current release Ext.Copy and Ext. Paste may not be compatible with all products that use the System Clipboard. 3. Freeze Titles MaxiPlan can Freeze any number of Rows from the top and number of Columns from the left. To execute Freeze Titles: * select a Range of Cells such that the bottom right most Cell designates the boundary of Freeze Titles * pull down the Options Menu and select Freeze Titles and then select one of the Submenu Items: - None - Rows (Horizontal) - Columns (Veritical) - Both When you print with Freeze Titles, the Column Headings and Row Headings will appear on all pages of the printout. 4. 32,760 Rows in MaxiPlan 500 and Plus MaxiPlan 500 and Plus have been limited to a maximum Worksheet size of 32,760 Rows. 5. Installation of MaxiPlan Plus on a new Workbench Disk Your Amiga computer comes with a Workbench Disk. MaxiPlan Plus is a bootable disk in that it has Workbench 1.2 installed on it already. You may wish to transfer MaxiPlan either to a backup copy of your Workbench or onto a copy of any new version of the Workbench that may subsequently be released. When installing MaxiPlan onto a new Workbench, you will want to install a special set of Fonts which are only used by Charts in a high resolution mode. To install MaxiPlan on a new Workbench Disk, be certain to copy the entire MaxiPlan drawer, not just the program. To install the special Trantor font set: Assuming you place MaxiPlan disk in df1 and your new system or boot disk in df0: From CLI type: * COPY DF1:TRANTOR.FONT DF0:FONTS * MAKEDIR DF0:FONTS/TRANTOR * COPY DF1:TRANTOR/16 DF0:FONTS/TRANTOR 6. Hard Disk Installation When installing MaxiPlan on a Hard Disk a few points must be kept in mind. * The whole directory should be copied not just the MaxiPlan program * The directory should be copied to the Root directory ofthe Hard Disk * Install the special Trantor font set for using Charts in high resolution or 44 line display mode. 7. When generating a Mail Merge output to a Disk File, there is no Icon created. You must access the Disk File from the File Selector or CLI. ------------------------------------------------------------ To Get a Hard Copy of this File from the CLI key in: Copy "MaxiPlanDATA:Read Me First!" PRT: 8. Printer Control Menu Version 1.8 introduces a new Menu in the Control Window which has the most frequently used printer commands used in Preferences. This Menu called the Printer Control Menu has the 8 Menu Items listed below. * Printer Output with two Submenu Items - Black & White - Color * Print Type Size with three Submenu Items - Pica (generally 10 characters per inch) - Elite (generally 12 characters per inch) - Fine (generally 15 characters per inch) * Set Left Margin (brings up a Requester for keying in character location) * Set Right Margin (brings up a Requester for keying in character location) * Set Page Length (brings up a Requester for keying in number of lines) * Perform Form Feed automatically inserts form feed before printing) * Line Spacing with two Submenu Items - 6 Lines - 8 Lines * Print Quality with two Submenu Items - Draft - Quality 9. Setting Column Widths with the Mouse A new feature of MaxiPlan Plus and 500 is the ability to change the width of an individual column with the mouse. You will notice there is a fine line on the worksheet border designating the boundary of each column. To change the width of a column, just move the pointer to the righthand border of a column, depress the left mouse button, reposition the column border to a different position, and then release the mouse button. The column will now have a different width. Thus the column can be changed as you are entering data should you find that it is not wide enought to accomodate your data. You can also make a column narrower by the same method. 10. Dithering of Charts On the Color and Options Menus of the Chart Drawing window are new menu items for executing Dithering of the Charts. Dithering is a speckle pattern of a complimentary or contrasting color which gives your charts a 3D look, and an alternative look to MaxiPlan Charts. Dithering can be applied to the Border area of the Chart as well as the Data area. On the Options Menu of the Chart Drawing window, is the Dither option. This must be turned on to activate Dithering. On the Color Menu are two menu items to determine the Dithering color for the Border area and Data area of the Chart respectively. You can experiment with different colors until you find the combination which is the most appealing. 11. Pattern Option for Charts When MaxiPlan is set up for Color output, the Charts are displayed with solid color components such as Bars, Pie slices, lines, etc. In Grey the default is to display these components with patterns, i.e. diagonal stripes, horizontal stripes, plaid, etc. You now have the option of choosing either type of display for either Color or Grey printout option. The Menu Item Patterns on the Options Menu in the Chart Drawing Window determines if the Pattern option is on or off.