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

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