wpf-8400-controls-and-libraries-pivot-grid-appearance-pivot-grid-elements-that-support-templates.md
View Example: Customize the Cell Template
The following table lists all template properties introduced by the Pivot Grid:
|
Visual Element
|
Property
|
Description
|
Data Context (Binding Source)
| | --- | --- | --- | --- | |
Field List
|
PivotGridControl.ExcelFieldListTemplate
PivotGridControl.FieldListTemplate
|
Specifies the template that defines the presentation of the Field List.
|
| |
Data Cell
|
PivotGridControl.FieldCellTemplate
PivotGridControl.FieldCellTemplateSelector
PivotGridControl.FieldCellKpiTemplate
PivotGridControl.FieldCellKpiTemplateSelector
PivotGridField.CellTemplateSelector
|
Specifies the template that defines the presentation of data cells.
|
| |
Drag Indicator
|
PivotGridControl.FieldHeaderDragIndicatorTemplate
|
Specifies the template that defines the presentation of the drag indicator.
|
null ( Nothing in Visual Basic)
| |
Field Header
|
PivotGridControl.FieldHeaderTemplate
PivotGridControl.FieldHeaderTemplateSelector
PivotGridField.HeaderTemplateSelector
|
Specifies the template that defines the presentation of field headers.
|
| |
Field Header (in a Field List, list arrangement)
|
PivotGridControl.FieldHeaderListTemplate
PivotGridControl.FieldHeaderListTemplateSelector
PivotGridField.HeaderListTemplate
PivotGridField.HeaderListTemplateSelector
|
Specifies the template that defines the presentation of field headers in the Field List when they are arranged in a list.
|
| |
Field Header (in a Field List, tree arrangement)
|
PivotGridControl.FieldHeaderTreeViewTemplate
PivotGridControl.FieldHeaderTreeViewTemplateSelector
PivotGridField.HeaderTreeViewTemplate
PivotGridField.HeaderTreeViewTemplateSelector
|
Specifies the template that defines the presentation of field headers in the Field List when they are arranged in a tree.
|
| |
Field Value
|
PivotGridControl.FieldValueTemplate
PivotGridControl.FieldValueTemplateSelector
PivotGridField.ValueTemplateSelector
|
Specifies the template that defines the presentation of field values.
|
PivotGrid.FieldValueElementData
| |
Focused Cell’s Border
|
PivotGridControl.FocusedCellBorderTemplate
|
Specifies the template that defines the presentation of the focused cell’s border.
|
null ( Nothing in Visual Basic)
| |
Resizing Indicator
|
PivotGridControl.ResizingIndicatorTemplate
|
Specifies the template that defines the presentation of the resizing indicator.
|
null ( Nothing in Visual Basic)
| |
Filter Drop-Down
|
PivotGridField.CustomExcelStyleFilterPopupTemplate
|
Specifies the template that defines the presentation of the drop-down filter.
| | |
Filter Editor
|
PivotGridControl.FilterEditorTemplate
|
Specifies the template that defines the presentation of the filter editor.
| | |
Filter Editor Dialog Service
|
PivotGridControl.FilterEditorDialogServiceTemplate
|
Specifies the template that defines the appearance and location of the filter editor window.
| |
The following example demonstrates how to use the PivotGridControl.FieldCellTemplate property to customize the appearance of data cells.
<Window x:Class="HowToCustomizeCellTemplate.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:dxpg="http://schemas.devexpress.com/winfx/2008/xaml/pivotgrid"
xmlns:local="clr-namespace:HowToCustomizeCellTemplate"
Title="Custom Cell Template" Height="450" Width="800" Loaded="Window_Loaded">
<Grid>
<dxpg:PivotGridControl x:Name="pivotGridControl1">
<dxpg:PivotGridControl.Fields>
<dxpg:PivotGridField
x:Name="fieldSales"
Area="DataArea"
Caption="Product Sales"
FieldName="ExtendedPrice">
</dxpg:PivotGridField>
<dxpg:PivotGridField
x:Name="fieldYear"
AllowFilter="False"
Area="ColumnArea"
Caption="Year"
FieldName="OrderDate"
GroupInterval="DateYear" />
<dxpg:PivotGridField
x:Name="fieldMonth"
AllowFilter="False"
Area="ColumnArea"
Caption="Month"
FieldName="OrderDate"
GroupInterval="DateMonth" />
<dxpg:PivotGridField
x:Name="fieldCategoryName"
Area="RowArea"
AreaIndex="0"
Caption="Category"
FieldName="CategoryName" />
<dxpg:PivotGridField
x:Name="fieldProductName"
Area="RowArea"
AreaIndex="1"
Caption="Product"
FieldName="ProductName" />
</dxpg:PivotGridControl.Fields>
<dxpg:PivotGridControl.FieldCellTemplate>
<DataTemplate>
<ProgressBar Name="cellShare" Minimum="0" Margin="3"
Maximum="{Binding Path=RowTotalValue, Mode=OneWay, Converter={local:RoundConverter}}"
Value="{Binding Path=Value, Mode=OneWay, Converter={local:RoundConverter}}"
HorizontalAlignment="Stretch" VerticalAlignment="Stretch"/>
</DataTemplate>
</dxpg:PivotGridControl.FieldCellTemplate>
</dxpg:PivotGridControl>
</Grid>
</Window>
using System;
using System.Collections.ObjectModel;
using System.Windows;
using System.Windows.Data;
using System.Windows.Markup;
namespace HowToCustomizeCellTemplate
{
public partial class MainWindow : Window {
public ObservableCollection<MyOrderRow> OrderSourceList { get; set; }
public MainWindow() {
InitializeComponent();
}
private void Window_Loaded(object sender, RoutedEventArgs e) {
OrderSourceList = DatabaseHelper.CreateData();
pivotGridControl1.DataSource = OrderSourceList;
pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader;
pivotGridControl1.BestFit();
}
}
public class RoundConverter : MarkupExtension, IValueConverter {
#region IValueConverter Members
public object Convert(object value, Type targetType, object parameter,
System.Globalization.CultureInfo culture) {
return System.Convert.ToInt32(value);
}
public object ConvertBack(object value, Type targetType, object parameter,
System.Globalization.CultureInfo culture) {
throw new NotImplementedException();
}
#endregion
public override object ProvideValue(IServiceProvider serviceProvider) {
return this;
}
}
}
Imports System
Imports System.Collections.ObjectModel
Imports System.Windows
Imports System.Windows.Data
Imports System.Windows.Markup
Namespace HowToCustomizeCellTemplate
Partial Public Class MainWindow
Inherits Window
Public Property OrderSourceList() As ObservableCollection(Of MyOrderRow)
Public Sub New()
InitializeComponent()
End Sub
Private Sub Window_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
OrderSourceList = DatabaseHelper.CreateData()
pivotGridControl1.DataSource = OrderSourceList
pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader
pivotGridControl1.BestFit()
End Sub
End Class
Public Class RoundConverter
Inherits MarkupExtension
Implements IValueConverter
#Region "IValueConverter Members"
Public Function Convert(ByVal value As Object, ByVal targetType As Type, ByVal parameter As Object, ByVal culture As System.Globalization.CultureInfo) As Object Implements IValueConverter.Convert
Return System.Convert.ToInt32(value)
End Function
Public Function ConvertBack(ByVal value As Object, ByVal targetType As Type, ByVal parameter As Object, ByVal culture As System.Globalization.CultureInfo) As Object Implements IValueConverter.ConvertBack
Throw New NotImplementedException()
End Function
#End Region
Public Overrides Function ProvideValue(ByVal serviceProvider As IServiceProvider) As Object
Return Me
End Function
End Class
End Namespace