Back to Devexpress

ColumnCollection.AutoFit(Int32, Int32) Method

officefileapi-devexpress-dot-spreadsheet-dot-columncollection-dot-autofit-x28-system-dot-int32-system-dot-int32-x29.md

latest5.6 KB
Original Source

ColumnCollection.AutoFit(Int32, Int32) Method

Adjusts the width of columns to accommodate cell content.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void AutoFit(
    int first,
    int last
)
vb
Sub AutoFit(
    first As Integer,
    last As Integer
)

Parameters

NameTypeDescription
firstInt32

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).

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.

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

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

wpf-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/DocumentPropertiesActions.cs#L46

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

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

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

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

vb
worksheet.Columns.AutoFit(1, 2)
Finally

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

vb
worksheet.Columns.AutoFit(1, 2)
Finally

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

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

See Also

Width

WidthInCharacters

WidthInPixels

DefaultColumnWidth

How to: Specify Row Height or Column Width

Rows and Columns in Spreadsheet Documents

ColumnCollection Interface

ColumnCollection Members

DevExpress.Spreadsheet Namespace