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

Free Support Forum - aspose.com

AutoFit for Merge Cell Not Working

Hi Team,

AutoFit For Merged cell not working, Please help me to resolve this.

I am using 21.5.0

var options = new AutoFitterOptions()
AutoFitMergedCellsType = AutoFitMergedCellsType.EachLine

image.png (3.0 KB)

Asset For Import_Cap Table.zip (10.2 KB)


Please notice, I am able to reproduce the issue as you mentioned by using your template file. I found auto-fit operation for some merged cells (e.g. P1 cell) is not working in the worksheet. I have logged a ticket with an id “CELLSNET-49055” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

@Amjad_Sahi, Any update on this


Could you please share your excepted result? Do you want to expand the columns’ width or wrap the text? You may share your expected file for reference.

@Amjad_Sahi, Expected is the text should be visible as of now it’s not. “Outstanding As Converted”.

Solutions should be expand the column width


Ok, got it. We will try to enhance the auto-fit operation in accordance with your needs.

Please try the latest fix 21.8.7
Aspose.Cells21.8.7 For .Net2_AuthenticodeSigned.Zip (5.6 MB)
Aspose.Cells21.8.7 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.8.7 For .NetStandard20.Zip (5.6 MB)

@simon.zhao, Thank you for the fix, In which NuGet version I will get the changes?

Thank you for the feedback. You will get it in a couple of days through NuGet with the release of next version 21.9.

The issues you have found earlier (filed as CELLSNET-49055) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao