Re: [libreoffice-users] Creating a text document from a Calc spreadsheet

2017-04-20 23:27 GMT+02:00 Regina Henschel <rb.henschel@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+unsubscribe@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+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