Reference: Managing files and data
Quattro Pro provides extensive file-handling options and a large range of supported file formats. Many graphics formats can be imported into Quattro Pro projects and exported from Quattro Pro into other applications.
File-handling options |  |
Folders
When you first open the Open file dialog box, it displays files in the startup folder. The startup folder is the folder from which you initially start Quattro Pro, but you can change it.
If you save or load a file in a folder other than the startup folder, this last-used folder becomes the default folder. Then the next time you save or load a file, the default folder initially displays in the dialog box. The last-used folder is always the default folder displayed until you restart Quattro Pro, when the startup folder again displays.
Wildcards
You can use the wildcard characters asterisk (*) and question mark (?) in any part of the Filename box to limit the files displayed. An asterisk represents any number of characters in its position; a question mark represents any single character in its position. For instance, *.prn lists all files with the filename extension .prn, and budget?.qpw lists all notebooks that begin with budget followed by one character before the .qpw extension.
The following examples show how different wildcard characters work in notebook links:
|
•
|
|
[] — links to the active notebook
|
|
•
|
|
[*] — links to all open notebooks
|
|
•
|
|
[AB*] — links to all open notebooks whose names begin with AB
|
|
•
|
|
[A*B] — links to all open notebooks whose names begin with A and end with B
|
|
•
|
|
[A?B] — links to all open notebooks with three-character names that begin with A and end with B
|
|
•
|
|
[AB???] — links to all open notebooks with five-character names that begin with AB
|
@SUM([*]A:A1) — adds the values in cell A1 in sheet A of all open notebooks (except the active one), and places the result in the active cell
@AVG([*]BUDGET:B3..C10) — finds the average of all values in cells B3..C10 in the sheet named BUDGET of each open notebook
@SUM([*]TOTALS) — sums the values of all cells in the selection TOTALS in any open notebooks containing TOTALS. These selections need not be the same size or in the same relative positions.
Read-only files
If you are working on a network and the file you are trying to open or retrieve has already been opened by another user, you will view a read-only prompt. You can choose to open the file with read-only rights (where you can save it under a different name) or cancel the operation.
Alternate file-handling dialog boxes
If you are using a document managing system that is compliant with the Open Document Management API (ODMA) standard, you will see alternate file-handling dialog boxes in the following Quattro Pro areas: File 
Open, File Close, File Save as, File Send to, and Insert External data Import database file.
Supported file formats | |
You can use spreadsheet files from a variety of applications with Quattro Pro. A list of supported file formats identifies the Quattro Pro filters available to convert files created in other applications. You can also save a Quattro Pro file in most of the formats listed.
To see a list of supported file formats, click File Save as, and scroll through the listed file types in the File type list. If you can’t find the format you need and you are saving the document for use in another application, consult the application’s documentation for suggested compatible file formats.
File formats marked with an asterisk (*) can be opened only, not saved.
Corel Quattro Pro for MS-DOS | |
You can display Corel Quattro Pro for MS-DOS menus within Quattro Pro. You can also open files and play macros originally created in Corel Quattro Pro for MS-DOS. Quattro Pro supports all Corel Quattro Pro for MS-DOS functions and most features. However, once you change a MS-DOS notebook in Quattro Pro, you should save it as a .qpw file to avoid losing new features and @functions not available in the MS-DOS program.
Enabling the Corel Quattro Pro for MS-DOS menu
There are some Quattro Pro commands that are not accessible from the Corel Quattro Pro for MS-DOS menus. Any features of Corel Quattro Pro for MS-DOS that are not available will display grayed in the menus.
To enable the Corel Quattro Pro for MS-DOS menu, click Tools Settings, click the Macro tab, and enable the Slash key compatibility check box. Then, to display this menu, press the forward slash (/).
Using the Corel Quattro Pro for MS-DOS editing keys
You can use Corel Quattro Pro for MS-DOS editing keys in later versions of Quattro Pro. When the Compatibility keys check box is enabled, a variety of keys work the same way as in Corel Quattro Pro for MS-DOS. When the check box is disabled, these keys work as they would in most Windows applications. For example, pressing Tab moves the cursor five spaces to the right when the Compatibility keys check box is enabled. When it is disabled, pressing Tab moves the cursor to the next word.
To use Corel Quattro Pro for MS-DOS editing keys, click Tools Settings, then select the General tab, and enable the Compatibility keys check box.
Running a Quattro Pro for MS-DOS macro
You can run Corel Quattro Pro for MS-DOS keystroke macros in Quattro Pro. Macros using Corel Quattro Pro for MS-DOS menu equivalents are still compatible.
To run a Corel Quattro Pro for MS-DOS macro, press the forward slash (/), and click Tools
/quattro-pro.helpmax.net/wp-content/uploads/sub/quattro-pro/en/source/images/onestep.jpg" height="14" width="9" border="0" hspace="0" vspace="0" align="absmiddle"> Macro
Execute. To ensure that the macro will not skip to the wrong cell, click Tools Settings, select the General tab, and disable the Move cell selector/enter key check box.
|
•
|
|
If you are working in Corel Quattro Pro for MS-DOS, you can open .sqz files by saving them as .wq1 files first.
|
|
•
|
|
Macros assigned to Alt keys in the MS-DOS version of Quattro Pro run in the Windows version using Ctrl + Shift. This change allows the Alt keys to be used for Windows standard menu shortcuts.
|
Graphic formats for importing | |
You can import graphics files in any of the following file formats; however, you should install the required filters when you install the application.
Graphic formats for exporting | |
You can export graphics files to any of the following file formats. If you are exporting a chart to send to a 35mm slide bureau, be sure to set the chart’s aspect ratio to 35mm Slide. For more information, see “To change the aspect ratio of a map.”
Rules for combining files | |
When you combine files with math operations, keep the following in mind:
|
•
|
|
Save the destination notebook, so that you can close and reopen it if you do not get the results you want from combining files.
|
|
•
|
|
If you are combining only part of a file with the active notebook, find out the cell name or coordinates you will be copying.
|
|
•
|
|
In the active notebook, cells that contain labels, formulas, ERR, or NA are not altered by the incoming data.
|
|
•
|
|
Value entries in the destination cells of the receiving notebook are replaced by the results of the mathematical operation you choose to perform with the original and incoming values.
|
|
•
|
|
Named cells are converted to cell coordinates when they are copied, to avoid confusion with names in the open notebook.
|
|
•
|
|
Column widths in the destination notebook can be adjusted to correspond to incoming source data.
|
Troubleshooting with OLE | |
When you click an object and receive the message “Can’t Turn Into An OLE Object,” there are several possible reasons:
|
•
|
|
The object is not an OLE object and has no source file. This means you can use the object in the document, but you cannot edit it.
|
|
•
|
|
The application necessary to edit the object is not available. For example, if the object is linked to Presentations, Presentations must be installed.
|
If the OLE object doesn’t open when you double-click it, consider the following:
|
•
|
|
The source application may have an open dialog box. Switch to the source application, and close the dialog box. Double-click the object again in Quattro Pro.
|
|
•
|
|
You may not have copied the object as an OLE object.
|
|
•
|
|
Your system may not have enough resources to open the application. Close unnecessary applications or windows, and double-click the object again.
|