Ubuntu
openoffice.org package

OO 3.0, Calc, Writer

Asked by peter

Hi

I've a spreadsheet with two columns. I would get a copy of the spreadsheet data for the Writer.

I copied the whole spreadsheet to the Writer. But after the insert of the data the data was placed somewhere in the document and the data looked like an object. It was surrounded by a border and it was movable.

How can I copy the spreadsheet data to the Writer as I'm used to do it with Word and Excel?

Thanks for your answer.
Peter

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
peter
Solved:
Last query:
Last reply:
Revision history for this message
Zied ALAYA (zied.alaya) said : 		#1

Good morning Peter,
it's simple:
1- copy your spreadsheet text
2- in the writer do a special paste using ctrl+shift+v. then choose the paste mode. the more appropriate choice for you will be "formatted text"

Hope this solve your problem.

Revision history for this message
Andre Mangan (kyphi) said : 		#2

In Calc select your cells and press Ctrl+c

In Writer press Ctrl+Shift+v (or use Edit, Paste Special) and choose "Unformatted text".

Revision history for this message
peter (peter-neuweiler) said : 		#3

Hi together

Thanks a lot! It works *lll.

Is it possible to insert the text as a table in the Writer? Thanks for your answer.
Peter

Revision history for this message
Zied ALAYA (zied.alaya) said : 		#4

Yes Peter, just:
  1- copy your spreadsheet text
  2- in the writer do a special paste using ctrl+shift+v. then choose the paste mode: "formatted text"

Revision history for this message
Andre Mangan (kyphi) said : 		#5

If you want the copied information from the spreadsheet to assume the style used in the word processor then use "unformatted text".

Try it and see for yourself.

Revision history for this message
peter (peter-neuweiler) said : 		#6

Thanks!
Peter