Page tree

History of changes: New features and improvements, bug fixes

December 10th, 2019: JChem for Office 19.21.2 - LTS Europium.2 release

Marvin/JChem 19.21.2 used.

November 27th, 2019: JChem for Office 19.25.0

Marvin/JChem 19.25.0 used.

Improvements

  • Now when editing JCStructure type structure cells a message informs the user that this kind of structure cannot be edited (only JCSYSStructure type.)

  • Now it is possible with other types of structure cells (eg. JCStructure, JCIDSYSStructure, etc.) to copy and paste multiple structures (with data) as table from JChem for Excel to JChem for Word, Powerpoint or Outlook with Ctrl+C and Ctrl+V.
  • Now when copying a structure from ChemDraw and then editing in JChem for Word, Powerpoint or Outlook with Marvin .NET editor, a message informs the user that some information can be lost, if currently selected structure editor settings will be used.

Bug Fixes

  • Structure Filter with substructure search gave wrong results when running on a formatted table.

  • Structures without appropriate alternate information were not possible to edit.
  • In Word and Outlook "Display" and "Scale" buttons didn't work properly on structures with IDs.

November 20th, 2019: JChem for Office 19.24.0

Marvin/JChem 19.24.0 used.

November 9th, 2019: JChem for Office 19.23.0

Marvin/JChem 19.23.0 used.

October 29th, 2019: JChem for Office 19.22.0

Marvin/JChem 19.22.0 used.

Improvements

  • Now it is possible to convert Insight for Excel files and worksheets to JChem for Excel files and worksheets with the standalone File Converter Tool and right-click menu item.

Bug Fixes

  • Copy/pasting multiple structures with data from Excel to Word/PowerPoint/Outlook failed if the worksheet name ended with a space character.

October 28th, 2019: JChem for Office 19.21.1 - LTS Europium.1 release

Marvin/JChem 19.21.1 used.

New Features

  • The full feature set of JChem for Excel and Office is now supported in Microsoft Office 2019.

  • Now Ctrl+C-Ctrl+V supports the same workflows as ribbon Copy-Paste in case of standard JChem for Office structures (JCSYSStructure type in JChem for Excel).

  • A new button (CompReg ID->Str) has been introduced in the JChem for Excel ribbon to import structures by IDs directly from CompReg database. Parallel to this the Associate ID button has been renamed to ID->Structure to be more consistent with the new button.

Improvements

  • File import process has been improved in cases when the chemical file format, for example, SMILES does not contain coordinates for the atoms, bonds, and so on, and 2D cleaning is necessary during the import process. The user can decide on the 2D Cleaning Confirmation dialog one by one or in bulk mode if the cleaning algorithm can eliminate special stereo information.

  • IKVM, the 3rd party tool that converts the java-based codebase to .NET to create .NET APIs (for example, JChem.NET) and .NET applications (for example, MarvinSketch.NET) has been upgraded to version 8.10.1.11.

  • The Delete button has been removed from the JChem ribbon in Word, Powerpoint, and Outlook. Use the Delete key instead.

Bug Fixes

  • When a structure, which was added to the document in CDX format was edited with ChemDraw, the modified image was a bit smaller than the original one.

  • JChemExcel add-in now starts loading in cases when there are no JCSYSStructure functions yet in the workbook, only other types of structure functions, for example, JCStructure, JCIDSYSStructure.

  • It was not possible to convert a special type of ChemDraw for Excel file format to JChem for Excel format.

  • There was a small issue in OLE object editing after pasting the object to JChem for PowerPoint.

  • Cartridge search was enabled on a view, which was created from a tabled where cartridge search was not enabled.

  • Import Format options (General, Date, Currency, Number, Text) in Import from Database and Import by IDs dialogs had no effect on the imported structure format on the Excel sheet.

  • An incomplete warning message was displayed after converting structures to text and vice versa.

  • When importing formats, which need 2DClean, for example, SMILES, CXSMILES, or IUPAC name, 2DClean related error message appeared in some cases.

  • When an image was selected in Word, adding a new structure overwrote the image.

  • The structure filter gave an error if the target column contained the molecule structure in merged cells.

  • The structure was overwritten when Microsoft Excel's AutoFilter and JChem for Excel's Structure Filter functionality was used alternatively.

  • From Text was not working in formatted tables with the Insert Right option.

  • Content of an .mrv file in text format, which doesn't contain scale information could not be pasted correctly (not as text) into Marvin .NET canvas and all JChem for Office applications.

  • Content of a .mol file in text format, even if the first row is empty could not be pasted correctly (not as text) into Marvin .NET canvas and all JChem for Office applications.

  • SMILES could not be pasted correctly (not as text) into Marvin .NET canvas and all JChem for Office applications.

  • Text copy with Ctrl+C-Ctrl+V worked only with double button press if the Ctrl+C-Ctrl+V runs JChem for Office Copy/Paste option has been set to True.

  • Double-clicking in a new email message in Outlook, the JChem for Office splash screen came up for a second, even if no JC4O functions/features have been used.

  • In some rare Windows 10 environments, JChem for Excel ribbon grayed out after installation.

  • When exporting a file that contained a cell with more than 32k characters the content of the cell itself did not export.

  • Numbers did not display with the same number of decimals when copying together structures with data from Excel to Word/Powerpoint/Outlook with Ctrl+C and pasting with Ctrl+V.

  • Unable to construct Marvin editor control message appeared when launching JChem for Outlook with Optimize for best appearance user interface option.

October 15th, 2019: JChem for Office 19.21.0

Marvin/JChem 19.21.0 used.

Bug Fixes

  • When a structure, which was added to the document in CDX format was edited with ChemDraw, the modified image was a bit smaller than the original one.

  • JChemExcel add-in now starts loading in cases when there are no JCSYSStructure functions yet in the workbook, only other types of structure functions: eg. JCStructure, JCIDSYSStructure.

September 19th, 2019: JChem for Office 19.20.0

Marvin/JChem 19.20.0 used.

Bug Fixes

  • It was not possible to convert a special type of ChemDraw for Excel file format to JChem for Excel format.
  • There was a small issue in OLE object editing after pasting the object to JChem for PowerPoint.
  • Cartridge search was enabled on a view, which was created from a tabled where cartridge search was not enabled.

September 9th, 2019: JChem for Office 19.19.0

Marvin/JChem 19.19.0 used.

Improvements

  • File import process has been improved in cases when the chemical file format (for example, SMILES) does not contain coordinates for the atoms, bonds, and so on. and 2D cleaning is necessary during the import process. The user can decide on the 2D Cleaning Confirmation dialog one by one or in bulk mode if the cleaning algorithm can eliminate special stereo information.

Bug Fixes

  • Import Format options (General, Date, Currency, Number, Text) in Import from Database and Import by IDs dialogs had no effect on the imported structure format on the Excel sheet.

  • An incomplete warning message was displayed after converting structures to text and vice versa.

  • When importing formats, which need 2DClean, for example, SMILES, CXSMILES, or IUPAC name, 2DClean related error message appeared in some cases.

  • When an image was selected in Word, adding a new structure overwrote the image.

August 5th, 2019: JChem for Office 19.18.0

Marvin/JChem 19.18.0 used.

Bug Fixes

  • The structure filter gave an error if the target column contained the molecule structure in merged cells.

  • When an image was selected in Word, adding a new structure overwrote the selected image.

July 30th, 2019: JChem for Office 19.7.3 - LTS Deuterium.3 release

Marvin/JChem 19.7.3 used.

Bug Fixes

  • In some rare Windows 10 environments, JChem for Excel ribbon grayed out after installation.
  • Unable to construct Marvin editor control message appeared when launching JChem for Outlook with Optimize for best appearance user interface option.

July 22nd, 2019: JChem for Office 18.22.6 - LTS Carbon.6 release

Marvin/JChem 18.22.6 used.

Bug Fixes

  • In some rare Windows 10 environments, JChem for Excel ribbon grayed out after installation.

  • Unable to construct Marvin editor control message appeared when launching JChem for Outlook with Optimize for best appearance user interface option.

July 17th, 2019: JChem for Office 19.17.0

Marvin/JChem 19.17.0 used.

Bug Fixes

  • The structure was overwritten when Microsoft Excel's AutoFilter and JChem for Excel's Structure Filter functionality was used alternatively.

July 5th, 2019: JChem for Office 19.16.0

Marvin/JChem 19.16.0 used.

June 24th, 2019: JChem for Office 19.14.0

Marvin/JChem 19.14.0 used.

New Features

  • The full feature set of JChem for Excel and Office is supported in Microsoft Office 2019.
  • Now Ctrl+C-Ctrl+V supports the same workflows as ribbon Copy-Paste in case of standard JChem for Office structures (JCSYSStructure type in JChem for Excel).
  • A new button (CompReg ID->Str) has been introduced in the JChem for Excel ribbon to import structures by IDs directly from CompReg database. Parallel to this the Associate ID button has been renamed to ID->Structure to be more consistent with the new button.

Improvements

  • IKVM, the 3rd party tool that converts the java-based codebase to .NET to create .NET APIs (for example, JChem.NET) and .NET applications (for example, MarvinSketch.NET) has been upgraded to version 8.10.1.11.

  • The Delete button has been removed from the JChem ribbon in Word, Powerpoint, and Outlook. Use the Delete key instead.

Bug Fixes

  • From Text was not working in formatted tables with the Insert Right option.

  • Content of an .mrv file in text format, which doesn't contain scale information could not be pasted correctly (not as text) into Marvin .NET canvas and all JChem for Office applications.

  • Content of a .mol file in text format, even if the first row is empty could not be pasted correctly (not as text) into Marvin .NET canvas and all JChem for Office applications.

  • SMILES could not be pasted correctly (not as text) into Marvin .NET canvas and all JChem for Office applications.

  • Text copy with Ctrl+C-Ctrl+V worked only with double button press if the Ctrl+C-Ctrl+V runs JChem for Office Copy/Paste option has been set to True.

  • Double-clicking in a new email message in Outlook, the JChem for Office splash screen came up for a second, even if no JC4O functions/features have been used.

  • In some rare Windows 10 environments, JChem for Excel ribbon grayed out after installation.

  • When exporting a file that contained a cell with more than 32k characters the content of the cell itself did not export.

  • Numbers did not display with the same number of decimals when copying together structures with data from Excel to Word/Powerpoint/Outlook with Ctrl+C and pasting with Ctrl+V.

  • Unable to construct Marvin editor control message appeared when launching JChem for Outlook with Optimize for best appearance user interface option.

June 4th, 2019: JChem for Office 19.7.2 - LTS Deuterium.2 release

Marvin/JChem 19.7.2 used.

Bug Fixes

  • Double-clicking in a new email message in Outlook, the JChem for Office splash screen came up for a second.

May 13th, 2019: JChem for Office 19.7.1 - LTS Deuterium.1 release

Marvin/JChem 19.7.1 used.

Installer Related Improvements

  • The standalone Marvin .NET editor has two installers: 64- and 32-bit versions.
  • JChem for Office installation now goes smoothly on Microsoft Office 2019. (Please note, that the environment itself is not fully supported yet.)
  • Now the installer shows a warning message if there are more than one bit-version of Microsoft Office is installed on the same computer and if the user approves, the install process continues.
  • The method of identifying the bit-version of the installed Microsoft Office version has been extended, because in some cases the "Bitness" variable used for detection was missing on the user's computer.
  • The installer stops and informs the user if the KB2670838 Windows 7 platform update (which is essential for structure rendering in Microsoft Office 2013 and above) is missing from the computer (in case of Windows 7 and Windows Server 2008).

Structure Editor Related Improvements

  • Now a user-friendly warning message comes up when the selected structure editor is not installed on the computer or the selected structure editor does not support the 64-bit version of Microsoft Office.
  • ChemDraw 18 editor is fully supported in 32 and 64-bit versions of JChem for Office.
  • A new option has been introduced in JChem for Office to switching on/off the automatic plus-sign placement in case of editing single-step reactions.

General Improvements

  • Diagnostic Tool can also identify Microsoft Office 2019 installed on the computer.
  • Chemical search is now enabled on Oracle cartridge views even for users who are not the owner of the cartridge index of the original table.

Bug Fixes

  • Copy-paste did not work if the structure contained an enhanced stereo flag.

  • Sometimes the plus sign disappeared from single-step reactions at editing.

  • There was an error at structure filtering if the header row contained structures.

  • The cursor was placed before the text after the pasting text into Word/PowerPoint/Outlook if the JChem for Office keyboard event handling was activated.

  • Structure objects in documents, which does not handle alternate text correctly could not be edited with double-click on JChem for Office.

  • Double-clicking on objects, which were not chemical structures (for example, images, OLE objects) gave an error.

  • Hiding a structure column (except the A column) gave an error in JChem for Excel.

  • The CXN .NET API license was checked in some cases when there was no reason to do it.

  • The structure editor could not be opened from Excel right after installing the ChemAxon license, the application had to be restarted.

  • When there was no license installed, clicking on a simple Microsoft Office object (for example, shapes, SmartArt graphics, charts), which were non-chemical objects, incorrectly a JChem for Office license was required.

  • In Microsoft Office with French language when copying a structure with Ctrl+C from java version of desktop Marvin Sketch to Word, MRV format was pasted in text format instead of live structure.

May 8th, 2019: JChem for Office 18.22.5 - LTS Carbon.5 release

Marvin/JChem 18.22.5 used.

April 9th, 2019: JChem for Office 19.9.0

Marvin/JChem 19.9.0 used.

Improvements

  • Chemical search is now enabled on Oracle cartridge views even for users who are not the owner of the cartridge index of the original table.

Bug Fixes

  • In Microsoft Office with French language when copying a structure with Ctrl+C from java version of desktop Marvin Sketch to Word, MRV format was pasted in text format instead of live structure.

March 20th, 2019: JChem for Office 19.8.0

Marvin/JChem 19.8.0 used.

Bug Fixes

  • Double-clicking on objects, which were not chemical structures (for example, images, OLE objects) gave an error.

  • When there was no license installed, clicking on a simple Microsoft Office object (for example, shapes, SmartArt graphics, charts), which were non-chemical objects, incorrectly a JChem for Office license was required.

March 14th, 2019: JChem for Office 19.7.0

Marvin/JChem 19.7.0 used.

Improvements

  • ChemDraw 18 editor is fully supported in 32 and 64-bit versions of JChem for Office.

  • The installer stops and informs the user if the KB2670838 Windows 7 platform update (which is essential for structure rendering in Microsoft Office 2013 and above) is missing from the computer (in case of Windows 7 and Windows Server 2008).

  • Informing message appears when the user tries to add a new structure and the selected editor is not available on the computer.

Bug Fixes

  • Hiding a structure column (except the A column) gave an error in JChem for Excel.

March 4th, 2019: JChem for Office 19.6.0

Marvin/JChem 19.6.0 used.

Improvements

  • JChem for Office installation now goes smoothly on Microsoft Office 2019. (Please note, that the environment itself is not fully supported yet.)

  • Diagnostic Tool can also identify Microsoft Office 2019 installed on the computer.

  • Now the installer shows a warning message if there are more than one bit-version of Microsoft Office is installed on the same computer and if the user approves, the install process continues.

  • The method of identifying the bit-version of the installed Microsoft Office version has been extended, because in some cases the "Bitness" variable used for detection was missing on the user's computer.

February 12th, 2019: JChem for Office 19.4.0

Marvin/JChem 19.4.0 used.

February 5th, 2019: JChem for Office 19.3.0

Marvin/JChem 19.3.0 used.

February 1st, 2019: JChem for Office 18.22.4 - LTS Carbon.4 release

Marvin/JChem 18.22.4 used.

Improvements

  • Now a user-friendly warning message comes up when the selected structure editor is not installed on the computer or the selected structure editor does not support the 64-bit version of Microsoft Office.

  • A new option has been introduced in JChem for Office to switching on/off the automatic plus-sign placement in case of editing single-step reactions.

