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?