Ask Your Question

Paste in calc as plain text [closed]

asked 2015-10-18 03:17:19 +0200

RealGomer1 gravatar image

updated 2020-08-11 18:03:43 +0200

Alex Kemp gravatar image

For some reason, when I paste something into Cal 5, wrap text and some oddball font are used. I tried setting up Paste-Values only but that doesn't do it. What are my options?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-11 18:04:03.758193

2 Answers

Sort by » oldest newest most voted

answered 2016-03-16 22:50:09 +0200

Alex Kemp gravatar image

updated 2016-03-16 22:54:36 +0200

The ‘Copy’ process is far more complicated than you think: it normally copies very much more than just the text.

The other half of the process (‘Paste’) with LO gives options to paste just one of the MIME types. In addition, you are dealing with 2 completely different Apps (1 to Copy, and LO to Paste).

Thus, to do a live example (Chrome 48.0.2564.116 to copy + LO- to paste, all under debian-8.3 (jessie)):

  1. Use Copy (Ctrl-Insert, 'cos I'm awkward) of your 1st sentence in the Question
  2. Paste (Shift-Insert) into cell A1 of Calc (full defaults accepted; seems to work well)
  3. Paste-Special (Ctrl-Shift-V) offers 2 MIME:

a. Unformatted text (text/plain)
b. HTML (text/html)

When you do ordinary Paste (Ctrl-V) it typically chooses the top MIME (as shown under Paste-Special). Thus, for me, that was uneventful. If Copy had placed HTML as the top-MIME then I could have had a similar experience to your own. If you are having experiences of this kind then use Paste-Special (it is under the Edit menu) and choose plain-text.

edit flag offensive delete link more

answered 2016-03-17 08:22:13 +0200

pierre-yves samyn gravatar image


If you paste in a cell (not a range) a faster way than the paste special: instead of clicking on the cell before pasting, Double-Click the cell then paste (e.g. Ctrl+V)


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-10-18 03:17:19 +0200

Seen: 1,590 times

Last updated: Mar 17 '16