Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Paste Special

Inserts the contents of the clipboard into the current file in a format that you can specify.

Paste Unformatted Text

Paste only the text contents, without any formatting.

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 formulae 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.

Paste Nested Table

Paste clipboard content (including native tables or tables copied from Calc or other spreadsheets) as nested tables in empty cells and at cell starting cursor position.

Paste as Row Above

Insert clipboard table data in a table as new rows instead of overwriting the content of the original cells of the target table.

Paste as Column Before

Insert clipboard table data in a table as new columns before instead of overwriting the content of the original cells of the target table.

Paste Special

Inserts the contents of the clipboard into the current file in a format that you can specify.