Bug Fixes

  • There was an error at structure filtering if the header row contained structures.
  • The cursor was placed before the text after the pasting text into Word/PowerPoint/Outlook if the JChem for Office keyboard event handling was activated.
  • The CXN .NET API license was checked in some cases when there was no reason to do it.
  • Structure objects in documents, which does not handle alternate text correctly could not be edited with double-click on JChem for Office.

January 29th, 2019: JChem for Office 19.2.0

Marvin/JChem 19.2.0 used.

Improvements

  • Now a user-friendly warning message comes up when the selected structure editor is not installed on the computer or the selected structure editor does not support the 64-bit version of Microsoft Office.

Bug Fixes

  • The cursor was placed before the text after the pasting text into Word/PowerPoint/Outlook if the JChem for Office keyboard event handling was activated.

  • The structure editor could not be opened from Excel right after installing the ChemAxon license, the application had to be restarted.

  • The CXN .NET API license was checked in some cases when there was no reason to do it.

  • Structure objects in documents, which does not handle alternate text correctly could not be edited with double-click on JChem for Office.

January 11th, 2019: JChem for Office 19.1.0

Marvin/JChem 19.1.0 used.

December 21st, 2018: JChem for Office 18.30.0

Marvin/JChem 18.30.0 used.

Improvements

  • A new option has been introduced in JChem for Office to switching on/off the automatic plus-sign placement in case of editing single-step reactions.

Bug Fixes

  • Sometimes the plus sign disappeared from single-step reactions at editing.

  • There was an error at structure filtering if the header row contained structures.

December 19th, 2018: JChem for Office 18.22.3 - LTS Carbon.3 release

Marvin/JChem 18.22.3 used.

December 11th, 2018: JChem for Office 18.29.0

Marvin/JChem 18.29.0 used.

November 29th, 2018: JChem for Office 18.22.2 - LTS Carbon.2 release

Marvin/JChem 18.22.2 used.

Improvements

  • The standalone Marvin .NET editor has two installers - 64- and 32-bit versions.

  • All registry modification-related questions appear in one message instead of five different messages.

  • The installer deletes the unnecessary Marvin OLE related "RunningMode" registry key if it is present in the registry.

Bug Fixes

  • Text could not be pasted from Microsoft Word and Microsoft PowerPoint into Marvin .NET editor.

  • Marvin textbox could not be pasted into Marvin .NET editor.

November 29th, 2018: JChem for Office 18.8.3 - LTS Barium.3 release

Marvin/JChem 18.8.3 used.

Improvements

  • The standalone Marvin .NET editor has two installers - 64- and 32-bit versions.

  • All registry modification-related questions appear in one message instead of five different messages.

  • The installer deletes the unnecessary Marvin OLE related "RunningMode" registry key if it is present in the registry.

Bug Fixes

  • Text could not be pasted from Microsoft Word and Microsoft PowerPoint into Marvin .NET editor.
  • Marvin textbox could not be pasted into Marvin .NET editor.

November 20th, 2018: JChem for Office 18.27.0

Marvin/JChem 18.27.0 used.

Improvements

  • The standalone Marvin .NET editor has two installers - 64- and 32-bit versions.

October 12th, 2018: JChem for Office 18.24.0

Marvin/JChem 18.24.0 used.

Bug Fixes

  • Copy-paste did not work if the structure contained an enhanced stereo flag.

October 3rd, 2018: JChem for Office 18.23.0

Marvin/JChem 18.23.0 used.

September 25th, 2018: JChem for Office 18.22.1 - LTS Carbon.1 release

Marvin/JChem 18.22.1 used.

General Improvements

  • Now it is possible to paste a structure from the clipboard into the Query Structure box of the R-Group Decomposition form by pressing the Ctlr+V.

  • Conditional formatting is copied by default at copying multiple structures with adjacent data in Excel.

  • Now it is possible to run queries by using IS NULL and IS NOT NULL search values in Import from Database functionality.

  • Drawing performance has been improved in Marvin .NET editor.

OLE Conversion Related Improvements

  • There is a significant performance improvement at conversion OLE object to JChem for Office object.

  • The Marvin OLE server can be run in resident mode, it is installed as a service and the uninstall process can kill it.

  • Display and scale settings of Marvin OLE object are retained at conversion to JChem for Office object.

  • The Replace OLE with JCO object upon editing option is TRUE by default in JChem options.

Bug Fixes

  • The Ctrl+V action could not be revoked by Undo function in Excel if the Keyboard Events option was set to TRUE in JChem for Excel.

  • The status of the Keyboard Event option in JChem for PowerPoint influenced the available Paste Options in Microsoft PowerPoint.

  • There was an error at double-clicking on a plain text in Outlook if JChem for Outlook was installed.

  • The table with structures was pasted from Excel into a new slide in PowerPoint instead of the selected one.

  • Sometimes the plus sign jumped away at editing broad reactions.

  • There was an error at structure copy-paste if the structure contained an enhanced stereo label.

  • In case of an extended display environment, when a MarvinSketch window opened from an Excel, Word, PowerPoint or Outlook instance started on the primary screen was dragged to the secondary screen, then menus and dialogs opened on the primary screen.

August 17th, 2018: JChem for Office 18.19.0

Marvin/JChem 18.19.0 used.

Bug Fixes

  • Empty .sd file was generated at exporting ID structures if the Show Structure option was set to FALSE.

  • Sometimes an empty file was generated at exporting structures.

  • The status of the Keyboard Event option in Jchem for PowerPoint influenced the available Paste Options in PowerPoint.

  • The Ctrl+V action could not be revoked by Undo function in Excel if the Keyboard Events option was set to TRUE in JChem for Excel.

  • Sometimes the OLE editor was opened at double-clicking on a Marvin OLE object even if the Replace OLE with JCO object upon editing option was set to TRUE.

August 9th, 2018: JChem for Office 18.18.0

Marvin/JChem 18.18.0 used.

Improvements

  • The installer is now able to check if a previous version of JChem for Office/Excel is installed or not and the new version cannot be installed before removing the previous one.

  • The installer is now able to kill the running MarvinOLEServer process at uninstalling the JChem for Office/Excel.

  • The default status of the Replace OLE with JCO object upon editing option has been changed to TRUE in JChem for Office.

Bug Fixes

  • Marvin structure editor could not be opened in Excel by clicking on the Add or Edit buttons if the Options > General > When using multiple displays Excel option was set to Optimize for best appearance.

  • The XLA references had to be updated manually at opening a JChem for Excel workbook containing JChemExcel functions and calculated values if the workbook was created in another environment with different bit-version of MS Office.

  • Turning on/off the Show Only Favourites check-box repeatedly removed the selection from the currently selected connection on Import from Database form.

  • Ribbon paste from IJC did not set the correct cell size for a single structure in Excel.

  • Structure IDs could not be converted back to structures after printing in Excel.

  • The function GetStructuresByFormula of JChemExcel COM API did not work for JCIDSYSStructure formulas.

  • Changing the scale setting of a structure by double-clicking resulted in about 10 times bigger structure in JChem for Office.

  • In case of broad reactions in Word, the right edge was cut off.

  • The table with structures was pasted from Excel into a new slide in PowerPoint instead of the selected one.

  • The Content frame was deleted from the slide and the inserted structure was not editable in case of the Title and Content slide layout in JChem for PowerPoint.

August 8th, 2018: JChem for Office 18.8.2 - LTS Barium.2 release

Marvin/JChem 18.8.2 used.

Bug Fixes

  • A Windows 10 update (OS update version: 1803) caused an error at opening the embedded Marvin structure editor from Office applications.

  • A Windows 10 update caused an Excel frozen at inserting a structure into a cell.

  • A Microsoft Office update caused an error at double-clicking on a JChem for Office object in Word and in PowerPoint.

  • A blue square stuck to the mouse after editing JChem for Office structures in PowerPoint.

  • Cell borders were lost at copy-paste multiples structure between Excel sheets.

  • Structure copy-paste from IJC into Excel failed when the clipboard table contained only a single structure.

  • The JChem ribbon was greyed out in case of an outdated and invalid Settings.xml.

  • The structure drawing was turned on by using Ctrl+V on the worksheet even if the structure drawing was turned off by Show/Hide function.

  • An unnecessary error log was generated at copying a single structure from an Excel sheet to the clipboard.

July 9th, 2018: JChem for Office 18.16.0

Marvin/JChem 18.16.0 used.

Bug Fixes

  • It took a relatively long time to paste a single structure into an Excel cell.

July 3rd, 2018: JChem for Office 18.15.0

Marvin/JChem 18.15.0 used.

June 27th, 2018: JChem for Office 18.14.0

Marvin/JChem 18.14.0 used.

Bug Fixes

  • A blue square stuck to the mouse after editing JChem for Office structures in PowerPoint.

  • Structure drawing was a bit slow at scrolling up and down on the Excel worksheets.

June 15th, 2018: JChem for Office 18.13.0

Marvin/JChem 18.13.0 used.

Bug Fixes

  • A Windows 10 update (OS update version: 1803) caused an error at opening the embedded Marvin structure editor from MS Office applications.

  • Cell borders were lost at copy-paste multiples structure between Excel sheets.

  • Multiple structure copy-paste within Excel did not result in the same column width on the target sheet as it was on the source sheet.

  • The user-specified display name of the column was applied unintendedly in the left side pane of the column selector tab of the Import from Database form.

  • Structure copy-paste - from IJC into Excel - failed when the clipboard table contained only a single structure.

  • The JChem ribbon was greyed out in case of outdated and invalid Settings.xml.

  • An unnecessary error log was generated at copying a single structure from an Excel sheet to the clipboard.

May 29th, 2018: JChem for Office 18.11.0

Marvin/JChem 18.11.0 used.

Improvements

  • Structures now can be pasted from MarvinJS into Excel by using Ctrl+C and Ctrl+V right after launching Excel.

  • Now it is possible to paste multiple structures with adjacent data to a worksheet by pressing the Paste button in the JChem ribbon even if they were copied by using Ctrl+C.

  • Now it is possible to paste a structure from the clipboard into the Query Structure box of the R-Group Decomposition form by pressing the Ctlr+V.

Bug Fixes

  • The structure drawing was turned on by using Ctrl+V on the worksheet even if the structure drawing was turned off by Show/Hide function.

  • A Windows 10 update caused an Excel frozen at inserting a structure into a cell.

  • A Microsoft Office update caused an error at double-clicking on a JChem for Office object in Word and in PowerPoint.

March 29th, 2018: JChem for Office 18.8.1 - LTS Barium.1 release

Marvin/JChem 18.8.1 used.

March 20th, 2018: JChem for Office 18.8.0

Marvin/JChem 18.8.0 used.

Improvements

  • Import from file by ID dialog and field recognition has been improved.

  • Single structure paste by Ctrl-V now works immediately after launching Excel.

  • Now it is possible to use the Ctrl+V on the Query tab of the Import from Database form to paste query structure.

  • Most popular date formats are recognized by the system when importing from a database.

  • Now it is possible to apply chemical filtering on synonyms when importing from a database.

Bug Fixes

  • There was a Microsoft Word crash at opening structure editor if a non-64-bit Office compatible ChemDraw version was set as structure editor in case of 64-bit version of Microsoft Office.

  • There was an error at executing a structure search in case of a JChem Web Services type connection if there was a primary key on a non-number type database column.

  • Structure search was not available at synonyms in case of connecting to Oracle Cartridge via JChem Web Services.

  • The structure was saved not in the selected format by using the Save Structure context menu item.

  • Excel close was slow if the Editor Pane was opened.

February 27th, 2018: JChem for Office 18.5.0

Marvin/JChem 18.5.0 used.

Improvements

  • Now it is possible to specify a date type search value by using a "date picker" at Import from Database function.

  • An informative message comes up in case of incorrect date format as search value at Import from Database function.

Bug Fixes

  • Structure drawing properties specified in the grid view of Import from Database function were not applied on mapped structures in Excel worksheet.

  • There was an error at connecting to a PostgreSQL database via JChem Webservices.

  • There was a backward compatibility issue at storing the bond hash spacing value since its unit has been changed from Angstrom to points.

February 23rd, 2018: JChem for Office 17.24.3 - LTS Argon.3 release

Marvin/JChem 17.24.3 used.

February 16th, 2018: JChem for Office 17.24.2 - LTS Argon.2 release

Marvin/JChem 17.24.2 used.

Bug Fixes

  • After launching Microsoft Word typing was possible only after double-clicking in the document if JChem for Word was installed.

  • Excel froze at opening Import from Database dialog if Logging Level was set to ALL.

  • Single structure copy-paste did not work from IJC into JChem for Office.

  • There was an Excel crash at using the JChem for Excel functions after Windows 10 update from version 1703 to 1709.

  • Columns were not listed in Import from Database by IDs dialog in case of Oracle Cartridge type connections.

  • Closing Microsoft Word took a long time if the JChem for Office was installed.

  • The Microsoft Word/PowerPoint froze for a while after starting the application if the JChem for Office was installed.

February 2nd, 2018: JChem for Office 18.3.0

Marvin/JChem 18.3.0 used.

Improvements

  • Now it is possible to search for date type fields in case of Oracle databases.

Bug Fixes

  • Copy-pasting a whole column with structures to an empty column with ribbon Copy-Paste button was very slow.
  • There was an error at copy-paste structures from Marvin sketch into Microsoft Word and PowerPoint.
  • Some operators (like, starts with, ends with) didn't work when a JChem Web Services connection was used for an Import from Database action.
  • Conditional formatting could not be transferred at copy-pasting multiple structures with data from Excel into other Office applications.
  • In case of an extended display environment, when a MarvinSketch window opened from an Excel, Word, PowerPoint or Outlook instance started on the primary screen was dragged to the secondary screen, then menus and dialogs opened on the primary screen.

January 11th, 2018: JChem for Office 18.1.0

Marvin/JChem 18.1.0 used.

Improvements

  • During installation JChem for Excel's installation check-box is greyed out, so this component will always be installed with JChem for Office installer.

Bug Fixes

  • It took a long time to import structures from an SD file by using the Import from File by IDs function.

  • Copy and paste multiple images including structures by using Ctrl+C did not work in PowerPoint.

  • The color of structures changed at converting structures to images in Excel.

December 9th, 2017: JChem for Office 17.29.0

Marvin/JChem 17.29.0 used.

Bug Fixes

  • Columns could not be listed when using the Import By ID dialog with Oracle Cartridge connections.

  • There was an Excel crash at opening the Import from Database dialog if the Logging Level was set to "All" in the options.

  • After launching the JChem for Word typing was possible only after double-clicking in the document.

November 9th, 2017: JChem for Office 17.28.0

Marvin/JChem 17.28.0 used.

Bug Fixes

  • Microsoft Excel 2013 and 2016 crashed at using the JChem for Excel functions after Windows 10 update from version 1703 to 1709.

October 27th, 2017: JChem for Office 17.27.0

Marvin/JChem 17.27.0 used.

October 20th, 2017: JChem for Office 17.24.1 - LTS Argon.1 release

Marvin/JChem 17.24.1 used.

October 13th, 2017: JChem for Office 17.25.0

Marvin/JChem 17.25.0 used.

September 26th, 2017: JChem for Office 17.24.0

Marvin/JChem 17.24.0 used.

Bug Fixes

  • After the first opening, the selected structure was not displayed in the Editor Pane in the 3rd row of Excel worksheet.

September 18th, 2017: JChem for Office 17.23.0

Marvin/JChem 17.23.0 used.

