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

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, 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 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.

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

In earlier versions of Microsoft Excel, 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 97, 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 97 than it is in earlier versions of Microsoft Excel.

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 right-hand bottom side of the text box to become truncated.