Excerpt |
---|
If you use a Mac and ChemDraw, learn the procedure to copy-and-paste ChemDraw elements for roundtrip editing with MS Office 2016 documents. The changed occurred after Microsoft Office 2011 (Mac) and staying with that version of Office is not a viable long-term solution. |
Summary, for end-users
If you use a Mac and ChemDraw, now is the time to learn the procedure to copy-and-paste ChemDraw elements for roundtrip editing with MS Office 2016 documents. The changed occurred after Microsoft Office 2011 (Mac) and staying with that version of Office is not a viable long-term solution.
Here is the procedure to copy a ChemDraw object into MS Office 2016's Word or PowerPoint applications:
- Step one is unchanged: copy (⌘+C).
- Step two has changed: Paste as PDF (⌘+Control+V) into an Office 2016 document. (This is instead of drag and drop or a simple "Paste" (⌘+V)).
With the end of the support lifecycle for Office 2011 on 10/10/2017, it may no longer be possible to install Office 2011 on newer versions of macOS.
Chemistry IT sharing information to the department:
Prior information from Chemistry IT on this topic:
- http://it.chem.cornell.edu/2016/12/19/new-chemdraw-16-mac-roundtrip-editing/
- http://it.chem.cornell.edu/2015/10/30/chemit-flash-2015-10/
Table of Contents
Table of Contents |
---|
What you need to know: Mac's MS Office and ChemDraw
The procedure to copy-and-paste ChemDraw elements for roundtrip editing with MS Office documents changed after Microsoft Office 2011 (Mac)
Microsoft changed how pasting works in Office 2016 for the Mac:
- http://forums.cambridgesoft.com/messageview.aspx?catid=12&threadid=3415
- http://forums.cambridgesoft.com/messageview.aspx?catid=12&threadid=3187
Similar programs have the exact same issue, also requiring you to "Paste as PDF" on the Mac:
- https://www.chemdoodle.com/features/universality/
- Round-trip Editing: Round-trip editing allows you to insert content into 3rd party applications, and then place that same content back into ChemDoodle from that 3rd party application for further editing. Round-trip editing is supported on Windows through OLE, Mac OS X via PDF and on Linux with OpenOffice.
Continuing to use Microsoft Office 2011 (Mac) is not sustainable
Up to now (as of August 2017), most people in our department have managed this change by continuing to use Office 2011 for Word and PowerPoint. This strategy is not sustainable for the reasons cited below.
1) Microsoft currently offers just Office 2016, and no other version is available for download via Office 365 to personal computers.
- Statement still valid, as of 8/2017.
2) End of mainstream support (no more security patching) for Microsoft Office 2011 on October 2017.
3) Also, support may end simply by virtue of new Mac OS's. For example, macOS 10.13 "High Sierra" has a new file system (APFS). Although APFS nominally may run any software newer than ~2009, might not for some specifically such as MS Office 2011. Example:
Info more for Chemistry IT staff
Status in Chemistry:
As of August 2017:
Researchers and others to perhaps reach out to in person:
...
Communication plan:
...
"Round trip" editing ChemDraw figures embedded within Office 2016 documents sometimes does not behave as expected as Office versions change. Here's how to fix some problems |
Why you need this page
On a Mac, sometimes round trip editing with ChemDraw to and from MS Office applications work great, including the release of MS Office 2016 v15.x. However starting at least with MS Office 2016 v16.12, it we discovered it started to fail with just PowerPoint. It still worked fine with MS Word. Such changes might occur in the future at any time so we here document a work-around we hope will still work in the future.
A solution
If pasting into ChemDraw from MS Powerpoint results in a non-editable version of the image:
- First paste into Word
- Copy and paste back into ChemDraw
- The image should now be editable by ChemDraw
As seen in the past, this solution may unfortunately change in the near future. There are many places (Powerpoint, Word, or ChemDraw) where this can change with a newest version release. This solution currently works for MS Office 2016 v16.12
...
Supporting Documentation
What we know
After viewing Clipboard information using Apple's ClipboardViewer, we found that image copied from ChemDraw, into Word, and back into ChemDraw contains the exact number of bytes, resulting in no quality loss. This was a concern as many posts on the internet had been reporting fuzziness, however this doesn't seem to be an issue for ChemDraw. Images are identical.
What we don't know
For some reason, when pasting into Powerpoint (either from ChemDraw or Word), the resulting image loses some bytes (in our test it went from 6835 to 4296). However, when pasting back into Word and subsequently ChemDraw, the original number of bytes are displayed. Perhaps MS Word converts the other remaining metadata from Powerpoint and rebuilds the original image? This tells us that even older images that have stopped working with roundtrip editing may be able to be "revived" by this Word conversion.
Blog post that gave some original guidance and introduced ClipboardViewer
ChemDraw 16:
Came out ~11/1/16:
The issues in the following section all apply to ChemDraw 16 as well as Chemdraw 15 and Chemdraw 15.1 on Apple MacOS computers.
To do:
Work through this statement from a user at PerkinElmer's support page to see if it's really true:
http://forums.cambridgesoft.com/messageview.aspx?catid=12&threadid=3415
- Topic Title: Chemdraw Prime 15 copy and paste completely broken
- Topic Summary:
- Created On: 8/24/2016 2:13 PM
- (...)
- 4/13/2017 3:09 AM
adpnm27
No support have it totally wrong, follow this procedure and the cut/paste will return without problems.
What and where is the metadata embedded in files which can roundtrip?
- Figure this out for both TIFF (paste onto the desktop, for example) and(?) PDF (as in "Paste as PDF").
- This article <https://dgleich.wordpress.com/2017/01/16/fuzzy-pixelated-pdf-copy-paste-from-macos-preview/> states:
So eventually I track down Clipboard Viewer to look at raw clipboard data. This was invaluable!
What of Apple's Office-like applications?
- Keynote. Heavily used by Geoff Coates, for example
Ensure the following compatibility behavior matrix is completed and accurate
- For any more-recent version of MacOS (macOS), Windows, and ChemDraw.
- Pay attention to version of MS Word (MS Office).
- Similar cut-and-paste issue as with MathType, apparently.
- Note: When creating pasting from CD into Windows (Office 16), it is possible to Paste Special from ribbon as a "CS ChemDraw Object" - double click image to roundtrip edit
- All with current version of ChemDraw (v16).
...
From ChemDraw to the following type of Word file:
...
Tested file on left on a Mac:
Open in Word (Office 2011) => ChemDraw
...
Tested file on left on a Mac:
Open in Word (Office 2016) => ChemDraw
...
Tested file on left on Windows:
Word (Office 2016) => ChemDraw
...
Created/ edit on a Mac: Office 2011 (Word):
- METHOD 1 (default): Drag or cut-and-paste
...
Created/ edit on a Mac: Office 2011 (Word):
- METHOD 2 (new): Paste Special => PDF
...
- METHOD 1 (default): Drag or cut-and-paste
...
- METHOD 2 (new): Paste Special => PDF
...
Created/ edit on a Windows: Any Office version (Word):
- The basic METHOD (default): Drag or cut-and-paste
...
Old ChemIT documentation - notes and history
See also:
Issues with Round trip editing on Macs
- For those using Office 2011 on Macs, it was possible to be able to drag and drop from Chemdraw into Word 2011 and drag and drop the image back into Chemdraw for editing. This is no longer the case for Office 2016.
- Dragging and dropping from ChemDraw 15.1 to Word 2016 will paste an image into the Word document but the image will NOT be editable
- Copying(⌘+C) and Pasting (⌘+V) will only paste text into Word(2016)
- IMPORTANT: Opening an old Office 2011 file in Office 2016 and re-saving it will not affect the images already in the document (you can drag them into Chemdraw for editing). However, anything dragged into Office 2016 will still not be editable.
- You must instead "Paste as PDF" (via menu or via ⌘+Control+V).
- You must instead "Paste as PDF" (via menu or via ⌘+Control+V).
Supporting documentation
- Issue came up with MS Office 2016, back in version ChemDraw v13:
- Still a noted issue with ChemDraw v15:
7 Known Issues, Limitations and Workarounds (as of download date 10/31/2016)
The following list describes the known issues, limitations, and workarounds for ChemOffice 15.1:
• When you copy any object from ChemDraw (Mac) and paste (default) in MS Word 2016, it pastes an MOL text version of that object instead of the original object view.
o Workaround: Use the 'Paste Special >> PDF option in MS Word to get the original object view pasted. This PDF object can be copied back to ChemDraw by maintaining all ChemDraw object properties.
...