Started using Gnumeric as a spreadsheet alternative. While I could get a hang of many Gnumeric features (and visual/UX differences compared to a commercial spreadsheet tool from Windows world), one thing that has me stumped is what is the right way to copy a bunch of rows that are visible on one worksheet, that are a result of having applied filter on a specific column value, into another separate (empty) worksheet. If I copy one row and small set of continuous cells in a row, and paste into another worksheet it works fine. However if I try to copy multiple rows (or all visible rows) that are a subset of the total number of non-null rows, thanks to a filter rule being applied on a particular column’s values, the copy and paste is broken. The copy seems to copy absolutely all of the rows i.e. including rows that are filtered out, and were not visible at the time of copy, s.t. pasting into the new worksheet, absolutely all of the original set of rows are copied, and not just the filtered/visible ones. What gives ? Is there a way I can have the desired copy-paste behaviour ?