Excel-like grid.

[Marco]

Hello,

We are testing the possibility of migrating our application to blazor

and we are trying to maintain the same user experience for data entry.

We would like to understand if in the future the DataGrid will be able to have same user experience as an excel-like grid.

Our goal is to be able to intercept the event of the "changed value" in a cell from user input "TAB or ENTER"

or by a programmatically background change (like the user case: "I click a button and change a cell value") and then:

- change another cell values,

- enable or disable editing of a cell in a row,

- place the focus(cell in edit state) in another desired cell,

- change backgrond of a cell/row,

by a c# function without refresh the entire grid.

...is it possible??? Or will it be possibile?

Best regards,

Marco

[Vignesh Natarajan]

Hi Marco,  

 

Thanks for contacting Syncfusion support.  

 

Yes, excel-like Grid can achieved using Batch editing feature of the Grid. Batch editing a cell based editing, where multiple cell from records can be edited and changes can saved on single click. Please find our below interpretation for your reference.  

 

Question: “programmatically background change (like the user case: "I click a button and change a cell value")” && “place the focus(cell in edit state) in another desired cell,” 

 

We understand that you want to edit the cell programmatically on a button click or external action. We suggest you to achieve your requirement EditCell method of Grid. Refer our API documentation for your reference 

 

https://help.syncfusion.com/cr/blazor/Syncfusion.Blazor.Grids.SfGrid-1.html#Syncfusion_Blazor_Grids_SfGrid_1_EditCell_System_Double_System_String_  

  

Question: “change another cell values,” 

 

We suspect that you want to update the another Cell Value without going into the edit state while editing one column. We can achieve your requirement using UpdateCell() method of Grid in the CellSaved event of the Grid.  

 

Refer the documentation link for your reference 

 

https://blazor.syncfusion.com/documentation/datagrid/events/#cellsaved  

https://help.syncfusion.com/cr/blazor/Syncfusion.Blazor.Grids.SfGrid-1.html#Syncfusion_Blazor_Grids_SfGrid_1_UpdateCell_System_Double_System_String_System_Object_  

  

Question: “enable or disable editing of a cell in a row” 

 

Yes, we can achieve your requirement using OnCellEdit event of Grid. This event will be triggered when cell goes into the edit mode. In the event argument we can get the current row details, based on that we can disable default action using Cancel property of event argument.  

 

https://blazor.syncfusion.com/documentation/datagrid/events/#oncelledit     

 

Question: “change backgrond of a cell/row,” 

 

We have already discussed this topic in our UG documentation which can be referred from below  

 

https://blazor.syncfusion.com/documentation/datagrid/cell/#customize-cell-styles  

 

Please get back to us if you have further queries.  

 

Regards, 

Vignesh Natarajan