Issue 81418

Summary:

"data to fields" button duplicates records in multiple pages document

Product:

Base

Reporter:

smesserli <stephane.messerli>

Component:

code

Assignee:

marc.neumann

Status:

CLOSED IRREPRODUCIBLE

QA Contact:

issues@dba <issues>

Severity:

Trivial

Priority:

CC:

issues, lohmaier

Version:

OOo 2.2.1

Keywords:

oooqa

Target Milestone:

---

Hardware:

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
A two-pages Writer document showing the duplicated records after using the "data-to-fields" button	none

Description smesserli 2007-09-09 18:24:33 UTC

When populating fields of a Writer document with the "data to fields" button,
the last record of a page and the first record of the next page are actually the
same (duplicated record bug).

To reproduce:
 - Create a database
 - Create a table with 1 column and ~10 records
 - Go to the File menu, New, Labels
 - Create a Labels document with 5 records on each page
 - Once the document is created, add a second page by copying the first one
 - Hit F4 (external data source)
 - Select all records of your database/table and click the "data-to-fields" button
 - Check the last record of the first page and the first record of the last
page, they are the same

This bug happens in both XP and Vista with OO version 2.2.1.

Comment 1 smesserli 2007-09-09 18:27:18 UTC

Created attachment 48088 [details]
A two-pages Writer document showing the duplicated records after using the "data-to-fields" button

Comment 2 marc.neumann 2007-09-10 12:46:38 UTC

Hi smesserli,

You need to add a "Next Record" Field into the last card on page first.
f.e.:
- Use Menu VIEW / FIELD NAME
- go to the end of the first card 
- copy the last field. named "next record ..."
- paste the field into the last card onto the first page.
- turn off the field names via VIEW / FIELD NAME
- use data to fields again
-> done.

Bye Marc

Comment 3 smesserli 2007-09-10 20:16:19 UTC

Thanks for you help, the "next record" field is indeed missing.
But is that a bug in OO or not?

The last card always misses the "next record" field in a new Labels document, so
adding a record at the end of the document will always lead to the same record
duplication issue.

Should I mark this issue as "invalid" nevertheless?

Cheers,
- StÃ©phane

Comment 4 christoph.lukasiak 2008-05-07 11:05:52 UTC

change owner

Comment 5 safway 2008-12-02 19:24:00 UTC

I can confirm this still happens in OOo version 3.0.  Question still remains
should this issue be marked as invalid?

Comment 6 lohmaier 2009-03-28 11:25:35 UTC

Not a bug IMHO.

You don't need to copy the page to print more labels, you could simply print one
page twice.

And to print e.g. 100 datasets, it is also not neccessary to create so many
pages to hold the 100 datasets. When using Print (since the document contains
fields, OOo asks whether you want to do a mail-merge print, answer yes) and
selecting more datasets, then OOo will not print duplicate entries, it will
automatically assume "next dataset" at the end of the document (i.e. the one
page in the document).

So: no bug IMHO, resolving worksforme.

Comment 7 lohmaier 2009-03-28 11:28:19 UTC

closing issue.