Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.