Cells content is not committed to the DataTable until the row is changed

Cells content is not committed to the DataTable until the row is changed

Posted by: dgiustina on 23 July 2025, 5:44 am EST

• 

  dgiustina

  • Post Options:
  • Link
    Copy

  Posted 23 July 2025, 5:44 am EST

  I have a Spread with the DataSource bind to a DataTable.
  
  Initially, the table does not contain any data. A DataRow is then added to the table and a new row appears in the grid. After entering the data, the value of the cells is not committed to the DataTable until a new row is selected.
  
  However, in my case, I do not need to add/select other rows and would like the data to be committed immediately after a cell has finished editing.

  How can I obtain this?

  Thanks.

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 23 July 2025, 7:38 am EST - Updated 23 July 2025, 7:43 am EST

  Hi Davide,

  Thanks for the information.

  We created a sample application based on the details provided by you. However, we could not replicate the behavior on our end. Kindly check the following GIF to see the behavior on our end:

  

  We kindly request you update the attached sample so that we can replicate the issue on our end and provide you with a more specific solution.

  Thanks & regards,
  
  Aastha

• 

  dgiustina

  • Post Options:
  • Link
    Copy

  Posted 23 July 2025, 9:47 am EST

  It’s very strange, in any case I found a solution calling: this.BindingContext[CertificationHeaders].EndCurrentEdit();
  
  (CertificationHeaders is the name of the bind DataTable) before saving.
  
  In this way the data source is always updated.

  Thanks.

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 24 July 2025, 12:44 am EST

  Hi Davide,

  Thanks for the update.

  We are glad to hear that you found a workaround for your use-case. This approach ensures that any pending cell edits are committed to the DataTable before saving.

  Thanks & regards,
  
  Aastha