PivotGridControl.CustomEditValue Event

The event handler receives an argument of type CustomEditValueEventArgs containing data related to this event.

The CustomEditValue event occurs for each data cell that has an in-place editor assigned to it. This event raises each time the cell is repainted, allowing you to change its value. To specify a custom cell value, use the event parameter's CustomEditValueEventArgs.Value property. This property initially contains a summary value calculated for this cell.

To assign an editor to a cell, use the PivotGridField.FieldEdit property, or handle the CustomCellEdit event.

Use the following properties to identify the edited cell:

• The DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.ColumnField, DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.RowField and DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.DataField properties return column, row and data fields related to the current cell.
• The DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.ColumnIndex and DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.RowIndex properties return the zero-based index of the cell's column or row. Note that the index is calculated based on visible rows or columns, thus collapsed and expanded rows/columns have different indexes.
• The DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.ColumnValueType and DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.RowValueType properties return column adn row types.
• If the current cell is a custom total cell, the DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.ColumnCustomTotal and DevExpress.XtraPivotGrid.PivotCellEventArgsBase<TField, TData, TCustomTotal>.RowCustomTotal properties return column and row custom totals. Otherwise, these properties return null (Nothing in Visual Basic).

In the following example, the Percents of the Columns field's cells display the percentage of the column total value. Cell values are in the range from 0 to 1. The progress bar visualizes the percentage value. The CustomEditValue event handler translates the 0 to 1 range values to the 0 to 100 range that is acceptable for the progress bar.

private void pivotGridControl_CustomEditValue(object sender, CustomEditValueEventArgs e) {
    if(e.DataField == fieldPercents)
        // e.Value = 0.1502539532880652 (before) 
        e.Value = Convert.ToDouble(e.Value) * 100f;
        // e.Value = 15 (after) 
}

The image below shows the result: