We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Autofit height with merged cells Autofit row height with merged cells in Excel using Aspose.Cells for .NET in C#

Hi. I have a row that has cells merged across several columns, but spanning only 1 row. Aspose doesn't seem to adjust the height of this row when I do a sheet.AutoFitRows(). Note that Excel 2003 seems to do this just fine, either by double-clicking in the row resizing area or by selecting the merged cell and doing Format|Row|Autofit.


Hi Howard,

Thanks for considering Aspose.

Well, the autofitting rows feature is not available for the merged cells. We will add it soon. Currently you may utilize the following sample code as a workaround (you may set the rowheights manually for your data):



Thank you.

Hi Howard,

Autofitting rows for merged cells is supported now. Kindly try the similar fix ( which we have already posted you in your other post: <A href="</A></P> <P>Thank you.</P>

Amjad, it appears to work perfectly, thanks!