On 03/19/2014 10:24 AM, Gilles wrote:
Here's a better illustration of what I mean: http://postimg.org/image/hw6kh9vx1/ -- View this message in context: http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102157.html Sent from the Users mailing list archive at Nabble.com.
Gilles,A non programming way is to manually generate a new sheet for each student which is a royal pain. I suspect this step will be very time consuming. Then use mail merge to link to each student's page and generate individual reports. I can not think of a tool that would work without some modification either to the data or the tool to do what you want. I suspect what most people do, is just "bite the bullet" and do it manually. Any "nice" solution requires using a database and possibly being able to write a script to automate the task which is well beyond the skills of most people.
One potentially nasty problem is duplicate student names such as two Mary Smiths or Tom Jones and the program can easily differentiate between the two people. I did see a "id" column which has a unique id for each student such as msmith000, msmith001. This would require someone to prep that data for any automated tool.
If you could transfer the data to Base, then the report builder tools might generate the reports automatically.
-- Jay Lozier jslozier@gmail.com -- 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