Simplest way to print rows to separate pages?

English
#1

I have a gradebook created in LibreOffice Calc. The columns have headings (A = lastname, B = firstname, C = grade on assignment 01, etc.). Each row represents a separate student and his/her scores.

I would like to print each row (accompanied by column headings) to separate pages to distribute to students. Ideally, I would be able to print three of four of these to each page, cut them apart and distribute them.

I had figured this out on Excel year ago but I cannot recall anything about how I accomplished the task. So, my question is, again, what is the simplest way to accomplish this in LibreOffice Calc?

Any pointers to workable examples will be most appreciated!

#2

I think you mean the AutoFilter

#3

Thanks for the suggestion.

I must be missing something regarding your suggestion of AutoFilter, though.

Wouldn’t this require that I select each row manually and then print them off, one-by-one?

#4

In a second sheet, duplicate the data, with a formula like:
Sheet2.A2: =Sheet1.A2

Change the row heigh for one that make keeps the number of rows what you like in one page.
Maybe set up cell format to Alignment-Vertical-Middle, can help to place better the data in the print.

#5

Ah, OK. Thanks, mariosv!

Your answer must have rolled-in when I started composing my own. Yours, too, looks like very useful information!

#6

OK, I think that I have a workable solution. The probability is very high that I do not have the simplest solution.

I took a look at the following document and learned how to create a database from a spreadsheet (p. 26) :

 https://wiki.documentfoundation.org/images/9/97/GS4008-GettingStartedWithBase.odt

Then, using the instructions provided here, I created a mail-document :

 http://openoffice.blogs.com/openoffice/2007/01/mail_merge_in_o.html

Once formatted the way I wanted, I printed to file, inspected, and printed to paper for distribution to the students.

Thanks, JohnSUN, for your reply. That will help me further down the road.

#7

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.