Ask Your Question

Pasting multiple fields into one field

asked 2019-02-18 19:01:29 +0100

Tomasz gravatar image

in LibreOffice Calc when I try to copy multiple fields from one column and paste them elsewhere, instead of pasting multiple fields -> multiple fields all my data is pasted into one field with spaces in between.

On the image below I selected fields A1, A2, A3 and wanted to copy them into A5 - A7. Instead, it results in all data of the fields being pasted into A5. How can I fix this?

The first time after I open LibreOffice Calc when I paste the copied fields they actually get pasted normally, into multiple rows. Every next copy-paste results in them being put into one field.

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-18 19:23:16 +0100

Opaque gravatar image

Hi, I never have experienced such a strange behavior, and the only idea that comes into my mind is, that the clipboard on your system is not working correctly (if you use Linux, try to delete the clibboard cache).

edit flag offensive delete link more


Some 3rd-party clipboard destroyer (aka "manager") is the most likely reason for such behaviour.

erAck gravatar imageerAck ( 2019-02-18 21:33:39 +0100 )edit

Thanks! I managed to fix it in the end. I had Parcellite installed, but not running at the time.

The track was correct. The clipboard was clearly the problem. Just checked each software/extension that I have, that could influence my clipboard behavior.

I think it most likely was a plugin for Anki flashcards software, where it would create new flashcards automatically if I had the correct format of data in my clipboard: After closing Anki, things seem to have returned to normal. Not 100% sure though.

Tomasz gravatar imageTomasz ( 2019-02-19 09:26:34 +0100 )edit

Please click the check mark to mark the answer as correct. Thanks.

erAck gravatar imageerAck ( 2019-02-19 12:46:41 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-18 19:01:29 +0100

Seen: 109 times

Last updated: Feb 18 '19