SetCellValue function doesn't add changes to batch changes

I used SetCellValue to set cell value programmatically, but if I add value not by using grid interface the applied changes do not appear in getBatchChanges.

Small context:

     Loaded grid can be edited. On every cell edit i'm looping through grids currentViewData and i'm using some logic while comparing currentViewData values. But there's the issue. If I edit cell by using grid interface, the changes are added to getBatchChanges() changedRecords, but it's not added in currentViewData. So in order to have newly edited data in currentViewData I tried to apply SetCellValue() function. By using this function new data appears in currentViewData but it doens't add it to batchChanges. 

Hi Domantas, 

 

Greetings from Syncfusion. 

 

Query: How to have cell changes either in currentViewData and in batchChanges assuming that I need to loop through edited data and save batchChanges to database later on 

 

We have analyzed your query and we suggest to use the updateCell method of the editModule to update the grid cells programmatically. By using this method you will be able to get the batch changes from getBatchChanges method for later update to the database since it acts as a actual batch cell edit. Using setCellValue method directly updates the cell value in the dataSource thus the changes will not be available in the getBatchChanges method but available in the currentViewData. Please refer to the below sample and documentation for your reference, 

 

Code Example:  

 

[.ts] 

 

Sample: https://stackblitz.com/edit/angular-mfjyfs-2po1h3?file=batch-editing.component.ts  

 

Documentation: https://ej2.syncfusion.com/documentation/api/grid/edit/#updatecell  

 

Please get back to us for further assistance. 

 

Regards,  

Pavithra S.   

Thank you for your answer, but that did not quite answer my question.

You're suggesting me use one or another, but what I need is to have correct values in BOTH either in currentData and batchChanges.

Different uses gives data to different places but not in both:

1. If I use setCellValue() I get data in currentViewData but don't get it in getBatchChanges()

2. If I use editModule.updateCell() I get data in getBatchChanges() but I don't get data either in currentViewData or getCurrentViewRecords()

Hi Domantas, 

 

Greetings from Syncfusion. 

 

Query: How to have cell changes in both places: currentData for looping new data, and in batchChanges for database saving 

 

We have analyzed your query and currentViewData is updated with new values only when the records are saved. So we suggest to use the dataBound event to get the currentViewData with new values and we have saved the batchChanges after updating the cell values. Please refer to the below sample for your reference, 

 

Code Example:  

 

[.ts] 

 

Documentation: https://ej2.syncfusion.com/angular/documentation/api/grid#databound  

 

Sample               : https://stackblitz.com/edit/angular-mfjyfs-u9x75j?file=batch-editing.component.ts  

 

Please get back to us for further assistance. 

  

Regards,  

Pavithra S 

So from that what you've said, it is not possible to have the changes in batch change and in currentViewData without copying to another variable and updating. Alright. I could work with this, but this acts differently with remote data. 

Example: 

I've prepared example from your demo with remote data loading. You can see in the example, that when I hit batchSave after updating the cell, the grid calls http post and tries to save them there, but it fails cause there is no such option. So not that it did not save data with link, but also it did not renew my currentViewData to work with.

Hi Domantas, 

Greetings from Syncfusion. 

Query: How to not call url post on batchSave() but add edited data to currentViewData 

 

We have analyzed your query and we suggest to use the getRowsObject method to get the current and changed records as per your requirement. In the below sample, after a cell is edited with a value, we have got the batch changes by using getBatchChanges method and we have created a variable to store the custom current view data from the getRowsObject method which has the updated cell values too. In the below work around we have not called the batchSave method, so the request will not be triggered until you do so. Please refer to the below sample for your reference, 

Code Example:  

[.ts] 

 

Sample: https://stackblitz.com/edit/angular-6mdnnf-8xgwfy?file=remote-data.component.ts  

 

Please get back to us for further assistance. 

 

Regards, 

Pavithra S.