XL2000: Text Is Truncated in a Text Box with Rounded Corners (211499)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q211499

SYMPTOMS

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

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.

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.

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.

Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbdtacode kbprb kbualink97 KB211499