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.