XL: Formatting and Charts Not Saved to .WQ1 Format

ID: Q110708

5.00 5.00c 7.00 WINDOWS BUGLIST5.00 kbusage

The information in this article applies to:

SUMMARY

In Microsoft Excel, the formatting and any chart sheets contained in the file may be lost when you save the file in the Quattro Pro for DOS (.WQ1) file format (a format used by Corel Corporation's Quattro Pro spreadsheet application).

WORKAROUND

To ensure that most of the formatting is retained when you export a file to Quattro Pro, save the file in the WK1,FMT (1-2-3) (.WK1) file format. The WK1/FMT (1-2-3) file format can handle more formatting information than the .WQ1 file format. The latest versions of Quattro Pro can read the WK1/FMT format.

To save a file in the WK1/FMT file format:

1. Activate the sheet that you want to save. (Activating this sheet is

   necessary because only the active sheet will be saved.)

2. From the File menu, choose Save As.

3. In the File Name box, enter the new name of the file. For example,

   "TEST". It is not necessary to include an extension at the end of the
   file name.

4. From the Save File As Type box, select WK1/FMT (1-2-3).

5. Choose OK to save the file.

6. Choose OK when you receive the message "Selected file type will save

   only the active sheet."

The file is saved in the WK1/FMT file format.

Note that when you use the above workaround, any chart sheets contained in the file are not saved, as indicated in the message above.

MORE INFORMATION

When you save a file in the Quattro Pro for DOS format, formatting applied to the file will be affected in the following ways:

Quattro Pro is manufactured by Corel Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this products' performance or reliability.

KBCategory: kbusage KBSubcategory:

Additional reference words: 5.00 5.00c 7.00 graph borland international

Version           : 5.00 5.00c 7.00
Platform          : WINDOWS

Last Reviewed: November 17, 1998