ChemAxon 0e37943a96
10-08-2009 14:28:43
Version: 5.3.3
Planned release date: 2 weeks after Marvin and JChem 5.3.3 release, June 1st, 2010
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
Improvements:
- 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
ChemAxon bd13b5bd77
09-07-2010 20:15:42
Planned release date: 9th July, 2010
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.
ChemAxon def2724101
04-08-2010 19:39:22
Planned release date: 5th August, 2010
New Features
- Copy to clipboard multiple images along with data. It is possible to convert the structures to images and copy them with other cell values to the clipboard in one step and paste them into another Microsoft Office application.
- Copy to clipboard multiple OLE objects along with
data. It is possible to convert the structures to Marvin OLE objects and copy them
with other cell values to the clipboard in one step and paste them into
another Microsoft Office application.
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 singel 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.
ChemAxon bd13b5bd77
23-08-2010 08:05:21
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.
ChemAxon def2724101
09-09-2010 10:48:09
Version: 5.3.8
Planned
release date: 10th September, 2010
Changes/Improvements
- 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.
ChemAxon 0e37943a96
20-10-2010 13:24:00
Version: 5.4.0
Planned release date: 2 weeks after Marvin and JChem 5.4.0 release,~ November 15, 2010
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
ChemAxon bd13b5bd77
31-10-2010 19:22:22
Version: 5.3.8 (166)
Planned release date: October 31, 2010
New features:
- Office 2010 compatible version. Installer accepts Office 2010 as a supported office version.
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
ChemAxon 0e37943a96
21-03-2011 10:42:16
Version: 5.4.1
New features:
- Initial Admin Guide included
Improvements:
- 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
Changes:
Developers Guide moved into installer and available in both CHM and PDF formats.
Bug fixes:
- Fixed Export to File - Large cell contents
ChemAxon 0e37943a96
10-06-2011 06:46:10
Version: 5.5.0
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
ChemAxon bd13b5bd77
21-06-2011 19:41:26
Version: 5.5.0 (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.
ChemAxon bd13b5bd77
04-07-2011 17:17:03
Version: 5.5.1
Dear Customers,
who missed the ChemDraw editor based on activex control approach in JChemExcel in 5.4.1 and 5.5 and were not fans of the ChemDraw (OLE), we started a new patch series 5.5.1, which will be relased along with the main ChemAxon Core patch.
JChem Core release plan:
version |
tag |
revision |
commit deadline |
alpha |
beta |
release |
5.5.1 |
BRANCH_5_5_1 |
132714 |
2011.05.31 |
2011.06.24 |
2011.07.01 |
2011.07.08 |
JChemExcel will be rolled out 1 week later because of the integration tests of the new ChemAxon Core.
If the dates are changing we try to keep this announcement up-to-date with the new dates ASAP.
For the time being the development versions are available from here (with the old JChem Core):
https://www.chemaxon.com/download.php?d=/data/download/jchem4xl/Development/JChem_For_Excel_5.5.0.246.msi
Viktor
ChemAxon bd13b5bd77
07-09-2011 12:59:54
ChemAxon bd13b5bd77
08-09-2011 18:30:08
Dear Customers,
we have rolled out the patch version into prod today. Please consider to upgrade to it if you use 5.5 version of Jchem.
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.
Viktor
ChemAxon 0e37943a96
19-09-2011 16:05:03
Version: 5.6.0
Planned release date: October 10, 2011
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
- 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
ChemAxon 0e37943a96
08-11-2011 09:36:12
Version: 5.7.1
Planned release date: December, 2011
New features:
- Import File by key
- Import from Database by key
- Import from Database - Relational
Improvements:
- User Guide for 2003 and 2007 are merged
Archive versions are available:
http://www.chemaxon.com/download/jchem-for-excel/
ChemAxon bd13b5bd77
10-02-2012 19:21:18
Version: 5.7.2
Planned release date: 10th of February, 2012
Bug fix:
- Marvin/JChem Library patch
ChemAxon bd13b5bd77
10-02-2012 19:23:15
Version: 5.8.2
Planned release date: 17th of February, 2012
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
- Fix of Currency and Date time format mismatch when exporting and importing
- RD/SD file import fixes
- Import from Database by key
ChemAxon bd13b5bd77
06-03-2012 21:42:07
Version: 5.9.0
Planned release date: 6th of March, 2012
Bug fixes:
MySQL database search fails because of an internal service identification problem.
ChemAxon bd13b5bd77
18-04-2012 09:42:15
Version: 5.9.2 (133)
Planned release date: 18th of April, 2012
Bug fixes for:
- Filtered structure sheet and office image conversion throws execption
- Embedded excel function like indirect/adress/match will work together with our drawing
- Devart license issues with certain .NET versions?
ChemAxon bd13b5bd77
24-04-2012 06:37:22
ChemAxon bd13b5bd77
11-06-2012 09:32:28
Version: 5.10
Planned release date: 13-14th of June, 2012
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 introduced to allow direct source input and provide structure drawing from that (N2S functionality also included, #CAS, IUPAC, Inchi, SMILES)
- JCIDSystructure function 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 (beta)
Improvements:
- Marvin OLE 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
ChemAxon bd13b5bd77
13-07-2012 21:15:46
Version: 5.10.1
Planned release date: 16th of July, 2012
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
ChemAxon bd13b5bd77
31-07-2012 13:17:59
Version: 5.10.2
Planned release date: 31st of July, 2012
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)
ChemAxon bd13b5bd77
15-08-2012 11:22:00
Version: 5.10.3
Planned release date: 15th of August, 2012
5.10.3 JChem library is 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
ChemAxon bd13b5bd77
29-08-2012 19:09:22
Version: 5.10.4
Planned release date: Sept 13, 2012
5.10.4 JChem library is used.
ChemAxon bd13b5bd77
13-09-2012 09:32:10
Version: 5.11
Planned release date: 19th of September, 2012
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
- Font colours will be 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
ChemAxon bd13b5bd77
27-09-2012 13:50:58
Version: 5.11.1
Planned release date: 27th of September, 2012
Bug fixes:
- JCStandardizeStructure will report more detailed exceptions
- 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
ChemAxon bd13b5bd77
11-10-2012 21:46:01
Dear Customers,
please check the new features and enhancements of our 5.11 release with useful links to the documentation:
http://www.chemaxon.com/jchem4excel/changes/changes.html
Version: 5.11.2
Planned release date: 15th of October, 2012
Improvements:
- Splash screen will be configurable from the Options dialog
- Copying structures and values into Power Point will be improved with keeping the aspect ratio for
(corner-dragging) without distorting the molecules
Bug fixes:
- Filter hit highlighting will work with alignment of the substructures and without loosing the original heteroatom colours (no hit colour)
- Splash screen will not be frozen on any specific environment
- JChem for Excel installer will work in advanced user mode as before
- JCStandardizer function functionality was broken in 5.11.1 for multiple string parameters like tautomerize..aromatize.. This will be fixed now and workiing again.
ChemAxon bd13b5bd77
19-10-2012 19:52:47
Version: 5.11.3
Planned release date: Oct 19th, 2012
5.11.3 JChem/Marvin library is used.
ChemAxon bd13b5bd77
20-11-2012 13:56:42
Version: 5.11.4
Planned release date: Nov 21th, 2012
5.11.4 JChem/Marvin library is used.
Dear Customers, we ar ready with the new release candidate (beta2):
https://www.chemaxon.com/download.php?d=/data/download/jchem4xl/Development/JChem_For_Excel_5.11.4.872.msi
containing these changes:
Improvements:
- A new option will be introduced to make smiles conversion customizable to be done along with or without automatic 2D co-ordinate cleanup
- A new option will be introduced to scale down/up the molecules per user taste to display the smaller and bigger ones with common bond length (beta)
- To Marvin OLE shape action generated active structures will get invisible border instead of the current strong black borders outlining the shapes
- To Marvin OLE shape conversion will be faster keeping the OLE component alive for frequent converters
Bug fixes:
- Batch conversion like CAS or IUPAC or Smiles will contain more logging especially because of the more frquent expired license issues
- Conversion of ISIS files saved as macro supported workbooks (xlsm) is going to support the original file extension (xlsm, xlst)
- Enlarging special structures with special scale will not cause "Overflow" exception
- MRV file header will not contain incorrectly filled header (product version)
- Frequency of hidden structures decreased in multi-document workbook environment
ChemAxon bd13b5bd77
03-12-2012 20:35:22
Version: 5.11.4 (886)
Planned release date: Dec 3rd, 2012
5.11.4 JChem/Marvin library is used.
Bug fixes:
- Eliminated missing structure hash keys error message for cloned workbooks.
ChemAxon bd13b5bd77
03-12-2012 21:28:07
Version: 5.12
Planned release date: Feb 15th, 2013
5.12 JChem/Marvin library is 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 lentgh for bigger or smaller molecules
- Merged cells can display structures in the center vertically and horizontally
- Document To Structure introduced as part of the File Import module
- JCxStructure (all calculated Structure functions) can be converted to editable format
- Copy and paste structures and data values works from our grid control (e.g. Database Import Prefiltering control)
- One click copy solution for table (to Word and Power Point)
- 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
- 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)
ChemAxon bd13b5bd77
18-01-2013 18:31:55
Version: 5.11.5 (906)
Planned release date: Jan 18th, 2013
5.11.5 JChem/Marvin library is used
Bug fixes:
- Better loading of JChem Excel functions even when Excel is started from other applciation (solution to #Name problem in cells)
ChemAxon bd13b5bd77
09-02-2013 19:38:19
Office 2013 will be supported at the end of this year (2013) similarly how we did with Office 2010 (in 2010). We also expect some patches from Micrososft till then.
In the first part of the year we are focusing on the 64 bit support of Office 2010. We managed to compile the JChem for Excel addin under 64 bit in a test version, which is good news however one of our module needs to be rewritten anyway for an official release.
ChemAxon bd13b5bd77
06-03-2013 00:01:18
ChemAxon bd13b5bd77
20-03-2013 17:15:52
Version: 5.12.1
Will be released today: March 20th, 2013
5.12.1 JChem/Marvin library will be used.
Improvements and fixes:
- 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 Wrd/PPT ignores the irrelevant rows => the code does not fall back to the original solution
ChemAxon bd13b5bd77
26-03-2013 17:59:52
Version: 5.12.2
Will be released: March 29th, 2013
5.12.2 JChem/Marvin library will be used.
Improvements and fixes:
- New IO.API will require license only for generating JChem for Excel file format, reading will be free of charge
- Filtering will be faster with processing only the target range in the spreadsheet
- Scale (new fixed scale feature in drawing) will be used in reports to Ms. Word and PowerPoint
- =JCMolFormat("C=C","inchikey:SAbs") will reflect the same functionlaity as in JChem .NET API
- C# demo projects will be up-to-date on the web site reflecting the current state also for COM API
- Opacity will be eliminated when pasting ChemAxon format (structures and values) inside Excel
regardless of the target structure shape types (OLE, EMF, JChemExcel)
ChemAxon bd13b5bd77
10-04-2013 21:10:04
Version: 5.12.3
Will be released: April 11/12th, 2013
5.12.3 JChem/Marvin library will be used.
- 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)
ChemAxon bd13b5bd77
16-04-2013 21:22:51
Version: 6.0
Will be released not before: May 15th, 2013
6.0 JChem/Marvin library will be used.
Features:
- OSRA image recognition can be configured for File Import Process
- Two menu series introduced for Chemists (standard) and Modellers (advanced)
- More usable user interface for R-Group Decomposition workflow, dialog
- More usable user interface for Filter and Database Search functionalities (dialogs)
- New, empty worksheet is default for Import for file and database and R-Group Decomposition
- 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 COM API (VBA, C#, C++)
- 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 Power Point
- Largest fragment are displayed from a compound by a new chemical function
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
- TNS name connection fixes
ChemAxon bd13b5bd77
03-05-2013 14:58:54
Version: 5.12.4
Will be released today: May 6th, 2013
5.12.4 JChem/Marvin library will be used.
Improvements:
- Java API will support 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 will be fixed
- ChemDraw for Excel file created with version 13 can now be converted to JC4XL format
ChemAxon bd13b5bd77
23-05-2013 20:47:17
ChemAxon bd13b5bd77
21-06-2013 16:49:53
Version: 6.0.1
Planned release date (today): June 21st, 2013
6.0.1 JChem/Marvin library is 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)
ChemAxon bd13b5bd77
01-07-2013 13:26:18
Version: 6.0.2
Planned release date (today): July 1st, 2013
6.0.2 JChem/Marvin library is 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)
ChemAxon bd13b5bd77
23-07-2013 07:25:58
Version: 6.0.3
Planned release date (today): July 23rd/24th, 2013
6.0.3 JChem/Marvin library is used.
No changes from JChem for Excel side.
ChemAxon bd13b5bd77
12-08-2013 19:59:17
Version: 6.0.4
Planned release date (today): Aug 12, 2013
6.0.4 JChem/Marvin library is used.
No changes from JChem for Excel side.
ChemAxon bd13b5bd77
14-08-2013 10:38:17
Version: 6.0.5
Planned release date (today): Aug 26-27, 2013
6.0.5 JChem/Marvin library is used.
Bug fixes:
- ISIS/Draw editor will not throw string data is null exception and will work normally
- ChemAxon.NET.Windows.Forms controls can be dropped from the toolbox to the form designer again
ChemAxon bd13b5bd77
17-08-2013 20:05:38
Version: 6.1.0
Planned release date (today): Sept 06, 2013
Features:
- JChem for Office (supporting Excel, Power Point,
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
- Windows 8
support
- Marvin Modules (custom java codes) can be
running in JChem for Excel by Chemical terms
Improvements:
- New Look & Feel (Ribbon facade) for both
JChem for Excel and Jchem for Office
- Quick filter intorduced for Grid View
control
- New .NET examples available to overview basic
visualization tools/controls
- Hit colouring in Grid View control
- Background colour for genrated moelcule images
(rendering)
- ChemDraw13 integration into JChem for Excel as an
editor
- More reliable license handling
- More currencies supported in SD file
export
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
ChemAxon bd13b5bd77
20-09-2013 22:54:45
ChemAxon bd13b5bd77
08-10-2013 09:36:30
Dear Customers,
recently the interest is growing up related to the JChem and Micrososft Office compatibility table, please let me share it with you:
Supported versions of JChem for Excel |
|
|
|
|
Office 2003 |
Office 2007 |
Office 2010 |
Office 2013 |
Office 365 |
32-bit Office |
yes |
yes |
yes |
in 6.2 (beta) |
2014? |
64-bit Office |
NA |
NA |
in 6.2 |
in 6.2 (beta) |
2014? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Supported versions of JChem for Office |
|
|
|
|
|
|
|
|
|
|
Office 2003 |
Office 2007 |
Office 2010 |
Office 2013 |
Office 365 |
32-bit Office |
no |
yes |
yes |
in 6.2 (full) |
2014? |
64-bit Office |
NA |
NA |
in 6.2 |
in 6.2 (full) |
2014? |
Where NA means that the host product is not available from Micrososft side.
Viktor
ChemAxon bd13b5bd77
18-10-2013 09:20:23
Version: 6.1.2
Planned release date (today): Oct 18, 2013
6.1.2 JChem/Marvin library is used.
Bug fixes and improvements:
- Rendering does NOT cause crash with specific (not at 100%) zoom setting of the video driver and screen anymore in JChem for Excel
- JCChemicalTerms 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)
- Fixed scale settings (to unify smaller and bigger molecules) can be applied in copy and paste in JChem for Office
ChemAxon bd13b5bd77
05-11-2013 12:31:29
Version: 6.1.3
Planned release date (today): Nov 5, 2013
6.1.3 JChem/Marvin library is used.
Bug fixes and improvements:
- Assay data containing date and time information is now searchable even on database views not only tables
ChemAxon bd13b5bd77
05-11-2013 13:07:20
Dear Customers,
we are about to start
- refactoring our database management features in both JC4XL and JC4O products. E.g. in 6.3 we would like
- to bring the same fast data mapping feature for JChem for Office we are having in JChem for Excel.
- In addition to this we would like to complete our ChemAxon .NET with consolidated API.
For the time being please check what our search and browse functionality IS against the databases:
|
|
Created with |
|
|
JChem base |
|
JChem Cartridge |
|
Other |
|
|
table |
view |
|
table |
view |
|
table |
view |
Query (the result does not contain structure) |
|
+ |
+ |
|
+ |
+ |
|
+ |
+ |
Query (the result contains structure) |
|
+ |
- |
|
+ |
+ |
|
- |
- |
DB level structure search |
|
+ |
- |
|
+ |
+ |
|
- |
- |
DB level filter (by Date/String/Numeric
column) |
|
+ |
+ |
|
+ |
+ |
|
+ |
+ |
|
Short term possible improvement |
|
Longer term improvement |
Supported DBs
(JC4XL): |
MySql, MsSql,
Oracle |
Viktor
ChemAxon bd13b5bd77
05-12-2013 18:13:05
Dear Customers,
- JChem for Office cannot be running without Office 2007 SP3. (e.g. with SP2 it will not work)
- JChem for Excel 64 bit cannot be running without Office 2010 64 bit and SP2.
Please make sure that the essential service packs are properly installed otherwise crashes and inconveniencies might happen. These are announced issues by Microsoft we cannot cure without MS service patches or kb(s).
For the detailed description how to fix them please visit our Known Issues and their resolution section under https://www.chemaxon.com/forum/ftopic4601.html
Unsorted
section.
Viktor
ChemAxon bd13b5bd77
05-12-2013 18:25:10
Version: 6.1.4
Planned release date (next week): Dec 10-11, 2013
6.1.4 JChem/Marvin library is used.
Bug fixes and improvements:
ChemAxon bd13b5bd77
12-12-2013 00:22:27
Dear Customers,
6.2 beta version is available on the download site:
https://www.chemaxon.com/download.php?d=%2Fdata%2Fdownload%2Fjchem4xl%2FDevelopment%2F
Features:
- Office 2013 support in JChem for Excel (Preview) and in other Office products like JChem for Word, PowerPoint and Outlook
- 64-bit Office 2010, 13 support for JChem for Excel and Office
- New fast Open functionality with multiple file selection (in File section of JChem Ribbon) in JChem for Excel
- Most commonly used editors like ChemDraw, ISIS and Symyx Draw is available in JChem for Office
Improvements:
- More responsive export in JChem for Excel
- Supporting CDX, SKC formats natively in JChem for Excel
- Autoclear of local structure cache after save
- Supporting row and column grouping/outlining in structure visualization
- 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
Viktor
ChemAxon bd13b5bd77
19-12-2013 08:17:02
Version: 6.1.5
Planned release date: Dec 20, 2013
6.1.5 JChem/Marvin library is used.
Bug fixes and improvements:
- 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
ChemAxon bd13b5bd77
20-12-2013 19:27:12
Dear Customers,
many thanks for all feedback so far you contributed to 6.2 beta 1, in the meanwhile the team tried to fix all the issues you reported and we released 6.1.5 version on the site.
6.2 Beta 2 version is available on the web site (we still wait for feedback):
https://www.chemaxon.com/download.php?d=%2Fdata%2Fdownload%2Fjchem4xl%2FDevelopment%2F
the main features are:
- 64-bit Office support for JChem for Excel and Office
- Office 2013 support in JChem for Excel (Preview) and in other Office products like JChem for Word, PowerPoint and Outlook
- New fast Open functionality with multiple file selection (in File section of JChem Ribbon) in JChem for Excel
- Most commonly used editors like ChemDraw, ISIS and Symyx Draw is available in JChem for Office
- Faster SDF import and record processing
- Faster OLE and Image conversion in-palce
- Realization of custom scale of drawing in OLE and Image conversions
JChem for Excel/Office, .NET team wishes you Merry Christmas and Happy New Year.
Viktor
ChemAxon bd13b5bd77
20-12-2013 20:59:28
ChemAxon bd13b5bd77
20-01-2014 19:29:33
Version: 6.1.6
Planned release date: Jan 20, 2014
6.1.6 JChem/Marvin library is used.
Bug fixes and improvements:
- License fixes for JChem for Excel and Office (implications)
ChemAxon bd13b5bd77
22-01-2014 22:40:59
Version: 6.1.7
Planned release date: Jan 22, 2014
6.1.7 JChem/Marvin library is used.
Bug fixes and improvements:
- Loading column selector schemas (db and file import - second tab) works without any problems for the first trial
ChemAxon bd13b5bd77
02-02-2014 14:41:32
Dear Customers,
Version: 6.2.0
has been released, please check the the history of changes here: http://www.chemaxon.com/jchem4excel/changes/changes.html
in February we are focusing on the 6.3 release.
The main goals will be:
- We are going to complete the new ChemAxon .NET API
- Database search
- Chemistry Services
(molecule visualization, property calculations, transformations, representations)
(R-group decomposition)
(Filter)
- IO
- Clipboard
- Widget library (viewer, editor, dialogs, grid)
- Workflow ?
- JChem for Office API for java, .NET
- Windows8 and Office 2013 support in JChem for Excel (structure visualization)
- JChem for Office and SharePoint integration
Viktor
ChemAxon bd13b5bd77
21-02-2014 10:25:44
Dear Customers,
many questions arrived regarding the #Name issues, let me give you a short summary related to JC4XL version and #Name issue:
#Name problem generally was caused by two or three issues in the past:
- Microsoft Loaded flag
- JC4XL loading problem
- Installer problem
1. Because the Installed state of the Automation addin (JChemExcel.Functions) was set and the addin was not loaded http://www.chemaxon.com/jchem4excel/changes/changes.html , it was fixed even in 5.11.5 (906)
(solution: we had to reset the Installed state flag as the earliest point as when the application is being loaded)
2. Sometimes, not in all cases possibly when the document was downloaded from a portal (e.g. SharePoint)
(JChemExcel.Functions in this case wanted to be loaded but our main application did not serve it)
The ultimate solution for that was done in the 6.2 release line
3. This very rarely comes: Automation addin dll has to be set manually since the installer rarely cannot cope with registry (not a documented way to set the addin in the registry by Microsoft)
4. The Code (IO API) generated issue for old workbooks (xls) was fixed in 5.12.
Viktor
ChemAxon bd13b5bd77
04-03-2014 11:20:07
Version: 6.2.1
Planned release date: March 5, 2014
6.2.1 JChem/Marvin library is 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!!!!! http://www.chemaxon.com/jchem4excel/userguide/copy_paste_to_word_powerpoint.html
- 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.
- http://www.chemaxon.com/jchem4office/userguide/selecting_rows_for_import.html 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!
Viktor
ChemAxon bd13b5bd77
05-03-2014 14:42:09
Dear Csutomers,
6.2.1 version of JChem for Excel and Office have been released, please visit our download side.
Viktor
ChemAxon 990acf0dec
19-05-2014 08:13:35
Dear Customers,
JChem for Office 6.3.0 has been released!
Marvin/JChem 6.3.0 used.
New features
- Office 2013 support in JChem for Excel on Windows 8 as well. Supported versions.
- 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
- It is now possible to mport from 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.
ChemAxon 990acf0dec
17-06-2014 12:39:49
Dear Customers,
JChem for Office 6.3.1 has been released!
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 favorites.
- 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.
ChemAxon 990acf0dec
23-06-2014 15:22:41
Dear Customers,
JChem for Office 6.3.1.1116/1117 has been released!
(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.
ChemAxon 990acf0dec
18-07-2014 10:04:55
Dear Customers,
JChem for Office 6.3.2 has been released!
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).
ChemAxon bd13b5bd77
22-07-2014 09:32:22
Dear Customers,
JChem for Office 14.7.21
Planned release date: 22/23.07.2014
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 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.
ChemAxon bd13b5bd77
23-07-2014 20:48:23
Marvin/JChem 14.7.21 used.
Viktor
ChemAxon 990acf0dec
30-07-2014 17:33:55
JChem for Office 14.7.2800 has been released!
Marvin/JChem 14.7.28 used.
ChemAxon 990acf0dec
31-07-2014 14:59:40
JChem for Office 6.3.3 has been released! (Placed into the Archive.)
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.
ChemAxon 990acf0dec
01-08-2014 12:58:08
JChem for Office 6.1.9 has been released! (Placed into the Archives.)
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).
ChemAxon 990acf0dec
05-08-2014 15:49:31
JChem for Office 14.8.400 has been released!
Marvin/JChem 14.8.4 used.
ChemAxon bd13b5bd77
13-08-2014 18:40:13
Marvin/JChem 14.8.1100 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.
ChemAxon 990acf0dec
22-08-2014 09:48:11
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.
ChemAxon bd13b5bd77
28-08-2014 15:01:37
Marvin/JChem 14.8.2600 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"
ChemAxon 990acf0dec
03-09-2014 15:30:17
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.
ChemAxon 990acf0dec
12-09-2014 12:03:15
JChem for Office 14.9.800 has been released
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".
ChemAxon 990acf0dec
16-09-2014 15:10:20
JChem for Office 6.3.4 has been released
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.
ChemAxon 990acf0dec
18-09-2014 09:34:40
JChem for Office 14.9.1500 has been released
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).
ChemAxon bd13b5bd77
24-09-2014 21:12:03
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 as default
- DataBase import in JChem for Office now is more documented
Fixes
- Tversky-metric parameter with a different default parameter made this function really different from Tanimoto-calculation
- License exception does not come in JChem for OneNote
- EMF exporter component has been synched technically with the MolExporter
- Molecule Import in JChem for Office and Excel has been reworked to get it faster
- Exception dialog accumulated errors and showed the first error on the top
ChemAxon 990acf0dec
01-10-2014 17:18:48
JChem for Office 14.9.2900 has been released
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.
ChemAxon 990acf0dec
09-10-2014 14:51:09
JChem for Office 14.10.600 has been released
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.)
ChemAxon 990acf0dec
15-10-2014 13:27:53
JChem for Office 14.10.1300 has been released
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).
ChemAxon 990acf0dec
22-10-2014 13:22:17
JChem for Office 14.10.2000 has been released
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
ChemAxon 990acf0dec
05-11-2014 16:10:00
JChem for Office 14.11.300 has been released
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.
ChemAxon 990acf0dec
13-11-2014 15:19:07
JChem for Office 14.11.1000 has been released
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.
ChemAxon 990acf0dec
19-11-2014 16:50:35
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.
ChemAxon 990acf0dec
21-11-2014 14:52:25
JChem for Office 14.11.1700 has been released
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.
ChemAxon 990acf0dec
28-11-2014 15:33:14
JChem for Office 14.11.2400 has been released
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.
ChemAxon 990acf0dec
04-12-2014 14:15:53
JChem for Office 14.12.100 has been released
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.
ChemAxon 990acf0dec
10-12-2014 17:44:15
JChem for Office 14.12.800 has been released
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.
ChemAxon 990acf0dec
17-12-2014 17:22:31
JChem for Office 14.12.1500 has been released
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.
ChemAxon 990acf0dec
07-01-2015 15:33:54
JChem for Office 15.1.500 has been released
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).
ChemAxon 990acf0dec
13-01-2015 16:46:35
JChem for Office 15.1.1200 has been released
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".
ChemAxon 990acf0dec
21-01-2015 17:21:04
JChem for Office 15.1.1900 has been released
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).
ChemAxon 990acf0dec
29-01-2015 17:26:09
JChem for Office 15.1.2600 has been released
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.
ChemAxon 990acf0dec
10-02-2015 17:51:18
JChem for Office 15.2.900 has been released
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.
ChemAxon 990acf0dec
26-02-2015 08:02:18
JChem for Office 15.2.2300 has been released
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.
ChemAxon bd13b5bd77
05-03-2015 10:53:45
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.
ChemAxon 990acf0dec
12-03-2015 06:47:49
JChem for Office 15.3.900 has been released
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
ChemAxon bd13b5bd77
18-03-2015 14:52:08
JChem for Office 15.3.1600 has been released
Marvin/JChem 15.3.1600 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.
ChemAxon 990acf0dec
25-03-2015 15:05:01
JChem for Office 15.3.2300 has been released
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.
ChemAxon 990acf0dec
02-04-2015 09:56:34
JChem for Office 15.3.3000 has been released
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.
ChemAxon 990acf0dec
08-04-2015 17:25:25
JChem for Office 15.4.600 has been released
Marvin/JChem 15.4.6 used.
ChemAxon 990acf0dec
14-04-2015 16:22:15
JChem for Office 15.4.1300 has been released
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.
ChemAxon 990acf0dec
22-04-2015 13:35:10
JChem for Office 15.4.2000 has been released
Marvin/JChem 15.4.20 used.
ChemAxon 990acf0dec
29-04-2015 17:25:03
JChem for Office 15.4.2700 has been released
Marvin/JChem 15.4.27 used.
ChemAxon 990acf0dec
06-05-2015 13:05:50
JChem for Office 15.5.400 has been released
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.
ChemAxon 990acf0dec
15-05-2015 08:33:12
JChem for Office 15.5.1100 has been released
Marvin/JChem 15.5.11 used.
ChemAxon 990acf0dec
22-05-2015 12:23:42
JChem for Office 15.5.1800 has been released
Marvin/JChem 15.5.18 used.
ChemAxon 990acf0dec
27-05-2015 15:28:16
JChem for Office 15.5.2500 has been released
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.
ChemAxon 990acf0dec
02-06-2015 16:07:17
JChem for Office 15.6.100 has been released
Marvin/JChem 15.6.1 used.
Improvements
- IKVM, the 3rd party tool that converts the java based code base 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.
ChemAxon 990acf0dec
11-06-2015 13:33:42
JChem for Office 15.6.800 has been released
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.
ChemAxon 990acf0dec
17-06-2015 13:58:05
JChem for Office 15.6.1500 has been released
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 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).
ChemAxon 990acf0dec
25-06-2015 15:11:49
JChem for Office 15.6.2200 has been released
Marvin/JChem 15.6.22 used.
ChemAxon 990acf0dec
01-07-2015 11:55:08
JChem for Office 15.6.2900 has been released
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 target column for structure search on the Query tab and as
structure column on the Columns tab.
Bug Fixes
- Database import didn't 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 (e.g. there was no any hit
resulted by the query). Now it properly displays if there is no result.
ChemAxon 990acf0dec
15-07-2015 13:56:23
JChem for Office 15.7.1300 has been released
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.
ChemAxon 990acf0dec
23-07-2015 15:03:49
JChem for Office 15.7.2000 has been released
Marvin/JChem 15.7.20 used.
Bug Fixes
- OLE copy did not work in MSketch.NET.
- Ctrl+C then Ctrl+V did nopt copy a single structure object in Word.
ChemAxon 0e37943a96
31-07-2015 11:35:13
JChem for Office 15.7.2700 has been released
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 expanded group in MarvinSketch.
ChemAxon 0e37943a96
07-08-2015 13:16:12
JChem for Office 15.8.300 has been released
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.
ChemAxon 990acf0dec
12-08-2015 13:19:18
Dear JChem for Office Users,
We plan to finish the support of MS Office 2007. If you use JChem for Excel/Word/PowerPoint/Outlook on MS Office 2007, please drop a reply here.
Thanks!!!
Akos
ChemAxon 990acf0dec
19-08-2015 12:26:56
JChem for Office 15.8.1700 has been released
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.
ChemAxon 990acf0dec
25-08-2015 14:59:00
JChem for Office 15.8.2400 has been released
Marvin/JChem 15.8.24 used.
ChemAxon 990acf0dec
03-09-2015 10:06:20
JChem for Office 15.8.3100 has been released
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 the top of each other.
- Copy/pasting a structure from Excel to PowerPoint/Word/Outlook did not reflect the Excel cell size.
ChemAxon 990acf0dec
17-09-2015 14:30:22
JChem for Office 15.9.1400 has been released
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.
ChemAxon 990acf0dec
25-09-2015 13:59:22
JChem for Office 15.9.2100 has been released
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 is 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).
ChemAxon 0e37943a96
01-10-2015 12:17:45
JChem for Office 15.9.2800 has been released
Marvin/JChem 15.9.28 used.
Bug Fixes
- After pressing "Display" button the structure will not shrink and will keep the size of the outer object if the document was created without scale information.
- "Scale" button now resizes the image according the size defined in Image Formatting options, previously it was resized always to 200x200.
ChemAxon 990acf0dec
15-10-2015 12:31:22
JChem for Office 15.10.1200 has been released
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 (e.g. Add, Edit, Filter, etc.) 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 (e.g. 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.
ChemAxon 990acf0dec
22-10-2015 08:56:38
JChem for Office 15.10.1900 has been released
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.
ChemAxon 990acf0dec
29-10-2015 17:27:12
JChem for Office 15.10.2600 has been released
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.
ChemAxon 0265132c1a
04-11-2015 10:06:44
Free Webinar: Office in small biotech's workflow
Dear all,
We will have a webinar today (4th November) from 4 pm CET (10 am ET) about small biotech workflow covering mostly Instant JChem and JChem for Office capabilities. Some talk - but even more demo.
If you have time and would love to join: Register here
Abstract:
Designed for SMEs ChemAxon’s MiniReg offers a straightforward solution to create and explore chemical databases containing biochemical assay results. Embedded in our Instant JChem it provides versatile solutions for chemical informatics related tasks such as substructure, similarity and complex query building, property calculations and basic mathematical functions. The clean custom interface that can be designed within the form view builder, provides improved user experience and a clearer way of data representation.
In order to make the transition from a cheminformatics platform to more general office tasks we are introducing you the revitalised JChem for Office application. Extending spreadsheets, documents and powerpoint presentations with chemical intelligence contributes to solving regular work-flows with higher efficiency and precision within the MS Office environment.
The goal of the webinar is to propose light-weight and end-to-end solutions from registration through analysis and reporting.
Hope to see you there
ChemAxon 990acf0dec
18-11-2015 17:08:50
JChem for Office 15.11.1600 has been released
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 then 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.
ChemAxon 990acf0dec
02-12-2015 15:47:42
JChem for Office 15.11.3000 has been released
Marvin/JChem 15.11.30 used.
New feature
- The name import web service specified in the marvin.properties file
(e.g. 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 e.g. 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 Coliring 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.
ChemAxon 990acf0dec
08-12-2015 14:52:07
JChem for Office 15.12.700 has been released
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.
ChemAxon 990acf0dec
18-12-2015 16:04:32
JChem for Office 15.12.1400 has been released
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.
ChemAxon 990acf0dec
08-01-2016 13:08:03
JChem for Office 16.1.400 has been released
Marvin/JChem 16.1.4 used.
ChemAxon 990acf0dec
15-01-2016 16:17:42
JChem for Office 16.1.1100 has been released
Marvin/JChem 16.1.11 used.
Bug Fixes
- The change of the FixedScale parameter to zero was not saved into the settings file.
ChemAxon 990acf0dec
22-01-2016 16:51:08
JChem for Office 16.1.1800 has been released
Marvin/JChem 16.1.18 used.
Bug Fixes
- The bracket character caused error when it was used in adding
JCFunctions to an Excel cell from a user defined macro code (e.g. when
trying to set a SMILES containing bracket in the argument of the
JCStructure function).
ChemAxon 990acf0dec
28-01-2016 18:24:26
JChem for Office 16.1.2500 has been released
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.
ChemAxon 990acf0dec
12-02-2016 15:04:55
JChem for Office 16.2.800 has been released
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).
ChemAxon 990acf0dec
03-03-2016 15:09:30
JChem for Office 16.2.2900 has been released
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, timestap, etc.) were not hidden during Import from Database.
ChemAxon 990acf0dec
18-03-2016 12:26:41
JChem for Office 16.3.1400 has been released
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
- 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 filed based on the fieldname, 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.
ChemAxon 990acf0dec
24-03-2016 20:10:56
JChem for Office 16.3.2100 has been released
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.
ChemAxon 990acf0dec
01-04-2016 14:36:38
JChem for Office 16.3.2800 has been released
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 Numbers that could be understood as date were imported into Excel as date during the Import by ID processes.
ChemAxon 990acf0dec
15-04-2016 14:42:53
JChem for Office 16.4.1100 has been released
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 addin 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 protected sheet, the structures were not displayed on that sheet after.
ChemAxon 990acf0dec
29-04-2016 16:30:45
JChem for Office 16.4.2500 has been released
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 supports "other user" entities as well.
- The ChemAxon.NET API now supports Windows authentication mode in 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.
ChemAxon 990acf0dec
23-05-2016 16:58:32
JChem for Office 16.5.1600 has been released
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.
ChemAxon 990acf0dec
02-06-2016 13:55:42
JChem for Office 16.5.3000 has been released
Marvin/JChem 16.5.30 used.
ChemAxon 990acf0dec
16-06-2016 13:22:50
JChem for Office 16.6.1300 has been released
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.
ChemAxon 990acf0dec
23-06-2016 14:13:54
JChem for Office 16.6.2000 has been released
Marvin/JChem 16.6.20 used.
Deprecated feature
- 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 database by IDs if the worksheet contained an ID with 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.
ChemAxon 990acf0dec
07-07-2016 17:21:59
JChem for Office 16.7.400 has been released
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 German Windows environment it was not possible to Edit a JChem for Outlook object using double-click.
- If ChemDraw OLE did not work as a chemical editor.
ChemAxon 990acf0dec
19-07-2016 17:08:09
JChem for Office 16.7.1800 has been released
Marvin/JChem 16.7.18 used.
ChemAxon 990acf0dec
27-07-2016 15:52:32
JChem for Office 16.7.2500 has been released
Marvin/JChem 16.7.25 used.
ChemAxon 990acf0dec
03-08-2016 15:58:33
JChem for Office 16.8.100 has been released
Marvin/JChem 16.8.1 used.
ChemAxon 990acf0dec
12-08-2016 13:31:02
JChem for Office 16.8.800 has been released
Marvin/JChem 16.8.8 used.
ChemAxon def2724101
17-08-2016 15:55:29
JChem for Office 16.8.1500 has been released
Marvin/JChem 16.8.15 used.
ChemAxon def2724101
25-08-2016 08:09:50
JChem for Office 16.8.2200 has been released
Marvin/JChem 16.8.22 used.
ChemAxon def2724101
09-09-2016 13:59:25
JChem for Office 16.9.500 has been released
Marvin/JChem 16.9.5 used.
Improvements
- Import By ID process is now possible for "cherry-pick"-ed IDs as well.
- 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.
ChemAxon 990acf0dec
28-09-2016 07:55:12
Dear Users,
We plan to remove the option from JChem for Office that enables to insert the chemical structures as OLE objects (instead of the default JChem for Office objects) into documents, and keep them in OLE during the editing. Using OLE objects will still be possible when JChem for Office is not installed.
Please contact us if you use your JChem for Office this way.
Thank you.
ChemAxon def2724101
29-09-2016 15:37:46
JChem for Office 16.9.2600 has been released
Marvin/JChem 16.9.26 used.
Improvements
- The Diganostic 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 database by ID-s if there were invalid, integer type ID-s 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).
ChemAxon def2724101
06-10-2016 15:58:49
JChem for Office 16.10.300 has been released
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 e-mails could not be correctly opened with their own application if the JChem for Outlook was installed.
ChemAxon def2724101
14-10-2016 14:41:49
JChem for Office 16.10.1000 has been released
Marvin/JChem 16.10.10 used.
Improvements
- MDL SDFile V3000 is now available among the file types during Export to file.
ChemAxon def2724101
21-10-2016 15:25:14
JChem for Office 16.10.1700 has been released
Marvin/JChem 16.10.17 used.
Improvements
- It is now possible to set the MDL SDFile V3000 as default chemical file format for Export to File function in JChem for Excel.
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).
ChemAxon 990acf0dec
27-10-2016 12:20:51
Dear Users,
We will stop supporting Microsoft Office 2007 in November 1, 2016, (the mainstream support from Microsoft for this Office version ended 4 years ago: https://support.microsoft.com/en-us/lifecycle/search/?p1=8753).
Please contact us if you still use this version of MS Office in production, and has extended support from Microsoft.
Best regards,
Akos Papp
ChemAxon def2724101
03-11-2016 15:17:00
JChem for Office 16.10.3100 has been released
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.
ChemAxon def2724101
11-11-2016 09:07:00
JChem for Office 16.11.700 has been released
Marvin/JChem 16.11.7 used.
ChemAxon def2724101
18-11-2016 17:15:06
JChem for Office 16.11.1400 has been released
Marvin/JChem 16.11.14 used.
Improvements
- It is now possible to save connections without username and password to use integrated authentication at database import.
New Features
- The Devart dotConnect for Oracle connection provider has been removed from JChem for Excel.
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.
ChemAxon def2724101
02-12-2016 16:36:24
JChem for Office 16.11.2800 has been released
Marvin/JChem 16.11.28 used.
ChemAxon def2724101
09-12-2016 16:43:35
JChem for Office 16.12.500 has been released
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 Oracle database table.
ChemAxon def2724101
15-12-2016 10:06:35
JChem for Office 16.12.1200 has been released
Marvin/JChem 16.12.12 used.
Bug Fixes
- Structures disappeared from Excel sheet after cancelling the Excel close process.
ChemAxon def2724101
22-12-2016 14:33:19
JChem for Office 16.12.1900 has been released
Marvin/JChem 16.12.19 used.
Improvements
- Now it is possible to set the atom label font type by using the new Atom Font Type structure display option.
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).
Bug Fixes
- The non-favourite 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 wasn't informative in JChem for Excel in case of missing licenses.
ChemAxon def2724101
13-01-2017 15:11:32
JChem for Office 17.1.900 has been released
Marvin/JChem 17.1.9 used.
ChemAxon def2724101
20-01-2017 12:56:30
JChem for Office 17.1.1600 has been released
Marvin/JChem 17.1.16 used.
ChemAxon def2724101
27-01-2017 09:07:46
JChem for Office 17.1.2300 has been released
Marvin/JChem 17.1.23 used.
ChemAxon def2724101
03-02-2017 15:51:16
JChem for Office 17.1.3000 has been released
Marvin/JChem 17.1.30 used.
Bug Fixes
- The CAS 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 restart of Microsoft Word and Microsoft PowerPoint.
ChemAxon def2724101
10-02-2017 08:54:21
JChem for Office 17.2.600 has been released
Marvin/JChem 17.2.6 used.
Bug Fixes
- The Import from Database by IDs function didn't work as expected in case of NUMBER(X,Y) type Oracle columns. Integer values were displayed instead of float values.
ChemAxon def2724101
17-02-2017 11:57:52
JChem for Office 17.2.1300 has been released
Marvin/JChem 17.2.13 used.
ChemAxon def2724101
24-02-2017 08:27:11
JChem for Office 17.2.2000 has been released
Marvin/JChem 17.2.20 used.