Class PivotViewCellEditSettings

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 you to add a new record to the data grid used to update the appropriate cells in the pivot table. AllowEditing: Allows you to edit the existing record in the data grid that used to update the appropriate cells in the pivot table. AllowDeleting: Allows you 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 you to restrict CRUD operations by double-clicking the appropriate value cell in the pivot table. ShowConfirmDialog: Allows you 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 you to show the confirmation dialog to delete any records from the data grid.

Inheritance
System.Object
Syncfusion.Blazor.SfBaseComponent
SfDataBoundComponent
PivotViewCellEditSettings
Inherited Members
Namespace: Syncfusion.Blazor.PivotView
Assembly: Syncfusion.Blazor.dll
Syntax
public class PivotViewCellEditSettings : SfDataBoundComponent

Constructors

PivotViewCellEditSettings()

Declaration
public PivotViewCellEditSettings()

Properties

AllowAdding

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

Declaration
public bool AllowAdding { get; set; }
Property Value
Type Description
System.Boolean

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.

Declaration
public bool AllowCommandColumns { get; set; }
Property Value
Type Description
System.Boolean

AllowDeleting

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

Declaration
public bool AllowDeleting { get; set; }
Property Value
Type Description
System.Boolean

AllowEditing

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

Declaration
public bool AllowEditing { get; set; }
Property Value
Type Description
System.Boolean

AllowEditOnDblClick

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

Declaration
public bool AllowEditOnDblClick { get; set; }
Property Value
Type Description
System.Boolean

AllowInlineEditing

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.

Declaration
public bool AllowInlineEditing { get; set; }
Property Value
Type Description
System.Boolean

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 as follows: Normal: Allows the currently selected row alone will be completely changed to edit state. You can 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. You can change the cell values and save it to the data source by clicking “Save” button in the dialog. Batch: Allows you 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. You can perform bulk changes like add, edit and delete data of the cells and finally save to the data source by clicking “Update” toolbar button.

Declaration
public EditMode Mode { get; set; }
Property Value
Type Description
EditMode

ShowConfirmDialog

Allows you to show a 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 the property Mode to be Batch, meaning, the showConfirmDialog option is only applicable for batch edit mode.

Declaration
public bool ShowConfirmDialog { get; set; }
Property Value
Type Description
System.Boolean

ShowDeleteConfirmDialog

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

The ShowDeleteConfirmDialog property supports all modes of editing.

Declaration
public bool ShowDeleteConfirmDialog { get; set; }
Property Value
Type Description
System.Boolean

Methods

OnInitializedAsync()

Method invoked when the component is ready to start, having received its initial parameters from its parent in the render tree. Override this method if you will perform an asynchronous operation and want the component to refresh when that operation is completed.

Declaration
protected override Task OnInitializedAsync()
Returns
Type Description
System.Threading.Tasks.Task

A System.Threading.Tasks.Task representing any asynchronous operation.
Overrides

OnParametersSetAsync()

Method invoked when the component has received parameters from its parent in the render tree, and the incoming values have been assigned to properties.

Declaration
protected override Task OnParametersSetAsync()
Returns
Type Description
System.Threading.Tasks.Task

A System.Threading.Tasks.Task representing any asynchronous operation.
Overrides