Ask Your Question

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

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-15 16:26:05.586348

1 Answer

Sort by » oldest newest most voted

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

Lupp gravatar image

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

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

Question Tools

1 follower


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

Seen: 352 times

Last updated: Sep 16 '17