ColumnCollection.AutoFit(Int32, Int32) Method

Adjusts the width of columns to accommodate cell content.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void AutoFit(
    int first,
    int last
)

VB.NET

Sub AutoFit(
    first As Integer,
    last As Integer
)

Parameters

Name	Type	Description
first	Int32	An integer value specifying the zero-based index of the first column to be automatically resized.
last	Int32	An integer value specifying the zero-based index of the last column to be automatically resized.

Remarks

To automatically fit a single column width to the content, use the Column.AutoFit method.

To set the column width value in required units of measurement, use the Column.Width, Column.WidthInCharacters or Column.WidthInPixels property (see the How to: Specify Row Height or Column Width example).

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AutoFit(Int32, Int32) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-spreadsheet-load-an-ms-access-database-file-into-the-document/CS/WindowsFormsApplication1/MSAccessImportHelper.cs#L163

    table.Style = wb.TableStyles[BuiltInTableStyleId.TableStyleLight1];
    workSheet.Columns.AutoFit(0, workSheet.Columns.LastUsedIndex);
}

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/DocumentPropertiesActions.cs#L46

    worksheet.Columns.AutoFit(1, 2);
}

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/DocumentPropertiesActions.cs#L45

    worksheet.Columns.AutoFit(1, 2);
}

VB.NET

winforms-spreadsheet-load-an-ms-access-database-file-into-the-document/VB/WindowsFormsApplication1/MSAccessImportHelper.vb#L183

    table.Style = wb.TableStyles(BuiltInTableStyleId.TableStyleLight1)
    workSheet.Columns.AutoFit(0, workSheet.Columns.LastUsedIndex)
End Sub

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/DocumentPropertiesActions.vb#L42

    worksheet.Columns.AutoFit(1, 2)
Finally

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/DocumentPropertiesActions.vb#L42

    worksheet.Columns.AutoFit(1, 2)
Finally

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/DocumentPropertiesActions.vb#L42

#End Region  ' #Built-inProperties
                worksheet.Columns.AutoFit(1, 2)
            Finally