Re: [Gambas-user] Connect to and control LibreOffice
On Tue, 2017-08-22 at 12:41 +0200, Benoît Minisini wrote: > 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, > Thank you for the clarification. I might be able to work with that, as the uncompressed file would be available for both reading and writing. I am also looking at controlling LibreOffice with python, as there is a fully functional 'bridge' already in existence and Gambas has a python component. As you can see, I am still trying to put the pieces of the puzzle together to achieve a useful outcome. If I get the result I am hoping for, I will post the answer here. Kind regards, Doug -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
Le 22/08/2017 à 19:07, Tony Morehen a écrit : I won't be submitting any merge requests. I made the mistake of deleting my fork of Gambas. That's why my previous merge requests were deleted. Now gitlab won't let me do a second fork, some sort of name collision. The merge request was not deleted, it was closed. You can see the changes again, as well as your DesktopFile.class on gitlab.com. So I will take your TerminalView changes and merge them by hand, and I suggest you clone the repository so that you can make a merge request again with your DesktopFile class. Regards, -- Benoît Minisini -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
Le 22/08/2017 à 18:54, Benoît Minisini via Gambas-user a écrit : Le 22/08/2017 à 18:34, Tony Morehen a écrit : You're not fixing TerminalView's Paste? You have closed your merge request, so I thought you wanted to make a new one with the changes I suggested. And if you want to modify the DesktopFile.class, make another merge request. Regards, -- Benoît Minisini -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
Le 22/08/2017 à 18:34, Tony Morehen a écrit : You're not fixing TerminalView's Paste? You have closed your merge request, so I thought you wanted to make a new one with the changes I suggested. -- Benoît Minisini -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
You're not fixing TerminalView's Paste? On 2017-08-22 11:46 AM, Benoît Minisini via Gambas-user wrote: Le 22/08/2017 à 17:35, Fabien Bodard a écrit : hum or this :-) ... on the road... And as I just fixed the TerminalView control, you can even finish the gb.term.form component. :-) -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
Le 22/08/2017 à 17:35, Fabien Bodard a écrit : hum or this :-) ... on the road... And as I just fixed the TerminalView control, you can even finish the gb.term.form component. :-) -- Benoît Minisini -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
hum or this :-) ... on the road... For now it display the grid, with zoom abilities Have multiple selection possibilities each cells have Background and borders properties each cells have font properties I have begin the work on the resolver based on Gambas expression class and standard spreadsheet functions. The goal is to have an interactive spreadsheet. with basic tools. Then it will be possible to add then a sub component to add loading functions. But my goal is to have it as simple as possible. see you soon 2017-08-22 15:39 GMT+02:00 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 > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user -- Fabien Bodard -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
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 -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
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, -- Benoît Minisini -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
Great! Here's a good reason to learn xml :-) I when I had to import (but you can also export I believe) data from Excel or Calc I used csv. Regards Gianluigi 2017-08-22 12:52 GMT+02:00 Rolf-Werner Eilert : > 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 > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
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 -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Connect to and control LibreOffice
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, -- Benoît Minisini -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Connect to and control LibreOffice
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 -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Connect to and control LibreOffice
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 -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user