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

Hello

A friend is a school teacher and needs to publish a report from the data she
keeps in an Excel document. In addition, she only has access to Word/Excel,
while Access is not available (she doesn't know databases, anyway.)

I originally thought Word's mail merge would do, but without programming, it
only supports reading data from a single sheet, while data is kept in
multiple sheets (one by year). Here's a screenshot of a mock document I
re-created in LO:
http://postimg.org/image/v2au21zsh/

Unless someone knows of a good, programming-free, Excel-based solution, it
looks like the right way to solve this problem is to stop using Excel as
poor man's database, and write a real database application with tables,
relations, input forms and report output... but she obviously doesn't have
the skills, doesn't have internal resources available for help, and I can't
spend time on this.

I know it's akward to ask this in an LO mailing-list, but can someone
experimented confirm that there's no MS Office-based solution (either
internal or third-party), and that moving to LibreOffice Base is the way to
go?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146.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