Bug 45570 - Cannot embed Writer document in an IBM Lotus Notes rich text field
Summary: Cannot embed Writer document in an IBM Lotus Notes rich text field
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
3.4.5 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-02 15:38 UTC by Rodrigo Castanheira
Modified: 2013-12-05 05:17 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Rodrigo Castanheira 2012-02-02 15:38:02 UTC
Problem description: An IBM Lotus Notes application makes use of Writer documents embedded in rich text fields. The object embedding operation is performed by means of native Lotusscript methods which currently work with OpenOffice 3.2.1 but have failed every try with LibreOffice up to version 3.4.5 (the last I've tested). Those methods also work with Microsoft Office documents.

Steps to reproduce:

1. Have LibreOffice 3.4.5 installed (any version after 3.3.0 fits).

2. Create a new, empty Writer document and save it to "C:\test.odt".

3. Create a new Lotus Domino application (tested with versions 6.5.1 and 8.5.2), open it inside Lotus Domino Designer and paste the following Lotusscript code under "Queryopen" of the default view:

Sub Queryopen(Source As Notesuiview, Continue As Variant)
      Dim session As New NotesSession
      Dim doc As NotesDocument
      Dim rtitem As NotesRichTextItem
      Dim OLE As NotesEmbeddedObject
      Set doc = session.CurrentDatabase.CreateDocument
      Set rtitem = New NotesRichTextItem( doc , "rt" )
      On Error Goto didnt_work
      Set OLE = rtitem.EmbedObject( EMBED_OBJECT , "" ,  C:\test.odt" , "" )
      Msgbox "Object succesfully embedded", 64, "OLE test"
just_quit:
      Continue = False
      Exit Sub
didnt_work:
      Msgbox "Cannot embed object" & Chr(13) & "Lotus Notes error message:" & Error$, 16, "OLE test"
      Resume just_quit
End Sub

4. Save changes, close Lotus Domino Designer and run/open the application.

5. Popup window displays "Cannot embed object".

6. Uninstall LibreOffice, install OpenOffice 3.2.1, create a new "C:\test.odt" Writer document and open the Notes application.

7. Popup window displays "Object succesfully embedded".

8. Install any Microsoft Office suite and create a "C:\test.doc" Word document. Open Lotus Domino Designer and replace "C:\test.odt" with "C:\test.doc" under "Queryopen". Close Designer and open the Notes application.

9. Popup window displays "Object succesfully embedded".

Platform: Windows XP Professional SP3.
Comment 1 sasha.libreoffice 2012-02-21 06:14:47 UTC
Thanks for bugreport. It is important to improve LibreOffice.
And if set in LibreOffice Tools->Options, Load/Save->General-> "Odf format version" to 1.0 and "Size optimization for ODF format" disable? (before saving file test.odt)
Comment 2 Rodrigo Castanheira 2012-02-22 14:15:35 UTC
I appreciate your help. Unfortunately, setting "Odf format version" to 1.0 and "Size optimization for ODF format" to disable (before saving) does not help.
Comment 3 sasha.libreoffice 2012-02-22 21:45:25 UTC
Sorry for I can not help.
Comment 4 sasha.libreoffice 2012-02-22 21:48:26 UTC
@ Tor
Please, take look at this bug when will have time. Compatibility problem with Lotus Notes on Windows XP.
Comment 5 Roman Eisele 2012-05-04 07:51:00 UTC
This is a Writer issue, therefore changed the 'Component' field accordingly.
Comment 6 Joel Madero 2012-09-07 16:08:45 UTC
Can you provide the lotus domino application and attach it? I'm not sure what it is but it'd help us triage and help the developers a lot if this could be provided. We tend to not like installing other apps to create test cases :) Marking as NEEDINFO, as soon as the attachment is made please set status to UNCONFIRMED and I'll get this triaged.

Thanks for the help
Comment 7 Rodrigo Castanheira 2013-01-05 22:39:24 UTC
Sorry for my delayed response. [from Wikipedia] "IBM Lotus Notes is the client of a collaborative client-server platform. IBM Lotus Domino is the application server. Lotus Notes provides integrated collaboration functionality, including email, calendaring, contacts management, ... and access to other Lotus Domino applications and databases. Whereas typical email applications are programmed to be an email client, Lotus Notes is an application that is part of an application development platform, where mail is just one of many possible applications. Applications for Lotus Notes are developed in a variety of development languages including the Java through XPages, as well as with a Visual Basic-like language called LotusScript. Lotus Notes is commonly deployed as an end-user email client in larger organizations, with IBM claiming a cumulative 145 million licenses sold to date" [end of quote]. It is an enterprise client-server software. There is no ".exe" or ".com" related to my application, so I'm afraid there is nothing to attach. I understand that it will not be easy or even feasible for a developer to install the whole suite only to investigate this problem. After searching the web for similar problems, I've found some forum posters saying that LibreOffice has not implemented ActiveX the same way OpenOffice used to do, and I suppose this may be related to this problem. Anyway, I've decided to redesign the application so as to avoid any embedding procedures, while still using LibreOffice automation. It is currently working that way. Thank you!
Comment 8 tommy27 2013-08-25 13:35:41 UTC
changing status to NEEDINFO.
I'm just curious to know if using recent LibO releases (4.0.5 or 4.1.0) the bug reported in old 3.4.5 version would still happen.
Comment 9 Jean-Baptiste Faure 2013-12-04 22:14:26 UTC
Why do think the bug is in LibreOffice ? Did you file a bug against IBM Lotus Notes ?

Best regards. JBF
Comment 10 Rodrigo Castanheira 2013-12-04 23:34:51 UTC
I've just tested the same Lotusscript code excerpt with LibreOffice 4.1.3.2 and the bug reported in old 3.4.5 version do NOT happen anymore. The object is succesfully embedded. 
This issue seems to have been resolved. Anyway, as I said in my previous comment (2013-01-05 22:39:24 UTC), I've redesigned the application so as to avoid embedding procedures.

Best regards!
Comment 11 Rodrigo Castanheira 2013-12-04 23:39:22 UTC
P.S.: Plataform now is Windows 8.1 Pro.
Comment 12 Jean-Baptiste Faure 2013-12-05 05:17:52 UTC
(In reply to comment #10)
> I've just tested the same Lotusscript code excerpt with LibreOffice 4.1.3.2
> and the bug reported in old 3.4.5 version do NOT happen anymore. The object
> is succesfully embedded. 
> This issue seems to have been resolved. 

Thank you for the quick answer. So we can close this bug report. Because we don't know which commit fixed the problem, I will close the bug with status WorksForMe.

Best regards. JBF