RadSpreadProcessing - AutoFitHeight with merged cell

[Loy]

I do notice that the AutoFitHeight works fine when I'm dealing with only a single row without any merged cells.

I have a situation where I have a merged cell which is the combination of cells from the same row (i.e. B2-B5).  When trying to use AutoFitHeight, there is no change to the row height.

Is there anything I could do? 

[Yoan]

Hello Loy,

When calling the AutoFitHeight method on a row that contains merged and wrapped cells the RowHeight value is set to default instead of calculating the row height according to its content. In that case, the row size must be manually set. In order to measure the cell content and obtain the cell content measurements you can check the exposed by the LayoutHelper class methods.

Example:

Size cellContentSize = LayoutHelper.CalculateCellContentSize(worksheet, rowIndex, columnIndex);
worksheet.Rows[0].SetHeight(new RowHeight(cellContentSize.Height, true));

Hope this helps.

Regards,
Yoan
Progress Telerik