Copy Paste Error


While copying from 1 sheet to another sheet - If I select alternative cells (1st cell, 3rd cell, 5th cell) it will copy only 1st cell content.

OS: lubuntu - 20.04

Please help me to solve this issue.

Thanks in advance.

Lokesh Kamath

The copy function work with multiple selection, provided that:

  • they all start at the same column and are the same width (with rows between selections, but with no spaces in each row), or
  • they all start in the same row and are the same height (with columns between selections, but with no spaces in each column).

image description

When you Paste, empty rows/columns in between will colapse.

If do you Paste Unformatted Text¹ (Ctrl+Shift+Alt+V) you will get the first row (if data are selected by rows), or the Text Import dialog (if data are selected by columns).

¹ Most probably, this is your case.

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.