Posted 8 September 2017, 1:34 pm EST
I have a spread bound to a dataTable. My problem is that the rowState of a row is not set to Modified when I make changes in a cell, neither if I move to another cell. It seems I have to move to another row for the edited row to be marked Modified. I need to check this flag and I execute the following code:
Dim dt As DataTable
ForEach aRow In dt.Rows
IfaRow.RowState = DataRowState.Modified Then
This if statement doesn't seem to execute its code if I only make a change in one cell. I thought the above EndEdit code should fix this, but is there anything else smart that I have overlooked?