3 ms·
I've just tried that row copying activity myself in LibreOffice, and it's behaving the same as you describe for Excel - row 1 copied to 5, row 3 copied to 6. I
by CmdrKrool 7y ago
I've just tried that row copying activity myself in LibreOffice, and it's behaving the same as you describe for Excel - row 1 copied to 5, row 3 copied to 6.
I selected the rows by clicking the row numbers (while holding Ctrl for the second one), and the version is 6.3.3.2.0, FWIW (I'm on Arch Linux so I suppose this is right up to date).
- tzs 7y agoI've got 6.3.3.2 on a Mac. I was selecting by just selecting the four columns in row 1 by clicking and holding on 1 while dragging to 4 and releasing, then doing the same thing with row 3 while holding the command key down which is how you do non-contiguous selection on Mac, then clicking on column 1 of row 5, and doing paste. I just tried it with clicking the row number, to do whole row selection. So click the number for row 1, then command-click the number for row 3. Then I clicked the first cell in row 5 and hit paste. Same result as I got before...just row 1 copies. I also tried it where I clicked the row number for 5, to select the whole row, before pasting, and no difference. Good to see that it is working better on Linux. That probably suggests this is just a bug in their Mac port rather than intentional behavior.
- CmdrKrool 7y agoYeah, if I select the cells in the way you just described then I get both the rows copied, again. It does sound like something in the Mac port. Certainly I would find that an annoying behaviour if I saw it. Tangentially, and perhaps weirdly, if the ranges I select don't span the same columns - eg. if I select A1:B1 and C3:D3, a dialog box pops up upon Copy which says "This function cannot be used with multiple selections". Even though the ranges are still the same size. That seems undesirable, to me.
- chopin 7y agoWorks as well in version 5.1.6.2 on Linux Mint.