[Solved] Filling a Writer table with values from SpreadSheet

Writing a book, Automating Document Production - Discuss your special needs here

[Solved] Filling a Writer table with values from SpreadSheet

Postby ChaimRobinson » Mon Aug 17, 2015 4:44 pm

I'm somewhat new to OpenOffice, and I'm having difficulty figuring this one out. No luck with searches either. In MS Office copying cells in Excel and pasting them into cells of an existing table had the desired result. How is it supposed to be done in OpenOffice?

It's something I do once a year for a schedule I need to print, so automation is not a requirement.

Thanks in advance for any guidance.
Last edited by Hagar Delest on Mon Aug 31, 2015 11:32 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.1 on Windows 7
ChaimRobinson
 
Posts: 2
Joined: Mon Aug 17, 2015 4:32 pm

Re: Filling a Writer table with values from a SpreadSheet

Postby acknak » Mon Aug 17, 2015 5:08 pm

Greetings and welcome to the community forum!

... In MS Office copying cells in Excel and pasting them into cells of an existing table had the desired result. ...

Sorry, this is not supported in OO.

The simplest workaround requires two separate steps:

1) Copy, then Edit > Paste Special > As (either) Formatted Text OR HTML
Either one will leave the spreadsheet content in a new Writer table.

2) Copy/Paste cells from the new Writer table into an existing Writer table. This works as you would expect.

More automated approaches might use mail merge or a database report.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Filling a Writer table with values from a SpreadSheet

Postby ChaimRobinson » Mon Aug 17, 2015 8:48 pm

Thank you for the response. As it turns out, after posting the question, I found that removing the table and replacing it with an embedded spreadsheet serves the purpose quite well in my case.
OpenOffice 4.1 on Windows 7
ChaimRobinson
 
Posts: 2
Joined: Mon Aug 17, 2015 4:32 pm


Return to Advanced Uses

Who is online

Users browsing this forum: No registered users and 0 guests