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

The real question is what sort of report she needs. It's all good and
well showing us a screenshot of a document with two sheets, but without
knowing what you want to do with that data, there's really no advice we
can give.

On Wed, 19 Mar 2014 05:54:51 -0700 (PDT)
Gilles <> wrote:


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:

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:
Sent from the Users mailing list archive at

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.