Re: [libreoffice-users] Re: Sequentially numberted tickets...

Hi Nino

Nino Novak <nn.libo@kflog.org> wrote:

> Am 08.08.2013 06:53, schrieb David Love:
> > I have been asked to design and print numbered tickets for an event
> > being organised by a Club to which my wife belongs.
>
> How I'd do it (it's from memory, so bear with me for little glitches):

Thank you for the prompt reply and my apologies for the delay in replying to
you.

> 1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
> desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
> format with two preceeding zeroes) into a column

Did that without problems.

> 2. design a nice text page with all 4 tickets in it (you could also try
> going with labels but for just 4 tickts per page I'd rather go with
> copy&paste instead of fumbling with labels)

O.K. Although I did have some trouble grouping all elements.

> 3. assign the spreadsheet from #1 as data source (for later use as
> mailmerge, from memory: File > New > Database > connect to existing >
> spreadsheet)

Perfect!

> 4. on your above designed ticket page, press F4 to open the spreadsheet
> from above as data source

No problem.  

> 5. enter (simply drag&drop) column header field into the appropriate place
> in stub and repeat this for the ticket

Went without a hitch.

> 6. after every SECOND field enter "next record" switch (Insert > field >
> others > database > next record) but NOT after the fourth ticket (as a
> page break always triggers a next record switch)

This is where I've gone wrong and I cannot figure out how.  As I understood
it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
above.  Is that correct?

and then, as it will be a new page, the numbering will continue in sequence
until we reach the end of the records.  Is that correct

> 7. Print as mailmerge (or form letter or whatever it's called) into 1
> document

I do this by Printing to file.  The first ticket is correct.  Tickets number
2, 3 and 4 are not numbered.  It then goes to the next page where the first
ticket is numbered 2 and the other three are not numbered.  And so it goes
on until the end of the records.  Each page is the next number.

I notice that when I have Next Record highlighted and click Insert, all that
happens is a thin grey vertical line appears where I click.  I would have
thought the words <next record> would have appeared.  Am I wrong?

> 8. review the document and if necessary correct&repeat some of the above
> steps

I am at a loss as to what I should do next.

> 9. print the merged documents,
>
> 10. enter perforation (I use a sewing machine, works perfectly if you use
> a thin needle and adjust the step width appropriately)
>
> 11. cut tickets apart :-)
>
> Enjoy learning ;-)
 
My enjoyment is leading to "grinding of teeth in frustration"

David

-- 
David Love
A "running mate" is a husband who dared to talk back

-- 
To unsubscribe e-mail to: users+unsubscribe@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