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
};
_worksheet.AutoFitColumns(options);
_worksheet.AutoFitRows(options);

image.png (3.0 KB)

Asset For Import_Cap Table.zip (10.2 KB)

@pankajgrwl123,

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

@pankajgrwl123,

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

@pankajgrwl123,

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

@pankajgrwl123
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?

@pankajgrwl123,
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