when i hide some rows and do drag and paste operation. hidden rows also getting updated with the dragged col value.
Drag and paste on hidden rows
This is correct behavior, as autofill plugin operates on physical indexes, and hiding rows works only on visual level of rows indexes, that’s why the data gets updated even if the rows are hidden.
Any resolution for this?
Hi
There’s a workaround for this. You can check if a row is hidden to avoid changing the values inside it, like here:
1 Like