TableView.BestFitColumns() Method

Resizes all visible columns to optimally fit their contents.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v19.1.dll

Declaration

C#

public void BestFitColumns()

VB.NET

Public Sub BestFitColumns

Remarks

Tip

Topic: Best Fit

Call the BestFitColumns method to resize the columns so that they display their contents completely.

C#

private static void TableViewOnLoaded(object sender, EventArgs e) {
    var tableView = sender as TableView;
    if(tableView != null) {
        foreach(var item in tableView.VisibleColumns) {
            tableView.BestFitColumn(item);
        }
    }
} 

VB.NET

Private Shared Sub TableViewOnLoaded(ByVal sender As Object, ByVal e As EventArgs)
    Dim tableView = TryCast(sender, TableView)
    If tableView IsNot Nothing Then
        For Each item In tableView.VisibleColumns
            tableView.BestFitColumn(item)
        Next
    End If
End Sub 

Columns are resized to the minimum width required. The content taken into account when calculating the required column width includes the column header contents, data cell contents, and the footer summary cell’s content. If the TableView.BestFitMaxRowCount property value is -1, all data cells are processed. Otherwise, the View only processes the number of cells specified by that property value.

If the BaseColumn.FixedWidth property is true, the column is not resized when calling the BestFitColumns method.

To apply the best width feature to a particular column, call the TableView.BestFitColumn method.

Note

The BestFitColumns method should be called only when the GridControl is loaded.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the BestFitColumns() 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#

how-to-allow-columns-to-fit-their-content-after-changing-or-modifying-gridcontrols-itemsource-e2042/CS/GridControlFitBehavior.cs#L33

    if (View != null)
        View.BestFitColumns();
}

VB.NET

how-to-allow-columns-to-fit-their-content-after-changing-or-modifying-gridcontrols-itemsource-e2042/VB/GridControlFitBehavior.vb#L41

Private Sub Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs)
    If View IsNot Nothing Then View.BestFitColumns()
End Sub