XL: Columns Hidden in File Saved to WK1 Format in SuperCalc

ID: Q118998

5.00 5.00c 7.00 WINDOWS kb3rdparty

The information in this article applies to:

Microsoft Excel for Windows, version 5.0
Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you open a file that was created in SuperCalc 5, the cells on the worksheet are not visible.

CAUSE

This behavior occurs in Microsoft Excel because the worksheet columns are hidden or saved with a column width of zero when you save a file to the Lotus WK1 file format in SuperCalc 5.

WORKAROUND

When you open a file in Microsoft Excel that was created in SuperCalc 5, do the following to display cells on the worksheet:

1. Select the entire Worksheet by choosing the Select All button (above

   the row number 1) or CTRL+A.

2. From the Format menu, choose Column, and then choose Unhide.

To display gridlines in the file, do the following:

1. From the Tools menu, choose Options.

2. Select the View tab, and under Window Options, select the Gridlines

   check box. Choose OK.

SuperCalc 5 is manufactured by Computer Associates, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

REFERENCES

For more information about Opening A Document Created By Another Application, choose the Search button in Help and type:

   importing data from other applications, opening imported documents

KBCategory: kb3rdparty KBSubcategory:

Additional reference words: 7.00 5.00 3rdparty dos 5.5b

Version           : 5.00 5.00c 7.00
Platform          : WINDOWS

Last Reviewed: March 29, 1997