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

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