When using Worksheet.AutoFitColumns() if the cell has a formula in it and the value is larger than the column width the column width isn’t adjusted properly. See attached file for an example.
Hi,
Please download the latest version: Aspose.Cells for .NET (Latest Version)
It is working fine. Please see the code below and the output file.
C#
string path = @“F:\Shak-Data-RW\Downloads\Example.xls”;
Workbook workbook = new Workbook(path);
workbook.Worksheets[0].AutoFitColumns();
workbook.Save(path + “.out.xls”, SaveFormat.Excel97To2003);
Hi,
Here is a file that I just generated with the latest download that you gave me. As you can see the problem is still there. If you would like I can send you the VB project that generated this file and you can see for yourself that this is not working correctly.
Hi,