History of changes: New features and improvements, bug fixes

27th of May, 2015: JChem for Office 15.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.

22nd of May, 2015: JChem for Office 15.1800

Marvin/JChem 15.5.18 used.

15th of May, 2015: JChem for Office 15.1100

Marvin/JChem 15.5.11 used.

6th of May, 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.

29th of April, 2015: JChem for Office 15.4.2700

Marvin/JChem 15.4.27 used.

22nd of April, 2015: JChem for Office 15.4.2000

Marvin/JChem 15.4.20 used.

14th of April, 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.

8th of April, 2015: JChem for Office 15.4.600

Marvin/JChem 15.4.6 used.

2nd of April, 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 time 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 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.

25th of March, 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 didn't work properly in some cases during Filter and R-Group decomposition.
  • Structure header text disappeared after 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 cloned worksheet after filtering.
  • Excel files saved in version 15.1.1900 or before containing a filter with non-default stereo search option could not be opened in later versions.

18th of March, 2015: JChem for Office 15.3.1600

Marvin/JChem 15.3.16 used.

Bug Fixes

  • The filter dialig 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.

12th of March, 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. E.g., 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

5th of March, 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.

26th of February, 2015: JChem for Office 15.2.2300

Marvin/JChem 15.2.23 used.

Improvements

  • The Clear Structure Filter action has been significantly sped up.
  • The pictures created from structures in Excel (e.g. 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.

Deprecated option

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

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.

10th of February, 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 of 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 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.

29th of January, 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.

21st of January, 2015: JChem for Office 15.1.1900

Marvin/JChem 15.1.19 used.

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 (e.g. in case of Duplicate search).

Bug Fixes

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

13th of January, 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 to see the atom labels in 3D structures has been renamed to "Atom Symbols Visible in 3D".

7th of January, 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 e.g. numbers in these new cells.
  • After editing a JChem for Excel structure that was imported from a lower level file format (e.g. SMILES) and adding higher level features (e.g. 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).

17th of December, 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 (e.g. 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 fiunctions.

10th of December, 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.

4th of December, 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.

28th of November, 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.

21st of November, 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 (e.g 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.

19th of November, 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 (e.g during selection or heteroatom drawing). Opening and editing an existing molecule structure can be done without any problem.

13th of November, 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 to big compared to other parts of the molecules in very small images.

5th of November, 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.

29th of October, 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.

22nd of October, 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.

15th of October, 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).

9th of October, 2014: JChem for Office 14.10.600

Marvin/JChem 14.10.6 used.

New feature

  • Ctrl+C and Ctrl+V is 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 searchoptions both in JChem for Excel and in the dotNET API.

Bug Fixes

  • Sorting of spreadsheets having no excel functions on it did not automatically refreshed the structure drawings in Excel 2010.
  • CD_SMILES was selected instead of CD_STRUCTURE as target column by default in case of 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 by the "Save to share" action was not the one from which the conversion was started. (E.g., if the "Save to share" was initiated on Sheet1, opening the resulted file showed Sheet2.)

1st of October, 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 was specified during the import from 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.

24th of September, 2014: JChem for Office 14.9.2200

Marvin/JChem 14.9.22 used.

Improvements

  • JChem for Excel and Office supports querying and retrieving molcules 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.

18th of September, 2014: JChem for Office 14.9.1500

Marvin/JChem 14.9.15 used.

Bug fixes

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

16th of September, 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. Documentation.
  • 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.

12th of September, 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. Documentation.
  • 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 "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.

28th of August, 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 module both in JChem for Office and Excel happens in aplhabetical 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 Catrridge (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
  • List of supported editor types are 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 vectorgraphical images representing the structures in JChem for Office keep the bond thickness even if the image is resized/enlarged. The issue appeared after copying and pasting column of structures from JChem for Excel to any Office application.
  • Warninig for some JChem for Excel Ribbon items never agains comes if the "Show add-in user interface errors" check-box is checked in Advanced Options"

22nd of August, 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. Documentation.
  • 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.

13th of August, 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.

Bug fixes

  • Edge of structures are no more cut when pasting structures into Ms. Word (not even in the case of Ball & Stick drawin style).
  • 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.

5th of August, 2014: JChem for Office 14.8.400

Marvin/JChem 14.8.4 used.

1st of August, 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).

31st of July, 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 bracket with attached data to the bracket could not be copied in Excel.

30th of July, 2014: JChem for Office 14.7.2800

Marvin/JChem 14.7.28 used.

23nd of July, 2014: JChem for Office 14.7.2100

Marvin/JChem 14.7.21 used.

New modules

  • The prototype of the 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. Documentation.

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 (e.g navigating to another sheet or workbook), the hit count is redisplayed whenever the sheet becomes active again. Documentation.
  • 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.

18th of July, 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 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).

23th of June, 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.

17th of June, 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.addins automatically, therefore the JChem tab did not appear, and after manually enabling the addins, there was a crash in Excel.
  • The yellow star icon was not displayed when adding a table to favourites.
  • MySQL View-s 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 a HRESULT E_FAIL error message.
  • The "Return non-hits" option has been disabled in case of Import DB through JChem Cartridge, since this JChem for Office option has no appropriate counter option in JChem Cartridge.

19th of May, 2014: JChem for Office 6.3.0

Marvin/JChem 6.3.0 used.

New features

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.

13th of May, 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) that has been fixed by upgrading it

