- Use sample attachment 183258 [details] from bug 151752. - Select A4-A6 - Edit-Select-Select Visible Rows - Try to copy and paste Select Visible Rows works for rows, not select in a range. This is enhancement request to make possible copy of visible cells from a selected range. (MSO can select with a shortcut or Find-Special-Visible or Select Visible Cells command or add-on. There is a difference if pasted consecutively or in original positions.)
This is definitely needed. There's no way to copy only the visible cells from a range of cells. Setting to NEW.
There is an extension that do that. https://extensions.libreoffice.org/en/extensions/show/copy-only-visible-cells