AutofitRows() on merged cells

[Najati Imam]

Quite simply, it doesn''t seem to work. The cells that result from the following code are, indeed, merged and the text in them is wrapped. However, they are only the default height when the text inside at least 2 lines worth.

...
workSheet.Range[rowIndex,3,rowIndex,9].Text = message;
workSheet.Range[rowIndex,3,rowIndex,9].Merge();
workSheet.Range[rowIndex,3,rowIndex,9].WrapText = true;
workSheet.Range[rowIndex,3,rowIndex,9].AutofitRows();
...

[Administrator]

Hi Najati,

Could you please explain on what you meant by "However, they are only the default height when the text inside at least 2 lines worth.".

I tested for this behavior by Autofitting the row in MS Excel but it does not seems to work on Merged cells. Please let me know if I am missing something.

Thanks,

Stephen.

>Quite simply, it doesn''t seem to work. The cells that result from the following code are, indeed, merged and the text in them is wrapped. However, they are only the default height when the text inside at least 2 lines worth.
>
>...
>workSheet.Range[rowIndex,3,rowIndex,9].Text = message;
>workSheet.Range[rowIndex,3,rowIndex,9].Merge();
>workSheet.Range[rowIndex,3,rowIndex,9].WrapText = true;
>workSheet.Range[rowIndex,3,rowIndex,9].AutofitRows();
>...
>

[Najati Imam]

I just meant that when the row should be taller to account for the wrapped text, it was not taller, and instead just the default row height. I hope thats worded a little more clearly, sorry for the confusion.

I tried it in Excel on a merged area and it, indeed, seems not to work.