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
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook
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
Regina
Martini schrieb:
Hi,
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
here.
I'd like to generate a text document using data from Calc.
Here's an anonymized example of a Calc file: https://ufile.io/yt27b
Here is the end result Id like to generate: https://ufile.io/j3e87
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:
http://nabble.documentfoundation.org/Creating-a-text-document-from-a-Calc-spreadsheet-tp4212734.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to: [email protected]
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
