History of changes: New features and improvements, bug fixes

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!