Issue 92524

Summary: Chemsketch ole-objects (chemical structures) inserted from file shown as placeholder
Product: General Reporter: amic03 <amic03>
Component: uiAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: 3.4.0Keywords: needhelp, needmoreinfo
Target Milestone: ---   
Hardware: PC   
OS: Windows, all   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=117309
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
chemical structures from applications like chemsketch are not interpreted
none
just a molecule drawn with chemsketch none

Description amic03 2008-08-06 16:01:45 UTC
OLE-problem with a table with chemical names and structures drawn and saved with
ChemSketch 11 Freeware from ACD/Labs (http://www.acdlabs.com - has to be installed).

The following procedure produces just the symbol and the content of the
OLE-object is not being displayed (see attached file).
Insert|Object|OLE-Object...|Create From File|"filename.sk2"|OK.

The following procedure works but is not very convenient
1. Insert|Object|OLE-Object...|Create New|More Objects|OK 
2. Create New|Object type: ACD/ChemSketch|OK 
3. Draw any structure, then go to File|“Close and return to noname00.sk2“, next
window click „Yes“

I have tried some workaround, without success as you can see in the attached file

Could be a problem in OpenOffice or in ChemSketch?!
Comment 1 amic03 2008-08-06 16:13:45 UTC
Created attachment 55603 [details]
chemical structures from applications like chemsketch are not interpreted
Comment 2 amic03 2008-08-06 16:25:41 UTC
Created attachment 55604 [details]
just a molecule drawn with chemsketch
Comment 3 Edwin Sharp 2013-12-26 12:05:50 UTC
As given in description.
AOO410m1(Build:9750)  -  Rev. 1551017
Rev.1551017
ChemSketch 14.01
Win 7
Comment 4 Rainer Bielefeld 2014-01-14 03:34:22 UTC
How can we know that it's not a chemsketch problem?
Comment 5 Ariel Constenla-Haile 2014-01-14 03:53:48 UTC
(In reply to Rainer Bielefeld from comment #4)
> How can we know that it's not a chemsketch problem?

The file in attachment 55604 [details] has sk2 extension.
Try to open this file with OpenOffice, it does not know how to handle this extension, so the default behaviour is to open it in Writer with the plain text filter.

Now try to insert that file as an OLE object:

Insert - Object - OLE Object...
Check "Create from file" and browse to the benzene.sk2 file.
Press Ok.
The ASCII Filter Options dialog will show up.
Press Ok.
The OLE Object is inserted: a Writer document.


There is no bug here, OpenOffice does not know how to handle these kind of files.

In order to be able to insert the molecule as seen in ChemSketch, ChemSketch should provide by itself the ability to create OLE objects. This is similar to creating a new OLE object from "Further objects" (this is Windows only, on Linux there is no support for OLE objects, except from the OpenOffice document types).

Insert - Object - OLE Object...
Check "Create new"
In "Object type", select "Further objects"
Press OK, a new system dialog will show up with all the support OLE types.

For example, I have Adobe Acrobat Reader installed, so there is an option with "Adobe Acrobat Document", it will allow me to insert a PDF OLE object. But this works because it is supported by Adobe Acrobat Reader itself.
Comment 6 Rainer Bielefeld 2014-01-14 04:33:54 UTC
I can confirm reported effect with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions: 

0. Install chemsk12.exe
1. Launch AOO
2. From Start Center open new Calc Document
3. Menu 'Insert -> OLE-Abject -> Create from File -> Browse for reporter's 
   sample "benzene.sk2" -> [ok]
   > Chemsketch will open and show a chemical structure
4. Click through lots of Chemsketch-dialogs and close Chemsketch
   Expected: chemical structure shown in document
   Actual: only placeholder shown

Additional info
---------------
(a) More or less the same  in Writer (ASCII import dialog appeared during 
    first attempt in step 3, further attempts worked).
    Also fails the same way in DRAW
    So this is not a CALC problem
(b) Also fails with Lotus Symphony Release 3.0.1 Revision 20120110.2000
(c) Also fails with FreeOffice, LibreOffice 4.1.3  (some differences to AOO)
(d) Also fails with OOo 1.1.5, 3.1.1

I asked for Support at acdlabs.com, we will see whether I will get an answer.

Currently I think  acdlabs.com is the appropriate address to ask for support.

Might be related:
-----------------
<http://www.oooforum.org/forum/viewtopic.phtml?t=200278>

<http://www.google.de/url?sa=t&rct=j&q=&esrc=s&source=web&cd=9&cad=rja&ved=0CJkBEBYwCA&url=http%3A%2F%2Flibrary.reed.edu%2Finstruction%2Fchemistry%2Fthesis%2Fimages%2Flucsciwrite.pdf&ei=ULzUUrmHCNCVhQfhvIH4BQ&usg=AFQjCNHsn8foOOw3hQUvGS9HxeB_gIdwgQ&sig2=9QJeHixsXmd4BKS_K7frkw&bvm=bv.59378465,d.Yms> on page 8 offers a solution, I did not test it.
Comment 7 Ariel Constenla-Haile 2014-01-14 13:31:48 UTC
(In reply to Rainer Bielefeld from comment #6)
> I can confirm reported effect with "AOO 4.0.1   – German UI / German locale 
> [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)",
> “historic”  4.0  User Profile used for all  predecessor versions: 
> 
> 0. Install chemsk12.exe
> 1. Launch AOO
> 2. From Start Center open new Calc Document
> 3. Menu 'Insert -> OLE-Abject -> Create from File 

What I wanted to mean in comment 5 is that "Create from File" will only work for documents that OpenOffice can *import*, and will insert an OpenOffice document embedded inside the current document.

You have to use Insert - Ole Object - Create new, as described in cell C2 from  attachment 55603 [details]; in fact, "Object 1" is the only ACD/ChemSketch embedded object in that document. "Insert from file" will never work with alien formats that AOO cannot import.
Comment 8 Rainer Bielefeld 2014-01-14 15:05:57 UTC
(In reply to Ariel Constenla-Haile from comment #7)
> You have to use Insert - Ole Object - Create new, as described in cell C2

My different test results concerning different behavior of 
menu 'Insert -> Object -> Ole Object ... -> Create from File'
and
menu 'Insert -> Object -> Ole Object ... -> Further Objects -> Create from File'
     (Seems to be OS, not AOO dialog) 
currently are rather unpredictable for me. I will have to think about your comment, my results and Help contents a while.