Improvements

  • Accelerated load of MS Office applications (both Excel and Word/PowerPoint/Outlook) when JChem for Office is installed.

  • Accelerated copy/paste of tables from Excel to PowerPoint.

  • Decreased size of EMF images and JChem for Office objects (to about the third) and OLE object size (to about the half).

  • Java 8 support in the .NET API.

  • ChemDraw 16 support (only for 32-bit, since ChemDraw ActiveX does not support 64-bit).

  • Improved sustainability of JChem for Office object handling.

  • .NET 4 support (4.5 and above).

  • JChem for Office java API improvements:

    • A new type of JChem for Office objects is created during insert.

    • JChem for Office objects can be inserted into existing documents as well.

    • All JChem for Office objects can be extracted from an existing Word/PowerPoint document.

    • All JChem for Office objects in a Word or PowerPoint document can be converted at once to a specific set of display settings (for example, according to a Journal Style).

    • Ability to create JChem for Office objects with FixedScale (instead of image size).

    • ID, display settings and other properties can be specified for a JChem for Office object during its creation.

    • Multiple image formats are supported (EMF, JPG, PNG, SVG, and so on).

Bug Fixes

  • Empty slides were inserted between imported structures in case of One Structure per Page import layout in JChem for PowerPoint.

  • There was an error at specifying query structure on the Import for Database form if there was a specified Default Database Field Filtering in the options.

  • There was an error at closing Excel if there were more opened Excel workbooks with active Editor Panes.

September 1st, 2017: JChem for Office 17.22.0

Marvin/JChem 17.22.0 used.

Improvements

  • Synonyms are supported in the case of MSSQL type connections at importing from a database.

Bug Fixes

  • The previous selection was not cleared automatically at selecting a new synonym in the treeview of the Import from Database form.

  • The structure column could not be recognized automatically for the first time in the case of views.

  • The Bond Hash Spacing value was changed at copy-paste structures from Marvin into Office applications.

August 18th, 2017: JChem for Office 17.21.0

Marvin/JChem 17.21.0 used.

August 11th, 2017: JChem for Office 17.20.0

Marvin/JChem 17.20.0 used.

Bug Fixes

  • The MS Office application had to be restarted to apply changes of Import from Database related settings in the options.

August 7th, 2017: JChem for Office 17.18.0

Marvin/JChem 17.18.0 used.

Bug Fixes

  • There was an Excel crash at structure drawing in case of certain environments with Windows 7 and Office 2013 32-bit.

Improvements

  • The selected state of the connection is cleared on the Import from Database form when the authentication has been denied.

July 25th, 2017: JChem for Office 17.16.0

Marvin/JChem 17.16.0 used.

New Features

  • Synonyms are now supported in case of connecting to Oracle Cartridge through JChem Web Services.

Improvements

  • The columns of a table or a view are loaded only after selecting that table or view from the list under the database node in the connections tree, so the initial connection to the database is now much faster.

July 17th, 2017: JChem for Office 17.15.0

Marvin/JChem 17.15.0 used.

Bug Fixes

  • Structures disappeared from the worksheet after freezing the top row of the worksheet.

  • The WHERE condition could not be used on a simple VIEW in case of JChem Web Services type connection.

  • There was no warning dialog at importing from a database when the user entered a wrong password on the login dialog in case of an unsaved password.

July 7th, 2017: JChem for Office 17.14.0

Marvin/JChem 17.14.0 used.

New Features

  • The Wireframe with Knobs structure rendering option has been removed.

Bug Fixes

  • CAS Registry Number did not work in the case of a 32-bit version of the Microsoft Windows operating system.

  • There was an error at converting Japanese chemical names to structures in Japanese environments.

  • There was a structure rendering problem in JChem for Office in case of the Ball and Stick display rendering option.

  • There was an error at importing structures from a database table in case of JChem Web Services type connections.

June 16th, 2017: JChem for Office 17.12.0

Marvin/JChem 17.12.0 used.

Bug Fixes

  • There was an error at converting CAS Registry Number to structure in JChem for Excel.

  • Login dialog appeared unnecessarily if authentication error occurred in case of using JChem Web Service type connection at Import from Database function.

June 9th, 2017: JChem for Office 17.11.0

Marvin/JChem 17.11.0 used.

June 2nd, 2017: JChem for Office 17.10.0

Marvin/JChem 17.10.0 used.

May 30th, 2017: JChem for Office 17.9.0

Marvin/JChem 17.9.0 used.

New Features

  • The Wireframe rendering option is applied to structures even if the Wireframe with Knobs rendering option is selected in the options.

May 5th, 2017: JChem for Office 17.7.0

Marvin/JChem 17.7.0 used.

April 28th, 2017: JChem for Office 17.6.0

Marvin/JChem 17.6.0 used.

April 24th, 2017: JChem for Office 17.5.0

Marvin/JChem 17.5.0 used.

Bug Fixes

  • The structure column was not refreshed automatically after applying an Excel filter on the worksheet.

April 6th, 2017: JChem for Office 17.4.300

Marvin/JChem 17.4.3 used.

Bug Fixes

  • There was an Excel crash upon creating a new worksheet after copying some structures to the clipboard by pressing Ctrl+C if the Event Handling > Keyboard Events > Ctrl+C and Ctrl+V runs JChem for Office Copy-Paste option was set to FALSE.

  • Chemical structure conversion to CAS Registry Number did not work by using chemical terms expression.

March 31st, 2017: JChem for Office 17.3.2700

Marvin/JChem 17.3.27 used.

March 23rd, 2017: JChem for Office 17.3.1300

Marvin/JChem 17.3.13 used.

Bug Fixes

  • The Import from Database by IDs did not work as expected in the case of NUMBER type Oracle columns. Integer values were displayed instead of float values.

February 24th, 2017: JChem for Office 17.2.2000

Marvin/JChem 17.2.20 used.

February 17th, 2017: JChem for Office 17.2.1300

Marvin/JChem 17.2.13 used.

February 10th, 2017: JChem for Office 17.2.600

Marvin/JChem 17.2.6 used.

Bug Fixes

  • The Import from Database by IDs function did not work as expected in the case of NUMBER(X, Y) type Oracle columns. Integer values were displayed instead of float values.

February 3rd, 2017: JChem for Office 17.1.3000

Marvin/JChem 17.1.30 used.

Bug Fixes

  • The CAS Registry Number conversion to structure did not work in JChem for Office/Excel because the underlying web service required Java 8.

  • Changes in structure display options had no effect on Import functions until the restart of Microsoft Word and Microsoft PowerPoint.

January 27th, 2017: JChem for Office 17.1.2300

Marvin/JChem 17.1.23 used.

January 20th, 2017: JChem for Office 17.1.1600

Marvin/JChem 17.1.16 used.

January 13th, 2017: JChem for Office 17.1.900

Marvin/JChem 17.1.9 used.

December 22nd, 2016: JChem for Office 16.12.1900

Marvin/JChem 16.12.19 used.

New Features

  • The Atom Label Size structure display option has been renamed to Atom Font Size (pt) and its unit has changed to point (pt).

Improvements

  • Now it is possible to set the atom label font type by using the new Atom Font Type structure display option.

Bug Fixes

  • The non-favorite tables were not displayed after deselecting the Show Only Favourites check-box on the Select Entity form of the Import from Database by IDs function.

  • The error message was not informative in JChem for Excel in case of missing licenses.

December 15th, 2016: JChem for Office 16.12.1200

Marvin/JChem 16.12.12 used.

Bug Fixes

  • Structures disappeared from the Excel sheet after canceling the Excel close process.

December 9th, 2016: JChem for Office 16.12.500

Marvin/JChem 16.12.5 used.

Bug Fixes

  • The Integrated Authentication check-box remained selected and username/password fields remained disabled on the Manage Connections form at changing to another database type from Oracle where the Integrated Authentication is not supported.

  • The Import from Database form had to be closed and reopened to apply modifications of an existing connection.

  • There was an error at Import from Database by IDs function if a data was stored in NUMBER(12) format in the Oracle database table.

December 2nd, 2016: JChem for Office 16.11.2800

Marvin/JChem 16.11.28 used.

November 18th, 2016: JChem for Office 16.11.1400

Marvin/JChem 16.11.14 used.

New Features

  • The Devart dotConnect for Oracle connection provider has been removed from JChem for Excel.

Improvements

  • It is now possible to save connections without username and password to use integrated authentication at database import.

Bug Fixes

  • Modifications of some connection parameters of existing connections could not be saved at Import from Database function.
  • There was an error at structure search in case of BLOB type structure field if the length of the query structure was greater than 4000 characters.

November 11th, 2016: JChem for Office 16.11.700

Marvin/JChem 16.11.7 used.

November 3rd, 2016: JChem for Office 16.10.3100

Marvin/JChem 16.10.31 used.

Improvements

  • MDL RD File V3000 and MDL RXN File V3000 are now available among the file types during Export to file.

October 21st, 2016: JChem for Office 16.10.1700

Marvin/JChem 16.10.17 used.

New Features

  • The default margin size is set to "7" in all applications (JChem for Excel, JChem for Word, JChem for PowerPoint, JChem for Outlook).

Improvements

  • It is now possible to set the MDL SD File V3000 as default chemical file format for Export to File function in JChem for Excel.

October 14th, 2016: JChem for Office 16.10.1000

Marvin/JChem 16.10.10 used.

Improvements

  • MDL SDFile V3000 is now available among the file types during Export to file.

October 6th, 2016: JChem for Office 16.10.300

Marvin/JChem 16.10.3 used.

Bug Fixes

  • The prototype of JChem for OneNote could not be installed in certain environments.

  • Attachments in the body of received emails could not be correctly opened with their own application if the JChem for Outlook was installed.

September 29th, 2016: JChem for Office 16.9.2600

Marvin/JChem 16.9.26 used.

Improvements

  • The Diagnostic Tool—an enhanced logging tool—is included in JChem for Office/Excel installer.

Bug Fixes

  • Structure conversion to Excel image shape and image conversion back to structure caused problems at structure drawing if there were cell comments in the workbook.

  • Sometimes structures disappeared from Excel after minimizing/maximizing the opened workbooks.

  • Needless, empty columns were inserted into the Excel worksheet in some cases by using the Associate IDs function.

  • Sometimes it caused error at importing structures from a database by IDs if there were invalid, integer type IDs in the list.

  • Anniversary update of Windows 10 caused Excel crash at using the JChem for Excel functions in cases of Microsoft Office 2013 and Microsoft Office 2016 (64-bit versions).

September 9th, 2016: JChem for Office 16.9.500

Marvin/JChem 16.9.5 used.

Improvements

  • The Import By ID process is now possible for "cherry-pick"-ed IDs as well.
  • The Associate IDs process is now possible for "cherry-pick"-ed IDs as well.

Bug Fixes

  • A few Chinese name conversions failed with From any text ribbon button.

August 25th, 2016: JChem for Office 16.8.2200

Marvin/JChem 16.8.22 used.

August 17th, 2016: JChem for Office 16.8.1500

Marvin/JChem 16.8.15 used.

August 12th, 2016: JChem for Office 16.8.800

Marvin/JChem 16.8.8 used.

August 3rd, 2016: JChem for Office 16.8.100

Marvin/JChem 16.8.1 used.

July 27th, 2016: JChem for Office 16.7.2500

Marvin/JChem 16.7.25 used.

July 19th, 2016: JChem for Office 16.7.1800

Marvin/JChem 16.7.18 used.

July 7th, 2016: JChem for Office 16.7.400

Marvin/JChem 16.7.4 used.

Improvements

  • Windows 10 is now fully supported (with MS Office 64-bit version too).

  • Office 2016 is now fully supported (64-bit version too).

  • New display properties are added to the options, and are handled during copy/paste from Marvin (reflecting document style settings in Marvin):

    • Bold Bond Width

    • Bond Hash Spacing

    • Margin Size

Bug Fixes

  • In the German Windows environment, it was not possible to edit a JChem for Outlook object using double-click.

  • ChemDraw OLE did not work as a chemical editor.

June 23rd, 2016: JChem for Office 16.6.2000

Marvin/JChem 16.6.20 used.

Deprecated feature

  • The similarity search option was removed from the Filter dialog and the Rows tab of the Import from Database and the Import from File dialogs. It is still available on the Query tab of the Import from Database dialog though.

Improvements

  • It is now possible to run consecutive filters even on columns that contain a structure-function that refers to the content of another cell (like JCStructure).

Bug Fixes

  • There was an error at importing from a database by IDs if the worksheet contained an ID with an invalid type.

  • If the Structure Detection Type option was set to No Detect, then selecting a non-structure column as target on the Filter dialog resulted in the removal of all rows after the filter.

  • The selected target column was not retained on the Filter dialog after reopening it.

June 16th, 2016: JChem for Office 16.6.1300

Marvin/JChem 16.6.13 used.

New feature

  • Both ChemDraw 14 and ChemDraw 15 are now supported as chemical editors inside JChem for Office.

Improvements

  • Import by ID from file now allows to import to IDs placed in the Structure column on an excel sheet.

Bug Fixes

  • There was an error message during the Import by ID from Database when there also were structures in the ID column.

  • Incorrect hit number appeared on the status bar after the second filter action on the same excel sheet.

June 2nd, 2016: JChem for Office 16.5.3000

Marvin/JChem 16.5.30 used.

May 23rd, 2016: JChem for Office 16.5.1600

Marvin/JChem 16.5.16 used.

New feature

  • Import from JChem Oracle Cartridge tables and views through JChem Web Services is now supported. Import by ID and Associate ID are also supported.

Bug Fixes

  • The structure column was not recognized during the 2nd consecutive import from a database view and resulted in an error.

April 29th, 2016: JChem for Office 16.4.2500

Marvin/JChem 16.4.25 used.

Improvements

  • DB schema reading has been sped up when the Show only favorites option is used.

  • Associate IDs now support other user entities as well.

  • The ChemAxon .NET API now supports Windows authentication mode in the case of MS SQL Express databases.

Bug Fixes

  • The selected structure was deleted from the document when the user attempted to add calculated properties to a structure in Word, Outlook, or PowerPoint.

  • The selected table/view and connection was not retained in the Select Entity dialog for Other users' entities.

  • The current user was also listed under the other users' node on the Select Entity dialog.

April 15th, 2016: JChem for Office 16.4.1100

Marvin/JChem 16.4.11 used.

New features

  • Import by ID from Database now supports Oracle Other user objects.

  • If there is no structure type content on the clipboard, but there is a text that can be recognized as MOL or MRV, it will be automatically converted to Structure in JChem for PowerPoint, Word, Outlook, and Excel (although in the latter case only if the add-in is already loaded). This feature enables the copy/paste from Marvin JS to JChem for Office using Ctrl+C/Ctrl+V.

Improvements

  • The Import by ID from Database dialog has been redesigned, and the tree-based object selector used in the normal DB import process has been implemented, so it supports displaying only the favorites.

  • The following field names are added to the already existing automatically recognized Structure fields during Import from Database (in this order): MOLECULE, MOL_STRUCTURE, MOLFILE, MOL_FILE, MOLCOLUMN, MOL_COLUMN, REACTION, RXNFILE, RXN_FILE.

Bug Fixes

  • If a structure containing an ID was added to a Word document, and then another structure with ID was added to the same document after inserting 1-2  empty lines, the ID of the second structure was placed above the structure.

  • If an Excel sheet containing structures was converted to a protected sheet, the structures were not displayed on that sheet after.

April 1st, 2016: JChem for Office 16.3.2800

Marvin/JChem 16.3.28 used.

Improvements

  • The Import by ID from Database process now supports importing multiple rows for the same ID: it inserts the extra lines into the worksheet below each ID that has multiple rows in the database table or view.

Bug Fixes

  • CAS Registry Numbers that could be understood as date were imported into Excel as date during the Import by ID processes.

March 24th, 2016: JChem for Office 16.3.2100

Marvin/JChem 16.3.21 used.

Improvements

  • During import into JChem for Excel now all records are selected on the Rows tab by default. During import into JChem for Word/Outlook/PowerPoint the first N number of rows are selected, where N is the number of Maximum Rows set in the Data Mapping Limitations option.

Bug Fixes

  • Date type columns imported through JChem Webservice from an Oracle database was incorrectly formatted (including the timestamp info) even if the Treat Date and Currency as Text option was set to True.

March 18th, 2016: JChem for Office 16.3.1400

Marvin/JChem 16.3.14 used.

New feature

  • Synonyms are listed among the tables and views on Import from DB by ID form (if the appropriate JChem for Excel option is active).

