Ask Your Question
0

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

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

jerrysg7 gravatar image

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

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
2

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

pierre-yves samyn gravatar image

Hi

  • 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.

Regards

edit flag offensive delete link more
0

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

kkivi gravatar image

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

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

Comments

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 +0100 )edit
0

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

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

2 followers

Stats

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

Seen: 7,522 times

Last updated: Aug 01 '19