Ask Your Question

How do I copy a Calc spreadsheet to a Writer table?

asked 2016-05-02 22:25:54 +0200

jerrysg7 gravatar image

updated 2017-02-17 12:53:21 +0200

ratrace gravatar image

I have a simple 2 column spread sheet (2x132) that I need to convert to a Writer table. How?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2016-05-03 08:50:17 +0200

pierre-yves samyn gravatar image


  • Select cells in Calc▸Copy

In Writer:

  • Edit▸Paste: you get an object.
    • Advantage: double click to be in the spreadsheet environment
    • Disadvantage: it is not a Writer table and you can not handle paging, everything fits on one page. This is not appropriate if many lines
  • Edit▸Paste special▸Formatted Text (RTF): you get a Writer table
  • Edit▸Paste special▸DDE link: you get a Writer table and, as @LKeithJordan said, data are linked to the original spreadsheet.


edit flag offensive delete link more

answered 2019-08-01 16:05:38 +0200

kkivi gravatar image

updated 2019-08-01 16:09:57 +0200

Looks like nobody understands what the task is.

The task is to transfer calc sheet ( after column hiding, sorting and filtering ) to the final report in wrter.

Instead of understanding this task and the fact it is next to impossible every adviser states that this task has no sense. PS Paste special as RTF ignores filtering and shows traces of hidden colums.

Upd. paste specal as HTML seems to be the best option

edit flag offensive delete link more


Stop whining! It's ridiculous.
The question was posted more than two years ago and did not mention the aspects of filtering and hiding you are now emphasizing.
If you have a related but "enriched" question post it as a new question and describe clearly what you already tried.
This might make sense, at least.

Lupp gravatar imageLupp ( 2019-08-01 17:14:25 +0200 )edit

answered 2016-05-03 04:50:42 +0200

LKeithJordan gravatar image

Unless there is a specific need to do as you ask, you would probably be better served by linking or embedding the spreadsheet in Writer. Linking allows you to dynamically reflect changes in Writer as you change the spreadsheet. Embedding allows you to keep Writer static despite subsequent changes to the spreadsheet.

Please click the checkmark next to the response you believe best answers your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2016-05-02 22:25:54 +0200

Seen: 11,936 times

Last updated: Aug 01 '19