Editing Values in Windows Forms Pivot Grid

Pivot grid provides support to edit the values of both value cells and total cells. This support is useful when users need to edit the cell values at run time and save their changes to the underlying data source, thereby the changes will be reflected in the total cells based on the modified data.

Editing value cells

Value cells can be edited by enabling the EnableValueEditing property of pivot grid control. While handling the editing operations, the modified values will be calculated and automatically reflected in the total cell values.

Refer to the below code sample to enable editing in total cells of pivot grid.

this.pivotGrid1.EnableValueEditing = true;
Me.pivotGrid1.EnableValueEditing = True

Editing-Values_img1

Editing total cells

Values of total cells can also be edited by using the AllowEditingOfTotalCells property of EditManager.

Refer to the below code sample to enable editing in total cells of pivot grid.

this.pivotGrid1.EnableValueEditing = true;
this.pivotGridControl1.EditManager.AllowEditingOfTotalCells = true;
To enable editing in the pivot grid control.
Me.pivotGrid1.EnableValueEditing = True
Me.pivotGrid1.EditManager.AllowEditingOfTotalCells = True

Editing-Values_img2

Customizing editing using custom editing manager

After editing the value, we can further customize the edited value through custom editing manager. The custom editing manager is used to format the value using the pivot cell information.

To customize the default editing, a class need to be created by deriving the PivotEditingManager class. Then, override the ChangeValue method in the derived class to customize the edited value as per your requirement.

Refer to the below code sample to append * symbol in the end of edited values using custom editing manager.

public partial class Form1 : Form
{
    public Form1()
    {
        ......
        this.pivotGridControl1.EditManager = new CustomEditingManager(this.pivotGridControl1.TableControl);
        ......
    }
}

public class CustomEditingManager : PivotEditingManager
{
    public CustomEditingManager(PivotGridControlBase pivotGridControlBase) : base(pivotGridControlBase)
    {
    }

    protected override void ChangeValue(object oldValue, object newValue, int row1, int col1, PivotCellInfo pi)
    {
        //do the base change
        base.ChangeValue(oldValue, newValue, row1, col1, pi);
        //mark all the adjusted cell contents
        pi.FormattedText += "*";
    }
}
Partial Public Class Form1
    Inherits Form
    Public Sub New()
        ......
        Me.pivotGridControl1.EditManager = New CustomEditingManager(Me.pivotGridControl1.TableControl)
        ......
    End Sub
End Class

Public Class CustomEditingManager
    Inherits PivotEditingManager
    Public Sub New(ByVal pivotGridControlBase As PivotGridControlBase)
        MyBase.New(pivotGridControlBase)
    End Sub

    Protected Overrides Sub ChangeValue(ByVal oldValue As Object, ByVal newValue As Object, ByVal row1 As Integer, ByVal col1 As Integer, ByVal pi As PivotCellInfo)
        'do the base change
        MyBase.ChangeValue(oldValue, newValue, row1, col1, pi)
        'mark all the adjusted cell contents
        pi.FormattedText &= "*"
    End Sub
End Class

Editing-Values_img3

A demo sample is available in the following location.

<Installed Drive>\Users\Public\Documents\Syncfusion\Windows\<Version Number>\PivotGrid.Windows\Samples\Interactive Features\Editing Demo