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
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();