Filtered rows in the middle are also being copied
Closed this issue · 3 comments
For example, if there are 4 rows of data and rows 2 and 3 are filtered out, then copying data to rows 1 and 2 results in rows 2 and 3 (which are filtered out) also getting the copied data. However, if the copy is done by dragging down from the first row, rows 2 and 3 (which are filtered out) do not get the copied data.
hey, thanks for reporting this. i wont be able to have a look for the next few days, but i will get back to you after verifying the same actions in google sheets.
ok so i had a look at google sheets, the behaviour when the values are dragged down is correct but the copy/paste operation should not be pasting the values in the filtered out rows. is this your expectation aswell?
ok so i had a look at google sheets, the behaviour when the values are dragged down is correct but the copy/paste operation should not be pasting the values in the filtered out rows. is this your expectation aswell?
yes