Skip to main content

PivotGridControl.BestFitMaxRowCount Property

Gets or sets the number of rows taken into account when calculating the optimal width required for columns (or rows) to completely display their contents.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid


public int BestFitMaxRowCount { get; set; }

Property Value

Type Description

An integer value that specifies the number of processed rows.


The PivotGridControl provides the capability to automatically calculate and apply the optimal width required for a column (or row) to completely display its contents. To do this, use the PivotGridControl.BestFit, PivotGridControl.BestFitColumn or PivotGridControl.BestFitRow method. End-users can resize columns and rows to their optimal width/height (if allowed) by double clicking their right border (bottom for rows).

By default, a column’s optimal width is calculated based on the text of all cells within this column. To increase the application’s performance, the number of records taken into account when calculating the optimal width can be limited by setting the BestFitMaxRowCount property. By default, this property is set to -1, to indicate that all cells are processed. If the BestFitMaxRowCount property is set to a positive value, the PivotGridControl processes the specified number of cells starting from the top visible cell.

To learn more, see Best Fit.

See Also