Ask Your Question

Paste in calc as plain text

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

RealGomer1 gravatar image

updated 2016-03-16 22:19:57 +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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 416 times

Last updated: Mar 17 '16