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

PivotViewCellEditSettings

Namespace: Syncfusion.Blazor.PivotView

Assembly: Syncfusion.Blazor.dll

Syntax

public class PivotViewCellEditSettings : OwningComponentBase

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
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
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
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
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
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
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
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
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
System.Boolean

Methods

Dispose()

Dispose the unmanaged resources.

Declaration

public virtual void Dispose()

Dispose(Boolean)

Dispose unmanaged resources in the component.

Declaration

protected override void Dispose(bool disposing)

Parameters

Type	Name	Description
System.Boolean	disposing	Boolean value to dispose the object.

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.

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.