Can't paste copied Writer text to Spreadsheet Merged field

Discuss the spreadsheet application
Post Reply
godsredeemer
Posts: 5
Joined: Thu Feb 24, 2011 9:27 pm

Can't paste copied Writer text to Spreadsheet Merged field

Post by godsredeemer »

Hello, Everyone:
I created a large field in SS by merging several fields.
I copy text from a Writer document, then do a "paste" into the merged SS field.
No matter what I do, nothing works right.
Please see attachment.
How do I paste straight-up copied text from a Writer document into this merged SS area in a way that looks like it did in Writer?

Thanks so much.
Original Writer text copied to SS. I had to compress it to show it here, so it looks weird.
Original Writer text copied to SS. I had to compress it to show it here, so it looks weird.
As it looks copied to SS
As it looks copied to SS
OpenOffice 3.3 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can"t paste copied Writer text to Spreadsheet Merged fie

Post by Villeroy »

You must not merge any data cells. This is a cosmetic feature for labels but you must not do that to your precious data.
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
Post Reply