Overlapping cell text

[joycieluvspink]

Hi Aspose team,

I am currently having an issue with overlapping cell text. The text of Column A spills over Column B. What property should we modify to resolve this issue? Adjusting the width of the cells is not an option since the text strings doesn't have a fixed length.

Thank you!

Regards,

Joyce

[shakeel.faiz]

Hi Joyce,

Thanks for your posting and using Aspose.Cells.

You can solve it with either auto fitting the column A or auto fitting all the columns of worksheet.

Please see the following code that explains how to autofit a single column and auto fit all columns of a worksheet.

C#

//Autofit column A

worksheet.AutoFitColumn(0);


//Autofit all columns

worksheet.AutoFitColumns();