Autosize bug in Excel 2007, textboxes, work arounds

[Anthony Berglas]

XL 2007 only seems to AutoSize the Height of a text box, not the Width.
This is different from XL 95..2003 which autosized both. (But autosize
for comments (almost) works correctly -- the UI is a bit broken if
editing manually.)

This is easily seen from the UI, just create an Autoboxed frame and type
into it, only in XL < 2007 does it get wider.

This makes it difficult to programatically create a text box, and put
some text in it and have the box displayed in a natural width. Same
goes for comments etc.

Any ideas for a work around most appreciated. (Guessing the width of
fonted strings is very error prone.)

Regards,

Anthony

[Had tried to post from Google Groups, but message never got to the group?]

 

[NickHK]

Anthony,
This is third post on the same subject. If you cannot see your posts through
Google, use a real news reader (like Outlook Express, Agent etc) instead and
connect directly to "msnews.microsoft.com".
....but I doubt you will see this reply anyway then...

NickHK

XL 2007 only seems to AutoSize the Height of a text box, not the Width.
This is different from XL 95..2003 which autosized both. (But autosize
for comments (almost) works correctly -- the UI is a bit broken if
editing manually.)

This is easily seen from the UI, just create an Autoboxed frame and type
into it, only in XL < 2007 does it get wider.

This makes it difficult to programatically create a text box, and put
some text in it and have the box displayed in a natural width. Same
goes for comments etc.

Any ideas for a work around most appreciated. (Guessing the width of
fonted strings is very error prone.)

Regards,

Anthony

[Had tried to post from Google Groups, but message never got to the

group?]