General Options in JChem for Excel

    The figure below shows the general options of JChem for Excel available from the Options tab.

    images/jchem-for-office-docs.chemaxon.com/jchem4excel/general_options_in_jchem_for_excel.png

    Select an option to learn more about it:

    2D Cleaning

    Co-authoring

    Logging

    R-group Decomposition and Filter

    Splash Screen

    Structure Drawing

    Worksheet Name

    2D Cleaning

    2D Clean During String Conversion

    It is possible to apply the 2D clean function automatically when converting strings to structures. The 2D clean function calculates new 2D coordinates for the molecules.

    Possible values are as follows:

    • TRUE

    • FALSE

    The default value of this option is TRUE.

    Co-authoring

    Use this option to enable the smooth co-authoring functionality in Office 365 environments, it avoids the forced reopening of the workbook when a co-author edits a JChem Excel function.

    images/download/attachments/1806985/GeneralOptions_Co_authoring.png

    Possible values are as follows:

    • TRUE

    • FALSE

    The default value of this option is FALSE, which means that the co-authoring functionality is not enabled. The application has to be restarted to apply the change.

    images/download/attachments/1806985/Warning_Co_authoring.png

    When changing the option back to TRUE, a restart is required again.

    Logging

    Logging Level

    Use this option to specify the logging level of user actions. The following levels can be specified:

    • OFF: The logging is turned off. Not recommended.

    • FATAL: Serious errors are logged.

    • ERROR:Errors are logged.

    • WARN: Errors and problems which can be handled by the system are logged.

    • INFO: General information about the usage of the application is logged.

    • DEBUG: Information with values of the variables is logged. Recommended for developers.

    • ALL: The highest logging level. All information is logged.

    The default value is ERROR.

    R-group Decomposition and Filter

    Default Structure

    Use this option to specify which structure is used as a query structure by default during R-group decomposition and structure filter.

    The possible options are as follows:

    • LastUsed:The same structure will be used as a query structure as the one in the last filtering/decomposition process.

    • ActiveCell: The structure in the cell which is currently selected will be displayed and used automatically in R-group decomposition and Filter dialog as query structure if the active cell contains a structure. If the active cell does not contain a structure, then the previously used query structure will be displayed, or if there was no previous filtering, the query form will remain empty.

    The default value is LastUsed.

    Structure Detection Type

    The following structure detection types are available:

    • DetectWithLimitedRows : In this case, only a predefined number of rows are taken into account to search for structure columns. The number of rows can be specified with the Structure Detection Threshold option.

    • NoDetect : The worksheet will not be checked when opening the dialog.

    • DetectAll : All columns and all rows will be checked in the worksheet.

    When detection is enabled (by either choosing DetectWithLimitedRows or DetectAll), columns that contain structures will be listed in the Target Column drop-down list in Filter dialog and R-group Decomposition dialog.

    The default value is DetectWithLimitedRows.

    Structure Detection Threshold

    If the value of Structure Detection Type is set to DetectionWithLimitedRows, you can use this option to specify the number of rows to be taken into account.

    The default value is 1000.

    Splash Screen

    Show Splash Screen

    The splash screen is displayed when starting the first JChem-specific function in a session.

    Possible values are as follows:

    • TRUE

    • FALSE

    The default value of this option is TRUE.

    Structure Drawing

    Rendering Technology

    A new structure rendering technology has been developed in JChem for Excel, which has been released in version 21.15.704 as default, and works properly on all supported MS Office versions.

    Possible values of this option are as follows:

    • Office 2021/Microsoft365 compatibility : The newly developed rendering technology that is fully compatible with Office 2021/Microsoft365. Please note that this is also available when the Rendering Technology option is set as Default.

    • Legacy: The Legacy rendering technology that still works fine on fully updated Office 2013/2016/2019 instances.

    • Default : Office 2021/Microsoft365 compatibility is set as a default after version 21.15.704.

    Please note that you have to restart Excel (all instances) after changing this option to activate the selected rendering technology.

    Structure Drawing Behaviour - Excel Dialogs

    Use this option to specify if the automatic switching off of structure drawing is allowed or not while special Excel dialogs, for example, editing function arguments with cross-references to other worksheets, are visible.

    Possible values are as follows:

    • TRUE

    • FALSE

    The default value of this option is FALSE.

    Worksheet Name

    Rename Worksheet to File Name

    This option affects the default state of the Rename Target Worksheet check-box which is used in the following cases:

    Possible values are as follows:

    • TRUE

    • FALSE

    The default value of this option is FALSE.