CellEditSettings

16 Mar 20264 minutes to read

Allow options for performing CRUD operations, such as add, edit, delete, and update the raw items of any cell from the pivot table.
The raw items can be viewed in a data grid that used to be displayed as a dialog by double-clicking the appropriate value cell in the pivot table.
CRUD operations can be performed in this data grid either by double-clicking the cells or using toolbar options.
The options available are as follows:

• allowAdding: Allows to add a new record to the data grid used to update the appropriate cells in the pivot table.
• allowEditing: Allows to edit the existing record in the data grid that used to update the appropriate cells in the pivot table.
• allowDeleting: Allows to delete the existing record from the data grid that used to update the appropriate cells in the pivot table.
• allowCommandColumns: Allows an additional column appended in the data grid layout holds the command buttons to perform the CRUD operations to edit,
  delete, and update the raw items to the data grid that used to update the appropriate cells in the pivot table.
• mode: Allow options for performing CRUD operations with different modes in the data grid that used to update the appropriate cells in the pivot table.
  The available modes are normal, batch and dialog. Normal mode is enabled for CRUD operations in the data grid by default.
• allowEditOnDblClick: Allows to restrict CRUD operations by double-clicking the appropriate value cell in the pivot table.
• showConfirmDialog: Allows to show the confirmation dialog to save and discard CRUD operations performed in the data grid that used to update the appropriate cells in the pivot table.
• showDeleteConfirmDialog: Allows to show the confirmation dialog to delete any records from the data grid.

  This feature is applicable only for the relational data source.
  See the editing section in the Pivot Table documentation for implementation details.

Properties

allowAdding boolean

Allows to add a new record to the data grid used to update the appropriate cells in the pivot table.

Defaults to false

allowCommandColumns boolean

Allows an additional column appended in the data grid layout holds the command buttons to perform the CRUD operations to edit, delete, and update the raw items to the data grid that used to update the appropriate cells in the pivot table.

Defaults to false

allowDeleting boolean

Allows to delete the existing record from the data grid that used to update the appropriate cells in the pivot table.

Defaults to false

allowEditOnDblClick boolean

Allows to restrict CRUD operations by double-clicking the appropriate value cell in the pivot table.

Defaults to true

allowEditing boolean

Allows to edit the existing record in the data grid that used to update the appropriate cells in the pivot table.

Defaults to false

allowInlineEditing boolean

Allows direct editing of a value cell without opening the edit dialog. NOTE: It is applicable only if the value cell is made by a single raw data. Otherwise editing dialog will be shown.

The allowInlineEditing property supports all modes of editing.

Defaults to false

mode EditMode

Allow options for performing CRUD operations with different modes in the data grid that used to update the appropriate cells in the pivot table.
The available modes are as follows:

• Normal: Allows the currently selected row alone will be completely changed to edit state. It is possible to change the cell values and save it to the data source by clicking “Update” toolbar button.
• Dialog: Allows the currently selected row data will be shown in an exclusive dialog. It is possible to change the cell values and save it to the data source by clicking “Save” button in the dialog.
• Batch: Allows to perform double-click on any data specific cell in the data grid, the state of that selected cell will be changed to edit state.
  It is possible to perform bulk changes like add, edit and delete data of the cells and finally save to the data source by clicking “Update” toolbar button.

Defaults to Normal

showConfirmDialog boolean

Allows to show the confirmation dialog to save and discard CRUD operations performed in the data grid that used to update the appropriate cells in the pivot table.

To use this option, it requires {@link CellEditSettings.mode} is Batch, meaning, the showConfirmDialog option is only applicable for Batch edit mode.

Defaults to true

showDeleteConfirmDialog boolean

Allows to show the confirmation dialog to delete any records from the data grid.

The showDeleteConfirmDialog property supports all modes of editing.

Defaults to false