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

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 <codecomplete@free.fr> wrote:

> 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