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
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: 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.