Copyright: Copyright (c) Corel 1996.
Citation: Copyright (c) Corel 1996. All Rights Reserved.


Common Questions

Dates

How do I enter a date in Quattro Pro?

Import/Export

How do I export ASCII text files with Quattro Pro?

How do I copy a graph from Quattro Pro into WordPerfect for Windows?

Coaches

I am receiving the message, "Internal Error: Tutorial System will be unloaded." It occurs when I am running the Coaches. Why is this occurring?

Moving From DOS to Windows

I've been using Quattro Pro for DOS and have recently switched to Quattro Pro for Windows. Can I use the DOS menus to run Quattro Pro for Windows?

How can I execute my hot key macros created in Quattro Pro for DOS?

Printing

How do I set up another printer for Quattro Pro?

How do I select a noncontiguous print block?

I have a notebook that contains several pages. How do I print each page on a separate sheet of paper?

Why is Print To Fit not filling my entire page?

Can Quattro Pro print page numbers or dates on each page?

Selecting

When I try to select a block of cells, the arrow changes to a hand and moves my cells. Is there any way I can change this?

I have enabled Move Cell Selector On Enter Key (by choosing Property|Application|General in the Property Band) in order to have the cell selector move down automatically after pressing Enter. However, it is not working. Why?

I am attempting to select a block of cells, yet I do not see the area selected.

Setup

What is the ideal environment for running Quattro Pro?

I would like an Object Inspector instead of a QuickMenu to appear when I click the right mouse button. How can I change this?

I have deleted my QPW.INI file and have lost all my Workgroup Desktop information. Can I get this back without reconfiguring Quattro Pro?

Toolbars

How can I tell what Toolbar buttons do?

How do you load another Toolbar in Quattro Pro?


How do I enter a date in Quattro Pro?

Quattro Pro can parse a date that you type as long as you enter it in one of the legal date or time formats. For example, you can type 06/12 in a cell to represent the date June 12.

If you type a plus sign (+) before the date, Quattro Pro interprets the date as a formula. For example, +06/12 represents 6 divided by 12; 0.5 displays in the cell.

You can enter a date or time in one of the following formats:

DD-MMM-YY (04-Mar-94)

DD-MMM (04-Mar)--this assumes the current year if you change to a date format that displays the year.

MMM-YY (Mar-94)--this assumes first day of the month if you change this to a date format that displays the day.

The Long International date format--the current International property setting (in the application Object Inspector), ordinarily MM/DD/YY.

The Short International date format--the shortened version of the current International property setting, ordinarily MM/DD.

HH:MM:SS AM/PM (01:42:30 PM).

HH:MM AM/PM (01:42 PM).

The Long International time format--the current International property setting, ordinarily HH:MM:SS.

The Short International time format--the shortened version of the current International property setting, ordinarily HH:MM.


How do I export ASCII text files...
How do I export ASCII text files with Quattro Pro?

There are three ways to export an ASCII text file: saving to a text file, extracting to a file, and printing to a text file.

To export to a text file, select the page with the text to be exported and choose File|Save As and name the file with a TXT extension, for example, FILENAME.TXT. Using File|Save As creates a Tab delimited file.

Notebook|Extract allows you to save all, or part of the notebook to a separate file, leaving the original file intact. Choose Notebook|Extract. Type in the filename with a TXT extension. Specify the block that you want to extract. Choose OK. Notebook|Extract creates a Tab delimited file.

You can also print the spreadsheet to a file. The Slash key (/) must be activated in order to bring up the Quattro Pro / DOS menu. To activate the Slash Key (/), choose Property|Application|Macro in the Property Band. Change the Slash Key to Quattro Pro - DOS. From then on, the slash key (/) activates the Quattro Pro - DOS menu. To print to a file, choose: / , Print|Destination|Text|File. Enter the filename to create a file. Choose Block to select a print block, then choose Spreadsheet Print to print the spreadsheet to the named file. Printing the spreadsheet to a file creates an ASCII file with no delimiters.


How do I copy a graph...
How do I copy a graph from Quattro Pro into WordPerfect for Windows?

To copy a graph from Quattro Pro, move to the Objects page of the notebook by clicking the >| button in the lower left hand corner of the screen. The Objects page is the last page of the notebook; the icon for each graph that you have created is displayed here. Select the icon for the graph that you wish to copy to WordPerfect for Windows and choose Edit|Copy. A copy of the graph has now been copied to the clipboard. To bring the graph into WordPerfect for Windows, switch to WordPerfect and choose Edit|Paste.


I am receiving the message, "Internal Error"...
I am receiving the message, "Internal Error: Tutorial System will be unloaded." It occurs when I am running the Coaches. Why is this occurring?

