Actions Reference

This section consists of the following subsections:

AboutAction

Opens the About JChem for Excel window to show the exact version number.

AddEditStructureSingleCellAction

Opens the structure editor to add a new structure to an empty Excel cell or to edit the existing structure in the Excel cell.
For more information, see Add a Structure to a Cell and Edit a Structure in a Cell.

AddEditStructureTaskPaneAction

Opens the Task Pane Editor to add a new structure to an empty Excel cell or to edit the existing structure in the Excel cell.

ClearFilterAction

Clears the actual structure filtering and displays the hidden rows with structures again. For more information, see Structure Filter.

DecreaseStructureSizeAction

Decreases the size of the structures by 10%. It resizes both the column width and row height. For more information, see Resize Structures.

EmbedInJCSMILESAction

Displays SMILES as an embedded function. The function (JCSysstructure) that describes the structure will be embedded into JCSMILES function and as a result, SMILES appears in the cell.
This action works differently from ConvertToSMILESAction because it doesn't convert the structure to SMILES, but keeps the original structure information providing the possibility to switch with a simple click between SMILES and structure. Structures can be displayed again by using the UnembedFromJCSMILESAction.
This action is not available on the ribbon as a button by default. It can be added easily by customizing the ribbon. For more information, see Customizing the Ribbon.

HelpAction

Opens JChem for Excel User Guide.

IncreaseStructureSizeAction

Increases the size of the structures by 10%. It resizes both the column width and row height. For more information, see Resize Structures.

LicenseAction

Starts the ChemAxon License Manager to manage ChemAxon licenses. For more information, see License Management.

MoleculeWorksheetFilterAction

Filter structures on the active worksheet. It is possible to search for structures by a query structure and specified search options.
Filtering can be saved with the workbook. It is also possible to apply more structure filtering right after each other to narrow step by step the hit list. For more information, see Structure Filter.

OpenStructureSingleCellAction

Opens a single structure from a wide variety of file formats. The following file formats can be opened: CDX, MOL, MRV, PDB. For more information, see Insert Single Structures.

OptionsAction

Opens the Options form, where default display settings and application behavior can be defined. The settings specified here are saved for the next sessions. For more information, see Options in JChem for Excel.

RedrawStructuresAction

Redraws structures if the structures are hidden from the worksheet because of any reason.

RemoveHitColoringAction

Removes hit coloring from the filtered structures. For more information, see Structure Filter.

ResizeStructuresToDefaultInSelectionAction

Resizes structures to the default structure size in a selected area. This action is not available in the JChem for Excel ribbon/context menu/menu/toolbar by default but it is possible to make it available by customizing the ribbon/context menu/menu/toolbar.

RGroupDecompositionAction

R-group decomposition is a special kind of substructure search that aims at finding a central structure (scaffold) and identify its ligands at certain attachment positions.
The query molecule consists of the scaffold and ligand attachment points represented by R-groups. These R-groups are simple R-group atoms without R-group definitions in most cases.

For more information, see R-group Decomposition in JChem for Excel.

SaveAsStructureSingleCellAction

Saves a single structure to a wide variety of file formats. The following file formats can be created:

  • CDX

  • MOL

  • MRV

  • PDB

For more information, see Save Single Structure to a File.

ShowHideStructuresAction

Displays and hides the structures. The structures are visible by default when adding them to JChem for Excel. For more information, see Show and Hide Structures.

ShowHideStructuresActionforIDs

This action went on the Ribbon to serve the JCIDSysstructure function by switching between the formulas. For more information regarding the JCIDSysstructure function, see JCIDSYSStructure.

UnembedFromJCSMILESAction

Displays structures again after an EmbedInJCSMILESAction.

This action is not available on the ribbon as a button by default. It can be added easily by customizing the ribbon. For more information, see Customizing the Ribbon.