Re: [libreoffice-users] writer: business cards w/ tables - duplicate cells

Hi,

On Saturday I promised I would get back to you relative to the labels. I 
had two issues, with one being the blank page between sheets, and the 
second being that if I was pulling the label information from a data 
base (Base), between sheets, one record would be missing. Here is what I 
wrote to another [post about 6 months ago:

> 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
Don



On 11/20/2011 12:39 PM, Matthew Monaco wrote:
> On 11/20/2011 12:50 AM, Libre User wrote:
> > Matt
> >
> > I see that if you do File>New>Business Card you are forced to use 
> > preformatted
> > cards with layouts and fields already selected.
> >
> > But if you use File>New> Label, and then select as your label, one of 
> > the
> > Business Card templates (e.g. Avery Letter Size; Avery 5371) you will 
> > get a
> > blank template of the proper size with no preselected fields or 
> > formatting. You
> > can then design that space any way you like. And then generate the 
> > sheet of
> > cards with the synchronize button.
>
> This still has some quirks I need to work out, but it is the best 
> solution so far. Thanks! I can now also see how the mirrored frames 
> are actually set up and can how to tweak it myself.
>
> > Don't you have to conform to the business card templates in terms of 
> > size and
> > margins in order to get them to print properly? This just seems like 
> > the easiest
> > way to do it.
>
> The table I had set up was easy because the margins were nice numbers 
> within any printer's margins. Its 10 3.5x2 cards on a 8.5x11 paper. So 
> I set the margins to be .5 top and bottom and .75 left and right (-.1 
> on the bottom for that extra paragraph). The table then fit perfectly 
> with 2x3.5 cells.
>
> > Jerry
> >
> >
> >
> > > Thank you to all of the replies. I am indeed not using the 
> > > label/business card
> > > templates because I don't like the way they look nor the control I 
> > > feel I have
> > > over them. If I could figure out how to create my own template that 
> > > might
> > > work. For now it seems the best solution is really to just copy and 
> > > paste.
> > >
> > > I've gotten rid of the extra page by change the font size outside of 
> > > the table
> > > to the smallest possible value and then decreasing the bottom margin
> > > ever-so-slightly.
> > >
> > > The reason I'm concerned about some of these particulars is because I'm
> > > setting this stuff up for an older even-less-informed user than 
> > > myself and I
> > > want him to be able to print and make small modifications without 
> > > too much
> > > knowledge.
> > >
> > > Thanks!
> > > Matt
> > >
> > > T
> > >
> > > --
> > > 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

--

*
***


--
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