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

Free Support Forum - aspose.com

Auto-Fit Rows

Hi !

I have 3 merged columns in excel sheet..

Runtime, I am inserting text in cell and I am using AutoFitRows(), however I am not getting auto fit rows in excel sheet

Appreciate if you guide me.


If you have some range of cells merged in a worksheet, the auto-fit feature (Auto-Fit Rows and AutoFit columns) will not be implemented to those merged cells. This behaviour is same as MS Excel.

Thank you.

Hi Amjad,

Is this still true as far as AutoFitRows not working on merged cells? I’m aware that Excel itself doesn’t do this, but it’d sure be great if Cells could do it.

Looks like it’s been about six months since this thread was complete, so thanks for an update.


Hi Mike,

Thanks for following up.

Yes, AutoFitRow(s) works for merged cells now. Kindly try our latest fix (4.5.1): http://www.aspose.com/community/files/51/file-format-components/aspose.cells/entry145662.aspx

Thank you.

That’s excellent news. Many thanks.