General Alignment Applied Differently to WK3 Files in XL5 (186765)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q186765 SYMPTOMS
When you open a file that was saved in the Lotus 1-2-3(.wk3) format in
Microsoft Excel 7.0 or Microsoft Excel 97, a Microsoft Visual Basic for
Applications subroutine may return False when you try to programatically
determine whether the values in a cell are left aligned. In Microsoft Excel
5.0, the same subroutine returns True.
To see an example of this problem, please see the "More Information"
section of this article.
CAUSE
This problem may occur when the cells are formatted with the General
format. In Excel 5.0, if the cell uses the General format, your subroutine
returns True if you test for left alignment. However, in Excel 7.0 or Excel
97, the same subroutine returns False if the cells use the General format.
REFERENCES
For more information about the alignment of cells, click Microsoft Excel
Help Topics on the Help menu, click the Index tab in Microsoft Excel 7.0
Help, type the following text
and then double-click the selected text to go to the "Basic Formattting"
topic.
Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
---|
Keywords: | kbdtacode kbprb KB186765 |
---|
|