LibreOffice Automation For OLE

Hi,
Anybody can please explain the steps in DXL to open, read, write, save and close a LibreOffice and OpenOffice calc document.
I tried and could open the service manager of LibreOffice. But how to open spreadsheet next and implement methods for this??
RakeshRanjanLal - Tue May 15 14:16:09 EDT 2012

Re: LibreOffice Automation For OLE
OurGuest - Tue May 15 16:44:24 EDT 2012

The ole automation object is:

Set oServiceManager = CreateObject("com.sun.star.ServiceManager") ' For OpenOffice

Re: LibreOffice Automation For OLE
OurGuest - Wed May 16 08:11:45 EDT 2012

OurGuest - Tue May 15 16:44:24 EDT 2012
The ole automation object is:

Set oServiceManager = CreateObject("com.sun.star.ServiceManager") ' For OpenOffice

More info can be found here: http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html

You will have to translate the VB to DXL.

Re: LibreOffice Automation For OLE
SystemAdmin - Wed May 16 08:30:58 EDT 2012

OurGuest - Wed May 16 08:11:45 EDT 2012
More info can be found here: http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html

You will have to translate the VB to DXL.

The problem is the call to "loadComponentFromURL" which requires an array type variable as it's last argument. And that is not something DOORS OLE functions can handle.

Had the similar kind of problem in Lotus Notes, so I would say that it is not possible to use OpenOffice / LibreOffice from DOORS OLE. If somebody can show a way use array variables then that would be excellent.

  • Pekka Mäkinen - http://www.softqa.eu/

Re: LibreOffice Automation For OLE
RakeshRanjanLal - Wed May 16 12:37:12 EDT 2012

OurGuest - Tue May 15 16:44:24 EDT 2012
The ole automation object is:

Set oServiceManager = CreateObject("com.sun.star.ServiceManager") ' For OpenOffice

Hi,
I tried this script but it opens the LibreOffice only. How to open the spreadsheet after this?
problem I am facing to use "Set oDesk = oSM.createInstance("com.sun.star.frame.Desktop")" and
"Set oCalc = oDesk.loadComponentFromURL("private:factory/scalc", "_blank", 0, arg())".
DXL is throwing error.

Re: LibreOffice Automation For OLE
RakeshRanjanLal - Wed May 16 12:38:53 EDT 2012

OurGuest - Tue May 15 16:44:24 EDT 2012
The ole automation object is:

Set oServiceManager = CreateObject("com.sun.star.ServiceManager") ' For OpenOffice

If we use "Excel.Application" as OleAutoObj, it opens the excel sheet directly. Is there any similar method there to open LibreOffice calc?