Re: [libreoffice-users] Selecting record range in mail merge.

The same bug I suspect. What makes me fairly sure its a bug is that if 
you select a single record, say 50 to 50, a page prints but no data. 
This is also inconsistent with printing, if you select to print pages 
5-7 you get pages 5,6,7 and not 5,6.
steve

On 23/08/11 1:44 AM, Don C. Myers wrote:
> Hi,
>
> I don't know if this might help anyone or not. I had an OpenOffice 
> form problem using the table template with a standard 30 label sheet 
> (3 x 10). I have all of our Christmas card addresses in an OpenOffice 
> database. I have the form setup, etc, to automatically pull the 
> address information in when I click print and select the database, 
> etc. It works great with one exception. Last year my wife said I 
> missed having a few addresses included. I didn't think anything about 
> it, and honestly, didn't think that was possible. This year before 
> giving her the printed labels I thought I would check that everyone 
> was there. I set the printing so it is sorting to print A_Z based on 
> the last name. It takes three sheets. I have 78 names in the database, 
> but only had 76 printed labels. What happened was when the printing 
> went from the first sheet to the second sheet, it misses one record. 
> The rest of the second page is fine. When I went from the second sheet 
> to the third sheet, once again, it skipped the next label, then 
> printed fine for the balance. When I say it skipped it, the missing 
> record just disappears. It isn't that I end up with a blank label at 
> the top of the sheet. The next one in line to be printed on the first 
> label on Page 2 vanishes and the one that should be the second one on 
> the second page becomes the first one on the second page. The same 
> with the third page. A person would never pick this up unless checking 
> the database against the printed labels.
>
> The solution!!!!!!!! I had one full page of labels with the fields in. 
> I read on-line that you need one complete page with fields in for each 
> page of labels. So I added two more pages so I have a three page 
> template. When I created Pages 2 and 3 and by pasting the complete 
> page 1, then scrolled up, I found there was a blank page between each 
> label page. I deleted those pages, and I now have a perfectly working 
> label template printing all of the address!!!!!!!!!
>
> Don
>
> On 08/22/2011 06:28 AM, Tom Davies wrote:
> > Hi :)
> > It's a fence-post error (i think).  "To" means "stop just short of", 
> > "up to&
> > including" is what you want but i don't know of a better work-around 
> > than the
> > one you are using.  If you were driving "into town" your first stop 
> > wouldn't be
> > outside the far side of town.
> >
> > http://catb.org/jargon/html/F/fencepost-error.html
> > http://www.dsm.fordham.edu/~moniot/Opinions/fencepost-error-history.shtml 
> >
> > http://en.wikipedia.org/wiki/Off-by-one_error
> >
> > Regards from
> > Tom :)
> >
> >
> >
> >
> > ________________________________
> > From: Steve Edmonds<steve.edmonds@ptglobal.com>
> > To: users@global.libreoffice.org
> > Sent: Mon, 22 August, 2011 3:48:28
> > Subject: [libreoffice-users] Selecting record range in mail merge.
> >
> > Hi.
> > When printing a mail merge/form letter you have the option to select a
> > record range for the form data.
> > If you select From 1 to 100 then records 1 to 99 inclusive are printed,
> > record 100 is not.
> > If you select record From 50 to 50 (so you can print just record 50)
> > then a letter prints with no data from the data source (those fields
> > left blank). To print record 50 you need to print From 50 to 51.
> >
> > I have LO 3.3.2 installed on SUSE which shows this bug and have filed
> > bug 40278.
> > https://bugs.freedesktop.org/show_bug.cgi?id=40278
> > steve

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted