Reg. Integration of LibreOffice with WPF

Java, C++, C#, Delphi... - Using the UNO bridges
Post Reply
vidyacal
Posts: 5
Joined: Wed Nov 23, 2011 12:34 pm

Reg. Integration of LibreOffice with WPF

Post by vidyacal »

Hi

I am evaluating to use Open Office to do inline editing of office documents in Windows Presentation Foundation application.

I am looking to check the feasibility of doing the following tasks

1. Open office documents(word, excel, powerpoint, etc) in the same application window (Inline editing of documents)

2. Integrating/using Open office in WPF application using c# scripting.

Could you please let me know if this can be achieved using Open office?


Thanks
Last edited by vidyacal on Wed Nov 23, 2011 6:02 pm, edited 2 times in total.
open office 3.3,windows 7
User avatar
floris v
Volunteer
Posts: 4431
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Support Required

Post by floris v »

Welcome to the forum. Please note that this forum is run by users, not developers. This subject really belongs in the Macros and API forum.

As to your questions:
#1 I don't think that'll be possible, except with very simple documents. There are too many compatibility problems between OOo and MSO.
#2 I don't know, you'd have to get the software development kit for OOo.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
rudolfo
Volunteer
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: Support Required

Post by rudolfo »

Hm, floris v was a bit earlier saying more or less the same, but for the sake of ActiveX I post this anyway:

For some reason I can only think of Word Perfect when I see the abbreviation WPF? Allthough the final F won't really match. You might look in the macro forum which has a special subforum for OpenOffice togehter with external programs: Macros and UNO API: External Programs.
There is a UNO bridge for C#, so scripting through C# is supported. Inline editing is a bit difficult: Mostly the UNO bridge is used for (automated) backend operations (file format conversion and the like). If you need the GUI frame for editing interactively I am not sure if the UNO bridge can help you, but you can use the COM/ActiveX Interface of OpenOffice on MS Windows systems.
And if you think of Word, Excel, Powerpoint if you say "OpenOffice Documents", it might be easier for you if you use Microsoft's Office Suite for your purposes. Interoperability for these binary formats is okay in several cases, but for more complicated documents you might see format distraction.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
User avatar
floris v
Volunteer
Posts: 4431
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Support Required

Post by floris v »

WPF is short for Windows Presentation Foundation.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
vidyacal
Posts: 5
Joined: Wed Nov 23, 2011 12:34 pm

Re: Support Required

Post by vidyacal »

Thanks for your response.

As you suggested I have posted the same question in Macros and UNO API: External Programs as well.

rudolfo, Is there any COM/ActiveX Interface of OpenOffice is availabe to integarate with .net?
open office 3.3,windows 7
rudolfo
Volunteer
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: Support Required

Post by rudolfo »

Maybe I should have mentioned in the other thread that it would be wise to change the title of the thread to something more specific before you repost in a different forum. But no problem you can change the title, also afterwards.
For your question from the original thread about the ActiveX/COM interface you might find some positive answers at:
Automating OpenOffice.org
Uno Bridge for CLI/.NET
 Edit: And searching the macro forums for ActiveX or UNO bridge is also a good idea. 
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
User avatar
RoryOF
Moderator
Posts: 34613
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Support Required

Post by RoryOF »

It would be better, as rudolfo says, to change the thread title, and best to change it to something more meaningful. One can take it for granted that almost every thread originates as a request for help.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
vidyacal
Posts: 5
Joined: Wed Nov 23, 2011 12:34 pm

Re: Reg. Integration of Libre office with WPF

Post by vidyacal »

I think it will be better if i am explaining my requirements a bit more . Please find my goals as follows:

1). Able to view Microsoft documents (Word,excel,powerpoint , etc..) from within application
2). Able to edit Microsoft documents (Word,excel,powerpoint , etc..) from within application
3). Keep the code purely managed.
4). Keep the document viewer / editor as light weight as possible.
5). Migrate doc to docx.
6). Not interfere with other applications running that use Microsoft
Word (such as Outlook).
7). The application will use the WPF (Windows Presentation Foundation) technology.

I am redesigning a current application that uses the DSO Framer. Although the DSO Framer has given me some of the items above.

Could you please suggest me how to use libre Office to achieve the above goals.

Regards,
Vidya
Last edited by vidyacal on Wed Nov 30, 2011 10:44 am, edited 1 time in total.
open office 3.3,windows 7
User avatar
floris v
Volunteer
Posts: 4431
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Reg. Integration of Libre office with WPF

Post by floris v »

You can't. Period. Use MS Office instead. The .docx format is still quite tricky for OOo (LibreOffice is better at it, but we still get regular docx files that LO can't open).
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
vidyacal
Posts: 5
Joined: Wed Nov 23, 2011 12:34 pm

Re: Reg. Integration of Libre office with WPF

Post by vidyacal »

Is there any Activex control available for Libre Office/ Open Office to check its functionality?
open office 3.3,windows 7
rudolfo
Volunteer
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: Reg. Integration of LibreOffice with WPF

Post by rudolfo »

There is no separate ActiveX control as you have it for example for Acrobat Reader. But as I have mentioned before OpenOffice and LibreOffice for MS Windows have a COM/Automation interface. See the above mentioned references.
And yes, this means to check it out you have to install either OpenOffice or LibreOffice.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
User avatar
floris v
Volunteer
Posts: 4431
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Reg. Integration of LibreOffice with WPF

Post by floris v »

I strongly suggest that you first test if LO can actually handle your docx's to your satisfaction. So far OOo can't even save in that format.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
gabrielel
Posts: 2
Joined: Mon Sep 29, 2014 4:21 pm

Re: Reg. Integration of LibreOffice with WPF

Post by gabrielel »

Hi vidyacal! I have your same problem? Can you help me?
Thanks a lot
Gabriel
OpenOffice 3.1 Windows Vista
Post Reply