7th of April, 2014: JChem for Office 6.2.2

Marvin/JChem 6.2.2 used.

Bug fixes

  • Comment editing did not work properly in case of the 64-bit version of Excel
  • The text based structure was not handled properly in case of import from database
  • Convert context menu items did not work in case of Office 2013

5th of March, 2014: JChem for Office 6.2.1

Marvin/JChem 6.2.1 used.

Bug fixes and improvements

  • Lipinski functions got documented more and better
  • Import by ID from the dabase does not throw exception from now if the cells contained empty cells in the range
  • Importing from database by IDs not all selected properties (columns) are filled in the worksheets with data (remained empty)
  • JCStandardizeStructure can except more complicated expression containing special characters like : [O:2]=[N:1]=O>>[O-:2][N+:1]=O
  • JChem for Excel IO API does not fail anymore if the worksheet contained already data inside in the file (cell indexes are fixed)
  • After copying structures and values from JChem for Excel to Word / PPT as OLE and opening them in Marvin, the structure WILL keep the original drawing settings!!!!! in terms of this workflow
  • Converting structures to OLE and the range (non structure cells) contained cell related comments these will NOT be lost after converting back the OLE images back to structures
  • Opening up Cell format dialog or other Excel dialogs will 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 applciation will keep the Hit Colouring!

1st of Feb, 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 is available in JChem for Office
  • IUPACNumbering IUPACNumbering (atom numbering) of structure visualization is available for both JChem for Excel and Office
  • 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 Excen and Office apps

Bug fixes

  • Crash when scrolling bigger SAR tables is eliminated
  • Crash when csv files are opened is eliminated

7th of Apr, 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

22nd of Jan, 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) works without any problems for the first trial

20th of Jan, 2014: JChem for Office 6.1.6

Marvin/JChem 6.1.6 used.

Bug fixes

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

20th of Dec, 2013: JChem for Office 6.1.5

Marvin/JChem 6.1.5 used.

Bug fixes

  • GetStructuresByFormula API method for VBA developers fixed, it can give back molecule data either in binary or text format from the local storage
  • 2D co-ordinates (orientation) applied for molecules (even if they are generated/converted from smiles)
  • Error 400 has been eliminated when workbooks are opened from remote, web store (workbooks are opened in protected view)
  • SDF containing RG (R-group info) molecules work from now

10th of Dec, 2013: JChem for Office 6.1.4

Marvin/JChem 6.1.4 used.

Bug fixes and 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, please check the documentation instead, and do not forget initializing by this description
  • JChem for Excel/Office installer accidentally allows the addins to be installed on Office 2013 environment too early, we discard this for 6.1 release line and will be allow 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

5th of Nov, 2013: JChem for Office 6.1.3

Marvin/JChem 6.1.3 used.

Bug fixes

  • Assay data containing date and time information is now searchable even on database views not only tables

