Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Text Is Truncated in a Text Box with Rounded Corners


View products that this article applies to.

This article was previously published under Q211499

↑ Back to the top


Symptoms

When you view a text box in a worksheet, text in the text box may be misaligned or truncated.

↑ Back to the top


Cause

This behavior may occur when the following conditions are true:

The text box has rounded corners.

-and-

You use a large (greater than 18) point size for some of the text in the text box.

Note that the larger the point size you use, the more pronounced the problem becomes.

↑ Back to the top


Workaround

To work around this behavior, use either of the following methods:

Reduce the point size of text in the text box.

Reducing the point size prevents text from appearing truncated. Note that reducing the point size does not correct the problem if the text box is simply too small to display all the text.

-or-

Resize the text box to a shape that can display all of the text.

↑ Back to the top


More information

In versions of Microsoft Excel earlier than Excel 97, when you apply rounded corners to a text box, the radius that defines the corners is the same in all text boxes regardless of the size of the text box.

In Microsoft Excel 2000, the radius that defines rounded corners in a text box varies with the size of the text box. So, the radius of the corners of a text box of width "x" and height "y" may be larger in Microsoft Excel 2000 than it is in versions of Microsoft Excel earlier than Excel 97.

This difference in behavior may cause problems when the text box contains text that is formatted in a large point size. For example, text at the top of the text box may shift down and to the right, away from the larger rounded upper-left corner of the text box. This behavior may cause text in the lower-right side of the text box to become truncated.

↑ Back to the top


Keywords: KB211499, kbfaq, kbdtacode, kbprb, kbualink97

↑ Back to the top

Article Info
Article ID : 211499
Revision : 3
Created on : 10/7/2003
Published on : 10/7/2003
Exists online : False
Views : 235