彩票走势图

本文运用PivotGridControl.CustomCellEdit事件，分配不同的In-place Editors 给不同类型的单元格。

在该示例中，两个In-place Editors 被创建来代表“Qty %”字段的值。其中， ProgressBar编辑器是用来表示常规的单元格的值，而SpinEdit编辑器用来表示此字段的总额：

代码如下：

C#

using DevExpress.XtraEditors.Repository;
using DevExpress.XtraPivotGrid;

// In-place editors used to represent values of regular and total cells respectively.
RepositoryItemProgressBar editorForCells;
RepositoryItemSpinEdit editorForTotals;

// Initialize the editors.
editorForCells = new RepositoryItemProgressBar();
editorForCells.Minimum = 0;           
editorForCells.Maximum = 100;
editorForTotals = new RepositoryItemSpinEdit();
pivotGridControl1.RepositoryItems.AddRange(
  new RepositoryItem[] { editorForCells, editorForTotals });

// Provide editors for cells depending on cell types
private void pivotGridControl1_CustomCellEdit(object sender, PivotCustomCellEditEventArgs e) {
    if (e.DataField != fieldQuantityPercent) return;
    if (e.RowValueType == PivotGridValueType.GrandTotal)
        e.RepositoryItem = editorForTotals;
    if (e.RowValueType == PivotGridValueType.Value)
        e.RepositoryItem = editorForCells;
}

VB

Imports DevExpress.XtraEditors.Repository
Imports DevExpress.XtraPivotGrid

' In-place editors used to represent values of regular and total cells respectively.
Dim editorForCells As RepositoryItemProgressBar
Dim editorForTotals As RepositoryItemSpinEdit

' Initialize the editors.
editorForCells = New RepositoryItemProgressBar()
editorForCells.Minimum = 0
editorForCells.Maximum = 100
editorForTotals = New RepositoryItemSpinEdit()
PivotGridControl1.RepositoryItems.AddRange(New RepositoryItem() _
    {editorForCells, editorForTotals})

' Provide editors for cells depending on cell types
Private Sub PivotGridControl1_CustomCellEdit(ByVal sender As System.Object, _
ByVal e As PivotCustomCellEditEventArgs) Handles PivotGridControl1.CustomCellEdit
    If e.DataField <> fieldQuantityPercent Then Return
    If e.RowValueType = PivotGridValueType.GrandTotal Then e.RepositoryItem = editorForTotals
    If e.RowValueType = PivotGridValueType.Value Then e.RepositoryItem = editorForCells
End Sub