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

Hi Martini,

that is a task, which should be solved using a database. If this is the only table, you can use the table itself as flat database, otherwise make a database and import the table data.

Write a query to get the value you want.

Make a report to show the result of the query.

There exist a guide for using database with LibreOffice

In Microsoft Office people often do not use a database, because the home and the small business package of MS Office do not include Access and the larger one is much more expensive. But in LibreOffice full database support is integrated :)

Kind regards

Martini schrieb:

First of all, I'm using libreoffice 5.2.6.

I've made some macros with Excel in my days but never used Calc and never
interfaced with another application (Word or Writer) so I'm pretty lost

I'd like to generate a text document using data from Calc.
Here's an anonymized example of a Calc file:
Here is the end result Id like to generate:

You can see column BCDE are meant to be a sort of paragraph header, F2:M2
are to be included if the cell is ticked, N contains a brief explanation of
the case.

Again, never used Calc for macros so I'll need basic training

Thanks for your help.

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.