We are having a small performance problem with the auto fit columns in Excel. Is this a known issue? We used both of the methods below. Is this the correct and best way of doing it?
Worksheet.AutoFitColumn(columnIndex);
where columnIndex is an integer specifying the column we want to adjust.
Please download and try the latest version: Aspose.Cells
for .NET v7.3.1.1. It should fix the performance problem you have mentioned.
If your columns are less in numbers, then you can use Worksheet.AutoFitColumn(columnIndex), but if there are many columns then we recommend you to use the Worksheet.AutoFitColumns().
If your issue still occurs, then please provide us your sample runnable application replicating this issue using the latest version.