PivotGridControl.BestFitDataHeaders(Boolean) Method

Resizes the Data Header Area to the minimum width required to display data field headers.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v19.1.dll

Declaration

C#

public void BestFitDataHeaders(
    bool considerRowArea
)

VB.NET

Public Sub BestFitDataHeaders(
    considerRowArea As Boolean
)

Parameters

Name	Type	Description
considerRowArea	Boolean	true, to prevent the Row Header Area width from being decreased; otherwise, false.

Remarks

The BestFitDataHeaders method resizes the Data Header Area to the minimum width required to display data field headers.

The BestFitDataHeaders method decreases the width of the Data Header Area if it exceeds the total width of the contained columns. As a result, the width of the Row Header Area, displayed below the Data Header Area, is also decreased and the text may be trimmed. Set the considerRowArea parameter to true to not decrease the Row Header Area width.

To resize all columns to the minimum width required to display the column’s contents, call the PivotGridControl.BestFit method. Use the PivotGridControl.BestFitColumnArea and PivotGridControl.BestFitRowArea methods to resize columns only in the respective areas.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the BestFitDataHeaders(Boolean) 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-pivotgrid-hide-totals-customcellvalue/CS/HideTotalsCustomCellValueExample/Form1.cs#L19

    pivotGridControl1.DataSource = data;
    pivotGridControl1.BestFitDataHeaders(true);
}

how-to-calculate-percent-and-absolute-variations-in-a-custom-direction-from-right-to-left-e2101/CS/WindowsApplication1/Form1.cs#L19

    pivotGridControl1.BestFit();
    pivotGridControl1.BestFitDataHeaders(true);
}

getting-a-summary-value-for-a-previous-period-while-calculating-the-current-one-e2125/CS/Percent_Difference_From_Previous_Period_Example/Form1.cs#L23

pivotGridControl1.BestFit();
pivotGridControl1.BestFitDataHeaders(true);
pivotGridControl1.CollapseAllColumns();

get-values-from-all-cells-that-are-shown-at-the-same-level-as-a-clicked-cell-e4108/CS/WindowsFormsApplication1/Form1.cs#L20

pivotGridControl1.BestFit();
pivotGridControl1.BestFitDataHeaders(true);

VB.NET

winforms-pivotgrid-hide-totals-customcellvalue/VB/HideTotalsCustomCellValueExample/Form1.vb#L19

    pivotGridControl1.DataSource = data
    pivotGridControl1.BestFitDataHeaders(True)
End Sub

how-to-calculate-percent-and-absolute-variations-in-a-custom-direction-from-right-to-left-e2101/VB/WindowsApplication1/Form1.vb#L17

    pivotGridControl1.BestFit()
    pivotGridControl1.BestFitDataHeaders(True)
End Sub

getting-a-summary-value-for-a-previous-period-while-calculating-the-current-one-e2125/VB/Percent_Difference_From_Previous_Period_Example/Form1.vb#L22

pivotGridControl1.BestFit()
pivotGridControl1.BestFitDataHeaders(True)
pivotGridControl1.CollapseAllColumns()

get-values-from-all-cells-that-are-shown-at-the-same-level-as-a-clicked-cell-e4108/VB/WindowsFormsApplication1/Form1.vb#L18

pivotGridControl1.BestFit()
pivotGridControl1.BestFitDataHeaders(True)