Improvements

  • The single structure objects in Word and Outlook are not included in a 1x1 table anymore.

  • Windows 10 with the 32-bit version of MS Office 2010, 2013 and 2016 is now fully supported.

  • The 32-bit version of MS Office 2016 on Windows7, Windows 8.1 and Windows 10 is now fully supported.

  • The Actions > Convert To Structure > Placement > Insert Right option now affects the Import by ID process as well. (Until now it affected only the convert From SMILES, From 'any' Text and the Associate ID processes.)

  • The table and view names are now sorted on the Import by ID from Database dialog.

  • The status of the Selection only checkbox on the Import by ID dialog can now be controlled using the Options > Convert To Structure By Key From Database > Conversions > Convert Selection Only option. (The default value is still False.)

Bug Fixes

  • The table drop-down list was not refreshed on the Import from Database by IDs form at changing database.

  • Cancel button crashed the Import process if there were too many structures listed in the data grid (on the Rows window of the import wizard).

  • If a CLOB field contained a leading empty line (like sometimes in case of a MOLFile), and this field was not automatically recognized as structure field based on the field name, then the leading empty line was removed during the Database Import into Excel, and it could not be converted to structure after.

  • Import dialog crashed when all rows were selected above 2,000 structures.

March 3rd, 2016: JChem for Office 16.2.2900

Marvin/JChem 16.2.29 used.

Improvements

  • Database and table names are readable in full length by mouse hover over on the Import by ID from Database dialog.

Bug Fixes

  • The cd_structure column had been automatically added to the columns during Import from DB using Web Service, even if the selected table was a non-JChem table, and if it was selected, it resulted in a null pointer exception.

  • When a field having null value was selected among the other fields during Import from Database through Web Service, the values slipped.

  • Clicking on the Operator field on the Query tab of the Import from Database dialog automatically selected =, but that disappeared when the value was entered.

  • Using special operators, like Starts with or End with, on the Query tab of the Database Import caused an error.

  • Technical columns of JChem tables (like fingerprint, timestamp, etc.) were not hidden during Import from Database.

February 12th, 2016: JChem for Office 16.2.800

Marvin/JChem 16.2.8 used.

Improvements

  • Import by ID from Database now has a Selection only option that imports the data only for the selected IDs (if they are not in a discrete selection).

January 28th, 2016: JChem for Office 16.1.2500

Marvin/JChem 16.1.25 used.

Improvements

  • The default setting for the starting position during Import from Database has been changed to the next row after the used range on the current sheet (it is already the default for Import from File).

Bug Fixes

  • Not the appropriate structure editor opened up from the query dialog of the import from database and chemical filtering processes.

January 22nd, 2016: JChem for Office 16.1.1800

Marvin/JChem 16.1.18 used.

Bug Fixes

  • The bracket character caused an error when it was used in adding JCFunctions to an Excel cell from a user-defined macro code (for example, when trying to set a SMILES containing bracket in the argument of the JCStructure function).

January 15th, 2016: JChem for Office 16.1.1100

Marvin/JChem 16.1.11 used.

Bug Fixes

  • The change of the FixedScale parameter to zero was not saved into the settings file.

January 8th, 2016: JChem for Office 16.1.400

Marvin/JChem 16.1.4 used.

December 18th, 2015: JChem for Office 15.12.1400

Marvin/JChem 15.12.14 used.

Bug Fixes

  • It was not possible to import structures from CDXML format in JChem for Excel.

  • If JChem Web Services required authentication during Import from Database, the connection was unsuccessful.

  • Structure filtering threw an exception if the structure column included a cell containing text instead of structure.

December 8th, 2015: JChem for Office 15.12.700

Marvin/JChem 15.12.7 used.

Improvements

  • Copying structures between workbooks has been significantly sped up In Excel 2013 and 2016.

Bug Fixes

  • Pasting a text inside a PowerPoint textbox using Ctrl+V resulted in a new textbox including the copied text.

December 2nd, 2015: JChem for Office 15.11.3000

Marvin/JChem 15.11.30 used.

New features

  • The name import web service specified in the marvin.properties file (for example, by entering its URL on the Save/Load tab of the Preferences dialog opened from a standalone MarvinSketch window) is loaded into JChem for Excel/Word/PowerPoint/Outlook as well, so, for example, IDs recognized by that service can be converted to structure using the From Text button on the JChem ribbon.

Improvements

  • MarvinSketch windows opened from dialog windows where query structures can be entered load the structure display settings defined in the JChem > Options > Structure Display section.

  • The Fixed Scale parameter is displayed in percentage, and 100% is the default value.

Bug Fixes

  • If the Hit Coloring option was set to FALSE, the structures were not displayed for the hits.

  • Editing a structure in a PowerPoint table copied from Excel resized the table cell.

November 18th, 2015: JChem for Office 15.11.1600

Marvin/JChem 15.11.16 used.

Bug Fixes

  • Double-click on a structure object in Word did not open the structure editor in German language installation of MS Office.

  • Using the Apply Scale function or editing an object without structural change in PowerPoint doubled the size of the structure object if the Fixed Scale parameter was set to zero in the options.

  • Using the Apply Scale function in PowerPoint on a structure copy/pasted from Excel drastically increased the size of the image border if the FixedScale parameter was set to greater than zero in the options.

  • In versions higher than 15.10.12 it was not possible to edit the structures in tables copy/pasted from Excel to PowerPoint/Word/Outlook.

  • Structures defined by JCStructure functions referring to other cells remained as image above the cell after printing.

  • Using the Create No Structure option during SD file export saved the header row as the first record.

October 29th, 2015: JChem for Office 15.10.2600

Marvin/JChem 15.10.26 used.

Improvements

  • Import from File by ID can handle duplications, so it returns the data for all instances of an ID in an Excel column.
  • The current sheet is set to be the default for Import from File even if there is data on that sheet, positioning the import to start at the first empty line. Another sheet or a new sheet can still be selected during the import of course.

Bug Fixes

  • When only the CD_ID and CD_STRUCTURE columns were selected during an import from an Oracle DB using JChem Cartridge search, then nothing was imported.

October 22nd, 2015: JChem for Office 15.10.1900

Marvin/JChem 15.10.19 used.

Improvements

  • Import from Database by ID can handle duplications, so it returns the data for all instances of an ID in an Excel column.

October 15th, 2015: JChem for Office 15.10.1200

Marvin/JChem 15.10.12 used.

Improvements

  • The Implicit Hydrogen and the R/S Stereo Labels display options are now loaded into MarvinSketch both from the structure objects (in case of editing a structure in Word/PowerPoint/Outlook) and from the local JChem options (when adding a new structure in Excel/Word/PowerPoint/Outlook).

  • Closing a MarvinSketch window opened by any of the actions of JChem for Office (for example, Add, Edit, Filter, and so on.) will not update the marvin.properties files anymore, so changing the Display Settings in a such a MarvinSketch window will not affect the desktop MarvinSketch or other MarvinSketch windows in 3rd party applications.

Bug Fixes

  • If a structure was selected at the time of pasting another structure in Word, PowerPoint or Outlook copied from another application (for example. MarvinSketch or Excel), the original structure was deleted.

  • If a structure object was resized in PowerPoint by selecting only the internal image, after editing the structure it was resized to its original size or scale.

  • It was not possible to insert a structure into a Word table using the Add feature.

  • Trying to apply the Display and/or Scale settings on an image (containing no structure info) copied from Windows Explorer to PowerPoint displayed an incorrect warning message.

  • The Import IJC function in PowerPoint imported only the first 10 structures.

October 1st, 2015: JChem for Office 15.9.2800

Marvin/JChem 15.9.28 used.

Bug Fixes

  • After pressing the Display button, the structure will not shrink and will keep the size of the outer object if the document was created without scale information.
  • The Scale button now resizes the image according to the size defined in Image Formatting options, previously it was resized always to 200x200.

September 25th, 2015: JChem for Office 15.9.2100

Marvin/JChem 15.9.21 used.

New features

  • The scale of the pasted structure in Word/PowerPoint/Outlook will now reflect the zoom factor used in MarvinSketch during the Copy action.

Improvements

  • The Structure Display settings stored in the Word/PPT/Outlook/Excel Options are passed to MarvinSketch when adding a new molecule (so the structure looks the same during the creation as it will be displayed after drawing it).

September 17th, 2015: JChem for Office 15.9.1400

Marvin/JChem 15.9.14 used.

Improvements

  • Vague Bond Level 0 and Half are added to the Chemistry Search Options applied during Import or Filtering, and Level Half is the new default value.

Bug Fixes

  • After a file or database import in Word, the structure images were oversized and did not fit into the column in some cases.

  • The format of the molweight column imported from a JChem table during JChem Web Services was considered as integer instead of float.

September 3rd, 2015: JChem for Office 15.8.3100

Marvin/JChem 15.8.31 used.

Bug Fixes

  • Moving the mouse over a Paste Options icon crashed Excel if the JChem drawing was active.

  • After a file or database import in PowerPoint, the tables were placed on top of each other.

  • Copy/pasting a structure from Excel to PowerPoint/Word/Outlook did not reflect the Excel cell size.

August 25th, 2015: JChem for Office 15.8.2400

Marvin/JChem 15.8.24 used.

August 19th, 2015: JChem for Office 15.8.1700

Marvin/JChem 15.8.17 used.

Improvements

  • The JChem for Office object in Word/PowerPoint/Outlook keeps the image size or scale after editing the structure: If the FixedScale parameter is different from 0, then the scale is kept, otherwise the image size.

  • Import from File/DB results in a single table in Word/Outlook by default, with repeating the first row of the table as header at each page in Word.

Bug Fixes

  • Rendering of structures in Excel slowed down in version 15.6.8 but has been sped up again.

  • If there was no JChem for Office action initiated during an MS Word session, the closing of MS Word took too much time.

August 7th, 2015: JChem for Office 15.8.300

Marvin/JChem 15.8.3 used.

New features

  • One-click Scale action has been introduced in Word/PowerPoint/Outlook as a new ribbon button functionality, which reflects the Fixed Scale settings specified in options. The action works on a selected single structure.

  • One-click Display action has been introduced in Word/PowerPoint/Outlook as a new ribbon button functionality, which reflects the Structure Display settings specified in options. The action works on a selected single structure.

  • One-click solution is introduced for combined Display and Scale ribbon functionality in Word/PowerPoint/Outlook, which reflects both changes at the same time, working the same way on a single selected structure.

Improvements

  • The molecule object in a Word/PowerPoint/Outlook document keeps the structure display settings after modifying the structure in MSketch.

  • When editing a structure object in Excel/Word/PowerPoint/Outlook the structure is displayed with the same display settings in MSketch as it is displayed in MS Office.

July 31st, 2015: JChem for Office 15.7.2700

Marvin/JChem 15.7.27 used.

Improvements

  • The default Oracle provider is now Oracle JDBC (previously it was Devart dotConnect).

Bug Fixes

  • S-groups have been displayed in contracted form even if they were defined as an expanded group in MarvinSketch.

July 23rd, 2015: JChem for Office 15.7.2000

Marvin/JChem 15.7.20 used.

Bug Fixes

  • OLE copy did not work in MSketch.NET.

  • Ctrl+C then Ctrl+V did not copy a single structure object in Word.

July 15th, 2015: JChem for Office 15.7.1300

Marvin/JChem 15.7.13 used.

Bug Fixes

  • MarvinSketch.NET did not put the structure format titles to the clipboard during Copy and Copy As, therefore JChem for Office could not automatically recognize it and convert it to structure object during Paste.

July 1st, 2015: JChem for Office 15.6.2900

Marvin/JChem 15.6.29 used.

New features

  • JChem Web Services can be used in Import from Database.

  • Postgre SQL databases are supported in Import from Database.

Improvements

  • If an Oracle Cartridge view contains cd_structure, structure, cd_smiles or smiles column, it is selected automatically (in the above order) as a target column for structure search on the Query tab and as structure column on the Columns tab.

Bug Fixes

  • Database import did not work on Oracle (non-cartridge) Views unless the Search option was set to No Structure Search on the Query tab. Now the structure search is automatically disabled on non-cartridge Oracle Views.

  • The Import from Database process displayed Fetching... on the Rows tab even if there was nothing to import (for example, there was no hit resulted by the query). Now it properly displays if there is no result.

June 25th, 2015: JChem for Office 15.6.2200

Marvin/JChem 15.6.22 used.

June 17th, 2015: JChem for Office 15.6.1500

Marvin/JChem 15.6.15 used.

Improvements

  • All errors detected during a file import in Excel are now collected at the end of the import process, and the error report is now selectable and can be copied to the clipboard.

  • Structure filtering failed in Excel when one structure contained features that could not be handled by the JChem substructure search (e.g. a Markush structure with polymer features). Now the filtering skips these structures, hides them together with the non-hit structures, the hit count is properly displayed at the status bar, and the problematic structures are reported in an error message at the end of the filtering process.

Bug Fixes

  • Copying a SMILES from Word and pasting it into the canvas of a MarvinSketch.NET window opened from Excel/PowerPoint crashed Excel/PowerPoint.

  • It was not possible to run the License Manager in Word/Outlook/PowerPoint, and if it was the first action in Excel, the loading of the License Manager crashed Excel.

  • If additional text was selected together with a single structure object in Word, Ctrl+C recognized it as a single JChem for Office object, and therefore Ctrl+V pasted only the structure (the extra text was lost).

June 11th, 2015: JChem for Office 15.6.800

Marvin/JChem 15.6.8 used.

Improvements

  • If the FixedScale parameter is set in the JChem for Word/PowerPoint/Outlook options (to result in unified bond length throughout the document), it is applied during the paste of a single structure.

Bug Fixes

  • Copy/pasting an image from a browser into a PPT slide resulted in a picture that was recognized as a JChem for Office object.

June 2nd, 2015: JChem for Office 15.6.100

Marvin/JChem 15.6.1 used.

Improvements

  • IKVM, the 3rd party tool that converts the java-based codebase to .NET to create .NET APIs (like JChem.NET) and .NET applications (like MarvinSketch.NET) has been upgraded to version 7.4.

Bug Fixes

  • Shift+Click was not working in MarvinSketch.NET.

  • Save To Share converted only the first 1,000 structures to images in a few environments.

May 27th, 2015: JChem for Office 15.5.2500

Marvin/JChem 15.5.25 used.

Bug Fixes

  • Selecting a single word in a text box then pushing Ctrl+C copied the whole textbox in PowerPoint.

  • Copy/pasting multiple structures to a different workbook, then saving the target workbook and reopening it resulted in the loss of those structures.

May 22nd, 2015: JChem for Office 15.5.1800

Marvin/JChem 15.5.18 used.

May 15th, 2015: JChem for Office 15.5.1100

Marvin/JChem 15.5.11 used.

May 6th, 2015: JChem for Office 15.5.400

Marvin/JChem 15.5.4 used.

Improvements

  • The R-group decomposition is 3 times faster than before.

Bug Fixes

  • Opening a Word or PowerPoint document and then immediately closing the application caused a crash of Word/PowerPoint.

April 29th, 2015: JChem for Office 15.4.2700

Marvin/JChem 15.4.27 used.

April 22nd, 2015: JChem for Office 15.4.2000

Marvin/JChem 15.4.20 used.

April 14th, 2015: JChem for Office 15.4.1300

Marvin/JChem 15.4.13 used.

Bug Fixes

  • Converting a structure to ID (defined with IDSYSSTRUCTURE function) resized the row height to the height of the ID text, even if there was another cell that required more space.

  • If there was no header in the file, but the My data has header option was left True during the R-group decomposition, the decomposition results were shifted one row upward.

April 8th, 2015: JChem for Office 15.4.600

Marvin/JChem 15.4.6 used.

April 2nd, 2015: JChem for Office 15.3.3000

Marvin/JChem 15.3.30 used.

New features

  • The SAR table generation can be run on Markush structures containing more than 2 R-groups; the R-group pair used in the SAR table is selected from dropdown lists during the process.

