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.

Thanks,
--Howard

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):

e.g..,

sheet.Cells.SetRowHeight(10,12.75);

Thank you.

Hi Howard,

Autofitting rows for merged cells is supported now. Kindly try the similar fix (4.4.1.8) 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!

--Howard