2017-04-20 23:27 GMT+02:00 Regina Henschel <rb.hensc...@t-online.de>:
> Hi Martini, > > that is a task, which should be solved using a database. On the other hand, what's the fun of that…? :P Kind regards Johnny Rosenberg > 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.documentfoundati >> on.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+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns > ubscribe/ > 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 > -- To unsubscribe e-mail to: users+unsubscr...@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