Ask Your Question

Pasting table in textdocument changes formatting [closed]

asked 2015-06-02 22:24:44 +0100

Stophface1 gravatar image

updated 2020-09-24 16:20:09 +0100

Alex Kemp gravatar image

LibreOffice, OS X 10.10

I have a spreadsheet document from which I copy & paste the content into a text document. I copy by marking the area which I want to copy, control + c and control + v pasting it into the text document. However, the formatting gets changed. Precisely, the borders of the cells!

That is how it looks like after exporting the text document as a pdf.

I want the second line to be as dark as the top line.

Thats how it looks in the text document before exporting it to pdf.

Thats how it looks like in the spreadsheet document.

Thats how my cells where the line shall occur is formatted. Note that the top line and bottom line have exactly the same formatting.

Why is it different?!

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-21 21:53:42.858651

1 Answer

Sort by » oldest newest most voted

answered 2015-06-02 23:21:55 +0100

Alex Kemp gravatar image

When you copy/paste, LO copies both the text & the formatting (style). Rather than a 'paste', do a 'paste special':

(menu): Edit | Paste Special...

That will give an inline-dialog with many options. One is 'unformatted text', and that is probably the option that you want.

edit flag offensive delete link more


Nope. That did not help. I tried calc8 and unformatted text. Unformatted text completely drops the formatting...

Stophface1 gravatar imageStophface1 ( 2015-06-03 09:39:57 +0100 )edit

Question Tools

1 follower


Asked: 2015-06-02 22:24:44 +0100

Seen: 377 times

Last updated: Jun 02 '15