Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Expand]Summarization
     Grouping
    [Expand]Sorting
    [Expand]Filtering
    [Collapse]Editing
      Cell Editors Overview
      Assigning Editors to Data Field's Cells
      Assigning Editors to Individual Cells
      Assigning Editors for In-place Editing
      Preventing Editors from Being Activated
     Data Formatting
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Cell Editors Overview

Pivot Grid Control cells do not support data editing by default, and only display summary values calculated against data fields. You can customize cell text by formatting values or dynamically handling the PivotGridControl.CustomCellDisplayText event.

In specific instances, you may need to change the way cell contents are presented on-screen (for instance, use progress bars to display values). You may also want to allow an end-user to modify cell contents by embedding in-place editors.

When an end-user edits a cell's value, the changes are not automatically saved to the underlying data source. You need to save these changes manually by handling the PivotGridControl.EditValueChanged event. Otherwise, the changes are lost once the cell loses focus.

Expanded Cell Editors Overview

You can assign in-place editors to cells to:

  1. replace cell values in display mode (when editing is inactive);
  2. allow an end-user to edit cells.

Pivot Grid Control cells can embed editors from the XtraEditors Library (descendants of the BaseEdit class). These include: ButtonEdit, DateEdit, CalcEdit, ProgressBarControl, LookUpEdit, etc.

The image below shows a sample PivotGridControl with different editors assigned to data fields. The CalcEdit and ProgressBarControl controls are used for in-place editing within cells corresponding to the first and second data fields (Extended Price and Percent of Column).

Note

Third-party editors cannot be embedded into cells.

Expanded Providing In-place Editors

Follow the steps below to assign in-place editors to cells:

  1. Create a repository item - a RepositoryItem class descendant that stores properties and events related to a specific editor. It contains all the information required for creating an editor. Refer to the Editors Class Structure.Editors Structure topic for more information.
  2. Add this item to the PivotGridControl.RepositoryItems collection that contains editors the current control can use.
  3. Assign the created repository item to the PivotGrid control using one of the approaches below.

The editor binding methods can be used in various combinations. This means you can provide editors for a data field and then override editor assignments for the particular cells of this field.

See Preventing Editors from Being Activated to learn how to prevent end-users from activating editors.

Expanded Saving Changes

When an end-user edits a cell's value, the changes are not automatically saved to the underlying data source. You need to save these changes manually by handling the PivotGridControl.EditValueChanged event. Otherwise, the changes are lost once the cell loses focus.

Expanded See Also

How would you rate this topic?​​​​​​​