Copy to Clipboard Marvin OLE Shapes and Cell Values

Back to index page

It is possible to convert the structures to shapes and copy them with other cell values to the clipboard in one step and paste them into another Microsoft Office application.

1.Select some structures and some other data (e.g.: CDBREGNO, MOLFORMULA, MOLWEIGHT) on a worksheet.
2.Copy them to the clipboard by using the Convert|Copy to Clipboard Shapes and Cell Values|Marvin OLE Shape context menu.

       Cells.CopyPasteOLEandCellValues

       

3.Change to a Word document and position the cursor somewhere in the document.
4.Make a right mouse click.
5.Select the ChemAxon Data context menu item.

       Menu.RightClick.ChemAxonData

There are three available formats to paste the structures into the Word document:

Marvin OLE Object
ChemAxon ActiveX Control
EMF Office Image

In case of the first two formats, structures are editable, but it is not possible in case of the third format.

6.Select an option and paste the structures in the selected format with cell values into the Word document.
7.The structures as shapes and the other data are displayed in the Word document.

       Word.PastedImagesandCellValues

 

You can use this function to paste structures as shapes with other data from Microsoft Excel into another Microsoft Office applications (e.g.: PowerPoint).

Currently there is no difference between the Convert|Copy to Clipboard Shapes and Cell Values|Image Shape and Convert|Copy to Clipboard Shapes and Cell Values|Marvin OLE Shape functions. All of the three paste formats are available in both cases.


Back to index page

Do you have a question? Would you like to learn more? Please browse among the related topics on our support forum or search the website. If you want to suggest modifications or improvements to our documentation email our support directly!