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.
[Solved] Filling a Writer table with values from SpreadSheet
-
- Posts: 2
- Joined: Mon Aug 17, 2015 4:32 pm
[Solved] Filling a Writer table with values from SpreadSheet
Last edited by Hagar Delest on Mon Aug 31, 2015 11:32 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice 4.1 on Windows 7
Re: Filling a Writer table with values from a SpreadSheet
Greetings and welcome to the community forum!
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.
Sorry, this is not supported in OO.... In MS Office copying cells in Excel and pasting them into cells of an existing table had the desired result. ...
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
-
- Posts: 2
- Joined: Mon Aug 17, 2015 4:32 pm
Re: Filling a Writer table with values from a SpreadSheet
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