Hello,
Just can't seem to figure out how to do this.
I have a spreadsheet I created in Calc. Using MacOS
I want to select a bunch of (contiguous) cells, and paste what I have
just selected, along with the cell dividing lines, into MS WORD document.
It won't allow me to do this, irrespective of everything I've tried.
How do I do it, please ?
Much thanks,
Bob
[Solved] Copying From Calc, And Pasting Into MS Word. How ?
[Solved] Copying From Calc, And Pasting Into MS Word. How ?
Last edited by Hagar Delest on Sun Apr 18, 2021 9:20 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
OOo 2.3.X on Ms Windows XP
Re: Copying From Calc, And Pasting Into MS WORD. How ?
It might help if you told us some of the things you have tried.
That aside, are you wanting the results or are you wanting the formulas? I'm going to guess you want the results.
Do you want them in a table?
Why are you doing the spreadsheet in OpenOffice Calc and then putting the information into MS Word?
If you want to work in OpenOffice, then you should paste in Writer. If you need it in MS Word, then you might be smarter to use Excel.
The cell dividing lines are not part of any cell, and will not be copied/pasted unless you make your own borders in Calc. Even then I'm not sure how they would appear when pasted.
Not having a copy of MS Word, I can't verify this, but using Ctrl+C (or the Mac equivalent) to copy, then using Ctrl+Shift+V (or the Mac equivalent) should give you a dialog box where you can select what it is you are wanting to paste.
That aside, are you wanting the results or are you wanting the formulas? I'm going to guess you want the results.
Do you want them in a table?
Why are you doing the spreadsheet in OpenOffice Calc and then putting the information into MS Word?
If you want to work in OpenOffice, then you should paste in Writer. If you need it in MS Word, then you might be smarter to use Excel.
The cell dividing lines are not part of any cell, and will not be copied/pasted unless you make your own borders in Calc. Even then I'm not sure how they would appear when pasted.
Not having a copy of MS Word, I can't verify this, but using Ctrl+C (or the Mac equivalent) to copy, then using Ctrl+Shift+V (or the Mac equivalent) should give you a dialog box where you can select what it is you are wanting to paste.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Copying From Calc, And Pasting Into MS Word. How ?
Open both files with either OpenOffice or with MS Office.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Copying From Calc, And Pasting Into MS Word. How ?
Hi,
Thanks.
Hints very appreciated.
Bob
Thanks.
Hints very appreciated.
Bob
OOo 2.3.X on Ms Windows XP
Re: Copying From Calc, And Pasting Into MS Word. How ?
If you open both documents with OpenOffice, copy the cells and do a menu:Edit>Paste-Special (Ctrl+Shift+V). Choose HTML as target format. This gives a normal text table which should be OK when saved as doc.
Why do you save doc format anyway?
Why do you save doc format anyway?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Copying From Calc, And Pasting Into MS Word. How ?
Hi,
Really new at this.
Frankly, wasn't sure of which format I ws saving to.
Again, thanks for help.
Nice of you, and very appreciated.
Sure helps.
Bob
Really new at this.
Frankly, wasn't sure of which format I ws saving to.
Again, thanks for help.
Nice of you, and very appreciated.
Sure helps.
Bob
OOo 2.3.X on Ms Windows XP