Print shadded on exam form

Discuss the spreadsheet application

Print shadded on exam form

Postby amcform » Sun Dec 18, 2016 6:23 am

hi
i mad AMC exam form (optical mark recognition)like this:
Image

and i made calc file to shadded students numbers and print students name on the forms (in attachment file).
the problem: i don't know how i can print the calc file on all forms automaticaly, now, the calc file can shadded and print the name for 1st student (only).
Attachments
form_omr.ods
(13.64 KiB) Downloaded 37 times
OpenOffice 3.1 on Windows Vista
amcform
 
Posts: 2
Joined: Sun Dec 18, 2016 6:13 am

Re: print shadded on exam form

Postby Lupp » Sun Dec 18, 2016 8:11 pm

Most likely I do not understand, but...

Do you want to print a kind of layout with many different values taken from a data collection again and again?

This is known as 'Mail Merge' and only implemented for 'Writer' documents (which may contain graphical objects, of course). The source of the changing insertions (names e.g.) can be a registered database then, and in this role a properly formatted (in fact: a rather unformatted simple table) sheet of a Calc document.

If you already spent a lot of time with the preparation of a spreadsheet as the "mother of the form" you may try to export it to .png and to insert it into a 'Writer' document as an image... This will not allow further editing, of course... Then make a mail-merge document of it...

Another approach would be to write a little "macro" which inserts the data from the table row by row into the respective cells of the "form" sheet and prints that sheet again and again.

See also: https://ask.libreoffice.org/en/question ... m-in-calc/
(If you post the same question in more than one forums, please always include links both ways.)
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2617
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Print shadded on exam form

Postby amcform » Mon Dec 19, 2016 8:29 am

thanks Lupp
now, i change the document to make it easy.

if you see the form_omr2.ods in attachment, i made 3 steps:
1- select the student number from the drop down (under the blue title).
2- select the student name from the drop down (under the blue title).
3- click on "print" button to print the page.

repeat or return this steps again for the 2nd student and the 3rd ..... .
i want macro to do all steps for all student the table, i hope you understand me.

regards
Attachments
form_omr2.ods
(15.98 KiB) Downloaded 34 times
OpenOffice 3.1 on Windows Vista
amcform
 
Posts: 2
Joined: Sun Dec 18, 2016 6:13 am


Return to Calc

Who is online

Users browsing this forum: YaCy [Bot] and 24 guests