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

## Wrap merged cells

### Re: Wrap merged cells

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.

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.

### Re: Wrap merged cells

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?

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?

### Re: Wrap merged cells

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