You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/01/12 23:10:18 UTC

[Issue 126788] pasting data from spreadsheet gives unexpected result

https://bz.apache.org/ooo/show_bug.cgi?id=126788

orcmid <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
                 CC|                            |orcmid@apache.org
             Status|UNCONFIRMED                 |CONFIRMED

--- Comment #1 from orcmid <or...@apache.org> ---
(In reply to Henry Ballard from comment #0)

> I would have been happy to attach a second file but didn't see any way to do
> that.

No problem.  So you have opened a new issue rather than adding to Issue 126786.
 You can use the Add Attachment feature any number of times and it will add
additional ones, not replace the one(s) there.  You can also add more
information by just adding more comments to an issue.

I see I can paste Joe Schmoe (computed as =A1&" "B1) into a Word document
without ceremony.

For OpenOffice Writer, I needed to do 

     Edit > Paste Special > Unformatted text

to accomplish the Paste with just the text and no table cell.

You can also save the spreadsheet as a CSV (changing the filename extension to
.txt) and that will give you a file with just the content of the cells, not the
formulas.  That might be a little easier to paste from.

-- 
You are receiving this mail because:
You are the assignee for the issue.