[Solved] Writer and Excel paste

Discuss the word processor
Post Reply
Cubanero
Posts: 19
Joined: Thu Nov 20, 2014 10:36 am
Location: Netherlands - Hellas

[Solved] Writer and Excel paste

Post by Cubanero »

When in Writer with a big blanc table I try to paste mutiple cells from Excel. Whatever cells I copy from excel is pasted in a solo cell in Writer. Is it possible to alter that response?
Last edited by Cubanero on Fri Feb 06, 2015 3:49 pm, edited 1 time in total.
OpenOffice 4.1.1 on Windows 8.1
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Writer and Excel paste

Post by RusselB »

I'm thinking you want to use Paste Special (Ctrl+Shift+V) rather than Paste (Ctrl+V)
I've never used tables in Writer, but I do realize that they can be useful at the correct times, so this is an educated guess rather than a firm response.
I also think that you'll want the Text, Numbers, Date & Time, and Formats (but not the Paste All) selections checked in the Paste Special dialog.
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
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Writer and Excel paste

Post by acknak »

You can paste cells from OO Calc into OO Writer as a new table, but you can only paste into an existing table as text in one table cell.

If you need the Calc cells in different cells of the Writer table, you have to paste first into a new Writer table, then copy/paste from there into the final target.
AOO4/LO5 • Linux • Fedora 23
Cubanero
Posts: 19
Joined: Thu Nov 20, 2014 10:36 am
Location: Netherlands - Hellas

Re: Writer and Excel paste

Post by Cubanero »

The last solution worked for me, paste in new table and then copy from there to the target table.
OpenOffice 4.1.1 on Windows 8.1
Post Reply