Paste Special /text/shared/01/pastespecialmenu.xhp

Paste Special

Inserts the contents of the clipboard into the current file in a format that you can specify.
paste special;only text (spreadsheet) paste special;only numbers (spreadsheet) paste special;only formula (spreadsheet)

Paste Only Text

Paste clipboard text contents only. Numeric and formula values are not pasted and their destination cells contents are deleted.

Paste Only Numbers

Paste clipboard numeric contents only. Text and formulas are not pasted and their destination cells contents are deleted.

Paste Only Formula

Paste clipboard formula contents only. Text and numeric values are not pasted and their destination cells contents are deleted.