Imported from UserVoice
Author: A
It seems that currently only Google Sheets allows you to copy non-contiguous cells, i.e., cells between rows hidden by table filters, to visible cells in another column of the same table that also has filters. (In other words, it copies and pastes into the portions visible to the user in the filtered table and not into the hidden rows.)
Thank you for the suggestion. You’re right that Google Sheets handles paste into filtered ranges differently — it skips hidden rows and pastes only into visible cells, while most other spreadsheet applications (including ONLYOFFICE and MS Excel) paste into all rows regardless of the filter.
We have this on our enhancement list for review(track number - 57542).
We’ll update the thread once there’s progress.