Mashup Builder > Widgets > Advanced Grids > Cell Editing in Advanced Grids
Cell Editing in Advanced Grids
You can edit cells using the IsEditable and EnableEditButtons properties and the methods described in the list that follows.
* 
You can set only one property at a time for cell editing.
IsEditable – Cell editing is available for all supporting renderers by setting the IsEditable property to true in the Mashup Builder configuration or through JSON configuration. When you set IsEditable, EditedTable property becomes available to bind the changed rows to a service. If you set these two properties, the grid is in edit mode by default and no edit buttons are available. You can use your own mashup edit buttons to put the grid in edit mode by binding the click events to a service, which would switch on or off edit mode.
When you set the IsEditable property, the following events are available:
EditCellStarted Event is triggered when you click on a cell to start editing.
EditCellCompleted Event is triggered when you edit a cell and press ENTER, press TAB, or click outside of the cell
EnableEditButtons property – You can set the EnableEditButtons property instead of the IsEditable property. If you set this property to true, a set of edit toolbar buttons appear in the grid. You can position these buttons with the EditButtonsLocation settings to top left or right or bottom left or right. The end user can then save the edits by clicking Edit followed by Save or Cancel.
See the images below to find Edit at the top right of the infotable.
When you activate Edit, the following events are available :
EditStarted - when you click Edit to start editing.
EditCompleted - when you click Save.
EditCancelled - when you click Cancel.
Edits are done per cell by clicking on the cell to see the raw unformatted value. A cell editor appears in which you can make changes. The cell renderer is applied to format the value in its display format.
* 
Press the ESC to leave the cell unchanged with its original value.
Selection of type of cell editor is done in the Mashup Builder in the Cell Editing Options table in the column configuration when the column is set to Editable.
Was this helpful?