PivotGridControl.BestFitColumnArea() Method

Resizes columns in the Data Area to the minimum width required to display their contents.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public void BestFitColumnArea()

VB.NET

Public Sub BestFitColumnArea

Remarks

To resize columns that display row field values, use the PivotGridControl.BestFitRowArea method.

You can also apply Best Fit to all columns, or to columns that correspond to a particular field. To do this, use the PivotGridControl.BestFit method.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the BestFitColumnArea() 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-pivot-change-the-field-value-header-appearance-backcolor/CS/WindowsApplication53/Form1.cs#L17

private void Form1_Load(object sender, EventArgs e) {
    pivotGridControl1.BestFitColumnArea();
}

VB.NET

winforms-pivot-change-the-field-value-header-appearance-backcolor/VB/WindowsApplication53/Form1.vb#L19

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs)
    pivotGridControl1.BestFitColumnArea()
End Sub