18th of Oct, 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 impelmented by the customers and can be used from JChem for Excel)

Bug fixes

  • Rendering does NOT cause 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) can be applied in copy and paste in JChem for Office

19th of Sept, 2013: JChem for Office 6.1.0

Marvin/JChem 6.1.0 used.

New features

Improvements

  • New Look & Feel (Ribbon facade) for both JChem for Excel and JChem for Office
  • Copy Table to Word and Power Point functionality supports the fixed scale setting from now
  • Quick filter intorduced for Grid View control - on Database Import Rows tab
  • Hit colouring 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) reports the conversion problems better

Bug fixes

  • Copy-Paste works inside Task Pane
  • Similarity Search fix
  • Inchi support on Windows8
  • Document to Structure fixes (better memory handling, more structure recognized)
  • After hitcolouring and filtering the export is more reliable
  • Multi-window state (minimized) does not freeze the application anymore

28th of Aug, 2013: JChem for Excel 6.0.5

Marvin/JChem 6.0.5 used.

Bug fixes

  • ISIS/Draw editor does not throw: "string data is null" exception and works normally
  • ChemAxon.NET.Windows.Forms controls can be dropped from the toolbox to the form designer again
  • Missing resource from Installer has been fixed, the application does not the "Catastrophic failure" at starting up

12th of Aug, 2013: JChem for Excel 6.0.4

Marvin/JChem 6.0.4 used.

24th of July, 2013: JChem for Excel 6.0.3

Marvin/JChem 6.0.3 used.

2nd of July, 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 result if the function contained optional parameter(s) e.g. JCReactionProductStructure
  • After Filtering the Hit Highlighted structure could not be exported into file (only in Structure only mode)

21st of June, 2013: JChem for Excel 6.0.1

Marvin/JChem 6.0.1 used.

Bug fixes

  • JChem for Excel implicates JChem search license for Filter again (this was broken in 6.0)
  • The new addin for grouping our chemical functions compiles from now under specific carsets/code pages (like Chinese, Japanese)

23rd of May, 2013: JChem for Excel 6.0.0

Marvin/JChem 6.0.0 used.

New features

Improvements

  • Better and faster structure range detection in molecule flter workflow
  • R-group decompostion improvements
  • Dialogs are closed after succesful 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 are no longer converted in SMILE conversion workflow
  • Copy table to Word and PowerPoint does not fall back to the original working mechanism if there is 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) works again
  • (Oracle) TNS name connection fixes

6th of May, 2013: JChem for Excel 5.12.4

Marvin/JChem 5.12.4 used.

Improvements

  • Java API supports appending to existing files (workbooks)
  • Structure column index in the Java API (Structure to JChemforExcel) can be specified from now

Bug fixes

  • Converter tool broken help file in the web help (Admin guide) is fixed
  • ChemDraw for Excel file created with version 13 can now be converted to JC4XL format

11th of April, 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 pruducts concurently)
  • 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)

29th of March, 2013: JChem for Excel 5.12.2

Marvin/JChem 5.12.2 used.

Improvements

  • New IO.API requires 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 is 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)

20th of March, 2013: JChem for Excel 5.12.1

Marvin/JChem 5.12.1 used.

Improvements

  • JCxStructure conversion to editable JCSyStructure will ignore the irrelevant cells containingother data types and formats
  • R-group Decomposition and Structure Filtering handle now properly binary chmical formats like CDX, SKC for molecule searching
  • Molecule filter performs proper filtering work also in that case when the user drags MOL file into the Molecule Panel
  • Molecule Panel/View (.NET component) handles binary cehmical 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/PPT ignores the irrelevant rows => the code does not fall back to the original solution

5th of March, 2013: JChem for Excel 5.12.0

Marvin/JChem 5.12.0 used.

New features

Improvements

  • Filter and R-group Decomposition GUI are displayed faster
  • Faster structure handling with our new ChemAxon.NET API
  • License check introduced for producing JChem for Excel file format
  • Blank workbook added automatically when certain actions are hit

Bug fixes

  • Conversion report inconsistencies fixed on report dialog
  • Geometry plugin license fixed (geometry plugin required for calculations as is in Marvin)

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