This message will occur if the video driver is one with which Quattro Pro is not 100% compatible. As a test, from the Program Manager, open the Main group, select Windows Setup, and determine what the Display setting is. If it is not "VGA", select Options|Change System Settings, and change the display to "VGA" (you may need your Windows disks to make this change). Restart Windows to make this change effective and then try to run the Coaches from Quattro Pro again.

Updating to the latest version of video drivers may resolve this problem as well. Contact the manufacturer of the video card for more information on revisions of the video driver, how to obtain the latest version, and how to install it.


I have been using Quattro Pro for DOS...
I have been using Quattro Pro for DOS and have recently switched to Quattro Pro for Windows. Can I use the DOS menus to run Quattro Pro?

Yes. Choose Property|Application|Macro in the Property Band. Under Options there is an option called Slash Key with a down arrow to the right. Click the down arrow and choose Quattro Pro--DOS and choose OK until you are back to the notebook. Now when you press the slash key, the familiar Quattro Pro for DOS menus appear.

Note:	There are some functions of Quattro Pro for Windows that are not accessible from the Quattro Pro for DOS menus. In addition, any feature of Quattro Pro for DOS that is not a feature in Quattro Pro for Windows will be dimmed in the menus.


How can I execute my hot key macros...
How can I execute my hot key macros created in Quattro Pro for DOS?

Macros executed with Alt+key combinations in Quattro Pro for DOS can be executed with a Ctrl+key combination in Quattro Pro for Windows. This change allows the Alt keys to be used for Windows standard menu shortcuts.


How do I set up another printer for Quattro Pro?

Quattro Pro uses the Windows printer drivers. To add a printer driver for Quattro Pro, open the Windows Control Panel, open Printers, select Add, pick your printer model from the list, choose Install, then choose Close. It will then appear on the list of available printers for Quattro Pro to use.

To change the selected printer in Quattro Pro, choose File|Print, then click Select Printer.


How do I select a noncontiguous block?
How do I select a noncontiguous print block?

If the noncontiguous print block is on the same page, you may use your mouse to select the blocks. To select the blocks with the mouse, highlight the first block, hold down the Ctrl key, and continue highlighting the additional blocks. When all blocks are selected, choose File|Print and verify that Selection is chosen and the print block is correct. Choose Print.

If the noncontiguous block is on different pages, you can type the block reference in the Spreadsheet Print dialog box in the Block Selection edit field, or you can use the Point Mode button [image] to point to noncontiguous blocks on the notebook. Separate each noncontiguous block with a comma. Refer to the following syntax as an example.

This will print pages A, B, and F, and the blocks listed.

(A:A1..G10,B:A1..E30,F:B2...C10)

Note:	If you have named your pages, you can use those names in the block.

(January:A1..G10,February:A1..E30,June:B2..C10)

Tip:	You can also use Edit|Go To (or press F5) to pre-select a contiguous block on different pages.


I have a notebook that contains several pages...
I have a notebook that contains several pages. How do I print each page on a separate sheet of paper?

If you chose File|Print and selected Block Selection for Print Area and specified a 3-D block, click Sheet Options in the Spreadsheet Print dialog box and select Page Advance under Print Between 3D pages.

If you chose File|Print and selected Notebook for Print Area, click Sheet Options in the Spreadsheet Print dialog box and select Page Advance under Print Between Blocks.


Why is Print To Fit not filling my entire page?

To use the Print To Fit option, choose File|Page Setup|Print Scaling, and check Print To Fit.

The purpose of the Print To Fit option is to get your print block onto one page, not to fill the page. Quattro Pro determines the scaling factor for Print To Fit by examining the entire print block before deciding upon a scaling factor. This scaling factor is calculated to bring the entire document onto one page while maintaining the integrity of the font. The printout is scaled both vertically and horizontally. Because of this, Print To Fit cannot stop at the edges of the page. Quattro Pro tries incrementally smaller point sizes, checking to see if all the data fits. If the data does not fit, it tries a smaller point size. Quattro Pro stops trying to scale the printout after it reaches 1 point.

Blank columns and rows that have been selected are included in the print block. If the print block includes blank rows or columns, the printout is reduced to a smaller point size than needed, resulting in extra empty space on the printed page.

An alternative to Print To Fit is the Scaling option. Choose File|Page Setup|Print Scaling and enter a value for Scaling. You can manually scale down the document to make better use of the white space on the page.

Note:	The Print To Fit and Scaling options should never be used in combination; use one or the other, but not both.

You can also apply the Center Across Block property (or choose Align|Center Across Block in the Property Band) or change print margins (File|Page Setup|Print Margins) to better control how the document is placed on the page.


Can Quattro Pro print page numbers...
Can Quattro Pro print page numbers or dates on each page?

