adjust cell height of xlsx

Hi,
When merging a new long text to a cell in xlsx template, is there any way to adjust cell height automatically to fit with the new content?
Thank you.

Hi,

Did you try with "Format Cells / Alignment / Text control / Wrap text" ?

Hi,
Thank you for your answer.
Yes, I did.
It affects only when I open Excel and input text by hand.
When I use OpenTBS to modify the text, the cell's height does not change.

Moreover, I'm trying changing value of xml tag.
Example:
<col>1</col>
<cNvPr descr="[new.x;att=col#val]"/>

It will become: <col val="$x">1</col>
How to change it into": <col>$x</col>

Hi.  I'm wrestling with essentially the same issue.  (In my case, the cells have merged data on multiple lines, not from wrapping, but from explicit line breaks.)  So far I do not see a way to really make this happen.  If there is a way, it would be great to know.

Alternatively, the workaround seems to be to embed some macro like this in the source template, and have it run when the document opens.

Sub AutofitRows()
    For Each CL In UsedRange
        If CL.WrapText Then CL.Rows.AutoFit
    Next
End Sub

(This macro comes from: http://excel.tips.net/T010734_Automatic_Row_Height_for_Wrapped_Text.html)

This link covers making your macros auto-run: http://office.microsoft.com/en-us/excel-help/running-a-macro-when-excel-starts-HA001034628.aspx

Any better suggestions for handling this?  Thanks.

Hi there. I am struggling with the same issue too. I did the suggestions mentioned above but was unable to solve it.

Thanks,
Hameed