File management is an important part of any project. You can open many different file formats in Quattro Pro, and you can import, insert, or combine data. You can also link data between notebooks or between Quattro Pro and another application.
In this section, you'll learn about
opening and saving files
sending files
inserting, importing, and combining files
importing text into columns
linking and embedding objects
editing and updating objects and links
creating notebook links
editing and updating notebook links
For more information about managing files and data, see "Reference: Managing files and data."
Opening and saving files
Using Quattro Pro, you can open files from other applications. For example, if you use Microsoft Excel or Lotus 1-2-3, you can open these files in Quattro Pro. You can also open files from the Internet.
Quattro Pro can open a Quicken Interchange Format (.qif) file.
You can save Quattro Pro data as database files, in dBASE or Paradox file format. The field names are based on the data in the first row of the first sheet. If the first row contains data that is invalid as a database field name, for example, containing numbers, spaces, symbol characters, or duplicate labels, Quattro Pro uses the spreadsheet column letters to represent the field names. You can save Quattro Pro files in other formats as well.
For additional information, see "Supported file formats" and "File-handling options."
To open a file from another application
1 Click File Open.
2 Choose the drive and folder where the file is stored.
3 Choose the filename extension from the File type list box.
4 Double-click the filename.
Notes
If the drive you require is not displayed in the Look in list box, you may have to map the drive. If the drive will not map to the path you specify, you may not have access to that location.
If you are using Quattro Pro for MS-DOS, you can open .sqz files by saving them as .wq1 files first.
To open a file from the Internet
1 Click File Open.
2 Type a URL in the Filename box.
3 Click Open.
Note
Quattro Pro makes a local copy of the file; you do not have to be continuously connected to the Internet to work with the file.
To open a Quicken Interchange Format (.qif) file
1 Click File Open.
2 Choose the drive and folder where the file is stored.
3 Choose Quicken Interchange Format (.qif) from the File type list box.
4 Double-click the filename.
Notes
When you open a .qif file in Quattro Pro, each spreadsheet row contains a single transaction record with the date, check number, payee, memo, cleared status, and amount columns. In addition, the assigned categories are broken down into columns. You can sum the category amounts for each column, create custom reports and charts, or use the transaction data within Quattro Pro as actual data.
When opening split transactions (multiple categories assigned to a single transaction), Quattro Pro places the correct amount in each category column. If a split transaction is composed of only a single category but has multiple descriptions, the category column contains a formula that includes all of the individual amounts.
Tip
When you save the opened .qif file, you must save it as a Quattro Pro file. You can save it in a different file format, but some formatting may be lost.
To save a database file
1 Click File Save as.
2 Choose one of the following from the File type list box:
dBASE
Paradox
3 Type the filename in the Filename box.
4 Click Save.
5 Choose a field from the Fields list, and make any changes to the field name or field type.
6 Click Write.
Notes
If you have used unique Quattro Pro features, a message may display stating that you are saving in a file format other than Quattro Pro. Click the database format to continue saving the database file.
To mark a field to be deleted, click it in the list, and press Delete. An asterisk displays next to the field name. To restore the field, press Delete again.
To save a Quattro Pro file in another format
1 Click File Save as.
2 Choose a file type from the File type list box.
3 Type a filename in the Filename list box.
4 Click Save.
Sending files
You can send notebooks to new locations. You can also send notebooks by email. If you have an email application installed on your computer or network, you can access it from within Quattro Pro.
To send a notebook to another location
1 Click File Send to.
2 Click the location where you want the file sent.
Note
To add destinations to the Send to submenu, see Windows Help.
To send a notebook by email
1 Click File Send to Send mail.
2 Set email options according to your system.
3 Send the email.
Inserting, importing, and combining files
Quattro Pro lets you insert a file into a notebook.
You can also import both delimited and fixed-width text files. When you import text, you can specify how the text should be arranged on the spreadsheet. Arranging data into columns and rows is called parsing. For example, you can parse a column of long labels into two or more columns of data.
When you open a text file that includes tabs indicating new segments of data, Quattro Pro starts a new column each time it encounters a tab in the text.
Every sheet in the inserted or imported file that contains data is placed on a new sheet in the active notebook. If only one sheet is inserted, the sheet is given the name of the inserted file. If multiple sheets are inserted, the new sheets are named in the default letter sequence.
You can save notebooks as tab- or comma-delimited text files. You can also import unformatted text.
You can combine files by adding, subtracting, multiplying, or dividing the cells of two notebooks. You can also combine files by using math operators. Adding data is useful for combining files for a cumulative total. For example, you could compile year-to-date figures from monthly notebooks to create a cumulative notebook showing year-to-date expense totals.
For additional information, see "Rules for combining files."
To insert a file into a notebook
1 Close the file you want to insert.
2 Click Insert Insert file.
3 Choose a filename.
If you want to insert a file from another application, include its filename extension.
4 Type the cell location before which you want to place the inserted file in the Before sheet box.
Notes
If the file is inserted within the boundaries of a named selection of cells, or cells referenced by a formula, references expand to include the new spreadsheets.
If inserting a file expands a named selection of cells or cell reference beyond the limit of a notebook (beyond spreadsheet ZZZ), the reference becomes ERR.
To import a text file
1 Click File Open.
2 Choose the drive and folder where the file is stored.
3 Choose ASCII Text (*.txt) from the File type list box.
4 Double-click the filename.
5 From the Parse settings list box, choose one of the following:
Automatic-automatically determines how best to parse the imported text file
Delimited auto-automatically parses imported delimited text files
Fixed width auto-automatically parses imported fixed-width text files
Notes
Lines larger than 4 KB are not imported. If the total number of lines (rows) you import exceeds the limit of the number of rows you specified for a spreadsheet, the data is truncated to this limit.
Files must be unformatted and saved as plain ASCII text files without any control codes or other word-processor formatting. Before you open a text file, remove any special formatting characters such as bold, underlining, or centering.
To save a text file
1 Select a cell on the relevant sheet.
2 Click File Save as.
3 Type the filename with the extension .txt in the Filename box.
4 Choose ASCII Text (tab delimited or comma delimited) from the File type list box.
Note
Only the contents of the current sheet (or, if it is empty, the first non-empty sheet) of a notebook are saved.
To import unformatted text
1 In the source application, select the data to paste into Quattro Pro.
2 Click Edit Copy.
3 In Quattro Pro, click Edit Paste special.
4 Choose Unformatted text from the As box.
5 Enable the Paste option.
To combine files by using math operations
1 Click File Open.
2 Choose the drive and folder where the destination notebook is stored.
3 Double-click the filename.
This notebook contains the existing values; data in this notebook will be altered.
4 Click Tools Data tools Combine files.
5 Click Browse and select the source notebook.
This notebook contains the incoming values; no changes are made to this notebook.
6 In the Source area, enable one of the following options:
Entire file-combines all data in the two files
Cell(s)-combines only data in the cells which you specify
7 In the Operation area, enable one of the following options:
Copy-inserts the exact contents of the source notebook
Add-adds the incoming values to the existing values
Subtract-subtracts the incoming values from the existing values
Multiply-multiplies the incoming values by the existing values
Divide-divides the existing values by the incoming values
Note
For additional information, see "Rules for combining files."
Tip
You can also combine files by copying the data from the source notebook and pasting it over the corresponding data in the destination notebook with the Paste special command.
Importing text into columns
You can import a text file and rearrange the text into columns at the same time. You can adjust the widths of imported columns and specify a parsing format for imported text.
You can customize how delimited and fixed-width text files are parsed. You can also add a fixed-width parse break to imported text.
To import a text file into columns
1 Click Tools Data tools QuickColumns.
2 Click the Browse button in the Text source box, and choose the text file.
3 Click the Range picker in the Text source box and select the source cells.
4 Click the Range picker in the Destination box and select a location for the imported data.
5 From the Parse settings list box, choose one of the following:
Automatic-automatically determines how best to parse the imported text file
Delimited auto-automatically parses imported delimited text files
Fixed width auto-automatically parses imported fixed-width text files
If you want to view how data displays in the spreadsheet, click Format.
Note
The QuickColumn Expert parses one column at a time.
Tips
The Destination box displays the active cell in the spreadsheet. Instead of specifying all the destination cells, you can specify one cell in which to begin inserting the parsed cells.
You can load previously saved parse settings by pressing the Browse button beside the Parse settings list box, and locating the .qpx file you want to load.
To adjust the column width for imported text
1 Click Tools Data tools QuickColumns.
2 Click Format.
3 In the column heading, point to the border until it changes to a double arrow.
4 Drag the border until the column reaches the required width.
Note
When you adjust columns that contain fixed-width text, the adjustment may change where the data is placed in the destination cells. When you adjust columns that contain delimited text, the adjustment resizes the entire column and does not affect where the data is placed.
To specify a parsing format for imported text
1 Click Tools Data tools QuickColumns.
2 Click Format.
3 In the Format area, select a row or column.
4 Choose a parsing action from the Action list box:
Skip-skips a row or column
Parse-parses a row or column
Label-copies a row as an unparsed label to the destination cells
You can also
Insert a row, column, or sheet into a parsed text file Click Break data flow control, and enable a break option.
Merge parsed cells Click Merge data control.
Switch a column to a row Select a column, and click Transpose data control.
Switch a row to a column Select a row, and click Transpose data control.
Specify delimiters as text Select a row, and click Delimiter to text.
Restore format options Click Revert text.
Set the style for a column Select a column, and choose a style from the Style list box.
Set the alignment for a column Select a column, and choose an alignment from the Alignment list box.
Set the delimiter for a column Right-click a column. In the Column delimiters dialog box, enable any column delimiter check box.
To customize parse settings for delimited text files
1 Click Tools Data tools QuickColumns.
2 Click the Browse button in the Text source box, and choose the text file.
3 Click the Range picker in the Text source box and select the source cells.
4 Click the Range picker in the Destination box and select a location for the imported data.
5 Choose Delimited auto from the Parse settings list box.
6 Click Settings.
7 In the General area of the Parse settings dialog box, enable any of the following options:
Apply formatting to spreadsheet-automatically applies the existing spreadsheet formatting to the imported text
Set spreadsheet column widths-automatically applies the existing spreadsheet column width to the imported text
Set page length to-lets you label or skip certain rows without parsing
If you enable the Set page length to check box, choose an action from the Action list box, and type a value in the Lines box.
8 Enable check boxes to establish delimiters (data breaks) in each of the following areas:
End of cell-establishes the selected character or characters as the start of a new cell within a row
End of row-establishes the selected character or characters as the start of a new row
End of sheet-establishes the selected character or characters as the start of a new spreadsheet
If you want to save your parse settings for future use, click Save and type a filename with a .qpx extension.
Tip
If you want data enclosed in a specific text qualifier to be parsed as a label, enable the Text qualifier check box in the Data type area, and type a text qualifier in the Text qualifier box.
To customize parse settings for fixed-width text files
1 Click Tools Data tools QuickColumns.
2 Click the Browse button in the Text source box, and choose the text file.
3 Click the Range picker in the Text source box, and select the source cells.
4 Click the Range picker in the Destination box, and select a location for the imported data.
5 Choose Fixed width auto from the Parse settings list box.
6 Click Settings.
7 In the Data type area, enable any of the following check boxes:
Skip first character-skips the first character in each line of text
Ignore nonconforming rows-skips lines in the text that the QuickColumns Expert cannot parse
Join broken lines at ## characters-unwraps lines before parsing. For example, if the text was generated by an application that wrapped text lines that exceeded 80 characters, enable this check box and type 80 in the Characters box.
To add a fixed-width parse break
1 Click Tools Data tools QuickColumns.
2 Click Format.
3 Click Set parse breaks.
4 In the Set parse breaks dialog box, type a value in the Parse break position box.
5 Click Set.
You can also
Repeat parse breaks at regular intervals Enable the Repeat every check box, and type a value in the Characters box.
Delete a parse break Use the Navigate parse break buttons to select a parse break, and click Clear.
Quattro Pro lets you use Object Linking and Embedding (OLE) to import and export projects and objects. Object linking and embedding works through two client-server protocols: OLE and Dynamic Data Exchange (DDE). DDE allows two applications running simultaneously to interact.
This version of Quattro Pro supports OLE 2.0 as a container (client) and server. Quattro Pro also acts as a client and server for OLE 1.0 and DDE. Several Quattro Pro macros can help application developers initiate and conduct DDE exchanges or "conversations." Application developers can use Quattro Pro macro commands and other features to create and control OLE objects in other applications that support OLE automation as a client.
In Quattro Pro, you can link to an object in another application. For example, you can create a link to a graphic in CorelDRAW, a bitmap in Corel PHOTO-PAINT, a memo in WordPerfect, or a slide in Corel Presentations.
When you link a file, the information resides in the source file, and a linked copy of the source file exists in the notebook. When information changes in the source application, it is automatically updated in the notebook. You may want to link to a file for a large object such as a bitmap, especially when it is used several places in a notebook, to keep the notebook file size at a minimum. Linking large objects makes the file size smaller because the object is stored in the source file, not in the file.
You can embed objects. When you embed an object, a copy of the object is inserted into the notebook. The copy remains separate from the original object. Objects in Quattro Pro can also be copied to other applications.
OLE objects can be resized to fit the constraints of a notebook. For additional information, see "Troubleshooting with OLE."
To link an object
1 Select the cell where you want to link an object.
2 Click Insert Object.
3 Enable the Create from file option.
4 Click Browse.
5 Choose the drive and folder where the object is stored.
6 Double-click the filename.
7 Enable the Link check box.
If you want to display the object as an icon, enable the Display as icon check box.
You can also
Link an object from Windows Explorer Drag the object filename from Windows Explorer into the document.
Link an object to another application In Quattro Pro, select the object. Hold down Ctrl, and drag it into the application window.
To embed an object
1 Select the cell where you want to embed an object.
2 Click Insert Object.
3 Enable the Create from file option.
4 Click Browse.
5 Choose the drive and folder where the object is stored.
6 Double-click the filename.
If you want to display the object as an icon, enable the Display as icon check box.
Note
If you enable the Create new option, a new blank object displays. If the source application supports in-place editing, the object is activated for in-place editing; otherwise, a new window opens and the source application runs in the new window. Use the source application's editing commands and tools to create and manipulate data.
Tip
You can also embed an object in another application by dragging. Select an object in Quattro Pro. Hold down Shift, and drag the object to the application window.
To copy an object to another application
1 Select an object in Quattro Pro.
2 Click Edit Copy.
3 Open the destination application.
4 In the destination application, select the Paste special option, and choose a Quattro Pro format.
To resize an OLE object
1 Right-click an OLE object, and click Properties.
2 Click the OLE tab.
3 Disable the Automatic resizing check box.
4 Drag the borders of the OLE object to the required size.
Editing and updating objects and links
Any objects you link or embed can be edited. When you edit a linked object, any changes you make to the object are also made to the object in the source file. When you edit an embedded object, you can edit it in the destination application, or you can open the source application, edit the object, and update the object to insert the changes in the destination application.
You can update linked objects manually or have Quattro Pro automatically update links to reflect any changes made in the source file.
You can edit Dynamic Data Exchange (DDE) links. DDE is a communication system used by Windows, OS/2, and Mac OS operating systems to allow two applications running simultaneously to interact.
You can change the source of a linked OLE object. Most objects are inserted as OLE links. For example, if a linked file is moved to a different folder, you can relink to the file in its new location.
A linked or embedded object can be converted to a different format.
Some objects, when activated, can display in more than one source application for editing. If more than one activation choice is available for the object, you can change its activation effect.
You can display an object as an icon. In this format, the object takes up very little space until you need to view or edit it.
To edit a linked or embedded OLE object
1 Right-click a linked or embedded OLE object, and click Object Edit.
2 Edit the object.
3 Click outside the object box.
Tip
You can also double-click most objects to edit them. However, when you double-click a sound or video clip, the clip plays.
To update a linked OLE object
1 Select a linked OLE object.
2 Click Edit OLE links.
3 Click Update now.
If you want to update the linked object automatically, enable the Automatic option.
To edit a DDE link
1 Open two linked applications.
2 Edit the source file.
The changes are updated in your linked notebook.
Note
The type of link you create depends on the types of links the source application supports and which format you select in Paste special. When you click a format, text below the format name describes how each format will display in your document.
Tips
To update DDE links, open the linked object's source and destination files in their respective applications. When you open a file that contains DDE links, and all supporting DDE server applications are not open, a dialog displays prompting you to open the corresponding application.
If you want to change the source of a linked DDE object you have to change the Link name, Application, Topic/Filename, and Item of the object.
To change the source of a linked OLE object
1 Select a linked OLE object.
2 Click Edit OLE links.
3 Click Change source.
4 Choose the drive and folder where the file is stored.
5 Double-click the filename.
To convert an OLE object format
1 Right-click an OLE object, and click Object Convert.
2 Enable the Convert to option.
3 Choose a format from the Object type list.
Note
When you convert an object format, the object is permanently converted to the selected format.
To change an OLE object's activation effect
1 Right-click an OLE object, and click Object Convert.
2 Enable the Activate as option.
3 Choose a format from the Object type list.
To display an OLE object as an icon
1 Right-click an OLE object, and click Object Convert.
2 Enable the Display as icon check box.
Tip
You can change the icon that displays by clicking Change icon.
Creating notebook links
You can insert links into Quattro Pro notebooks. There are several advantages to setting up notebook links instead of using multisheet notebooks. You can eliminate redundancy, ensure data is always up to date, save disk space, divide tasks among several people, and build larger models that exceed the limits of a single notebook.
You can link notebooks by selecting cells in the source notebook (when both notebooks are open). When you are consolidating information from several files that have the same layout, you can use wildcards to link to the same place in all of them. You can also link cells.
Links between Quattro Pro and other applications can be created. For example, you can write a memo in WordPerfect and link a cell in Quattro Pro to it.
You can create hyperlinks in a notebook to jump to another file or an Internet site.
To insert a notebook link
1 Select a cell in which you want to place a link.
2 Type a plus sign (+), and type the link address as [Drive:\Path\Filename.Extension]Sheet:Cell reference, where:
Drive-is the drive containing the notebook. This is necessary only if the notebook you are linking is not on the same drive as the primary notebook.
Path-is the path to the folder containing the notebook. This is necessary only when the notebook is not in the same folder as the primary notebook.
Filename-is the name of the notebook
Extension-is a three-letter suffix separated from the filename by a period (.). It is necessary only when the notebook has a different extension from the primary notebook.
Sheet-is any valid sheet name, sheet range, or group name (such as C, Sales, D..F, or YearToDate)
Cell reference-is any valid cell address, pair of coordinates, or cell name. However, cell coordinates are valid only when the link contains a spreadsheet function to operate on the cells.
Note
Because link statements are not case-sensitive, you can type all parts of the link in either uppercase or lowercase. Do not include blank spaces in any part of the reference.
To link notebooks by selecting cells
1 Click File Open.
2 Choose the drive and folder where the notebook is stored.
3 Double-click the filename.
4 Select a cell.
5 Type a plus sign (+) in the cell.
6 On the application bar, click the name of the supporting file.
7 Click the cell that contains the link you want to place in the primary notebook.
If the formula is incomplete, finish typing it.
8 Press Enter.
Tip
You can also activate the target notebook by clicking Window and choosing the window from the numbered list at the bottom of the menu.
To link notebooks by using wildcards
1 Click File Open.
2 Open the primary notebook and any relevant supporting files.
3 Type a wildcard character in place of the filenames in the link.
Notes
When you finish entering the link, the formula is revised to include specific filenames. This means that if you open new files after using a wildcard in a link, they are not referenced in the formula.
You can use the wildcards question mark (?) and asterisk (*) in links. A question mark (?) represents any single character, and an asterisk (*) represents any number of characters. For additional information, see "File-handling options."
To link cells
1 In the source notebook, select the cells you want to link.
2 Click Edit Copy.
3 In the destination notebook, select the upper-left cell of the destination cells for the links.
4 Click Edit Paste special.
5 Click Link.
Note
Each copied cell contains a formula beginning with a plus sign (+) followed by the filename in parentheses (if different from the active notebook), the sheet name and a colon (if different from the active sheet), and the cell address.
To link data between applications
1 In the source application, select the data you want to link to from Quattro Pro.
2 Click Edit Copy.
3 In Quattro Pro, click the cell where you want to place the linked data.
4 Click Edit Paste special.
5 Enable the Paste link option.
6 Choose a file format from the As box.
Notes
You can link contiguous and noncontiguous selections.
Each copied cell contains a formula beginning with a plus sign (+) followed by the filename in parentheses (if different from the active notebook), the sheet name and a colon (if different from the active sheet), and the cell address.
To insert a hyperlink
1 Select a cell on the active spreadsheet.
2 Click Tools Hyperlink.
3 Type a text description of the link in the Text to link box.
4 Type a link source in one of the following boxes:
Link to file or URL-allows you to link to a file or URL
Specific location-allows you to link to a cell address in the same notebook
Note
You can also create a Web link to a specific Web site, such as one that provides a stock quote. For more information, see "Working with Web links."
Tips
If you want Quattro Pro to use a relative path to the file you've linked to, enable the Use relative path check box. If you move a file that contains a hyperlink, ensure that you also move any linked files as necessary to maintain the hierarchy.
You can also use UNC paths in your relative addressing as long as the network path you are using has previously been mapped. For example, if you map network drive \\documents\spreadsheets to drive F: on your computer, then the hyperlink \\documents\spreadsheets\financials.qpw could be used to access the file financials.qpw.
Editing and updating notebook links
You can open files linked to the active notebook, and you can update links to unopened files so that they reflect any changed information. Updating links is useful when you are working on a network; while you are using one notebook, others can be working on supporting files, which remain closed to you.
You can also change notebook links to another file; all link references to the selected file change to the new filename in the active notebook. As well, you can delete both notebook links and hyperlinks.
To open a file linked to the active notebook
1 Click Edit Links Open links.
2 Select a file.
Note
When you open files linked to the active notebook, only files that are directly linked to the active notebook are opened. You must repeat the procedure for all directly linked files that contain additional file links.
To update a link to an unopened file
1 Click Edit Links Refresh links.
2 Select a file.
Note
When you update a link to an Internet file specified by a URL, the file is reloaded from the Internet, not from a local temporary file.
To change a notebook link to another file
1 Click Edit Links Change links.
2 Select a file.
3 Type the name of the new file in the To box.
Notes
All link references to the selected file change to the new filename in the active notebook.
The new supporting file must have the same layout as the previous one because the same relative cells are referenced. If it does not, formulas that reference linked cells may show errors or produce meaningless values.
To delete a notebook link
1 Click Edit Links Delete links.
2 Select a file.
Notes
The Undo command cannot restore deleted links.
When you delete a notebook link Quattro Pro replaces all link references to the deleted files with ERR values, but it does not remove any formulas containing ERR values. You can edit the formulas to replace the ERR values with valid references.
To delete a hyperlink
1 Select a cell containing a hyperlink.
2 Click Tools Hyperlink.
3 Click Remove link.
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.
Type Application
.qpw Quattro Pro 9 and 10 for Windows 95, 98, NT, ME, and 2000
.wb3 Quattro Pro 7 and 8 for Windows 95 and Windows NT
.wb2 Quattro Pro for Windows, version 6.0
.wb1 Quattro Pro for Windows, versions 1.0 and 5.0
.wq1 Quattro Pro for DOS
.wq2* Quattro Pro for DOS, versions 5.0 and 5.5
.xls Microsoft Excel, versions 5.0, 7.0, 97, and 2000
.123* Lotus 1-2-3 97/9, and 9.5 Millennium Edition
.wk4 Lotus 1-2-3, versions 4, 5
.wk3 Lotus 1-2-3, version 3.x, and Lotus 1-2-3 for Windows
.wk1 Lotus 1-2-3, version 2.x
.wks Lotus 1-2-3, version 1.0
.wke Lotus 1-2-3, educational version
.db Paradox
.dbf dBASE III, dBASE II, III Plus, and IV, and dBASE for Windows
.txt Tab-delimited text
.csv Comma-delimited values
.dif Data Interchange Format
.slk Symbolic Link
.html/.htm HTML version 3 (tables only), includes XML
.wpd* WordPerfect (all versions)
.qif* Quicken Interchange Format
Quattro Pro for MS-DOS
You can display Quattro Pro for MS-DOS menus within Quattro Pro. You can also open files and play macros originally created in Quattro Pro for MS-DOS. Quattro Pro supports all 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 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 Quattro Pro for MS-DOS editing keys
You can use 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 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 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 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.
Notes
If you are working in 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 Corel 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.
Type Format Description
.bmp Bitmap image-the format used in Windows paint programs such as Paint and in the Windows Control Panel for wallpaper
.cdr CorelDRAW-the filename extension for files created in CorelDRAW
.cgm Computer Graphics Metafile-the most common vector-based clipart format. To install .cgm import, you must select it under Accessories during a custom installation.
.clp QP DOS Clipboard-a graphic format used by Quattro Pro for DOS
.cpt Corel PHOTO-PAINT-the filename extension for bitmap image files created by Corel PHOTO-PAINT.
.emf Enhanced Metafile Format-the native internal file format of Windows 95 and Windows NT. It supports both bitmap and vector information and 24-bit RGB color.
.eps Encapsulated PostScript-the file format universally understood by PostScript printers and image setters. The file contains PostScript code for high-quality output, plus a bitmap image for lower-resolution screen display. (If the .eps file does not contain a bitmap image, you cannot import it into Quattro Pro.)
.gif Graphics Interchange Format-a bitmap image format originating on CompuServe Information Service (CIS) and widely used on other electronic bulletin boards
.jpg JPEG-a standard format developed by the Joint Photographic Experts Group, allowing the transfer of files between a wide variety of platforms, using superior compression techniques
.pcx PC Paintbrush-a bitmap image format supported by many programs, including Paint and Quattro Pro for DOS
.pic Lotus PIC-the chart format used in the DOS versions of Lotus 1-2-3
.tga Truevision Targa bitmap image-the extension for files in Targa format, a bitmap image format commonly used to store digitized color photographs
.tif Tag Image File Format-a bitmap image file format often used for scanned or gray scale images. Because .tif files can be large, they are often compressed.
.wmf Windows Metafile-a file format used by many Windows programs
.wpg WordPerfect Graphic-a graphic format used by Corel Presentations
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."
Type Format Description
.bmp Bitmap image-the format used in Windows paint programs such as Paint and in the Windows Control Panel for wallpaper
.cgm Computer Graphics Metafile-the most common vector-based clipart format
.emf Enhanced Metafile Format-the native internal file format of Windows 95 and Windows NT. It supports both bitmap and vector information and 24-bit RGB color.
.eps Encapsulated PostScript-the file format universally understood by PostScript printers and image setters. The file contains PostScript code for high-quality output, plus a bitmap image for lower-resolution screen display.
.gif Graphics Interchange Format-a bitmap image format originating on CompuServe Information Service (CIS) and widely used on other electronic bulletin boards. .gif files can be exported only in 256 color (or less) mode.
.jpg JPEG-a standard format developed by the Joint Photographic Experts Group, allowing the transfer of files between a wide variety of platforms, using superior compression techniques. .jpg files can export only in true color mode (available when using the high color (16-bit) palette).
.pcx PC Paintbrush-a bitmap image format supported by many programs, including Paint and Quattro Pro for DOS
.tif Tag Image File Format-a bitmap image file format often used for scanned or gray scale images. Because .tif files can be large, they are often compressed.
.wmf Windows Metafile-a file format used by many Windows programs
.wpg WordPerfect Graphic-a graphic format used by Corel Presentations
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.
Make sure you set up the source and destination areas similarly. For example, put headings in the same position. Data that is copied takes on the properties of the open notebook, retaining only its numeric format.
Check that the receiving notebook contains only values where you are combining data. If cells contains formulas, convert them to values (by clicking Edit Convert to values) before using a mathematical operation. The mathematical operation will not occur in cells with formulas or labels.
In the active notebook, cells that contain labels, formulas, ERR, or NA are not altered by the incoming data.
When adding incoming values to those in the notebook, you can specify that all incoming formulas convert to their end values, and that labels and blank cells be ignored. Formulas resulting in ERR, NA, or strings can be also ignored.
References in formulas adjust to reflect their new positions, even when they are absolute. (Absolute formulas remain absolute in the new notebook after their initial adjustment; they retain the dollar signs ($), but their references adjust.) If a formula refers to cells outside of the selection being copied, the result may be inaccurate.
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 information may have been created in an application that does not support DDE or OLE linking. For example, if you are trying to link to a spreadsheet or database application, you should use a spreadsheet or database link. You can use the Windows Object Packager utility to create an OLE package. Consult Windows documentation.
The application necessary to edit the object is not available. For example, if the object is linked to Corel Presentations, Corel 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.
If it is a linked object, make sure the source file has not been moved, renamed, or deleted. If the source file has been moved or renamed, select the object, click Edit OLE links, and click Change source to change the source of the link.