Improvements

  • Structure filtering speed has been improved significantly: about 5 times faster in case of the first filtering action in an open Excel workbook, and about 10 times faster at any further filtering on the same open workbook (regardless of the query structure).

Bug Fixes

  • The query structure was not retained when initiating a filter action after opening a JChem for Excel file that was saved with a filtered sheet.

March 25th, 2015: JChem for Office 15.3.2300

Marvin/JChem 15.3.23 used.

Bug Fixes

  • Save to Share output files created from 97-2003 excel files (.xls) could not be opened.

  • Pasting JC structure functions over cells that already contained other JC structure functions threw an error message.

  • After converting a structure to OLE in excel, when editing it, the structure was not displayed in the OLE editor.

  • The My Data Has Headers option did not work properly in some cases during Filter and R-Group decomposition.

  • Structure header text disappeared after a clear filter if the My data has headers option was set to false during the filtering process.

  • The number of hits was not correct on the cloned worksheet after filtering.

  • Excel files saved in version 15.1.1900 or before containing a filter with a non-default stereo search option could not be opened in later versions.

March 18th, 2015: JChem for Office 15.3.1600

Marvin/JChem 15.3.16 used.

Bug Fixes

  • The filter dialog did not open on files that were saved with filter results using a JChem for Excel version 14.x.y or before.

  • The hit count info on the status bar showed a higher processed number if structures were deleted from the bottom of the sheet before filtering.

March 12th, 2015: JChem for Office 15.3.900

Marvin/JChem 15.3.9 used.

Improvements

  • The size of edited Marvin OLE objects has been reduced to less than half.

Bug Fixes

  • Structure filtering did not work on excel files containing JC STRUCTURE functions including a different argument separator than that of the current regional setting. For example, structure filtering failed on a computer having English regional settings if the JCIDSYSSTRUCTURE functions used in the file were created on a Hungarian computer (and therefore included semicolon separators instead of commas).

  • The Ctrl+Shift+N shortcut did not work in MarvinSketch.NET.

March 5th, 2015: JChem for Office 15.3.200

Marvin/JChem 15.3.2 used.

Bug Fixes

  • Import by ID and Associate ID functions did not work if the chemical structures were stored on BLOB type fields.

  • Hit result count was still displayed after Clear Filter.

February 26th, 2015: JChem for Office 15.2.2300

Marvin/JChem 15.2.23 used.

Deprecated option

  • The Copy Rows option has been removed from the Filter Actions since the Clone Rows functionality completely covers the related use case.

