Issue 9672

Summary: Synchronize contents option for single page, multiple labels creates looping Form Letter
Product: Writer Reporter: brh <brian>
Component: codeAssignee: h.ilter
Status: CLOSED FIXED QA Contact: issues@sw <issues>
Severity: Trivial    
Priority: P3 CC: issues, oooqa
Version: OOo 1.0.1Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Bibliography database
none
Faulty document produced by 'New Labels' none

Description brh 2002-11-29 16:06:49 UTC
When generating labels, individual records in the database may be duplicated a
random number of times.  I have traced this to a fault in the generation of the
 'NextRecord' field by the 'New Labels' wizard code.  It seems that the condition
tested for is random, instead of TRUE.  (There is no way of displaying the
condition - perhaps this is an item for future enhancement).
I isolated this by editing the faulty document by deleting the 'NextRecord'
field, and re-inserting it manually, followed by clicking 'Synchronise Labels'.
The 'Form Letter' processing now worked correctly.
Comment 1 prgmgr 2002-12-02 21:34:50 UTC
*** Issue 9673 has been marked as a duplicate of this issue. ***
Comment 2 prgmgr 2002-12-02 21:52:27 UTC
Thank you for using and supporting OOo.

Unable to duplicate on RH 8.0, OOo 643c.
Comment 3 prgmgr 2002-12-03 02:55:04 UTC
Unable to duplicate on Win2k server SP3, OOo 643c.
Unable to duplicate on RH 8.0, RH OOo 1.0.1.

Please list step by step instructions to reproduce this issue.
Attach any small, simple files required to reproduce this issue.
Comment 4 brh 2002-12-03 12:20:39 UTC
Created attachment 3868 [details]
Bibliography database
Comment 5 brh 2002-12-03 12:22:53 UTC
Created attachment 3869 [details]
Faulty document produced by 'New Labels'
Comment 6 brh 2002-12-03 12:24:55 UTC
The fault can be reproduced using the bibliography database supplied
with the product.

I have attached this database along with a faulty document.  If you
execute 'Form Letter' for this document, and output to file, you will
see it run away (I hope !), initially duplicating the MEA99A entry.

The document was created with 'New Labels' using Avery C2163
stationery, with 'sheet' setting, although this does not seem to be
critical.  What does appear to be critical is the number of fields.

The fields in this case are:
<Bibliography.biblio.0.Identifier>
<Bibliography.biblio.0.Address>
<Bibliography.biblio.0.Author>
<Bibliography.biblio.0.Title>
<Bibliography.biblio.0.Year>
<Bibliography.biblio.0.ISBN>
Comment 7 prgmgr 2002-12-03 18:55:06 UTC
Duplicated on RH 8.0, OOo 1.0.1.
Duplicated on RH 8.0, OOo 643c.

1.  File->New->Labels

2.  Labels tab

    Select Bibliography DB, biblio table, any field
    Format, change to sheet
    Brand, Avery A4
    Type, C2163 Avery Inkjet Label

3.  Options tab
    
    Synchronize contents, enabled


4.  Click New Document button.


Problem, "Next record" field is added to the last label on the page (
bottom right hand corner ).  This creates a looping situation when the
Form Letter command is run.  

Synchronize contents option performed as expected, but when multiple
labels are on the same sheet, the last label should not contain the
"Next record" field.  Problem does not exist if synchronize contents
not used during creation of label page.

Workaround, do not use the Synchronize Contents option for pages with
multiple labels. 
Comment 8 prgmgr 2002-12-03 18:58:59 UTC
User summary
Label Generation Produces Erratic Numbers of Duplicates
Comment 9 h.ilter 2002-12-04 13:53:06 UTC
HI->OS: Nice bug, never ending counting.
Comment 10 eric.savary 2002-12-19 11:34:55 UTC
*** Issue 9984 has been marked as a duplicate of this issue. ***
Comment 11 Oliver Specht 2003-01-30 10:33:31 UTC
The problem was the incorrect creation of the NextRecord field. The
condition contained the column name of the previous database field. In
the attached document this was ISBN. 
Fixed in sw/source/ui/app/applab.cxx in cws os5
Comment 12 Oliver Specht 2003-02-13 08:29:42 UTC
Reassigned to HI
Comment 13 Oliver Specht 2003-02-13 08:30:02 UTC
Fixed
Comment 14 h.ilter 2003-02-13 15:36:06 UTC
Verified with 644o_8503 (cws:os5) = still occurs.
Comment 15 h.ilter 2003-02-13 15:36:39 UTC
.
Comment 16 Oliver Specht 2003-02-14 09:47:57 UTC
OS->HI: The fix works as seen. The bugdoc cannot be repaired anymore.
The not correctly working mail merge to file is independent from this
cws and needs a new task.
Comment 17 Oliver Specht 2003-02-14 09:48:16 UTC
Fixed.
Comment 18 h.ilter 2003-02-17 14:14:26 UTC
Ok, it works with new created doc.
Comment 19 h.ilter 2003-02-24 12:33:30 UTC
HI: Verified with srx644_m4s3-3_01.8551 = The Next record field is not
necessary if the synchronize check box is enabled.