Yes. Below is a list of special codes you can place in headers and footers within Quattro Pro:

Code	Description

#	(number sign) Enters the current page number.

@	Enters the current date (per your computer's calendar).

|	Causes text immediately to the right to be centered on the page.

| |	Causes text immediately to the right to be right aligned on the page.

#d	Enters the current date in Short International format (04/28)

#D	Enters the current date in Long International format (04/28/94)

#ds	Enters the current date in Standard Short Date format (28-Apr)

#Ds	Enters the current date in Standard Long Date format (28-Apr-94)

#t	Enters the current time in Short International format (HH:MM)

#T	Enters the current time in Long Interantional format (HH:MM:SS)

#ts	Enters the current time in Standard Short Time format (HH:MM AM/PM)

#Ts	Enters the current time in Standard Long Time format (HH:MM:SS AM/PM)

#p	Enters the current page number

#p+n	Enters the current page number plus the number "n"

#P	Enters the total number of pages in the prinout.

#P+n	Enters the total number of pages in the printout plus the number "n"

#f	Enters the name of the notebook printing with no path (SAMPLE.WB1)

#F	Enters the name of the notebook printing including the path (C:\QPW\SAMPLE.WB1)

#n	Prints the remainder of the header or footer on a second line


When I try to select a block of cells...
When I try to select a block of cells, the arrow changes to a hand and moves my cells. Is there anyway I can change this?

If you select one cell for too long, Drag and Drop is enabled, letting you drag individual cells or blocks from one part of the notebook to another. To avoid Drag and Drop behavior, select the cell for a shorter period, or lengthen the delay time for cell Drag and Drop. To do this, choose Property|Application|General in the Property Band and increase the value for Cell Drag And Drop Delay Time from 500ms to 1000ms. Continue to increase the delay time if neccessary.


I have enabled Move Cell Selector On Enter Key...
I have enabled Move Cell Selector On Enter Key (by choosing Property|Application|General in the Property Band) in order to have the cell selector move down automatically after pressing Enter. However, it is not working. Why?

Choose Property|Application|General in the Property Band. Make sure Compatible Keys is unchecked; otherwise, Move Cell Selector On Enter Key is automatically disabled.


I am attempting to select a block of cells...
I am attempting to select a block of cells, yet I do not see the area selected.

This happens if the video driver is one with which Quattro Pro is not 100% compatible. As a test, from the Program Manager, open the Main group, select Windows Setup, and determine what the Display setting is. If it is not "VGA", select Options|Change System Settings, and change the display to "VGA" (you may need your Windows disks to make this change). Restart Windows to make this change effective and then try to run the Coaches from Quattro Pro again.

Updating to the latest version of video drivers may resolve this problem. Contact the manufacturer of the video card for more information on revisions of the video driver, how to obtain the latest version, and how to install it.


What is the ideal environment for running Quattro Pro?

A 386/486 PC with 8Mb (or more) of RAM, Windows 3.1, and at least 40MB of free disk space are preferred. If the hard disk is compressed, the best environment would have at least 70Mb of reported free disk space before installing.


I would like an Object Inspector instead of a QuickMenu...
I would like an Object Inspector instead of a QuickMenu to appear when I click the right mouse button. How can I change this?

QuickMenus can be quite convenient. To get to the Object Inspector quickly, hold down the right mouse button and drag slightly to the right before releasing the button. If you still prefer to go directly to the Object Inspector when you click the right mouse button, add the following to the [Quattro Pro for Windows 6.0] section of the QPW.INI file:

RightMouseInspect = 1

Caution: This setting will disable Coaches.


I have deleted my QPW.INI file...
I have deleted my QPW.INI file and have lost all my Workgroup Desktop information. Can I get this back without reconfiguring Quattro Pro?

Rename the QPW.INI file to QPW.BAK. Rename the file QPW.QPW to QPW.INI. QPW.QPW is a backup file created automatically by the Quattro Pro installation program.


How can I tell what Toolbar buttons do?

When you point to a Toolbar button with the mouse, a brief description of the button appears in the Quattro Pro title bar. For further help about Toolbar buttons, use Quattro Pro's Object Help. Place your mouse on a Toolbar button, hold down the Ctrl key, and press the right mouse button. Quattro Pro displays a window with a description of the button in question. To clear Object Help, click anywhere except the help button in the window.


How do you load another Toolbar...
How do you load another Toolbar in Quattro Pro?

Click on Toolbar in the Property Band and choose Append Toolbar. Change to the directory containing any user-defined Toolbars, choose the specific Toolbar file, and choose OK. To use the same collection of Toolbars the next time you use Quattro Pro, turn on the Save Toolbars On Exit option by choosing Property|Application|General in the Property Band.