GridView.BestFitColumns() Method

Adjusts column widths so that columns fit their content in the optimal way.

Namespace: DevExpress.XtraGrid.Views.Grid

Assembly: DevExpress.XtraGrid.v19.2.dll

Declaration

C#

public virtual void BestFitColumns()

VB.NET

Public Overridable Sub BestFitColumns

Remarks

Call the BestFitColumns method to resize columns so that they completely display their content. Note that BestFitColumns resizes columns to the minimum width required. When it calculates the required column width, it evaluates the cell contents: column header contents, data cell contents and the footer summary cell’s content. If the View’s GridOptionsView.BestFitMaxRowCount property value is -1, BestFitColumns processes all data cells; otherwise, only the number of cells specified by that property value.

If the columns’ auto width feature (see the GridOptionsView.ColumnAutoWidth property) is in effect, the columns’ total width always matches the View’s width. In this case, the BestFitColumns method resizes columns proportionally with respect to their content.

If a column’s OptionsColumn.FixedWidth option is enabled, the BestFitColumns method retains the column size.

To apply the best width feature to a particular column, call the column’s GridColumn.BestFit method.

Note

If you need to invoke the best fit functionality in the form’s System.Windows.Forms.Form.Load event handler, you should call the GridControl.ForceInitialize method in advance.

The code sample below illustrates how to update column widths when users change cell values.

C#

gridView1.CellValueChanged += GridView1_CellValueChanged;

private void GridView1_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
    gridView1.BestFitColumns();
}

VB.NET

Private gridView1.CellValueChanged += AddressOf GridView1_CellValueChanged

Private Sub GridView1_CellValueChanged(ByVal sender As Object, ByVal e As CellValueChangedEventArgs)
    gridView1.BestFitColumns()
End Sub

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references 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#

Reporting_report-server-how-to-manage-scheduled-jobs-from-a-windows-forms-application-t431255/CS/ScheduledTasksAPIClientDemo/MainForm.cs#L43

    scheduledJobsGrid.DataSource = scheduledJobs;
    scheduledJobsView.BestFitColumns();
}

how-to-load-data-from-the-azure-sql-data-base-and-show-it-in-gridcontrol-/CS/DXApplication1/Main.cs#L14

gridControl.DataSource = await DataTableProvider.Instance.GetDataAsync();
gridView.BestFitColumns();
gridView.LoadingPanelVisible = false;

how-to-provide-the-ability-to-resize-rows-e617/CS/Form1.cs#L185

    gridView1.Columns["Payment Amount"].DisplayFormat.FormatString = "c";
    gridView1.BestFitColumns();
}

grid-control-create-an-example-to-demonstrate-how-to-introduce-spacing-between-columns-e4254/CS/ColumnSpacing/Form1.cs#L19

    myGridView1.Columns[1].ColumnSpacing = 8;
    myGridView1.BestFitColumns();
}

how-to-display-a-drill-down-data-source-within-the-popupcontaineredit-e1568/CS/PivotGridDrillDownDataExample/DrillDownControl.cs#L17

    InitializeComponent();
    gridView1.BestFitColumns();
}

VB.NET

Reporting_report-server-how-to-manage-scheduled-jobs-from-a-windows-forms-application-t431255/VB/ScheduledTasksAPIClientDemo/MainForm.vb#L43

    scheduledJobsGrid.DataSource = scheduledJobs
    scheduledJobsView.BestFitColumns()
End Sub

how-to-load-data-from-the-azure-sql-data-base-and-show-it-in-gridcontrol-/VB/DXApplication1/Main.vb#L16

gridControl.DataSource = Await DataTableProvider.Instance.GetDataAsync()
gridView.BestFitColumns()
gridView.LoadingPanelVisible = False

how-to-provide-the-ability-to-resize-rows-e617/VB/Form1.vb#L178

    gridView1.Columns("Payment Amount").DisplayFormat.FormatString = "c"
    gridView1.BestFitColumns()
End Sub

grid-control-create-an-example-to-demonstrate-how-to-introduce-spacing-between-columns-e4254/VB/ColumnSpacing/Form1.vb#L18

    myGridView1.Columns(1).ColumnSpacing = 8
    myGridView1.BestFitColumns()
End Sub

how-to-display-a-drill-down-data-source-within-the-popupcontaineredit-e1568/VB/PivotGridDrillDownDataExample/DrillDownControl.vb#L16

    InitializeComponent()
    gridView1.BestFitColumns()
End Sub