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: [email protected]
Reporter: [email protected]
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.
