Greetings.
I’ve been trying to copy non-adjacent rows from one sheet to another where I need them adjacent.
I know this is possible to do in Excel, so I was wondering if there’s a way to do this with LibreOffice.
In resume: I select 10 non-adjacent rows on sheet 1, Ctrl+C, select 10 rows on sheet 2 and paste de contents from sheet 1.
I’ve tried several options with Special Paste, but to no avail.
Any suggestions?
Regards.
You can do that with filtered rows.
Thanks, @Villeroy.
That’s a bit more complicated than just a simple copy+paste with row selection on sheet 2, but it worked.
I found that you don’t need to mark columns. Just a quick filter on the column and selecting the desired rows from the filter down arrow.
It’s not an intuitive solution, which I think a bit odd for something that should be simple, but I hope this helps others like me that made the switch to LibreOffice and will never look back again.
If you are using Windows then you need to turn off Clipboard History.
Click Start menu - Settings - System - Clipboard and turn off clipboard history
its the default on copy multible ranges and paste
see attached
130475.ods (14.3 KB)
select the »green« ranges, copy it, and paste it into the next sheet into A1
Version: 25.8.4.2 (AARCH64) / LibreOffice Community
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded