The Pivot Grid control does not support data editing functionality out of the box because it displays aggregated data. This example demonstrates how to implement a custom CellTemplate with in-place editing functionality.
This example implements the base set of features. It does not allow users to go to the next cell by pressing the tab or arrow key.
The PivotGridEditHelper
class implements the in-place cell editor. When editing is finished, the editor calls the pivotGridControl1_OnCellEdit
method. This method retrieves the underlying data for the edited cell and recalculates cell values related to the edited cell (for example, Total and Grand Total values).
- MainWindow.xaml (VB: MainWindow.xaml)
- MainWindow.xaml.cs (VB: MainWindow.xaml.vb)
- PivotGridEditHelper.cs (VB: PivotGridEditHelper.vb)
(you will be redirected to DevExpress.com to submit your response)