Automatically adjust width of colums on Table

[mlenz]

If I populate a table from a database, I would like to automatically adjust the width of the respective columns based on the maximum width of the text contained in the respective columns. I see that there is a property to automatically adjust row height but I can't find a way to automatically adjust the width. Since this is based on selected font, how would I determine the pixel width of a string such that I can use the property node of cell width to achieve my objective?

[chilly_charly]

The trick is to use the "get text rect" vi (in the graphic & sound > Picture functions) sub-palette.
However, I think I missed something since to get it work properly, I'm obliged to concatenate a space to the cell string.
The remaining problem (until NI add the function) is that you have to define manually which font is used.
See the attached example.

CC

[Megan B.]

Charly is right. The way to do this is to use the GetTextRect.vi. You will probably want to use a loop to examine the length of each cell's text and set the cell width to the longest length, perhaps padded a bit. You may want to check out this post as well:
http://forums.ni.com/ni/board/message?board.id=170&message.id=65837&requireLogin=False

Let us know if this doesn't help!

Megan B.
National Instruments

[chilly_charly]

Sorry, I forgot the attachment !

CC

[mlenz]

Charly and Megan....Thanks for your help.

The attached VI clearly illustrates the discussion.