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.
@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