Excel Displays Only First Column in Embedded Worksheet
The information in this article applies to:
- Microsoft Visual Basic Control Creation, Learning, Professional, and
Enterprise Editions for Windows, version 5.0
- Standard, Professional, and Enterprise Editions of Microsoft
Visual Basic, 16-bit and 32-bit, for Windows, version 4.0
- Microsoft Excel, versions 5.0, 7.0x, 97
SYMPTOMS
Microsoft Excel displays only the first column in an Auto-Formatted
multiple-column worksheet object embedded from a file. This problem occurs
when the instance of Microsoft Excel that is opened is subsequently closed.
This behavior is exhibited by both the 16-bit and 32-bit versions of
Microsoft Excel version 5.0.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem was corrected in
Microsoft Office 97 Service Release 2 (SR-2).
For additional information about SR-2, please see the following article
in the Microsoft Knowledge Base:
ARTICLE-ID: Q151261
TITLE : OFF97: How to Obtain and Install MS Office 97 SR-2
MORE INFORMATION
Steps to Reproduce Problem
1. Start a new project in Visual Basic. Form1 is created by default.
2. Add an OLE Client control to Form1. Select the Create From File check
box in the Insert Object dialog, and specify a previously saved .XLS
file that contains a Auto-Formatted worksheet with more than one column
of data. Click OK, and note that the entire spreadsheet is displayed.
3. Set the SizeMode property of the OLE Client control to Autosize.
4. Right-click the control, and select OPEN.
5. Exit from Microsoft Excel.
The first column of the spreadsheet is displayed in a stretched format,
but the control retains its same size. Because SizeMode = Autosize, the
entire spreadsheet should be displayed but it is not.
Keywords : kbinterop kbprg kbVBp400 kbVBp500 IAPOLE VB4WIN vbwin
Version : WINDOWS:4.0 5.0 7.0x 97
Platform : WINDOWS
Issue type : kbbug
