Ask Your Question

How do I copy Calc data to a Write table?

asked 2017-02-03 14:39:25 +0200

Lars J gravatar image

Given data in a Calc spreadsheet, how do I copy them to a Writer table? Just the data as text in a table (even if the data are numbers).

I have tried several ways, but without success:

a) Copy the Calc data and insert them into the Writer document. This gives me a Calc object within the Writer document, but with less ability of formatting as would be the case for a table.

b) Creating the table first, then copying the Calc data. This gives me a Calc object within the first cell of the table.

c) As b), but selecting the whole table first. Result is worse: Each cell contains a calc object with all data!

d) Saving Calc data as html or csv, then opening the data and inserting in the table. Still no conversion to table.

Does anybody has a better (and perhaps simpler) idea?

Best regards, Lars J

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-02-03 15:28:04 +0200

gabix gravatar image

Copy Excel data to the clipboard. In Writer, use Paste special → Formatted text (RTF).

edit flag offensive delete link more


Thanks, this solves my problem! (How do I mark question as solved?)

Lars J gravatar imageLars J ( 2017-02-06 14:48:11 +0200 )edit

Click on the circle with a checkmark under the control arrows next to my answer to make it green. Optionally, upvote the answer by clicking on the up arrow.

gabix gravatar imagegabix ( 2017-02-07 08:48:44 +0200 )edit

Paste special → Formatted text (RTF) has got a few bugs. If it doesn't work, try 'Paste special → HTML' might be better!

Zeca gravatar imageZeca ( 2017-02-20 12:42:41 +0200 )edit

Neither RTF nor HTML work for me. Everything ends up in column 1.Import CSV should be a Table option in Writer - why make it so hard?

duncan_roe gravatar imageduncan_roe ( 2017-07-29 11:46:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-03 14:39:25 +0200

Seen: 816 times

Last updated: Feb 03 '17