Skip to main content
BuyLog In
Silverlight Controls
Search in…
Docs > Silverlight Controls > Controls > Pivot Grid > Concepts > Layout Features > Best Fit
All docs
V14.2
Silverlight Controls
What Is New
Installation and Demos
Common Concepts
Controls
Reporting
Data Grid
Ribbon Controls
Toolbar-Menu
Chart Control
Pivot Grid
Product Information
Getting Started
Fundamentals
Concepts
Providing Data
Data-Related Features
Layout Features
Field Location and Order
Data Cell Layout
Customization Form
Standalone Field Header Areas
Field Groups
Group Value
Best Fit
Data Formatting
Data Output
End-User Interaction
Styles and Templates
Miscellaneous
Visual Elements
End-User Capabilities
Examples
Scheduler
Rich Text Editor
Tree List
Gauge Controls
Map Control
Dock Windows
Tile and Layout
Printing-Exporting
Data Editors
Navigation Bar
Utility Controls
Spell Checker
LightSwitch Reporting
Localization
Redistribution and Deployment
Get More Help
API Reference

Best Fit

  • 2 minutes to read
In This Article
Best Fit Overview
End-User Capabilities

PivotGridControl provides the capability to automatically calculate and apply the optimal width/height required for a column/row to completely display its contents.

#Best Fit Overview

The Best Fit feature can be applied to an individual column or row, as well as to all columns and rows displayed within the PivotGridControl.

Use the PivotGridControl.BestFitArea (PivotGridField.BestFitArea) property to specify interface elements (field headers, field values or cells) that should be taken into account when adjusting column widths and row heights.

If cell values are taken into account when calculating the optimal width of a column (or the height of a row), you can specify the way this width/height is calculated. To do this, use the PivotGridControl.BestFitMode (PivotGridField.BestFitMode) property. By default, the column's width (or the row's height) is calculated based on the text of all cells within this column (or row).

To increase the application performance, the number of cells taken into account when calculating the optimal width/height can be limited by setting the PivotGridControl.BestFitMaxRowCount (PivotGridField.BestFitMaxRowCount) property. By default, this property is set to -1, to indicate that all cells are processed. If the PivotGridControl.BestFitMaxRowCount property is set to a positive value, the PivotGridControl processes the specified number of cells starting from the first visible cell (top visible, for columns, and leftmost visible, for rows).

The following table lists methods used to apply the Best Fit feature:

Method

Description

PivotGridControl.BestFit

Depending on the particular overload, applies the Best Fit:

  • to all columns and rows
  • to the columns/rows that correspond to the fields contained within the specified area
  • to the columns/rows that correspond to the specified field

PivotGridControl.BestFitColumn

Resizes the specified column to the minimum width required to completely display its contents.

PivotGridControl.BestFitRow

Resizes the specified row to the minimum height required to completely display its contents.

Note that the Best Fit feature cannot be applied within the PivotGridControl.BeginUpdate and PivotGridControl.EndUpdate method calls.

NOTE

The Best Fit feature cannot be applied to the pivot grid if the PivotGridControl.AllowResizing property is set to false.

The Best Fit is available only after the PivotGridControl has been loaded in the visual tree.

#End-User Capabilities

End-users can resize columns to their optimal width (if allowed) by double clicking the right border. Rows are resized by double clicking the bottom border.

pivotgridbestfit