Copy and Paste with IDs

It is possible to copy and paste from a sheet, which contains IDs associated with structures and a few columns with data. See the following sections for more information about IDs associated with data:

There are several ways to perform copy and paste action in JChem for Excel. These are as follows:

  • Using Ctrl+C to copy and then Ctrl+V to paste.

  • Using the Copy and Paste buttons, which are available through the context menu and the ribbon.

It is possible to combine the above-mentioned methods.

The following scenarios are supported:

  • Copy and paste single IDSYSstructure to another Excel object (cell, worksheet, workbook). In this case, the whole IDSYSStructure function will be pasted.

  • Copy and paste single IDSYSstructure to another MS Office application (for example, PowerPoint , Word, or Outlook). In this case, the structure will be pasted together with the corresponding ID, which will be displayed under the structure. For this to work, Options > Event Handling > Keyboard Events > Ctrl+C and Ctrl+V runs JChem for Office Copy/Paste must be set to TRUE .

  • Copy and paste IDSYSStructures with data as a table to another Excel object (cell, worksheet, workbook). In this case, the whole table will be pasted keeping the IDSYSStructure functions.

  • Copy and paste IDSYSStructures with data as a table to another MS Office application (for example, PowerPoint , Word, or Outlook ). In this case, the whole table will be pasted, structures will be pasted together with the corresponding IDs, which will be displayed under the structure. For this to work, Options > Event Handling > Keyboard Events > Ctrl+C and Ctrl+V runs JChem for Office Copy/Paste must be set to TRUE .

If you only have a JChem for Excel license (without JChem for Office license) and you are pasting to other MS Office applications, IDs will not be displayed under the structures.

  1. Select the IDSYSStructure column and other columns you would like to copy to other MS Office applications.

  2. Press the Copy button on the ribbon.

    images/download/attachments/1806450/ID_Copy.png
  3. Change to a Word, PowerPoint, or Outlook document and position the cursor somewhere in the document.

  4. Press the Paste on the button.

  5. The structures and corresponding data are pasted in a table to the opened document (in this case Word), IDs are displayed in the same cells under the structure.

    images/download/attachments/1806450/ID_Paste.png