[Gambas-user] Connect to and control LibreOffice

[Rolf-Werner Eilert]

Am 22.08.2017 13:05, schrieb Benoît Minisini via Gambas-user:
> Le 22/08/2017 à 12:52, Rolf-Werner Eilert a écrit :
>> Am 22.08.2017 12:41, schrieb Benoît Minisini via Gambas-user:
>>> Le 22/08/2017 à 05:47, Doug Hutcheson a écrit :
>>>> On the page http://gambaswiki.org/wiki/doc/intro?nh is this
>>>> information:
>>>>
>>>> Gambas is build on top of many free softwares, and could not exist
>>>> without them.
>>>> So I would like to thank every people involved in the following
>>>> projects:
>>>>   * Linux
>>>>   * KDE
>>>>   * GCC and all of the GNU tools, of course.
>>>>   * The Qt toolkit.
>>>>   * The GIMP and its toolkit GTK+.
>>>>   * Libre Office.
>>>>   * The MySQL, PostgreSQL and SQLite database management systems.
>>>>   * And any other libraries used by Gambas.
>>>>
>>>> The reference to LibreOffice is interesting. Does it mean there are
>>>> built-in 'hooks' into LibreOffice? I suppose that would be too much to
>>>> hope for, but perhaps there is a 'bridge' between LO and Gambas? I need
>>>> to update several LO spreadsheets in tandem with creating and
>>>> maintaining a new PostgreSQL database storing the same data but in
>>>> properly normalised tables.I cannot change the structure of the
>>>> existing spreadsheets, so just uncompressing them and running search-
>>>> and-replace processes is not quite good enough.
>>>>
>>>> Any pointers to help in this would be welcome, even if only to say I am
>>>> wasting my time.    "8-)
>>>> Kind regards,
>>>> Doug
>>>
>>> No, it just means that I used LibreOffice to write some presentation
>>> files. :-)
>>>
>>> When I want to create a LibreOffice file, I do the following:
>>>
>>> - I create a "template" LibreOffice file that has the look of the final
>>> file, and where the data I want to put is replaced by string patterns.
>>>
>>> - I unzip the LibreOffice file.
>>>
>>> - I modify the content.xml file by replacing the string patterns with
>>> the final data.
>>>
>>> - I zip the result, and I get my final LibreOffice file.
>>>
>>> Regards,
>>>
>>
>> Clever :) I will print this and pin it to the wall... Might even be a
>> way to cope with Scribus.
>>
>> Regards
>>
>> Rolf
>>
>
> Of course it is actually more complex: the structure of the content.xml
> file is sometimes difficult to manage, especially with LibreOffice
> sheets. Using the XML components may help.
>
> Regards,
>

Yeah, ok, I am fully aware of that. But if I would need a single sheet 
of paper with some graphical stuff (a form to fill and check some 
squares etc.) this might help.

Regards
Rolf