BUG: Excel Displays Only First Column in Embedded Worksheet

 Last reviewed: September 29, 1997
Article ID: Q129793
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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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          : IAPOLE VB4ALL VB4WIN vb5all vbwin GnrlVb kbinterop kbprg
Technology        : kbole kbvba
Version           : WINDOWS:4.0 5.0 7.0x 97
Platform          : WINDOWS
Issue type        : kbbug

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.