Re: [libreoffice-users] Re: Turning spreadsheet data into legible report?

On 2014-03-20 02:55, Gilles wrote:
> Sorry about that.
>
> The spreadsheet 1) has too many columns to fit on a document, even in
> Landscape mode (she wants Portrait), and 2) data are spread on multiple
> sheets, one by year.
>
> She needs to print the data thusly:
> =================
> Last Name: Doe
> First Name : Jane
> Date of Birth: 12/12/2000
>
> Year 2012-2013
> Trimester 1
> Col1 | Col2 | Col3
> Trimester 2
> Col1 | Col2 | Col3
> ...
> Year 2013-2014
> Trimester 1
> Col1 | Col2 | Col3
> Trimester 2
> Col1 | Col2 | Col3
> =================
>
> So she needs some way to turn the spreadsheet into the above *while keeping
> data in different tabs* (one per year) since the list of students is
> different every year.
>
> Ideally, it should be doable with a spreadhseet (Excel or Calc) and some
> programming-free tool, but Word can't handle more than one tab in a
> spreadsheet. Like I said, she can't work with a database.
>
> Incidently, this problem is very common since a lot of users rely on Excel
> as poorman's database. I wonder how they all manage once they hit this type
> of issue.
>
> Thank you.
Hi.
I assume also that students will come and go, some could be in 2013-2014 
but not in 2012-2013 or 2014-2015 and may not even have data for all 
trimesters. What would you start at the year the student first appeared 
or have blank preceding years.
Steve
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102153.html
> Sent from the Users mailing list archive at Nabble.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