Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.