Improvements

  • The Clear Structure Filter action has been significantly sped up.

  • The pictures created from structures in Excel (for example, by To Image or Save To Share) are linked to the excel cells using the Move and Size with cells option from now on (this option was Move but don't size with cells before), which caused issues in case of excel data filtering.

Bug Fixes

  • Hit count information was not removed when pressing Clear Filter or when starting a new filtering process.

  • The characters at the end of longer descriptions on the JChem for Office Options dialog were sometimes compressed.

February 10th, 2015: JChem for Office 15.2.900

Marvin/JChem 15.2.9 used.

New feature

  • Marvin OLE objects in Word/PowerPoint/Outlook documents can be set to be replaced with a normal JChem for Office object upon editing (by double-click or using the Edit button).

Improvements

  • The Fixed Scale parameter in the JChem for PowerPoint and Word Structure Display options (Preferences > Display) now overwrites the picture size settings, so if it is set to different from 0, a single structure will be created according to that (even in case of editing), ensuring that the bond length will be the same in all parts of the document. In addition, the aspect ratio of the image is the same as the structure.

  • The default setting in JChem for PowerPoint/Word/Outlook is now changed to have no border when adding a new structure.

Bug Fixes

  • Importing from databases by ID did not import the structures if in a previous import process from the same table a non-structure field was set to be used as a structure.

  • If an excel sheet had only one column, containing structures defined by the JCIDSYSStructure formula (including ID info as well), the Structures only checkbox was selected automatically, and it was not possible to unselect, so there was no way to set the ID info to be exported.

January 29th, 2015: JChem for Office 15.1.2600

Marvin/JChem 15.1.26 used.

Improvements

  • The Stereochemistry option on the Filter and Import from Database dialogs is changed automatically to Exact if the Search Type is set to Duplicate, and to Stereospecific in any other Search Type (but can be changed manually to any other option).

Bug Fixes

  • If an Excel sheet had no header row, the structure in the first row was not exported.

January 21st, 2015: JChem for Office 15.1.1900

Marvin/JChem 15.1.19 used.

Deprecated option

  • The Paste ChemAxon Format context menu option (that was available in Word and PowerPoint even if only JChem for Excel was installed) has been removed. Please use the JChem for Office paste instead.

Improvements

  • The Stereochemistry option in the Basic Search Options on the Filtering dialog is changed from True/False values to Stereospecific/Exact/Ignore/Diastereomer/Enantiomer values to better reflect the options available in JChemBase. At the same time, the Exact Stereo Matching option has been removed from the Chemistry Search Options, because it is not needed anymore; the Stereochemistry=Exact option has to be used instead (for example, in case of duplicate search).

Bug Fixes

  • Characters that were available on a specific language keyboard only by combination with the AltGr key (for example, backslash on the German or Hungarian keyboard) could not be typed in dialogs opened from MarvinSketch.NET (the default editor in JChem for Office).

January 13th, 2015: JChem for Office 15.1.1200

Marvin/JChem 15.1.12 used.

Improvements

  • The Bond Lengths structure display option that controls the display of the bond lengths at each bond has been renamed to Bond Lengths Visible.

  • The Atom Symbols Visible structure display option that enables us to see the atom labels in 3D structures has been renamed to Atom Symbols Visible in 3D.

January 7th, 2015: JChem for Office 15.1.500

Marvin/JChem 15.1.5 used.

Improvements

  • The Align hits as query option is checked in by default during R-group decomposition.

Bug Fixes

  • In the 64-bit version of JChem for Excel, if the Region of Windows was set to Hungarian, excel cells containing imported/generated structures picked up a custom 'gene/r/al' format instead of using the standard 'General' format. This caused issues when inserting a new cell to the right or to the bottom of the given structure cell because Excel automatically gives the same formatting to the new cell, which mixed up the display of, for example, numbers in these new cells.

  • After editing a JChem for Excel structure that was imported from a lower-level file format ( SMILES) and adding higher-level features (for example, adding a query property to an atom), the structure did not change, because JChem for Excel tried to keep the original format. Now in these cases, the format is automatically upgraded to the corresponding higher-level format (in case of MarvinSketch to MRV).

December 17th, 2014: JChem for Office 14.12.1500

Marvin/JChem 14.12.15 used.

Improvements

  • In case of molecule structures that contain a part including aromatic bonds that cannot be converted to Kekule form (for example, a query structure with aromatic bonds), the non-converted part is displayed in its original form (with aromatic bonds) even if the Aromatic Bonds as Discrete Double Bonds display option is set to True. The structure rendering displayed an exception in these cases in the past.

  • The installer places an executable (EnableJCXLAddins) in the Program Files folder that runs a PowerShell script after a remote install to enable the JChem for Excel functions.

December 10th, 2014: JChem for Office 14.12.800

Marvin/JChem 14.12.8 used.

Improvements

  • The cell width and height in Excel are increased to the default size set in Options > Formatting > Default Cell Size, unless it was already at least 50% of it. It is applied during the following actions:

    • Add a new structure into the cell.

    • Insert a new structure from a file.

    • Paste a single structure.

  • The default value of the JChem for Excel Default Cell Size (that can be set in Options > Formatting) has been changed from 100,100 to 210,150 (in Excel metrics: column width = 28.5, row height = 112.5). Note: Upgrading from previous versions of JChem for Excel requires to use the Restore Defaults button on the Options dialog to apply this change.

December 4th, 2014: JChem for Office 14.12.100

Marvin/JChem 14.12.1 used.

New features

  • A new option has been introduced in the Structure Display settings: Bond Length globally sets the length of the bonds defined in points (similar to MarvinSketch).

  • A new value has been added to the Stereo > RS Labels option in the Structure Display settings: Show all possible R/S for any molecule, which—besides displaying the R or S labels for the specified stereocenters—displays a question mark at possible stereocenters.

Improvements

  • Pasting a structure in PowerPoint/Word/Outlook is now reflects the structure display settings of the source if it is available on the clipboard either as rendering settings or inside the molecule source, otherwise, it uses the local display settings.

Bug Fixes

  • Export to SDFile was very slow if there were extra rows or columns remaining from a previous version of the excel file.

November 28th, 2014: JChem for Office 14.11.2400

Marvin/JChem 14.11.24 used.

Improvements

  • The default file format in export has been set to .sdf instead of .mrv.

Bug Fixes

  • Marvin editor could not open when editing a structure in a table that was copied from Excel and pasted into Word, PowerPoint or Outlook.

November 21st, 2014: JChem for Office 14.11.1700

Marvin/JChem 14.11.17 used.

Improvements

  • Now it is possible to load the .NET controls on a background thread using the ChemAxon.NET API.

Bug Fixes

  • The canvas of a new, empty instance of the MarvinSketch.NET editor became unresponsive at rendering atom labels (for example, during selection or heteroatom drawing).

  • The Open and Save As dialogs of MarvinSketch.NET responded very slowly for opening a folder on a remote drive, especially if it contained many items.

  • There was a license exception in Word, PowerPoint, and Outlook if the license file did not include Marvin Beans license.

November 19th, 2014: JChem for Office 14.11.1000 has been withdrawn

Critical Issue found

  • The canvas of a new, empty instance of the MarvinSketch.NET editor becomes unresponsive when an atom label should be rendered (for example, during selection or heteroatom drawing). Opening and editing an existing molecule structure can be done without any problem.

November 13th, 2014: JChem for Office 14.11.1000

Marvin/JChem 14.11.10 used.

Improvements

  • The first time loading of Marvin editor has been sped up.

  • 5 new properties have been added to Structure Display Options (available in .NET API as well):

    • Atom Symbols Visible

    • Atom Properties Visible

    • Charge with Circle

    • Coordinate Bond Style on Single atom

    • Coordinate Bond Style on Multicenter atoms

Bug Fixes

  • Exporting formatted numbers from Excel to SDFile did not work properly if the decimal symbol was set to comma (e.g. in French local) in the Regional Settings of Windows.

  • Atom labels were too big compared to other parts of the molecules in very small images.

November 5th, 2014: JChem for Office 14.11.300

Marvin/JChem 14.11.3 used.

Deprecated features

  • The JChem for Office Paste action (from the JChem Ribbon or from the context menu) will not automatically convert texts to structures anymore. The From text option is still available to convert a text to structure after paste.

Bug Fixes

  • Atom labels were shifted to the top-left direction in small resolution images.

October 29th, 2014: JChem for Office 14.10.2700

Marvin/JChem 14.10.27 used.

Bug Fixes

  • Double-clicking in an empty cell of a table in a Word document launched the structure editor.

  • When trying to insert a hyperlink into the mail body in outlook using the Insert > Hyperlink option, when pasting the copied link into the Address field of the Insert Hyperlink dialog, the link was pasted directly into the email body.

October 22nd, 2014: JChem for Office 14.10.2000

Marvin/JChem 14.10.20 used.

Bug Fixes

  • IDs in Accord for Excel files in the cells behind the structures were lost during the conversion to JChem for Excel file.

  • Copying a single cell in Excel containing a structure specified by the JCIDSysStructure function could not be copied using Ctrl+C.

  • Pasting a directory path into the File name field of the Open dialog landed the directory path text in the active cell of Excel.

October 15th, 2014: JChem for Office 14.10.1300

Marvin/JChem 14.10.13 used.

Bug Fixes

  • IDs in Accord for Excel files in the cells behind the structures were lost during the conversion to JChem for Excel file.

  • Structure queries during DB import from Oracle cartridge using Devart connection did not proceed if the query structure was too big (more than 4,000 characters in the molecule source).

October 9th, 2014: JChem for Office 14.10.600

Marvin/JChem 14.10.6 used.

New feature

  • Ctrl+C and Ctrl+V are redirected to the JChem for Office Copy/Paste in case of single structure selection. It works in Excel, Word, PowerPoint, and Outlook; it is not implemented in OneNote yet (still the Copy/Paste ribbon buttons have to be used there). This behavior can be switched off by setting the corresponding option in Options > General > Event Handling > Keyboard Events to False.

Improvements

  • The Select All and Deselect All buttons have been replaced with a 3-state selector checkbox both on the column and on the rows selector tab of the Database import and File import dialogs. The number of selected columns/rows is also indicated next to it.

  • The HomologyNarrowTranslation option has been added to the search options both in JChem for Excel and in the dotNET API.

Bug Fixes

  • Sorting of spreadsheets having no excel functions on it did not automatically refresh the structure drawings in Excel 2010.

  • CD_SMILES was selected instead of CD_STRUCTURE as a target column by default in the case of the JChem Cartridge structure search method.

  • If JChem for Excel was not installed (only other JChem for Office components), the Import from Database could not find the Connection.xml, therefore the import did not work from PowerPoint, Word or Outlook.

  • 0 was accepted as Max number of imported structures on the Import File form.

  • The active sheet of the file resulted from the Save to share action was not the one from which the conversion was started. For example, if the Save to share was initiated on Sheet1, opening the resulted file showed Sheet2.

October 1st, 2014: JChem for Office 14.9.2900

Marvin/JChem 14.9.29 used.

Improvement

  • The JChem for Office installer places only a single item in the installed application list, so no need to uninstall JChem for PowerPoint, Word, Outlook, and OneNote before upgrading JChem for Office in the future.

Bug Fixes

  • If a database search criteria were specified during the import from a database where the table or the view was a Synonym, the import failed.

  • Structure queries during DB import from Oracle cartridge did not proceed if the query structure was too big (more than 4,000 characters in the molecule source).

  • Save to share did not convert sheets if there was only a single structure on cell A1 and an additional OLE object below it (no more structures on the sheet).

  • If JChem for Excel was not installed (only other JChem for Office components), the Import from Database could not find the Connection.xml, therefore the import did not work from PowerPoint, Word or Outlook.

September 24th, 2014: JChem for Office 14.9.2200

Marvin/JChem 14.9.22 used.

Improvements

  • JChem for Excel and Office supports querying and retrieving molecules from Oracle Synonyms.

  • Double click over JChem for Office images launches the editor from now by default.

  • Molecule import in JChem for Office and Excel has been accelerated.

  • DataBase import in JChem for Office now is better documented.

Bug Fixes

  • Tversky-metric used an incorrect default parameter, which resulted in the same values as Tanimoto-calculation.

  • There was a license exception in JChem for OneNote.

  • EMF exporter component was not synchronized with the MolExporter component.

  • Exception dialog accumulated errors and showed the first error on the top.

September 18th, 2014: JChem for Office 14.9.1500

Marvin/JChem 14.9.15 used.

Bug fixes

  • The JCAtomCount function could not calculate the total number of atoms (when the AtomicNumber parameter was not specified).

September 16th, 2014: JChem for Office 6.3.4

Marvin/JChem 6.3.4 used.

Improvements

  • Molecules are now displayed and searchable on Database Views as well.

  • The changes in the options of JChem for Powerpoint/Word/Outlook are retained during the upgrade of JChem for Office.

Bug fixes

  • Warnings for some JChem for Excel Ribbon items do not come anymore if the Show add-in user interface errors check-box is checked in Advanced Options.

  • The JCGhoseFilter function resulted in incorrect results because it used the heavy atom count instead of the all atom count.

  • The Help on this function links on the JChem function dialogs in Excel opened the index of the JChem for Excel Users Guide, not the specific function description pages.

September 12th, 2014: JChem for Office 14.9.800

Marvin/JChem 14.9.8 used.

Improvements

  • The simplified Copy and Paste functions are now directly available in the root of the context menu of Excel.
  • Synonyms (of tables, views, etc.) are now supported during import and JChem cartridge search on Oracle databases.

Bug fixes

  • Implicit hydrogens were converted to explicit hydrogens if both the "Explicit Hydrogens" and the "Aromatic bonds as discrete double bonds" display options were set to "True".

3rd of September, 2014: JChem for Office 14.9.100

Marvin/JChem 14.9.1 used.

Improvements

  • Molecules are now displayed and searchable on Database Views as well.
  • All structure editors are available in JChem for OneNote as in all other JChem for Office products.
  • The Save Password and Encrypt Password options are selected by default on the Import from Database dialog.

Bug fixes

  • The Restore Defaults option did not work in PowerPoint and OneNote.

  • The JCGhoseFilter function resulted in incorrect results because it used the heavy atom count instead of the all atom count.

  • The structures were not copied properly to the new sheet during Structure Filtering with the Copy Rows option, if the target structures were calculated (referenced) structures.

  • Having a structure copied from Excel, after pasting it as OLE in Word or in PowerPoint, the next pasting as image did not work until copying it again in Excel.

  • The Help on this function links on the JChem function dialogs in Excel opened the index of the JChem for Excel Users Guide, not the specific function description pages.

August 28th, 2014: JChem for Office 14.8.2600

Marvin/JChem 14.8.26 used.

Improvements

  • New simplified Copy and Paste released into prototype phase on /JChem for Office/ 14.8.1100 now replaced the old Copy/Copy OLE, Paste/Paste Table approach in the Ribbon. The user can do the copy and paste with 2 Ribbon buttons.

  • Listing database tables for database import modules both in JChem for Office and Excel happens in alphabetical order to get its usability more increased.

  • Database connection credentials (password) are stored in encrypted format as default from now.

  • Database import from View is possible now with setting selecting the Structure column on the columns tab. Searching for structures is still possible only with JChem Cartridge (JCC) search and retrieve.

  • JChem for OneNote can now be installed on the following environments: Windows 7 (64bit) - Office 2010 and Office 2013 (64bit) Windows 8.1 (64bit) - Office 2013 (32bit and 64bit).

  • Well known Help, About and License menu items in JChem for Office have been introduced also for JChem for OneNote.

  • A list of supported editor types is also available in JChem for OneNote from now (Marvin Sketch, ISIS Draw, MDL Draw, ChemDraw).

  • Double click editing over the structure images has been introduced for JChem for PowerPoint, Word, and Outlook as a demo version. OneNote solution is coming soon.

Bug fixes

  • The vector graphical images representing the structures in JChem for Office kept the bond thickness even if the image is resized/enlarged. The issue appeared after copying and pasting the column of structures from JChem for Excel to any Office application.

  • Warning for some JChem for Excel ribbon items never occurred again if the Show add-in user interface errors check-box is checked in Advanced Options.

August 22nd, 2014: JChem for Office 14.8.1800

Marvin/JChem 14.8.18 used.

Improvements

  • The maximum number of importable columns and rows from a database or file into Word, PowerPoint, or Outlook documents can now be configured in Options > General > Data Mapping Limitations.

  • The changes in the options of JChem for Powerpoint/Word/Outlook are retained during the upgrade of JChem for Office.

Bug fixes

  • Export to image was not working in the dotNet version of MarvinSketch.

August 13th, 2014: JChem for Office 14.8.1100

Marvin/JChem 14.8.11 used.

Improvements

  • Demo version of simplified copy action introduced and can be customized for evaluation in both JChem for Office and Excel. In the upcoming version, this approach will replace the copy/copy ole and paste/paste table action with single Copy/Paste labels.

  • Filtering rows into a different worksheet user workflow has been fixed and extended with clone rows solution keeping all references of chemical functions/calculations synchronized.

Bug fixes

  • Edge of structures was cut when pasting structures into MS Word.

August 5th, 2014: JChem for Office 14.8.400

Marvin/JChem 14.8.4 used.

August 1st, 2014: JChem for Office 6.1.9

Marvin/JChem 6.1.9 used.

Improvements

  • Converting AccelrysDraw 4.1 OLE objects is now supported (AccelrysDraw changed the OLE content in version 4.1).

July 31st, 2014: JChem for Office 6.3.3

Marvin/JChem 6.3.3 used.

Improvements

  • Converting AccelrysDraw 4.1 OLE objects is now supported (AccelrysDraw changed the OLE content in version 4.1).

Bug fixes

  • Due to a change caused by a Windows upgrade (from Windows 8 to Windows 8.1), Excel was freezing at first JChem action on Win8.1/Excel2013-64-bit. Please use your Windows 8 with the latest updates!

  • Molecules in generic brackets with attached data to the bracket could not be copied in Excel.

July 30th, 2014: JChem for Office 14.7.2800

Marvin/JChem 14.7.28 used.

July 23rd, 2014: JChem for Office 14.7.2100

Marvin/JChem 14.7.21 used.

New modules

  • The prototype of JChem for OneNote module has been added to the JChem for Office package. Currently, it supports Office 2010-32-bit version and includes the Add/Edit and Copy/Paste features (internal and across other office documents). We encourage everyone to evaluate it and send feedback to jc4xl-support@chemaxon.com. Thank you.

New features

  • Save to Share: It converts the structures to images and the JChem functions to pure values to be able to share the file with others having no JChem for Excel installed.

Deprecated features

  • The VMN file format is not supported anymore in JChem for Office, so molecules cannot be imported from or exported to .vmn files.

Improvements

  • The number of hits found on an Excel sheet is displayed on the left side of the status bar after the filtering action and kept displayed for 10 seconds. If the sheet becomes inactive (for example, navigating to another sheet or workbook), the hit count is redisplayed whenever the sheet becomes active again.

  • A progress bar has been added to the File import dialog to provide visual feedback on the status of the import process.

  • The last connection that was used during Import from Database is now automatically selected at the next import process inside the same MS Office program until the instance of that program is closed.

  • The default options can be restored using the Restore defaults button on the Options dialog in JChem for Excel.

  • Asian punctuation marks are now supported in names during converting them to structure.

  • A new class (WorkbookRecognizer) has been added to the JChem for Excel IO API that returns the format of the Workbook as ISIS, ChemDraw, Accord or JChemExcel.

Bug fixes

  • The order of the columns after the import from File, Database or InstantJChem did not retain the order of the columns set on the Rows tab of the import dialog window.
  • The Next button on the penultimate tab of the import dialog window in JChem for Word/PowerPoint/Outlook did not perform the Import.

July 18th, 2014: JChem for Office 6.3.2

Marvin/JChem 6.3.2 used.

Improvements

  • The InstantJChem interface has been improved to enable importing data into office documents even without molecular structures included in it.

  • The file converter tool has been improved:

    • The conversion of large files has been sped up significantly.

    • Now it is possible to select the file type (ISIS/Symyx or ChemDraw or Accord) to skip the autorecognition and avoid failure in case of mixed Excel files.

Bug fixes

  • Copy and paste did not work into a cell which was referred to in another cell inside a chemical function.

  • When pasting a single structure copied from Excel into Word, the Color Scheme in the Structure Display setting was overwritten by the color scheme of the original structure source.

  • The Convert Accord to JC4XL item was not available in the context menu (in the Convert > Convert (from) Other Workbooks submenu).

June 23rd, 2014: JChem for Office 6.3.1.1116/1117

(including JChem for Excel 1806/1807)

Bug fixes

  • Upgrading from Office 2007 to Office 2010 could make the buttons on the JChem for Excel ribbon disabled.

  • Having several Excel error tags (a green triangle in the upper-left corner of the cells) in the visible area caused antialiasing issues in the structure display until the first click.

June 17th, 2014: JChem for Office 6.3.1

Marvin/JChem 6.3.1 used.

Bug fixes

  • After the automatic updates of Windows 7 and Windows 8 in the middle/end of May 2014 the 6.2.x and 6.3.0 installers could not load the COM add-ins automatically, therefore the JChem tab did not appear, and after manually enabling the add-ins, there was a crash in Excel.
  • The yellow star icon was not displayed when adding a table to favorites.
  • MySQL Views could not be imported if the user name was different from the DB name.
  • If the JChem4XL drawing was not activated in a newly created workbook yet, pasting cells from another workbook where only the IDs were visible resulted in #Value display instead of properly showing the IDs.
  • In 6.3.0 excel files, structures containing hit-highlight could not be indexed in Sharepoint.
  • On Windows with French regional setting and Swiss keyboard, exporting structures with properties in the molecule into SDFiles from Excel, then importing them back into Excel resulted in an HRESULT E_FAIL error message.
  • The Return non-hits option was disabled in case of Import DB through JChem Cartridge, since this JChem for Office option has no appropriate counter option in JChem Cartridge.

May 19th, 2014: JChem for Office 6.3.0

Marvin/JChem 6.3.0 used.

New features

  • Office 2013 support in JChem for Excel on Windows 8 as well.

  • Data fields can be merged during the opening of multiple files by selecting the Merge files onto a single worksheet option.

  • Accord for Excel files can now be converted by

    • the File converter tool

    • the Convert right-click menu and

    • upon customization, as a JChem for Excel ribbon action

  • It is now possible to import from a database in Word, PowerPoint, and Outlook.

  • Input/Output API is now available for JChem for Word and JChem for PowerPoint as well. Implementation examples.

  • The ChemAxon .NET API has been extended with a Database API (insert/update/delete). The new ChemAxon .NET API provides better usability; see how it can be leveraged through the implementation examples.

  • Aqueous solubility calculations (intrinsic and pH-dependent) are now available as JChem for Excel functions.

  • CSRGF files can be imported.

Improvements

  • The number of structures to be imported is now displayed during the Import from DB and import from InstantJChem processes, as well as during the import from file in Word/PowerPoint/Outlook.

  • The hits can be optionally aligned during R-group decomposition.

  • Import by is now possible on database views as well.

  • The usability of the Import from Database and the Import from File dialogs has been improved:

    • The tabs and the options have been reorganized, and the dialogs are standardized throughout the JChem for Office products.

    • The table selection tree has been redesigned.

    • Record filtering and selection are consolidated.

Bug fixes

  • The second import from file in Word/PowerPoint/Outlook using the One structure per page option displayed an error message (although the import itself was successful).

  • IUPAC numbering was not displayed for all structure format.

  • File import aborted in case of structure cleaning error of a molecule in the file.

May 13th, 2014: JChem for Office 6.2.3

Marvin/JChem 6.2.3 used.

Bug fixes

  • Structures were not displayed in cells having comments added after choosing Hide then Show.

  • It was not possible to add a comment to a cell on an empty worksheet.

  • Cell comments were sometimes mixed after using the To OLE/From OLE conversions consecutively.

  • Opening some Excel files containing special images was not successful due to an error in a third-party .dll (SX.dll from SMARTXLS).

April 7th, 2014: JChem for Office 6.2.2

Marvin/JChem 6.2.2 used.

Bug fixes

  • Comment editing did not work properly in the case of the 64-bit version of Excel.

  • The text-based structure was not handled properly in case of import from a database.

  • Convert context menu items did not work in the case of Office 2013.

March 5th, 2014: JChem for Office 6.2.1

Marvin/JChem 6.2.1 used.

Bug fixes and improvements

  • Lipinski functions got documented more and better.

  • JCStandardizeStructure can except more complicated expression containing special characters like : [O:2]=[N:1]=O>>[O-:2][N+:1]=O.

  • After copying structures and values from JChem for Excel to Word / PPT as OLE and opening them in Marvin, the structure now keeps the original drawing settings in terms of this workflow.

  • Converting structures to OLE and the range (non-structure cells) contained cell-related comments that are not lost after converting back the OLE images back to structures.

  • Opening up Cell format dialog or other Excel dialogs does not stop visualization of structures in Excel 2010 and 2007.

  • Filtering data in JChem for Office before the data import in the grid and after the filter copying data and pasting in other applications keep the Hit Colouring.

Bug fixes

  • Import by ID from the database did not threw exception from now if the cells contained empty cells in the range.

  • Importing from a Database by IDs, not all selected properties (columns) are filled in the worksheets with data (remained empty).

  • JChem for Excel IO API failed if the worksheet already contained data inside the file (cell indexes are fixed).


February 1st, 2014: JChem for Office 6.2.0

Marvin/JChem 6.2.0 used.

New features

  • 64-bit Office support for JChem for Excel and Office.

  • Office 2013 support in JChem for Excel (Preview - Windows7 and Office 2013 works together - Windows8 with Office2013 is coming soon).

  • Office 2013 support in other Office products like JChem for Word, PowerPoint and Outlook.

  • New fast Open functionality with multiple file selection in JChem for Excel.

  • Most commonly used editors like ChemDraw, ISIS and Symyx Draw are available in JChem for Office.

  • IUPACNumbering (atom numbering) of structure visualization is available for both JChem for Excel and Office.

  • The default property set for structures is introduced in JChem for Office.

Improvements

  • Faster SDF import and record processing in JChem for Excel.
  • Faster OLE and Image conversion in-place in JChem for Excel.
  • Realization of custom scale of drawing in OLE and Image conversions in JChem for Excel.
  • Realization of custom scale of drawing in Copy and Paste between JChem for Excel and Office applications.
  • Supporting CDX, SKC formats natively in JChem for Excel.
  • New AutoClear option/setting of local structure sheet cache after saving a workbook.
  • Supporting row and column grouping/outlining in structure visualization of JChem for Excel.
  • New cancellable progress bar for longer operations both in JChem for Excel and Office apps.

Bug fixes

  • Scrolling bigger SAR tables crashed the program.

  • Opening .csv files crashed the program.

April 7th, 2014: JChem for Office 6.1.8

Marvin/JChem 6.1.8 used.

Improvements

  • The Marvin View Control has been improved:

    • Direct context menu control

    • Clear the content

    • Read-only mode at run-time

January 22nd, 2014: JChem for Office 6.1.7

Marvin/JChem 6.1.7 used.

Bug fixes

  • Loading column selector schemas (db and file import - second tab) caused problems.

January 20th, 2014: JChem for Office 6.1.6

Marvin/JChem 6.1.6 used.

Bug fixes

  • License fixes for JChem for Excel and Office (implications)

December 20th, 2013: JChem for Office 6.1.5

Marvin/JChem 6.1.5 used.

Bug fixes

  • GetStructuresByFormula API method for VBA developers did not return molecule data from the local storage.

  • 2D coordinates (orientation) applied for molecules (even if they are generated/converted from smiles).

  • Opening workbooks from remote, web store caused error 400.

  • SDF containing RG (R-group info) molecules did not work.

December 10th, 2013: JChem for Office 6.1.4

Marvin/JChem 6.1.4 used.

Improvements

  • JChem for Excel gets rid of supporting Instant JChem connections since we support IJC import applying its native credential system from 6.1 major.

Bug fixes

  • JChem for Excel/Office installer accidentally allowed the add-ins to be installed on Office 2013 environment too early, we discard this for 6.1 release line and will be allowed again in 6.2 soon.
  • COM/VBA API of JChem for Excel for Import structures damaged in 6.1, in 6.1.4 it has been fixed.

November 5th, 2013: JChem for Office 6.1.3

Marvin/JChem 6.1.3 used.

Bug fixes

  • Assay data containing date and time information is was not searchable.

October 18th, 2013: JChem for Office 6.1.2

Marvin/JChem 6.1.2 used.

Improvements

  • CChemicalTerms in JChem for Excel supports custom function added via Marvin Services to extend JChem for Excel built-in functions (java jar has to be implemented by the customers and can be used from JChem for Excel).

Bug fixes

  • Rendering caused crash with specific (not at 100%) zoom setting of the video driver and screen anymore in JChem for Excel.

  • Fixed scale settings (to unify smaller and bigger molecules) could not be applied in copy and paste in JChem for Office.

September 19th, 2013: JChem for Office 6.1.0

Marvin/JChem 6.1.0 used.

New features

  • JChem for Office (supporting Excel, PowerPoint, Word, and Outlook).
  • SAR table generation in JChem for Excel.
  • OSRA integration in JChem for Excel.
  • IJC (live connection) dataset import for both JChem for Excel and JChem for Office.
  • Paste from IJC Dataset.
  • Windows 8 support.

Improvements

  • New Look & Feel (Ribbon facade) for both JChem for Excel and JChem for Office.
  • Copy Table to Word and PowerPoint functionality supports the fixed scale setting from now.
  • Quick filter introduced for Grid View control—on Database Import Rows tab.
  • Hit coloring in Grid View control—on Database Import Rows tab.
  • New .NET examples available to overview basic visualization tools/controls.
  • ChemDraw13 integration into JChem for Excel as an editor.
  • More reliable license handling.
  • More currencies supported in SD file export.
  • From Text (name, CAS Registry Number) reports the conversion problems better.
  • Inchi support on Windows 8.
  • Document to Structure improvements  (better memory handling, more structure recognized).
  • After hit coloring and filtering the export is more reliable.

Bug fixes

  • Copy-Paste did not work inside Task Pane.

  • Similarity Search did not work.

  • Multi-window state (minimized) froze the application.

August 28th, 2013: JChem for Excel 6.0.5

Marvin/JChem 6.0.5 used.

Bug fixes

  • ISIS/Draw editor threw string data is null exception.

  • ChemAxon.NET.Windows.Forms controls could not be dropped from the toolbox to the form designer.

  • A resource from Installer was missing.

August 12th, 2013: JChem for Excel 6.0.4

Marvin/JChem 6.0.4 used.

July 24th, 2013: JChem for Excel 6.0.3

Marvin/JChem 6.0.3 used.

July 2nd, 2013: JChem for Excel 6.0.2

Marvin/JChem 6.0.2 used.

Bug fixes

  • R-group decomposition after Filtering caused wrong highlighted results in the previous version.

  • New grouped chemical functions gave bad results if the function contained optional parameters, for example, JCReactionProductStructure.

  • After Filtering the Hit Highlighted structure could not be exported into a file (only in Structure only mode).

June 21st, 2013: JChem for Excel 6.0.1

Marvin/JChem 6.0.1 used.

Improvements

  • The new add-in for grouping our chemical functions compiles from now under specific charsets/code pages (like Chinese, Japanese)

Bug fixes

  • JChem for Excel did not implicate JChem search license for Filter.

May 23rd, 2013: JChem for Excel 6.0.0

Marvin/JChem 6.0.0 used.

New features

  • OSRA image recognition can be configured for File Import Process.

  • Two menu series introduced for Chemists (standard) and Modellers (advanced).

  • New, empty worksheet is default for Import for file and database and R-Group Decomposition.

  • More usable user interface for R-Group Decomposition workflow dialog.

  • More usable user interface for Filter and Database Search functionalities (dialogs).

  • New Excel add-in added to classify our chemical functions and give direct help (context) to our help file.

  • Moleculename/identifier appears as a new column from the SDF file/Mol file header section.

  • Corporate ID handling is introduced for JChem for Excel IO API (C# .NET).

  • Corporate ID handling is introduced for JChem for Excel Java API.

  • Corporate ID handling is introduced for Copy and Paste tables to Word and PowerPoint.

  • The largest fragment is displayed from a compound by a new chemical function.

Improvements

  • Better and faster structure range detection in molecule filter workflow.

  • R-group decomposition improvements.

  • Dialogs are closed after the successful processing of data.

  • R-group decomposition form handles binary data formats like .skc, and .cdx.

  • Better copy and paste reliability between workbooks, structure sheet fixes.

Bug fixes

  • Headers were converted in SMILE conversion workflow.

  • Copy table to Word and PowerPoint did fall back to the original working mechanism if there was no valid selection.

  • In Filter form, the target molecule is properly re-read from the active cell.

  • Copy and Paste between instances (ID and Structures) did not work.

  • (Oracle) TNS name connection did not work properly.

May 6th, 2013: JChem for Excel 5.12.4

Marvin/JChem 5.12.4 used.

Improvements

  • Java API supports appending to existing files (workbooks).

  • The structure column index in the Java API (Structure to JChemforExcel) can be specified from now.

Bug fixes

  • The converter tool broke the help file in the web help (Admin guide).

  • ChemDraw for Excel file created with version 13 could not be converted to JC4XL format.

April 11th, 2013: JChem for Excel 5.12.3

Marvin/JChem 5.12.3 used.

Improvements

  • Corporate ID support for java IO API.

  • Inchi library can be unloaded with a helper routine (not to break inchi functionality in customer codes and in ChemAxon products concurrently).

  • Better copy and paste even when Structure Sheet cannot be created (more reliable Structure Sheet handling, more stable structure storage).

  • JCFunctions will be automatically refreshed and give back valid values if the target structure arrives on the sheet later with copy and paste).

March 29th, 2013: JChem for Excel 5.12.2

Marvin/JChem 5.12.2 used.

Improvements

  • New IO.API requires a license only for generating JChem for Excel file format, reading will be free of charge.

  • Filtering is faster with processing only the target range in the spreadsheet.

  • C# demo projects are up-to-date again on the web site reflecting the current state also for COM API.

  • Opacity is eliminated when pasting ChemAxon format (structures and values) inside Excel regardless of the target structure shape types (OLE, EMF, JChemExcel).

March 20th, 2013: JChem for Excel 5.12.1

Marvin/JChem 5.12.1 used.

Improvements

  • JCxStructure conversion to editable JCSyStructure will ignore the irrelevant cells containing other data types and formats.

  • R-group Decomposition and Structure Filtering handle now properly binary chemical formats like CDX, SKC for molecule searching.

  • Molecule filter performs proper filtering work also in that case when the user drags the MOL file into the Molecule Panel.

  • Molecule Panel/View (.NET component) handles binary chemical formats from the clipboard properly (this component can be found on R-group and Filter dialog).

  • Associate ID (with Structures from Database) can handle native IJC credentials (user name, and password).

  • Copy to Word/PowerPoint ignores the irrelevant rows => the code does not fall back to the original solution.

March 5th, 2013: JChem for Excel 5.12.0

Marvin/JChem 5.12.0 used.

New features

  • One-click solution added for ID association from database (Displays structures or IDs in the worksheet after a quick search).

  • New JChemExcel.IO.API service introduced.

  • Conversion from ChemDraw for Excel.

  • New Java and Dotnet API for JChem for Excel File format introduced.

  • Custom scale of molecules to achieve fixed bond length for bigger or smaller molecules Fixed Scale.

  • Merged cells can display structures in the center vertically and horizontally Merged Cells.

  • Document To Structure introduced as part of the File Import module Document To Structure.

  • JCxStructure (all calculated Structure functions) can be converted to an editable format by a customizable action.

  • Copy and paste structures and data values works from our grid control.

  • One-click copy solution for table (to Word and PowerPoint).

  • Import from MS SQL database is supported from now.

Improvements

  • Filter and R-group Decomposition GUI are displayed faster.

  • Faster structure handling with our new ChemAxon.NET API.

  • A license check introduced for producing JChem for Excel file format.

  • Blank workbooks added automatically when certain actions are hit.

Bug fixes

  • There were some conversion report inconsistencies.

  • The Geometry plugin license did not work properly (geometry plugin required for calculations as is in Marvin).

January 18th, 2013: JChem for Excel 5.11.5 (906)

Marvin/JChem 5.11.5 used.

Improvements

  • Better loading of JChem Excel functions even when Excel is started from other applications (solution to #Name problem in cells).

January 14th, 2013: JChem for Excel 5.11.5

Marvin/JChem 5.11.5 used.

December 3rd, 2012: JChem for Excel 5.11.4 (886)

Marvin/JChem 5.11.4 used.

Bug fixes

  • Cloned workbooks gave a missing structure hash keys error message.

November 21st, 2012: JChem for Excel 5.11.4

Marvin/JChem 5.11.4 used.

Improvements

  • A new option has been introduced to make smiles conversion customizable to be done along with or without automatic 2D co-ordinate cleanup.

  • A new option has been introduced to scale down/up the molecules per user taste to display the smaller and bigger ones with common bond length (beta).

  • Enlarge structures in the case of a fixed scale can be done by the increase/decrease size action buttons.

  • To Marvin OLE shape action generated active structures get invisible border instead of the current strong black borders outlining the shapes.

  • To Marvin OLE shape conversion is faster now keeping the OLE component alive for frequent converters.

  • The frequency of hidden structures decreased in a multi-document workbook environment.

Bug fixes

  • Batch conversion like CAS Registry Number, IUPAC, or Smiles contained less logging.
  • Conversion of ISIS files saved as macro supported workbooks (.xlsm) did not support the original file extension (.xlsm, .xlst).
  • Enlarging special structures with special scale caused Overflow exception in the case of specific structures.
  • MRV file header contained an incorrectly filled header (product version).

October 19th, 2012: JChem for Excel 5.11.3

Marvin/JChem 5.11.3 used.

October 15th, 2012: JChem for Excel 5.11.2

Improvements

  • In addition to registry settings, the splash screen is configurable now from the Options dialog as well.

  • Copying structures and values into PowerPoint has been improved with keeping the aspect ratio for (corner-dragging) without distorting the molecules.

Bug fixes

  • Filter hit highlighting works with alignment of the substructures only without losing the original heteroatom colors (no hit color)
  • Splash screen will not be frozen on any specific environment
  • JChem for Excel installer works now in advanced user mode as before
  • JCStandardizer function functionality was broken in 5.11.1 for multiple string parameters like tautomerize..aromatize. Fixed now.

September 27th, 2012: JChem for Excel 5.11.1

Bug fixes

  • JCStandardizeStructure reports more detailed exceptions from now
  • JCStandardizeStructure is able to accept the ruleset file (full path) as an action string from now
  • JCStandardizeStructure is able to accept the ruleset file name if the folder of ruleset files is specified in the option from now

September 21st, 2012: JChem for Excel 5.11.0

New features

  • Database import Query tab will provide an option for the user to load only the favorite tables
  • Database Import Rows tab the grid will provide copy - (paste) option
  • 5.10 ID or Structure feature will be extended for Database and File import to select the ID column
  • JCChemical terms will be handling molecules and molecule arrays as return values
  • FromText action will be introduced to convert any recognizable text from cell to JChem for Excel structure
  • JCReactantStructure, JCProductStructure, JCReagentStructure: new functions will be able to extract component structures from a reaction molecule
  • New bridge from IJC (export flattened data from IJC, copy-paste IJC data into JChem for Excel)
  • New Java API module to create JChem for Excel documents (for Knime, Pipeline Pilot, other applications)

Improvements

  • Cross-sheet limitation when editing function formulas is eliminated with a configurable option (Misc section)
  • Font colors are part of copy from structure and nonstructural data to other Office applications
  • Conditional formatting(back color, font color) will be part of copy from structure and nonstructural
  • Data to other Office applications
  • Time import and date information separation after import
  • More documentation about IJC connection
  • Improving performance of the Structures embedding in Smiles

Bug fixes

  • JCIDStructure function will accept not only true/false but 1 or 0 integer values.
  • Task pane fixes
  • CDX file can be opened after an export from a worksheet
  • Fix crash when Embedding in Smiles is done in the first row of the spreadsheet
  • Printing was not consistent for ID state of JCIDStructure (in ID state on print page both the structure and IDs could be seen)
  • Substructure search filter will be able to highlight the structures with customized color again
  • Hit color is changeable again and can be set on filter form

September 13th, 2012: JChem for Excel 5.10.4

Marvin/JChem 5.10.4 used.

August 15th, 2012: JChem for Excel 5.10.3

Marvin/JChem 5.10.3 used.

Improvements

  • Improving performance of the Structures embedding in Smiles

Bug fixes

  • Fix crash when Embedding in Smiles is done in the first row of the spreadsheet
  • Printing was not consistent for ID state of JCIDStructure (in ID state on print page both the structure and IDs could be seen)
  • Allowing bridging R-group search in R-group decomposition works consistent with the User Interface from now

July 31th, 2012: JChem for Excel 5.10.2

Marvin/JChem 5.10.2 used.

Bug fixes

  • After filtering the structures in the worksheet JChemExcel does not refresh (draw) the screen showing irrelevant structures (especially when the same number of rows are kept from filter)

July 16th, 2012: JChem for Excel 5.10.1

Marvin/JChem 5.10.1 used.

Bug fixes

  • ISIS Excel conversion issue (Excel limitation: frozen panes are not handled properly in Excel xls->xlsx conversion)
  • Database Import handles Table Views better for Database Search

June 12th, 2012: JChem for Excel 5.10.0

Marvin/JChem 5.10.0 used.

New features

  • Copy structure and values action takes some formatting properties like background color, font alignment, and size and puts on the clipboard
  • Copy structure and values action takes the formatted text value from the cell instead of the pure value and puts on the clipboard
  • JCStructure has been introduced to allow direct source input and provide structure drawing from that (N2S functionality also included, #CAS, IUPAC, Inchi, SMILES)
  • JCIDSystructure function has been introduced to get a new editable function beside SysStructure and allow the user to flip-flop between ID text formula and drawn structure formula
  • Show/HideStructures actions went on the Ribbon to serve the new JCIDSystructure function by switching between the formulas
  • Embedding/UnEmbedding structures actions introduced to get in-place SMILES representations e.g. R-Group Decomposition
  • File and Database import contains a new field selector(save/load) to make handling of the huge number of properties much more comfortable
  • Import from Database got a new look and feel, row selector got introduced before the user maps the records on the spreadsheet
  • ISIS Converter tool will be introduced officially

Improvements

  • Marvin OLE has been reintroduced again to get a standalone Marvin based editor for JChem 4 Excel
  • Progress bar is displayed on time on Export and R-Group Decomposition form
  • R-Group Decomposition is much faster for more than 5000 structures
  • Installer gives clearer message for prerequisites (especially for 64 bit Office)
  • New API property [IsLoaded] will be introduced to give information about if the full JChem 4 Excel add-in is loaded or not

Bug fixes

  • Reactor does not exclude the stored selectivity and reactivity values from the reaction schema/template
  • Instance-instance copy by invoking XML Spreadsheet format will not cause crash if it is launched from the Ribbon (Paste Special)
  • Only the structure column is selected for .cxsmiles file format
  • Marvin .NET Editor gets the keyboard focus when it is displayed from now
  • SharedAddin does not affect negatively closing of the Excel application anymore
  • Fixes in query syntax of MySQL and other vendors
  • R-Group decomposition works also in the last column of the Excel spreadsheet from now
  • String operators works now for both MySQL and Oracle (like, begin with, ...) in the database import module

May 14th, 2012: JChem for Excel 5.9.4(182)

Marvin/JChem 5.9.4 used.

Bug fixes

  • Open XML API works fine for AddStructure functionality.
  • Pre-read of SDF on the Import File wizard (2.tab) to determine selectable columns works properly.
  • Pre-read of Excel worksheet column numbers for Export to File functionality does not have a 50-row limitation.
  • Smaller cosmetics happened on Structure column width detection (GetRange size exception has been eliminated).

April 24th, 2012: JChem for Excel 5.9.3(150)

Marvin/JChem 5.9.3 used.

Bug fixes

  • JChem Base search in other owner's schema (Oracle-specific).
  • IUPAC name import fills the Name column (next to structure column) automatically again.

April 18th, 2012: JChem for Excel 5.9.2(136)

Marvin/JChem 5.9.2 used.

Bug fixes

  • Filtered structure sheet and office image conversion does not throw exception.
  • Embedded excel functions like indirect/address/match work together with our drawing from now.
  • Database import and Devart client component works again without having license issues.

April 15th, 2012: JChem for Excel 5.9.2(132)

Marvin/JChem 5.9.2 used.

Improvements

  • More detailed description for functions like Chemical terms

Bug fixes

  • JCIUPAC and JCTraditional name functions work if they are combined on a worksheet.
  • OLE clipboard content can be pasted now if the clipboard contains only the pure OLE storage stream (Selecting Marvin OLE object and Copy from Office apps and paste into JChemExcel)
  • Pure OLE content can be pasted now into molecule panel controls on Filter and R-Group Decomposition form
  • The protein structure can be imported now much faster and managed much better if the cell size is over 100 pixels
  • ISIS to JchemExcel conversion works again
  • SDF file export works even when mol and .mrv are mixed/imported on structure sheet
  • SDF file export writes the Windows line endings again as normally
  • SDF file export works properly for binary (.skc, .cdx) formats
  • OLE conversion works well if the structure sheet contains pure binary formats (.skc, .cdx) or mixed formats
  • Image conversion works faster normally from JCXL drawing objects to Office shapes
  • Printing works faster when the printing is over and the worksheet gets back to the normal view from print preview
  • Reactivity, selectivity parameters from now works not only for JCReactProductStructure but FOR the JCReactReactionStructure. You can check reactor integration here.

March 6th, 2012: JChem for Excel 5.9.0

Marvin/JChem 5.9.0 used.

Bug fixes

  • MySQL database search fails because of an internal service identification problem.

February 15th, 2012: JChem for Excel 5.8.2

Marvin/JChem 5.8.2 used.

New features and improvements

  • Export functionality in JChemExcel API
  • ISIS/Symyx document conversion feature as a new action
  • Open XML API for JChemExcel document generation on Windows Servers

Bug fixes

  • Drawing causes problems in opening workbooks and copy of sheets
  • RD/SD file export and import fixes
    • Currencies can be exported
    • Date time format is read without conversions
    • Currencies are read without conversions
    • Export with range selection does not throw error any longer
    • Overwrite import function works from current position without applying the overwrite option
    • Import considers Excel column and row limitations from Excel 2003-2010
    • Result from R-group decomposition can be exported
    • Column size specified by the user is kept after the second import by append option
    • Import functionality is more tolerant against invalid data
    • Fixes on the UI
  • Import from Database by key
  • Copy and paste between Excel instances (XML Spreadsheet format) works again
  • V3000 format is supported in the import process from SD files
  • Column size specified by the user is kept after the molecule conversions

February 10th, 2012: JChem for Excel 5.7.2

Marvin/JChem 5.7.2 used.

Bug fixes

  • Marvin/JChem Library patch.

December 16th, 2011: JChem for Excel 5.7.1

Marvin/JChem 5.7.1 used.

New features

    Import File by key
    Import from Database by key
    Import from Database - Relational

Improvements

    • User Guide for 2003 and 2007 are merged

November 8th, 2011: JChem for Excel 5.6.0

Marvin/JChem 5.6.0.4 used.

New features

      • Advanced copy-paste to Office applications (https://www.chemaxon.com/forum/ftopic7902.html)
      • R-Group Decomposition Functions
      • Structure editor in Task Pane
      • Import File by key - Beta
      • Import from Database by key - Beta
      • Import from Database - Relational - Beta
      • Samples for reading from / and writing JC4XL specific workbooks in OpenXML
        • Java Examples
      • KNIME Nodes - to be released by Infocom

Improvements

      • Structure Filter - all filter options are saved
      • Structure Sheet record overwrite protection

Bug fixes

      • Copy-paste issue between workbooks in Excel 2010
      • Error reading other users schema
      • Error specifying criteria for other users schema
      • Out of memory error in Export to File functionality
      • Problem in image conversion back and forth inside Excel

September 8th, 2011: JChem for Excel 5.5.1 (262)

Marvin/JChem 5.5.1 used.

Bug fixes

      • Image conversion affected the drawing negatively in special cases.
      • From Image, To Image fixes when the underlying worksheet is being changed.
      • Worksheet name validation caused exception for too long worksheet names.
      • Printing cannot be returned, the application got frozen in certain cases.
      • Excel application-application instance copy/pasted by using Paste Special and XML spreadsheet data type did not work for structures.

July 28th, 2011: JChem for Excel 5.5.1

Marvin/JChem 5.5.1 used.

Bug fixes

      • ChemDraw ActiveX (default) editor reactivated.

June 21st, 2011: JChem for Excel 5.5 (226)

Marvin/JChem 5.5.0.1 used.

Bug fixes

      • Memory leak when exporting a huge number of structures to file eliminated.
      • Installer listing domain users for adding activation is removed till the next release.

June 10th, 2011: JChem for Excel 5.5

Marvin/JChem 5.5.0.1 used.

New features

      • JCHitColorSimilarityStructure

Improvements

      • 3rd party .NET data provider for Oracle
        • Support TNS Names
        • Support Direct and OCI connections
        • Support Integrated Authentication

Changes

      • Moved rendering from managed to native code.

Bug fixes

      • Import from Database - importing NULL values

May 9th, 2011: JChem for Excel 5.4.1 (446)

Marvin/JChem 5.4.1.1 (patch) used.

Bug fixes

      • Office 2010 backstage view crash eliminated.

March 19th, 2011: JChem for Excel 5.4.1

Marvin/JChem 5.4.1.1 (patch) used.

New features

      • Initial Admin Guide included
      • Support for embedded functions inside JCxImage or JCxStructure functions
      • Support for special functions inside JCxImage or JCxStructure functions
      • Support No Structure rendering and editing
      • Display Valence Errors
      • Options for displaying aromatic bonds as discrete double bonds
      • Import from File - Option to import transposed - to columns instead of rows
      • Export to File - Export selection only
      • Export to File - Optionally create No Structure for empty cells
      • Export to File - Export a structure matrix - for example a reaction products
      • Export to File - Select which row to use as header, or optionally use column letters
      • Export to File - Optionally select column to set as structure name when exporting to SDF

Improvements

      • Developers Guide moved into installer and available in both CHM and PDF formats.

Bug fixes

      • Fixed Export to File - Large cell contents

December 8th, 2010: JChem for Excel 5.4.0

Marvin/JChem 5.4.0.1 (patch) used.

New features

      • Office 2010 Support
      • Structure Checker and Fixer with Excel formulas
      • Most common substructure with Excel formulas
      • R-group definition display with Excel formulas
      • Markush Match with Excel formulas
      • Import from Oracle Views
      • Convert to aromatic, Kekule form
      • Add, remove explicit hydrogens
      • Convert from MOL to Structure

Improvements

      • Set the default structure size in Options
      • Set the preferred printing range in Options

Bug fixes

      • Fixed Calculations Pack license issues with various plug-ins

October 31st, 2010: JChem for Excel 5.3.8.166

Marvin/JChem 5.3.8 are used.

New Features

      • Office 2010 compatible version. Installer accepts Office 2010 as a supported office version.

Changes/Improvements

      • Default structure size can be set in options
      • New printing modes to make the printing process faster (workbook, worksheet, selection specific structure preparation for printing)
      • Some new JChem functions integrated (e.g. JCMCSStructure)
      • More ChemDraw® editor support
      • Better logging around start-up to get more informative log messages (e.g. incompatible dot net version, or other installation problems)

Bug fixes

      • Import from the database can accept standard database tables without structures
      • Side-by-side workbook window view is supported in the scrolling of molecules
      • Refine the context menu to make distinction batch mode actions and single structure actions

September 10th, 2010: JChem for Excel 5.3.8

Marvin/JChem 5.3.8 are used.

Bug fixes

      • The structure editor (Marvin) can be closed without closing the Structure Checker window.
      • Enable/disable context menu items based on selection change even if the multiple selection has been executed by using the Ctrl keyboard button.
      • Structure drawing problem at scrolling in side by side windows has been solved.

August 17th, 2010: JChem for Excel 5.3.7

Marvin/JChem 5.3.7 are used.

Bug fixes

      • Installer Incompatibility issues with Marvin. From 5.3.7 mixed JChem and JChem for Excel version is also supported.
      • Marvin OLE shapes copy alone and along with cell values on Office 2003. From now OLE content is not lost using them in Excel and in other Office applications.

August 5th, 2010: JChem for Excel 5.3.6

Marvin/JChem 5.3.6 are used.

New Features

      • Copy to clipboard multiple images along with data.
      • Copy to clipboard multiple OLE objects along with data.

Changes/Improvements

      • The JChem for Excel specific context menu is available if rows or columns are selected or if the whole worksheet is selected.
      • Enable/disable context menu items based on selection change.
      • Paste a single structure from an external editor: Marvin Sketch, ChemDraw, ISIS/Draw and Symyx Draw are supported by this function.
      • JChem for Excel supports molecule string format correction in the databases.

Bug fixes

      • The IUPAC names can be converted back to structures after converting the structures to IUPAC names.
      • Open and initialization at the same time problem has been eliminated. A recent XLS file containing sys structures can be opened right after a Microsoft Excel instance has been started.
      • The converted pictures (images and OLE objects) are not converted back to sys structures automatically after printing.
      • The structures remain selectable after printing.
      • Partitioning, Protonation, Conformation and some other plugins can be used with the Calculations Pack license.
      • Convert to structures from SMILES function can be used more times on the same workbook file.
      • R/S label stereochemistry display option has been corrected.
      • Not only the A column is available as a target column on the Filter form.
      • Structure visibility problem after importing an RD file has been solved.

July 9th, 2010: JChem for Excel 5.3.5

Marvin/JChem 5.3.5 are used.

New Features

      • New text conversion features (InChi, IUPAC name, SMARTS)
      • Convert and copy multiple structures to Marvin OLE/Image Shape

Changes/Improvements

      • Marvin OLE as an integrated structure editor has been deprecated/removed.

Bug fixes

      • Spacing of bonds and atom label size in 2D cleaning is fixed and now corresponding with options/settings.
      • 3D cleaning issue had an effect on the rendering of the original structure.
      • Distortion of molecules after Marvin OLE conversion has been eliminated.

June 3rd, 2010: JChem for Excel 5.3.3

Marvin/JChem 5.3.3 are used.

New Features

      • ISIS Draw® and Symyx Draw® structure editor support
      • IDBS ChemXtra® cartridge support
      • Symyx Cartridge® 5.x support
      • Customizable UI
      • Marvin OLE support in Marvin .NET
      • Geometry Plug-In functions
      • Import from standard database tables

Changes/Improvements

      • The underlying JChem API has changed from 5.3.2 to 5.3.3.
      • R-Group Decomposition
        • Insert results into new columns on the same worksheet
      • Import from File
        • Optionally rename the destination worksheet name to the file name
      • Convert to Structure
        • Optionally resize cells to default size before conversion

Bug fixes

      • Fixed importing from JChem tables with multiple structure string formats

May 3rd, 2010: JChem for Excel 5.3.2

Marvin/JChem 5.3.2 are used.

Changes

      • The underlying JChem API has changed from 5.3.1 to 5.3.2.
      • Marvin OLE .NET version is available from JChem for Excel.
        • Marvin (Beans) .NET installation is required for accessing it.

February 24th, 2010: JChem for Excel 5.3.1

Marvin/JChem 5.3.1 are used.

New Features

      • Use ChemDraw® as editor
        • ChemDraw can be used for editing structures after changing the settings under Options/Structure Editor.
      • New API methods for turning on and off drawing, and getting version

Changes

      • JChem for Excel will be released along with Marvin and JChem releases.
        • This change will be reflected in the JChem for Excel version number clearly.

Bugfixes

      • Fixed calling API from VSTO Add-In
      • Fixed prompting from save, when the workbook was not changed
      • Fixed sub-menus not appearing in Marvin .NET in Windows Vista

December 14th, 2009: JChem for Excel 1.1.3

Marvin/JChem 5.2.6 are used.

New Features

      • New Installer
        • No need to manually configure JChem for Excel Automation Add-In.
      • API Guide
        • Examples in C# and VBA, documentation.
      • Convert Structures to and from Excel images
        • Allows copy to other applications such as PowerPoint.
        • Allows viewing structures without JChem for Excel.
      • Added Alignment options to hit coloring
        • Hit alignment is off by default.
      • Use XML configuration with JCStandardizeStructure

Changes

      • Marvin Applet editor removed, default editor is Marvin .NET
      • Convert to Structure changed to From SMILES
        • It supports only conversion from SMILES.
        • Note: Other formats will be added in 1.2.

Bugfixes

      • Fixed problems with Convert to Structure from SMILES
      • Fixed importing SDFile in V3000 format
      • Fixed Structure render strange when using JChem for Excel through Remote Desktop Protocol (Terminal Services)
      • Fixed Drawing Options: Color Scheme, Atom Label Size, Double Bond Width
      • Fixed Options load problem with French regional settings
      • Fixed using JChem for Excel with multiple users on the same computer
      • Fixed using JChem for Excel together with JChem .NET API
      • Fixed displaying IUPAC names containing Greek characters
      • Fixed Import from MySQL JChem Base databases having non-default JChem Properties table name
      • Fixed MYSQL query criteria
      • Fixed deleting a query criteria on Import from Database and running Search throwing exception
      • Fixed copy between Microsoft Excel instances
      • Fixed Slow quitting from Excel in certain cases
      • Fixed Resize problem of certain graphical objects (pictures in Excel 2003, embedded OLE objects)
      • Fixed Transparency problem (cell background color) in printing mode (print preview, print)

September 23rd, 2009: JChem for Excel 1.1.2

Marvin/JChem 5.2.4 are used.

New Features

      • Structure Editing

        • Marvin .NET Beta included as the default structure editor.

        • Open single structure files (CDX,MOL,MRV,PDB).

        • Save single structure to file (CDX,MOL,MRV,PDB).

      • Structure Manipulation

        • Convert to Structure from SMILES.

        • Convert to SMILES from Structure.

        • Remove hit coloring from selected structures.

      • Structure Rendering

        • Structure display options have been added.

      • Copy-Paste:

        • Copy-paste between workbooks

        • Copy to external editors supporting MDL CT format.

        • Paste from external editors supporting MDL CT format.

      • New Unique Image and Structure functions:

        • Rendering: JCBallStickImage, JCSpaceFillImage

        • Display Options: JCAtomNumberImage, JCBondLengthImage

        • Plug-Ins: JCChargeImage, JCHBDAImage, JCHuckelAnalysisImage, JClogPImage, JCOrbitalElectroNegativityImage, JCpKaImage, JCPolarizabilityImage.

        • 2D Clean: JC2DCleanStructure

        • Structural Framework: JCBemisMurckoStructure

        • Standardizer: JCStandardizeStructure

        • Reactor: JCReactProductStructure, JCReactReactionStructure

Improvements

      • Functions
        • Added JCHeavyAtomCount
        • Extended JCAtomCount with an optional AtomicNumber parameter
      • Export to File
        • Option to skip hidden rows.
      • Import from File
        • Option to put the original SMILES or IUPAC name on the sheet, when importing from these formats.
      • Licensing
        • Added License Manager form.
      • Performance
        • Fast Excel start-up with the Add-In. Only a thin native Add-In is loaded on Excel startup. The .NET Add-In is loaded on the first usage.
      • Printing
        • Clear printing of structures for any paper size.
      • Structure Filter
        • Filter is saved with workbooks.
        • Select the structure column to filter on, there are more structure columns on the sheet.
        • Filter could be reapplied. The previously drawn query structure is not lost.
        • Filter uses the new JCHitColorStructure function for hit coloring.
      • Structure Rendering
        • Truly transparent structure rendering (no remainders of atom label background around atom labels).

Bugfixes

    • Import from Database
      • JChem Cartridge search on non-JChem Base generated tables.
      • JChem Cartridge search *VARCHAR* typed target structures.
    • Structure Rendering
      • Wrong structure placement if the workbook (child) window is not maximized.
      • Changed from resizing to clipping when splitters or panes are turned on.
      • Structures are invisible after sorting in Excel 2007.
      • Horizontal splitter or pane breaks the scrolling with selection in Excel 2003 .
      • The structure is invisible when the user closes the Function Arguments form by the Cancel button.
      • Adding a new window (clone) is not maximized mode get structures invisible.
      • The structures are disappeared from the sheet after saving the Excel workbook.
      • Horizontal splitter or pane breaks the scrolling with selection on Office 2003.