Page 1 of 1

[Solved] Filling a Writer table with values from SpreadSheet

PostPosted: Mon Aug 17, 2015 4:44 pm
by ChaimRobinson
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.

Re: Filling a Writer table with values from a SpreadSheet

PostPosted: Mon Aug 17, 2015 5:08 pm
by acknak
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.

Re: Filling a Writer table with values from a SpreadSheet

PostPosted: Mon Aug 17, 2015 8:48 pm
by ChaimRobinson
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.