Axolot Data

Hi everybody,

is it possible to wrap text in merged cells? I am able to wrap text in a non-merged cell. I am using MergeCells and WrapText functions. I also tried AutoHeightRows but with no success.

Thank you for your answer,
Andrej

Hello!
Some time ago I also faced this problem. I solved it by modifying a function TXLSWorksheet.AutoHeightRow. I sent the corrected version to the author. But he hasn't answered yet.

As I know Excel itself cannot make row autoheight in case of merged cells with text wrap.
The only way is to calculate and set row height directly.

alexey.t, what was the solution of a problem?
I'm simply interested, because I also sometimes have to solve problem with merged cells and text wrap.
But I solve it as I described - I calculate and set row height directly.
What is yours way?

What does setting row height directly do exactly in regards to this issue?