Topic
  • 5 replies
  • Latest Post - ‏2012-05-16T16:38:53Z by RakeshRanjanLal
RakeshRanjanLal
RakeshRanjanLal
6 Posts

Pinned topic LibreOffice Automation For OLE

‏2012-05-15T18:16:09Z |
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??
Updated on 2012-05-16T16:38:53Z at 2012-05-16T16:38:53Z by RakeshRanjanLal
  • OurGuest
    OurGuest
    163 Posts

    Re: LibreOffice Automation For OLE

    ‏2012-05-15T20:44:24Z  
    The ole automation object is:

    Set oServiceManager = CreateObject("com.sun.star.ServiceManager") ' For OpenOffice
  • OurGuest
    OurGuest
    163 Posts

    Re: LibreOffice Automation For OLE

    ‏2012-05-16T12:11:45Z  
    • OurGuest
    • ‏2012-05-15T20:44:24Z
    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.
  • SystemAdmin
    SystemAdmin
    3180 Posts

    Re: LibreOffice Automation For OLE

    ‏2012-05-16T12:30:58Z  
    • OurGuest
    • ‏2012-05-16T12:11:45Z
    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/
  • RakeshRanjanLal
    RakeshRanjanLal
    6 Posts

    Re: LibreOffice Automation For OLE

    ‏2012-05-16T16:37:12Z  
    • OurGuest
    • ‏2012-05-15T20:44:24Z
    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.
  • RakeshRanjanLal
    RakeshRanjanLal
    6 Posts

    Re: LibreOffice Automation For OLE

    ‏2012-05-16T16:38:53Z  
    • OurGuest
    • ‏2012-05-15T20:44:24Z
    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?