Skip to Content
author's profile photo
Former Member

Open Office Integration

Hi All,

We are trying to integrate Open Office with SAP but running out of luck. I tried maintaining the OLE entries but not sure if I am missing any steps. Do I need to activate this in any other way other than running RSOLEINT. How do I see the changes? Downloading to a spreadsheet on a PC that just has Open Office and not Excel, results in an error stating "Not possible to setup a DDE connection to a local display service".

Please advice.

Thank You.

PS: Sorry if you have already seen this question in a different forum. I am just trying my best to get as much audience as possible.

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • author's profile photo
    Former Member
    Posted on Feb 23, 2005 at 05:07 AM

    Hi,

    Take a look at this wonderful article on SAP Desktop Office Integration Using ABAP Objects at http://www.intelligent-apps.com/feature/archive/ehre.jhtml . See if it helps with your efforts.

    There has been a lot of discussion already on DOI on this forum. Try searching for OLE and I am sure you will get something useful. Otherwise, please post your code so that we can try to assist you.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 23, 2005 at 08:46 AM

    Hi,

    I haven't heard of complete desktop office integration (DOI) with Open Office - so direct calls and field fillings.

    But I worked already with a 4.7 system, where some documents were stored in SBWP (common folders). On my computer were installed MS Office and Open Office, which was configured to handle all files (like *.xls, *.doc, ...). By clicking a spreadsheet or textdocument (with excel or word icons 😊) file was downloaded and my Open Offices opened. After saving I could upload changed version - pretty much like other users with MS Office.

    To test your general settings: works download / change / upload with MS Office? If yes, is your Open Office configured to handle MS file formats by default?

    Regards,

    Christian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I haven't worked with Open Office before, but a quick search on www.openoffice.org revealed that an ActiveX is installed for Windows. For further details on ABAP OLE Automation Controller, take a look at ABAP Programming and Runtime Environment-->External Program Interfaces in the SAP Documentation installed on your app server. There are various samples available in SAP, trn code DWDM, for ActiveX integration and OLE automation. Please check these out.

      For the standard list download functions in SAP, I don't think you can replace those with your own, but as far as ALV is concerned, you can create your own button in the application toolbar that launches the OpenOffice Application you desire.

      Please get back with what you have tried so far and then perhaps we can figure out a way.

      Regards

  • author's profile photo
    Former Member
    Posted on Feb 24, 2005 at 02:24 PM

    Thanks a lot guys for all the helpful suggestions. I guess I will end up spending a lot more time on this than I visualized. Will keep you posted on what I could achieve on this. Please let me know if you come across anything more on this topic.

    Thanks again.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Christian Wohlfahrt

      Hi Christian,

      Thanks for spending time on this. Truly appreciate the effort. It makes sense that the file has to be named with ".csv" extension. If by mistake ".txt" is assigned then the user has to go through an extra step by opening the application first. I wish there was a similar way if the user saves it as .xls extension. Reason for this being that, users are so used to Excel and downloading the files with .xls extension. Right now all tab-delimited files saved with ".xls" are opened as preformatted text files. Wish there was a macro that checks to see if its a tab-demilited file and does the appropriate logic.

      Thanks again...