Contents that are stored on the clipboard can be pasted into your document using different formats. In LibreOffice you can choose how to paste the contents using a dialog or a drop-down icon.
The available options depend on the contents of the clipboard.
In Writer text documents, you can press Command+OptionCtrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text.
Click the arrow next to the \<emph\>Paste\</emph\> icon on the Standard Bar to open the menu.
Select one of the options.
If you do not like the result, click the \<emph\>Undo\</emph\> icon and then paste again with another option.
Choose \<emph\>Edit - Paste special\</emph\>.
Select one of the options and click \<emph\>OK\</emph\>.
If you are in a spreadsheet and the contents of the clipboard are spreadsheet cells, then a different \<emph\>Paste Special\</emph\> dialog appears. Use the \<emph\>Paste Special\</emph\> dialog to copy cells using basic or advanced options.
\<emph\>Transpose\</emph\>: swaps the rows and the columns of the cell range to be pasted.
\<emph\>Link\</emph\>: pastes the cell range as a link. If the source file changes, the pasted cells change also.
The other options are explained in the help, when you call the Paste Special dialog from within LibreOffice Calc.