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?]

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

"Anthony Berglas" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?]