Liren Large Software Subsidy 6

home *** CD-ROM | disk | FTP | other *** search

/ Liren Large Software Subsidy 6 / 06.iso / b / b323 / 1.img / README < prev next >

Wrap

Text File | 1992-02-12 | 18.7 KB | 468 lines

Welcome to Quattro Pro version 4 --------------------------------- This file contains important information--please read all of it. All information here supersedes information in the Quattro Pro manuals. Table of Contents ----------------- 1. Installation 2. How to contact Technical Support 3. Upgrading from Quattro Pro 3 4. Bitstream fonts 5. WYSIWYG mode 6. Problems using a mouse 7. Running under Windows 8. Sound files 9. Slide transitions 10. Using expanded memory 11. Printing 12. Links in a 1-2-3 version 2.2 file 13. Importing a .WK1 file 14. Allways formatting 15. Cell references in a 1-2-3 version 3x file 16. Importing LICS and LMBCS 17. Sample .QLL file 18. Selecting blocks in macros 19. Documentation corrections 20. Solve For improvements 21. Optimizer tip 22. Dual values in Optimizer 23. Who should use Overstrike Print 24. Printing from Audit 25. Pre-formatting cells 26. Format code for a number in scientific notation 27. Network users 28. How to customize an overriding graph type 29. The Borland Print Spooler 30. Exporting to a Harvard Graphics file 31. Installing different character sets 32. Enhanced fonts 33. Clearing a custom style 1. Installation --------------- To install Quattro Pro on your hard disk: o Place Disk 1 in drive A. o Type A:INSTALL and press ENTER. o Follow the directions that appear onscreen. If you have trouble reading the installation screens, use the optional command line parameter /B to run INSTALL in a black and white display mode: o Type A:INSTALL /B and press ENTER It may be necessary to use /B if you're using an LCD screen or a system that has a color graphics adapter with a monochrome or composite monitor. After you install Quattro Pro, to start the program: o Type Q and press ENTER. 2. How to contact Technical Support ----------------------------------- If you need help with Quattro Pro, please read this file and the manuals. If you still have a question and need assistance, help is available from the following sources: 1. Type GO BORAPP on the CompuServe bulletin board system for access to the BORLAND forums with their libraries of technical information and answers to common questions. 2. Check with your local software dealer or users' group. 3. Call the BORLAND Technical Support Department at (408) 438-5300. Please have the following information ready before calling: o Product name and serial number on your original distribution disk. Please have your serial number ready, or we will be unable to process your call. o Computer brand and model, and the brands and model numbers of any additional hardware. o Operating system and version number (you can determine the version number by typing VER at the DOS prompt). o Contents of your AUTOEXEC.BAT file. o Contents of your CONFIG.SYS file. 4. Write to: BORLAND INTERNATIONAL, INC. QUATTRO PRO Technical Support 1800 Green Hills Road P.O. Box 660001 Scotts Valley, CA 95067-0001 Please include the serial number of your software, or we will be unable to process your letter. 5. TechFax is a 24-hour automated service that sends free technical information to your fax machine. You can use your touch-tone phone to request up to three documents per call. Call (800) 822-4269. 6. For technical assistance outside the USA, check the product packaging for the name, address, and phone number of the distributor nearest you. 3. Upgrading from Quattro Pro 3 ------------------------------- To upgrade to Quattro Pro 4 from an earlier version of Quattro Pro, follow the instructions in Chapter 2 of "Getting Started." If you previously used BSINST to install additional Bitstream fonts, you must reinstall them after installing Quattro Pro 4. If you have the newer type of Bitstream fonts (.SPD files), you must use SPDINST to install them. If you previously installed BORLAND's ProShow ValuePack, you must re- install it after installing Quattro Pro 4. If you have any read-only files in the Quattro Pro directory, make them read-write before you run INSTALL. If INSTALL encounters any read-only files, installation can't be successfully completed. If you have custom menu trees from earlier versions, save them to a different directory before you run INSTALL. Copy them back to the Quattro Pro directory afterwards, then run NEWMU to translate them to version 4 menu files. This retains all previous menu structures. Upgrading network installations ------------------------------- When upgrading a network installation of Quattro Pro 3 to version 4, the menu and resource files stored in each user's private directory must be updated. These include any .MU, .MP, or .RF files. Replace the .RF files with the updated versions and create new .MP files using MPMAKE as described in the "User's Guide." 4. Bitstream fonts ------------------ Quattro Pro uses Bitstream's typefaces and enabling software, producing high-quality bitmap fonts. When you look closely at printed output from Quattro Pro, you may occasionally notice extra white space between characters. This is not a problem with your fonts. This extra white space is commonly reduced using a composition function called kerning. Quattro Pro 4 does not offer kerning. You can access Bitstream fonts in two places: /Style|FontTable|Edit Fonts|Typeface /Style|Fonts|Typeface 5. WYSIWYG mode --------------- There are new default spreadsheet colors in version 4. These colors appear in text display mode only, not in WYSIWYG mode. If you want to use the version 3 text-mode colors, choose /Options|Colors|Palettes|Version 3 Color. When using proportional fonts in WYSIWYG mode, the following commands may produce inappropriate results: /Style|Column Width; /Style|Block Size|Set Width, Reset Width, and Auto Width; /Tool|Reformat, and Parse. For best results, change to a text display mode before using these commands. 6. Problems using a mouse ------------------------- Display problems using Quattro Pro and Microsoft mouse driver version 7.04 disappear after CONFIG.SYS is changed to "device=mouse.sys /Y". If the mouse pointer doesn't appear on screen, you may need to update your mouse driver. See "Extended text display mode" in Chapter 1 of the "User's Guide." 7. Running under Windows ------------------------ If you want to run Quattro Pro in a small window (instead of full- screen), either delete the file EGASPL.PCX, rename it, or move it to another directory. Within Quattro Pro, set the display mode to one of the text modes. This way, Quattro Pro won't start up in graphics mode. 8. Sound files -------------- You may not be able to play sound files when running under Microsoft Windows in 386/Enhanced mode, or while running under Quarterdeck DESQView. When using the above configurations, save your spreadsheets before experimenting with sound files. See Chapter 13 of the "User's Guide" for instructions on using sound files. If you would like to order additional sound effects, see the coupon from RealSound that is included in your Quattro Pro package. 9. Slide transitions --------------------- Some video adapters don't support all slide transitions. If you find that one transition doesn't work with your video adapter, try another. 10. Using Expanded memory ------------------------- Quattro Pro can use up to 8MB of expanded memory. To test whether your EMS hardware and software are working correctly, run EMSTEST.COM from DOS and follow instructions on the screen. If errors are detected, contact your local hardware dealer. 11. Printing ------------ Font 1 (Normal font) controls both vertical and horizontal spacing. The vertical height of a row is calculated as follows: * A manual row-height setting overrules the default row height. * If the height of the row has not been manually set, the height is determined by either the largest font in that row or the height of Font 1, whichever is largest. If the selector is within an inserted graph block, /Print|Graph Print|Go will always print the inserted graph. To print a different graph, position the selector outside the inserted graph and use /Print|Graph Print|Name to select a different graph. In text mode, when printing to a Color PostScript printer, black shading is controlled by the foreground color of /Options| Color|Spreadsheet|Shading. For black shading, choose foreground color of black and background color of any other color. In WYSIWYG mode, when printing to a color or black & white PostScript printer, black shading may appear gray. Use /Options| Colors|Spreadsheet|WYSIWYG Colors|Shaded Cells to choose a color other than gray. 12. Links in a 1-2-3 version 2.2 file ------------------------------------- The maximum number of different spreadsheets that a Quattro Pro spreadsheet can link to is 62. If a 2.2 file has links to more than 62 files, Quattro Pro stops reading data after the 62nd link. Data beyond that point will not be loaded. To load a 2.2 spreadsheet with more than 62 links, convert the links into their values first, or relocate the important links into a link library and keep the links to 62 or less. 13. Importing a .WK1 file ------------------------- If the .WK1 file you're importing has Allways or WYSIWYG/Impress formatting, Quattro Pro asks if you want to import it. If you answer yes, the file is imported with a .WQ1 file extension. 14. Allways formatting ---------------------- Allways formatting is translated when importing a 1-2-3 version 2.2 file. 15. Cell references in a 1-2-3 version 3x file ---------------------------------------------- If a .WK3 file has multiple spreadsheets, 3-D cell references are translated with @@ . For example, the formula +D:A1*100 in BUDGETS.WK3 converts to @@("[BUDGETS.W0D]A1")*100. 16. Importing LICS and LMBCS ---------------------------- Choose /Options|International|LICS/LMBCS Conversion|Yes before importing a 1-2-3 file that contains international characters. 17. Sample .QLL file -------------------- Quattro Pro includes a file called SAMPLE.QLL, which contains several add-in @functions. You can load this file with the /Tools|Library|Load command. Once this file is loaded, the following additional @functions are available: ADD-IN @FUNCTION DESCRIPTION ================================================================ sinh(x) (exp(x) - exp(-x))/2 cosh(x) (exp(x) + exp(-x))/2 tanh(x) sinh(x)/cosh(x) hypot(x,y) sqrt(x^2+y^2) add_months(x,y) date obtained by adding y months to date x. It handles the end of the month and year as follows: 30-Nov-91 + 2 mon = 30-Jan-92 30-Nov-91 + 3 mon = 29-Feb-92 last_day(x) returns the last day of month of the serial date number x (the time of day is dropped from the serial number) Use the following syntax with these @functions: @LIBRARY.function (for example, @SAMPLE.sinh(x)). 18. Selecting blocks in macros ------------------------------ In macros, use {/ Macro;RetainBlock} to retain selected blocks as Quattro Pro 4 does; use {/ Macro;NoRetainBlock} to do block selection as Quattro Pro 3x did. Unless you use {/ Macro;RetainBlock}, blocks are retained like Quattro Pro 3x in macro execution. 19. Documentation corrections ----------------------------- Here are some minor corrections to the manuals: o The /Print|Layout|Percent Scaling command is now called % Scaling. o Step 3 on page 674 of the "User's Guide" should include: Type: SPDINST and press Enter o The correct menu-equivalent macro command for the Max Bubble Size option in the /Graph|Customize Series dialog box for bubble graphs in the "@Functions and Macros" manual (pages 201 and 226) is {/ Bubble;Size}. o There is a menu-equivalent macro command {/ Protection;Formstatus} to find the status of formula protection. 20. Solve For improvements -------------------------- Due to an improved solver engine, the Solve For command might give slightly different answers than in previous versions of Quattro Pro. Solve For is now more sensitive to the starting values supplied in nonlinear problems and might display the message "No feasible solution can be found." Solve For tries solving the problem, but first warns you that the result may not be optimal because of your starting variable value. Since the results are probably close, choose Go again, or use a different starting value and try again. 21. Optimizer tip ----------------- For best performance, we suggest you use Optimizer in text display mode. 22. Dual values in Optimizer ---------------------------- If dual values in the answer report are close to zero, choose Go again a few times to refine them. The solution will stay the same, but dual values will converge. 23. Who should use Overstrike Print ----------------------------------- /Options|International|Overstrike Print remaps accented characters according to the French ISO character set. It is intended primarily for French Canadian users of the U.S. English version of Quattro Pro. You might not get the expected overstrike characters on a U.S. 7-bit printer. 24. Printing from Audit ----------------------- When you choose /Tools|Audit|Destination|Print, the following print settings are used from the Print Layout dialog box: o Break Pages o % Scaling o Margins o Orientation (but Banner prints as Landscape) You might want to set Break Pages to No when printing Label References, Blank References, ERR, or External Link audits. 25. Pre-formatting cells ------------------------ If you pre-format a group of cells with a custom date format, then press Ctrl-D to enter a date, the custom format is overwritten with the default date format. Try entering all the dates first, then applying the custom date format. 26. Format code for a number in scientific notation --------------------------------------------------- To create format code for scientific notation, follow this example: Cell contents Format code Display as ------------- ----------- ---------- 123456 N0.00e+0 123e+5 27. Network users ----------------- Quattro Pro lets you log in to any NetWare file server you have rights to. However, you can't log in to the same server as two different users from one station. If you try, you see the message "Already logged in to server as a different user." If you're performing a network task within Quattro Pro, such as running a print-queue monitor, and the network goes down, you might need to reboot after exiting Quattro Pro. 28. How to customize an overriding graph type --------------------------------------------- To customize the overriding graph type series, set /Graph|Graph Type to the overriding type. In the dialog box, select the overriding series, then set the options you want. Finally, set Graph Type back to the overall type. For example, if the graph is a bar graph and the second series is set to Override Type|Line, choose /Graph|Graph Type|Line, then choose Customize Series. Choose 2nd Series, then change the options for a line. Choose Quit, then set Graph Type back to Bar. 29. The Borland Print Spooler ----------------------------- If you use DOS 5.0 when installing BPS.COM, don't use LOADHI BPS.COM. If you're printing to LPT3, LPT4, PRN, or EPT with background printing enabled, the device will be remapped to LPT1. If you load BPS.COM, then load a TSR program (such as a Novell NetWare driver), you should unload the TSR program before unloading BPS.COM to avoid problems. 30. Exporting to a Harvard Graphics file ---------------------------------------- Elements created with Quattro Pro's Annotator are lost if you export to a Harvard Graphics file. 31. Installing different character sets --------------------------------------- Contrary to the instructions in Appendix K of the User's Guide, you must reinstall Quattro Pro 4 to install a different character set. 32. Enhanced fonts ------------------ If you customize fonts in a Quattro Pro 4 file, the fonts will change if you load the file in an earlier version of Quattro Pro. 33. Clearing a custom style --------------------------- Clearing a custom style with /Style|Define Style|Erase returns General numeric format to the block.