Ask Your Question

paste data, NOT formats, into LO?

asked 2018-03-03 12:54:37 +0100

nic gravatar image

I copy a paragraph from a word doc into Writer OR I copy a cell from excel into Calc. When I paste, the [unwanted] parent formatting is pasted as well - can the child document be set so that this is avoided without the need to paste special every time?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-03-05 13:10:21 +0100

m.a.riosv gravatar image

In calc unformatted past is on the right arrow of paste bottom.

image description

edit flag offensive delete link more


Or on Shift+Ctrl+V

erAck gravatar imageerAck ( 2018-03-05 17:25:19 +0100 )edit

I already use Shift+Ctrl+V. Although a useful comment, Q was really whether the child document could be set [default formatted] to receive pasted data unformatted - looks like the answer is no.

nic gravatar imagenic ( 2018-03-07 19:26:58 +0100 )edit

answered 2018-03-04 12:34:28 +0100

nic gravatar image

updated 2018-03-05 12:03:57 +0100

Thanks: I count this as 'answered' for me because I'm operating on 14.04 and Synaptic tells me that LO 1:4.2.8-0ubuntu5.3 is the 'Latest Version' and so 'Paste Unformatted Text' shows as a valid option in the Function List, but I hit a snag on this as 'Paste Unformatted Text' ONLY shows as a valid option in the Function List IN WRITER - very strangely it is absent as an option in CALC.

Although not a direct answer to the Q, for my purposes, Ctrl+Alt+Shift+V from Jim K's links is also a solution [but only in Writer].

However I appreciate that this question may not be 'answered' for users of etc

edit flag offensive delete link more


Should be not so easy find people answering question here using 4.2 version LibreOffice Release Plan

m.a.riosv gravatar imagem.a.riosv ( 2018-03-05 13:07:39 +0100 )edit

@nic: Good additional information. To close out the question, please click the ✔ next to an answer. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-03-05 14:35:41 +0100 )edit

Can't tick my own answer - not enough points.

nic gravatar imagenic ( 2018-03-07 19:11:53 +0100 )edit

m.a.riosv: thanks for the useful link. Q [not for this forum!] is why Synaptic in 14.04 says LO 1:4.2.8-0ubuntu5.3 is the 'Latest Version'. I am very reluctant to take anything until Ubuntu has cleared it and put in Synaptic after having lost many days of work to a bug in Calc a few years ago. Perhaps LTS on 14.04 doesn't extend to versions of LO?

nic gravatar imagenic ( 2018-03-07 19:47:29 +0100 )edit

answered 2018-03-03 18:37:33 +0100

Jim K gravatar image

updated 2018-03-03 18:40:17 +0100

The preferred solution seems to be from

Tools -> Customize. On the Keyboard tab choose the category Edit and scroll through the Function list to Past Unformatted Text.

However, I no longer see this function in the list (tested LO and AOO 4.1.3).

So instead, use the macro at

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-03 12:54:37 +0100

Seen: 148 times

Last updated: Mar 05 '18