[Solved] Copying From Calc, And Pasting Into MS Word. How ?

Discuss the spreadsheet application

[Solved] Copying From Calc, And Pasting Into MS Word. How ?

Postby Robert11 » Sat Apr 17, 2021 11:40 pm

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
Last edited by Hagar Delest on Sun Apr 18, 2021 9:20 pm, edited 1 time in total.
Reason: tagged solved.
OOo 2.3.X on Ms Windows XP
Robert11
 
Posts: 8
Joined: Sat Jan 10, 2009 11:26 pm

Re: Copying From Calc, And Pasting Into MS WORD. How ?

Postby RusselB » Sun Apr 18, 2021 12:07 am

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.
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.
User avatar
RusselB
Moderator
 
Posts: 6400
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Copying From Calc, And Pasting Into MS Word. How ?

Postby Villeroy » Sun Apr 18, 2021 6:45 am

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
User avatar
Villeroy
Volunteer
 
Posts: 29729
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Copying From Calc, And Pasting Into MS Word. How ?

Postby Robert11 » Sun Apr 18, 2021 11:39 am

Hi,

Thanks.
Hints very appreciated.

Bob
OOo 2.3.X on Ms Windows XP
Robert11
 
Posts: 8
Joined: Sat Jan 10, 2009 11:26 pm

Re: Copying From Calc, And Pasting Into MS Word. How ?

Postby Villeroy » Sun Apr 18, 2021 8:17 pm

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?
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
User avatar
Villeroy
Volunteer
 
Posts: 29729
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Copying From Calc, And Pasting Into MS Word. How ?

Postby Robert11 » Sun Apr 18, 2021 9:06 pm

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
OOo 2.3.X on Ms Windows XP
Robert11
 
Posts: 8
Joined: Sat Jan 10, 2009 11:26 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests