Ask Your Question

How do I get a report out of Calc and into Writer?

asked 2017-09-16 19:58:40 +0200

ljfnord gravatar image

I need to store data in Calc and run some sort of macro or report that spits it out in Writer format, without the tables. I'm only dealing with 13 rows (a number that may vary) by 8 columns (a fixed number), but I need to make conditional decisions based on cell contents as to what gets output (or if anything gets output at all). Is this possible?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-16 22:01:34 +0200

Lupp gravatar image

updated 2017-09-16 22:19:04 +0200

This is clearly possible, but I don't think somebody can tell you with a few words how to do it. If you want to try to do it yourself you will need to study how to use the API in one of the supported programming languages. If you want to do it in LibreOffice BASIC with its bridge to the API, you may start here or **here or with the famous texts ("Book", "Useful Information") by Andrew Pitonyak. They are to find here.

Others may be better in giving hints how to do it in Python or otherwise.

An even better way should be to keep the data im a database and to generate the 'Writer' file as a report.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-16 19:58:40 +0200

Seen: 177 times

Last updated: Sep 16 '17