PivotGridControl.BestFitArea Property

Gets or sets which interface elements are taken into account when calculating optimal width for columns.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v25.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public FieldBestFitArea BestFitArea { get; set; }

VB.NET

Public Property BestFitArea As FieldBestFitArea

Property Value

Type	Description
FieldBestFitArea	A FieldBestFitArea enumeration value that specifies interface elements that are taken into account when calculating the optimal width for columns.

Available values:

Name	Description
None	The best-fit functionality is disabled.
FieldValue	The contents of field values are taken into account when calculating the best-fit size.
FieldHeader	The contents of field headers are taken into account when calculating the best-fit size.
Cell	The contents of data cells are taken into account when calculating the best-fit size.
All	The contents of data cells, field headers and field values are taken into account when calculating the best-fit size.

Remarks

To learn more, see Best Fit.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the BestFitArea property.

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#

wpf-pivotgrid-how-to-display-underlying-data-asynchronously/CS/WpfDrillDownDataSourceExample/MainWindow.xaml.cs#L35

private void ThemedWindow_Loaded(object sender, RoutedEventArgs e) {
    pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader;
    pivotGridControl1.BestFit();

wpf-pivotgrid-customize-the-cell-template/CS/HowToCustomizeCellTemplate/MainWindow.xaml.cs#L19

pivotGridControl1.DataSource = OrderSourceList;
pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader;
pivotGridControl1.BestFit();

wpf-pivotgrid-customize-filter-drop-down/CS/WpfPivotCustomFilterDropDownExample/MainWindow.xaml.cs#L22

{
    pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader;
    pivotGridControl1.BestFit();

wpf-pivotgrid-how-to-display-underlying-data/CS/WpfDrillDownDataSourceExample/MainWindow.xaml.cs#L37

{
    pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader;
    pivotGridControl1.BestFit();

VB.NET

wpf-pivotgrid-customize-the-cell-template/VB/HowToCustomizeCellTemplate/MainWindow.xaml.vb#L20

pivotGridControl1.DataSource = OrderSourceList
pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader
pivotGridControl1.BestFit()

wpf-pivotgrid-customize-filter-drop-down/VB/WpfPivotCustomFilterDropDownExample/MainWindow.xaml.vb#L20

Private Sub ThemedWindow_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
    pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader
    pivotGridControl1.BestFit()