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. Quattro Pro can also open a Quicken Interchange Format (.qif) file.

You can also open files from the Internet.

You can save Quattro Pro files in other formats. You can also 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.

For additional information, see “Supported file formats” and “File-handling options.”

To open a file from another application

Click File

Open.

Choose the drive and folder where the file is stored.

Choose the filename extension from the File type list box.

Double-click the filename.

•

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.

To open a Quicken Interchange Format (.qif) file

Click File

Open.

Choose the drive and folder where the file is stored.

Choose Quicken Interchange Format (.qif) from the File type list box.

Double-click the filename.

•

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.

•

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 open a file from the Internet

Click File

Open.

Type a URL in the Filename box.

Click Open.

•

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 save a Quattro Pro file to another format

Click File

Save as.

Choose a file type from the File type list box.

Type a filename in the Filename list box.

Click Save.

To save a database file

Click File

Save as.

Choose one of the following from the File type list box:

•

dBASE

•

Paradox

Type the filename in the Filename box.

Click Save.

Choose a field from the Fields list, and make any changes to the field name or field type.

Click Write.

•

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.

Wordperfect Quattro Pro