Suresh3594
New Member
- Joined
- Jul 5, 2017
- Messages
- 7
Hi,
I have a tables which has bunch of data which is bound to a list-object data-source, Data-source is List<My-class>. I am using WorkSheet.Change event to handle edits. Say if a cell in second row was edited, in Change event, I am checking for the row number of target and then access the item in data-source using row number as index. But when sort is applied on the table, my data-source doesn't reflect the sort order of the table. Next time when I try to edit say 3rd row, getting item from data-source using row number fails( by fails, I mean that it retrieves wrong item).
Can anyone please help me on this?
I have a tables which has bunch of data which is bound to a list-object data-source, Data-source is List<My-class>. I am using WorkSheet.Change event to handle edits. Say if a cell in second row was edited, in Change event, I am checking for the row number of target and then access the item in data-source using row number as index. But when sort is applied on the table, my data-source doesn't reflect the sort order of the table. Next time when I try to edit say 3rd row, getting item from data-source using row number fails( by fails, I mean that it retrieves wrong item).
Can anyone please help me on this?