paste data, NOT formats, into LO? [closed]

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

nic
26 ●8 ●13 ●15

updated 2020-07-25 20:21:58 +0100

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-25 20:22:10.459438

add a comment

1

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

m.a.riosv

25744 ●7 ●53 ●139

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

image description

edit flag offensive delete link

Comments

Or on Shift+Ctrl+V

erAck ( 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 ( 2018-03-07 19:26:58 +0100 )edit

add a comment

0

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

Jim K

3811 ●7 ●26 ●53

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

The preferred solution seems to be from https://forum.openoffice.org/en/forum...:

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 5.4.3.2 and AOO 4.1.3).

So instead, use the macro at https://ask.libreoffice.org/en/questi....

edit flag offensive delete link

add a comment

0

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

nic
26 ●8 ●13 ●15

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 5.4.3.2 etc

edit flag offensive delete link

Comments

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

m.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 ( 2018-03-05 14:35:41 +0100 )edit

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

nic ( 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 ( 2018-03-07 19:47:29 +0100 )edit

add a comment

paste data, NOT formats, into LO? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-25 20:22:10.459438

3 Answers

Comments

Comments

Question Tools

Stats

Related questions

paste data, NOT formats, into LO? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-07-25 20:22:10.459438

3 Answers

Comments

Comments

Question Tools

Stats

Related questions

paste data, NOT formats, into LO? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-25 20:22:10.459438