Marvin/JChem 5.11.5 used.

Bug fixes:

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

14th of 2013 January, 2012: JChem for Excel 5.11.5

Marvin/JChem 5.11.5 used.

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

Marvin/JChem 5.11.4 used.

Bug fixes:

  • Eliminated missing structure hash keys error message for cloned workbooks.

21st of November, 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 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

Bug fixes:

  • Batch conversion like CAS or IUPAC or Smiles contains more logging especially because of the more frquent expired license issues
  • Conversion of ISIS files saved as macro supported workbooks (xlsm) supports the original file extension (xlsm, xlst)
  • Enlarging special structures with special scale does not cause "Overflow" exception in the case of specific structures
  • MRV file header will not contain incorrectly filled header (product version)
  • Frequency of hidden structures decreased in multi-document workbook environment

19th of October, 2012: JChem for Excel 5.11.3

Marvin/JChem 5.11.3 used.

15th of October, 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 Power Point 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 loosing the original heteroatom colours (no hit colour)
  • 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.. Fxied now.

27th of September, 2012: JChem for Excel 5.11.1

Bug fixes

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

21st of September, 2012: JChem for Excel 5.11.0

New features

  • Database import Query tab will provide option for the user to load only the favourite 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 colours is part of copy from structure and non structural data to other Office applications
  • Conditional formatting(back color, font color) will be part of copy from structure and non structural
  • 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 cusomized colour again
  • Hit colour is changeable again and can be set on filter form

13rd of September, 2012: JChem for Excel 5.10.4

Marvin/JChem 5.10.4 used.

15th of August, 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 decompisition works consistent with the User Interface from now

31th of July, 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)

16th of July, 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

12th of June, 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 colour, 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 addin is loaded or not

Bug fixes

  • Reactor does not exclude the stored selectivity and reactivity values from the reaction schema/tempalte
  • 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 synthax 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

14th of May, 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 50 row limitation.
  • Smaller cosmetics happened on Structure column width detection (GetRange size exception has been eliminated).

24th of April, 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.

18th of April, 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/adress/match work together with our drawing from now.
  • Database import and Devart client component works again without having license issues.

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

Marvin/JChem 5.9.2 used.

Improvements

Bug fixes

  • JCIUPAC and JCTraditional name functions work if the 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.

6th of March, 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.

15th of February, 2012: JChem for Excel 5.8.2

Marvin/JChem 5.8.2 used.

New features and improvements

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
    • Currenies 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 import process from SD files
  • Column size specified by the user is kept after the molecule conversions

10th of February, 2012: JChem for Excel 5.7.2

Marvin/JChem 5.7.2 used.

Bug fixes

  • Marvin/JChem Library patch.

16th of December, 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
  • 08th of November, 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

    08th of September, 2011: JChem for Excel 5.5.1 (patch 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 applciation got forzen in certain cases.
    • Excel application-application insatnce copy/pase by using Paste Special and XML spreadhseet data type did not work for structures.

    28th of July, 2011: JChem for Excel 5.5.1

    Marvin/JChem 5.5.1 used.

    Bug fixes

    • ChemDraw ActiveX (default) editor reactivated.

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

    Marvin/JChem 5.5.0.1 used.

    Bug fixes

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

    10th of June, 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

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

    Marvin/JChem 5.4.1.1 (patch) used.

    Bug fixes

    • Office 2010 backstage view crash eliminated.

    19th of March, 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 coulmns insted 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

    8th of December, 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

    31st October, 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 databse can accept standard database tables without structures
    • Side-by-side workbook window view is supported in scrolling of molecules
    • Refine context menu to make distinction batch mode actions and single structure actions

    10th September, 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 conext 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 conext 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 remains 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 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 depricated/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 effect on 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
      • Optinally rename the destination worksheet name to the file name
    • Convert to Structure
      • Optinally 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 appering 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 colour) 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 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 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 backround 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 Cancel button.
      • Adding a new window (clone) in 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.

    Do you have a question? Would you like to learn more?

    Please browse among the related topics on our support forum or search the website. If you want to suggest modifications or improvements to our documentation email our support directly!