[Issue 126788] New: pasting data from spreadsheet gives unexpected result

[bu...@apache.org]

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

          Issue ID: 126788
        Issue Type: DEFECT
           Summary: pasting data from spreadsheet gives unexpected result
           Product: Writer
           Version: 4.1.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: hwballard@gmail.com

Scenario: trying to print specific course / instructor / student / date
information onto pre-printed certificates, given a template for what gets
printed and a list of student names. Once course, instructor, and date are
adjusted, want to get student names from spreadsheet file one by one, replace
the name in the template, print it, and continue. Note, in spreadsheet, the
name is calculated from two cells containing first name and last name. It's not
just a simple piece of data. 
While this works as one would like it to when using XCEL and WORD to handle the
spreadsheet and the certificate document, respectively, it does not work in
Open Office. When one goes to the spreadsheet, copies the cell with "Joe
Schmoe" in it, calculated by concatenating the nearby cells with "Joe",
"Schmoe", and a " ", highlight the fully formatted "Student Name" in the
template document, and choose "Paste", by whatever method, Open Office replaces
the formatted "Student Name" with a little box containing "Joe Schmoe" - a
single element table, rather than just "typing over" the letters of "Student
Name" with the letters of "Joe Schmoe", to give a fully formatted certificate,
ready to print.

spreadsheet of student names: column of first names, column of last names,
calculated column of full name as it should appear on the certificate:

first |  last   |  full name    |
Joe   |    Schmoe    | Joe Schmoe    |
Fred  |    Schmuck    | Fred Schmuck  |
Leroy |    Washere    | Leroy Washere |

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

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

[Issue 126788] pasting data from spreadsheet gives unexpected result

[bu...@apache.org]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|orcmid@apache.org           |

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

[Issue 126788] pasting data from spreadsheet gives unexpected result

[bu...@apache.org]

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.

[Issue 126788] pasting data from spreadsheet gives unexpected result

[bu...@apache.org]

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

--- Comment #2 from Peter <le...@gmail.com> ---
*** Issue 126786 has been marked as a duplicate of this issue. ***

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