Cell with pending changes are lost when you leave the spreadsheet control

Posted by: pianoman1962 on 8 September 2017, 2:11 pm EST

  • Posted 8 September 2017, 2:11 pm EST

    I'm using FarPoint.Win.Spread version 2.5.2015.2005.  I have a custom control that contains a spreadsheet control and a text box. When I type into a cell then directly click into the text box the pending change is lost.  If I click on another cell or press enter the pending edit is saved.

     I'm looking at using the Leave event which fires but I cannot determine determine how to force the pending edit to the active cell.  I have tried calling StopCellEditing() and setting EditMode = false.  Any advice?

  • Replied 8 September 2017, 2:11 pm EST


    I replicated your issue and you can force the pending changes by calling the EndEdit() on each DataRow object and then update the dataTable accordingly.

    Please check the attachment for the sample.

  • Replied 8 September 2017, 2:11 pm EST

    I'm using the control in an unbound fashion; so your proposed solution doesn't work. Any other suggestions?
  • Replied 8 September 2017, 2:11 pm EST


    I am not able to replicate the issue at my end as when i write something in the cell and then click into the textbox, all the pending changes in the active cell are being saved. The changes persist. This is the default behaviour that we are seeing.

    Please check the attachment for the sample. And if this doesn't help can you please tell us what you are actually trying to do and if possible please share a zipped sample with us to debug the issue at our end.


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels