Filter in Edit Mode Question

[jimf]

Does edit mode force updated rows to be clustered together in the worksheet?. For example, when I filter my worksheet, go into edit mode, update 10 rows, unless those 10 rows are contiguous (rows next to each other), the add-in does not update them - it updates the first cluster of rows, and leaves the others in edited color, but does not update them. Is expected behavior?

[Shalex]

Please specify (here or via contact form) the following information:

1) the exact steps you perform to filter your worksheet

2) in the Devart tab of your Excel book, press Options > Edit > Error Handling and select the "Show SQL" option. After this, try to "update 10 rows" again and specify the SQL statements generated

3) describe your environment with the help of the Devart tab > About > Copy Info