View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Autosize bug in Excel 2007, textboxes, work arounds

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" wrote in message
...
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?]