Issue with AutoFitColumns function

Aspose.Cells Product Family
1

Observe column K in the source excel file, upon passing the sheet through AutoFitColumns function the column width becomes extremely small (observe the output file).
I have attached the code, source excel file and the output excel . AutoFitColumns should ensure that the column width is adjusted according to the data in the cells but in this case the width drastically decreases and effects the visibility of data in column. Please suggest a fix, FYI aspose cells version is 25.5.
using Aspose.Cells;

namespace columnwidth
{
    internal class Program
    {
        static void Main(string[] args)
        {
            string sourcePath = ""; //enter source file path here
            Workbook sourceWb = new Workbook(sourcePath);
            Worksheet sourceSheet = sourceWb.Worksheets[0];


            AutoFitterOptions autoFitOptions = new AutoFitterOptions();
            autoFitOptions.IgnoreHidden = true;
            autoFitOptions.AutoFitMergedCellsType = AutoFitMergedCellsType.EachLine;
            sourceWb.Worksheets[0].AutoFitColumns(4, 8, 40, 8, autoFitOptions);
            string outputPath = ""; //enter output path here
            sourceWb.Save(outputPath);
        }
    }
}

source file link: sourcecellwidthissue.xlsx - Google Sheets
output file link:
newoutputcellwidthissue.xlsx - Google Sheets

2

@Rit3sh
Thank you for providing the sample code, source file, and the output file. We appreciate the detailed information, as it allowed us to quickly set up a reproduction environment to investigate the behavior you are seeing with the AutoFitColumns method.

I have successfully reproduced the issue using Aspose.Cells for .NET 25.5. Upon running your code, I observed that Column K is indeed being resized to an extremely small width, which causes the data to become hidden or truncated. This appears to be a calculation discrepancy in the auto-fit engine when processing the specific content or formatting present in that column.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-60007

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@Rit3sh,

While we thoroughly evaluate the issue and resolve it, you may temporarily use the following code snippet as a workaround; it should perform better.

AutoFitterOptions autoFitOptions = new AutoFitterOptions();
autoFitOptions.IgnoreHidden = true;
autoFitOptions.AutoFitMergedCellsType = AutoFitMergedCellsType.EachLine;
sourceWb.Worksheets[0].AutoFitColumns(autoFitOptions);

And, once we figure out the issue (Ticket ID: “CELLSNET-60007”), we will let you know here.