I have a simple 2 column spread sheet (2x132) that I need to convert to a Writer table. How?
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
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.
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
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.